Re: [GENERAL] pg-dump -- primary Key - Mailing list pgsql-general

From Chris Bitmead
Subject Re: [GENERAL] pg-dump -- primary Key
Date
Msg-id 379A9D03.9D032840@tech.com.au
Whole thread Raw
In response to pg-dump -- primary Key  ("Dan Wilson" <dan_wilson@geocities.com>)
Responses Re: [GENERAL] pg-dump -- primary Key
List pgsql-general
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.

>
> It's not a huge deal, but I was wondering if there was reasoning behind it
> of which I am unaware.
>
> -Dan

--
Chris Bitmead
mailto:chris@tech.com.au
http://www.techphoto.org - Photography News, Stuff that Matters

pgsql-general by date:

Previous
From: "Dan Wilson"
Date:
Subject: pg-dump -- primary Key
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] pg-dump -- primary Key