0

While trying to move Craig Ringer's PostgreSQL gapless sequences example in to another schema 'test' I get an error. The query

INSERT INTO test.dummy(id, blah)
VALUES ( test.get_next_id('test.thetable_id_counter','last_id'), 42 );

errors with

relation "test.thetable_id_counter" does not exist
UPDATE "test.thetable_id_counter" SET "test.last_id" = "test...
       ^

yet the query:

SELECT to_regclass('test.thetable_id_counter');

does not result in NULL.

ingo
  • 117
  • 10

0 Answers0