From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com>, "Martin" <martin(at)cornhobble(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Setting Sequence Values |
Date: | 2007-12-22 06:22:33 |
Message-ID: | 20071221222233.0e371f54@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, 21 Dec 2007 23:56:55 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2007-12-22 06:37:50 | Constraint Trigger's referenced_table |
Previous Message | Chuck | 2007-12-22 05:56:27 | installation on Mac OS X 10.5.1 |