Re: [GENERAL] Unique key with nulls and copying databases across computers

1998-08-14 Thread Wim Ceulemans
y, August 14, 1998 4:14 AM Subject: Re: [GENERAL] Unique key with nulls and copying databases across computers >Wim Ceulemans wrote: >> >> Hi >> >> I have a few questions: >> >> 1. Is there a simple way in postgresql 6.3.2 to implement a unique index on >&g

[GENERAL] Unique key with nulls and copying databases across computers

1998-08-12 Thread Wim Ceulemans
Hi I have a few questions: 1. Is there a simple way in postgresql 6.3.2 to implement a unique index on one field with null's allowed. So if the field is null it's ok else the value must be unique? 2. I have copied the contents of a database ( ../data/base/name/* ) from one computer to another c