| From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
|---|---|
| To: | pgsql general <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] pg-dump -- primary Key |
| Date: | 1999-07-25 06:40:12 |
| Message-ID: | 19990725014012.A1550@wallace.ece.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herouth Maoz | 1999-07-25 13:45:31 | Re: [GENERAL] Installation of postgresql-6.5.1 data missing ? |
| Previous Message | Chris Bitmead | 1999-07-25 05:13:39 | Re: [GENERAL] pg-dump -- primary Key |