Re: inserting new records without OIDs

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: inserting new records without OIDs
Дата
Msg-id 40324C24.604@pse-consulting.de
обсуждение исходный текст
Ответ на inserting new records without OIDs  ("Matt Doggett" <mdoggett@coas.oregonstate.edu>)
Ответы Re: inserting new records without OIDs  ("Matt Doggett" <mdoggett@coas.oregonstate.edu>)
Re: inserting new records without OIDs  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgadmin-support
Matt Doggett wrote:

>Ooops. I sent this yesterday to the wrong maillist address. Sorry. I'll
>repost here.
>
>MD
>-----Original Message-----
>When I create a new table that does not have OIDs (the Has OIDs checkbox
>is off and I'm using a serial column type to id my records), then I
>CANNOT insert new data records using the Edit Data window.  There is no
>blank row (with an asterisk *) in which to enter new data.  In other
>words, I've discovered that you MUST use OIDs to be able to insert new
>records with the Edit window.
>  
>
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!

Regards,
Andreas




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

Предыдущее
От: "Matt Doggett"
Дата:
Сообщение: inserting new records without OIDs
Следующее
От: "Markus Wollny"
Дата:
Сообщение: Re: connection dropping continued