Re: Restoring Backup With OIDs As Primary Key

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Restoring Backup With OIDs As Primary Key
Дата
Msg-id 20080826141251.GP10936@commandprompt.com
обсуждение исходный текст
Ответ на Restoring Backup With OIDs As Primary Key  ("Ben C" <ben.c@ect.com.au>)
Список pgsql-admin
On Tue, Aug 26, 2008 at 01:30:23PM +1000, Ben C wrote:
>
> Is there a way to increment the OID by changing a value in the system tables?

I don't think so, but I just tried creating a table in 8.3 with a
column named "oid", and it worked.  Maybe you can load in your data
that way, so that you don't need to change your application.  (I'd
test it a little more carefully for side effects than I just did, mind.)

A
--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

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

Предыдущее
От: "Ben C"
Дата:
Сообщение: Restoring Backup With OIDs As Primary Key
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Restoring Backup With OIDs As Primary Key