Unique key with nulls and copying databases across computers - Mailing list pgsql-general

From Wim Ceulemans
Subject Unique key with nulls and copying databases across computers
Date
Msg-id 002c01bdc621$b754cb90$67faa8c0@aladdin.nice.be
Whole thread Raw
List pgsql-general
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 computer. Is this in fact the way to copy databases?
After copying everything works except for example \dt , \di which gives the
following
error:

ERROR: cache lookup for userid 1003 failed

What does this mean?

Regards
Wim Ceulemans
Nice Software Solutions



pgsql-general by date:

Previous
From: "Krasnow, Greg"
Date:
Subject: Select MIN() & MAX()
Next
From: Dimitri
Date:
Subject: Re: [GENERAL] Select MIN() & MAX()