Unique key with nulls and copying databases across computers

Поиск
Список
Период
Сортировка
От Wim Ceulemans
Тема Unique key with nulls and copying databases across computers
Дата
Msg-id 002c01bdc621$b754cb90$67faa8c0@aladdin.nice.be
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Krasnow, Greg"
Дата:
Сообщение: Select MIN() & MAX()
Следующее
От: Dimitri
Дата:
Сообщение: Re: [GENERAL] Select MIN() & MAX()