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.