Re: serial as FK ?

Поиск
Список
Период
Сортировка
Искать
От
Oleg Bartunov
Тема
Re: serial as FK ?
Дата
Msg-id
Pine.GSO.4.62.0502282314220.18315@ra.sai.msu.su
Ответ на
Re: serial as FK ? (Stephan Szabo)
Список
Дерево обсуждения
serial as FK ? Oleg Bartunov <oleg@sai.msu.su>
Re: serial as FK ? Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: serial as FK ? Oleg Bartunov <oleg@sai.msu.su>
On Mon, 28 Feb 2005, Stephan Szabo wrote:

>
> On Mon, 28 Feb 2005, Oleg Bartunov wrote:
>
>> what's wrong to use SERIAL as FK without explicit PRIMARY KEY or UNIQUE ?
>
> Serial isn't enough to guarantee uniqueness as required by foreign keys.

you're certainly right !

>
	Regards,		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

В списке pgsql-hackers по дате отправления
От: Pavel Stehule
Дата:
Сообщение: Re: SQL99 Hierarchical queries
От: Nicolai Tufar
Дата:
FAQ