On Sat, Jan 15, 2005 at 09:02:12AM +0100, 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 ;)...
Hmmm...that's odd, since the query gets the sequence name through a series of inner joins that go back go pg_class -- if the sequence doesn't exist then where is the name coming from? I did notice that the query should add "AND attisdropped IS FALSE" to the join with pg_attribute, but I don't see how that would affect this case. Can you spot where the mistake is? What does "\d tablename" show for the table in question? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
