ALTER TABLE .. SET WITH / WITHOUT OIDS

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема ALTER TABLE .. SET WITH / WITHOUT OIDS
Дата
Msg-id 1039359174.79804.100.camel@jester
обсуждение исходный текст
Ответы Re: ALTER TABLE .. SET WITH / WITHOUT OIDS  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: ALTER TABLE .. SET WITH / WITHOUT OIDS  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Opted for the syntax in the subject as I didn't think that ADD / DROP
OIDS would work (shift/reduce conflicts), and it matches the CREATE
TABLE oids syntax.

Added and removed the oids column from several inherited tables many
times, while adding and playing with data.  I could not come up with any
issues with insert, select, update, delete statements.  So I'll assume
that the various places reading OIDS are doing the right thing.

Works somewhat like adding / dropping a column with the default of 0.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Вложения

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: doc fix for OS/X (was: 7.3 on OS X HOWTO)
Следующее
От: Neil Conway
Дата:
Сообщение: minor doc improvements