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