Skip to content

Manager1K.sh fails on modern PostgreSQL - abstime type deprecated #68

@NetIRC

Description

@NetIRC

Hello,

The Manager1K.sh script doesn't work with modern PostgreSQL versions (10+)
because it uses the deprecated 'abstime' type.

Error:
ERROR: type "abstime" does not exist

The script also doesn't support PostgreSQL password authentication.

I have a working fixed version that:

  • Uses extract(epoch from now())::int4 instead of now()::abstime::int4
  • Adds PostgreSQL password support
  • Allows searching users by ID or username

Can I submit these fixes?

Thanks,
TheDavid - NetIRC IRC Network

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions