Skip to content

Generating a ID overwrites instance ID GUC & issues with the time values #5

@pdeaudney

Description

@pdeaudney

Have manually set the GUCs in a config file:

cat /etc/postgresql/14/main/conf.d/pgflake.conf
pgflake.start_epoch = 1719611959
pgflake.instance_id = 100

Reloaded PostgreSQL.
Installed the extension and generate an ID and the GUC values are being overwritten:

paul=# show pgflake.instance_id;
 pgflake.instance_id
---------------------
 100
(1 row)
paul=# show pgflake.start_epoch;
 pgflake.start_epoch
---------------------
 1719611959
(1 row)
paul=# select pgflake_generate();
  pgflake_generate
---------------------
 7205366207539986432
(1 row)
paul=# show pgflake.start_epoch;
 pgflake.start_epoch
---------------------
 start_epoch
(1 row)
paul=# show pgflake.instance_id;
 pgflake.instance_id
---------------------
 22026
(1 row)

And additionally there is some weird time movement going on. The instance.id was also reset??

paul=# select pgflake_generate();
  pgflake_generate
---------------------
 7205367237581357056
(1 row)

paul=# show pgflake.instance_id;
 pgflake.instance_id
---------------------
 0
(1 row)

paul=# select pgflake_extract_sequence('7205367237581357056');
 pgflake_extract_sequence
--------------------------
                        0
(1 row)

paul=# select pgflake_extract_time('7205367237581357056');
 pgflake_extract_time
----------------------
        1717893418689
(1 row)

paul=# select to_timestamp(pgflake_extract_time('7205367237581357056'));
          to_timestamp
--------------------------------
 56407-11-17 03:18:08.999936+11
(1 row)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions