| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | ALTER TABLE .. SET WITH / WITHOUT OIDS |
| Date: | 2002-12-08 14:52:55 |
| Message-ID: | 1039359174.79804.100.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| Attachment | Content-Type | Size |
|---|---|---|
| altoid.patch | text/plain | 18.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-12-08 16:49:00 | proposal: array utility functions phase 1 |
| Previous Message | Neil Conway | 2002-12-07 18:45:39 | doc fix for OS/X (was: 7.3 on OS X HOWTO) |