-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 21 Dec 2007 23:56:55 -0500 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > [pokes at it for a bit...] Actually the deptype='a' bit is not so > robust; we used to use 'i' for serial dependencies. I'd leave that > test out entirely, I think --- it doesn't seem essential, because > there isn't any other reason for a sequence to depend on a table > column. Otherwise the query seems correct. 8.2 is type 'a' (and I assume 8.3), 8.1 is 'i'. I don't know about anything older. Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHbK0vATb/zqfZUUQRAknrAKChvcHWdSpJSvCIl4nXXuJLF1CPQgCcDLVn 0ZQAn4F5mSyUaWWcaztJJC4= =jE0v -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
