Re: oh dear - have i messed up my OIDs?

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: oh dear - have i messed up my OIDs?
Дата
Msg-id 20060628160213.GE44573@pervasive.com
обсуждение исходный текст
Ответ на oh dear - have i messed up my OIDs?  (brian ally <brian@zijn-digital.com>)
Список pgsql-general
On Sun, Jun 25, 2006 at 03:14:41PM -0400, brian ally wrote:
> My question is, can i safely run my modifications again, but swap out
> the INSERTs for the COPY WITH OIDs bit from the dump (adding my new
> INSERTs after)? Would those OIDs still be "good", so to speak?

Probably.

> ANY advice appreciated.

Don't use OIDs, use SERIALs instead. You're going to run into all kinds
of problems using OIDs.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

В списке pgsql-general по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Idea for vacuuming
Следующее
От: "Bill Eaton"
Дата:
Сообщение: unusual "relation xxx does not exist" problem