Re: inserting new records without OIDs

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: inserting new records without OIDs
Дата
Msg-id 4032EE37.8040105@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: inserting new records without OIDs  (Andreas Pflug <pgadmin@pse-consulting.de>)
Ответы Re: inserting new records without OIDs  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список pgadmin-support
> Not true. Currently, you need either OID *or* a primary key. Obviously, 
> that id column should get a pk.
> We'll extend the grid some time, to accept any other unique keys also. 
> Still, defining a PK on every table is best practice.
> Defining a column as serial does *not* guarantee it's unique!

Remember that unique indexes can have multiple NULL values.  Also, oids 
are not guaranteed unique.

Chris


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

Предыдущее
От: Adam H.Pendleton
Дата:
Сообщение: Re: connection dropping continued
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: inserting new records without OIDs