Re: OID Usage

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