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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
