PFC wrote:
> As a sidenote, I have a table with a primary key which is not a
> sequence, and this query displays the non-existing sequence name. It
> would be easy to check if the sequence exists (yet another join !),
> only display sequences that exist ;)...
Hmm, I just tried the same, and got a differant result :
create table test_table ( id INTEGER PRIMARY KEY, name varchar( 100 ));
SELECT seqname, seqschema from pk_sequence WHERE tablename = 'test_table';
seqname | seqschema
---------+-----------
(0 rows)
So it works as expected here !
/BL
