Re: [GENERAL] pg-dump -- primary Key
От | Dan Wilson |
---|---|
Тема | Re: [GENERAL] pg-dump -- primary Key |
Дата | |
Msg-id | 004f01bed710$efbf68e0$ac0bfea9@dwilson обсуждение исходный текст |
Ответ на | pg-dump -- primary Key ("Dan Wilson" <dan_wilson@geocities.com>) |
Список | pgsql-general |
I understand this, but does it set the indisprimary flag in the pg_index table? The reason I ask is because I am writing a web based app to administer a pgsql database and am attempting to keep track of the indices/keys. This is the property I am looking at determine whether the index is a primary key. Is there a better property or flag to examine for this purpose? -Dan > On Sun, Jul 25, 1999 at 03:13:39PM +1000, Chris Bitmead wrote: > > Dan Wilson wrote: > > > > > Yes, I am aware that the primary key does not really mean anything except > > > implicitly making it a unique key, but it's supposed to be there for > > > compatibility and it's not even in the dump. > > > > Someone mentioned recently that primary key enforces nulls as unique > > whereas unique index doesn't. > > > > Actually, I belive it enforces NOT NULL on primary keys, which it also > dumps in the pg_dump output. > > Ross
В списке pgsql-general по дате отправления: