[GENERAL] Installation of postgresql-6.5.1 data missing ?

1999-07-24 Thread Jesper K. Pedersen
I have been using a much older version of postgresql and decided to "trash" it and go to the 6.5.1beta1 All installation of the server/client/devel went fine - but i am unable to install the default database - postgresql-data-X.X.X as i cant find any for 6.5.1 Anyone have any help that

[GENERAL] pg-dump -- primary Key

1999-07-24 Thread Dan Wilson
I was looking at the pg_dump and realized that it does not indicate the primary keys. Why is this? It does dump the primary keys with the indexed, however as far as I could tell, it did not indicate anything as the primary key. Yes, I am aware that the primary key does not really mean anything

Re: [GENERAL] pg-dump -- primary Key

1999-07-24 Thread Chris Bitmead
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

Re: [GENERAL] pg-dump -- primary Key

1999-07-24 Thread Ross J. Reedstrom
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