Re: Setting Sequence Values

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Setting Sequence Values
Дата
Msg-id 20071221222233.0e371f54@commandprompt.com
обсуждение исходный текст
Ответ на Re: Setting Sequence Values  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 21 Dec 2007 23:56:55 -0500
Tom Lane <tgl@sss.pgh.pa.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-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Chuck
Дата:
Сообщение: installation on Mac OS X 10.5.1
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Constraint Trigger's referenced_table