Unique key with nulls and copying databases across computers

From: "Wim Ceulemans" <wim(dot)ceulemans(at)pophost(dot)eunet(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Unique key with nulls and copying databases across computers
Date: 1998-08-12 18:47:52
Message-ID: 002c01bdc621$b754cb90$67faa8c0@aladdin.nice.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri 1998-08-12 19:25:40 Re: [GENERAL] Select MIN() & MAX()
Previous Message Krasnow, Greg 1998-08-12 18:11:10 Select MIN() & MAX()