| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Doug McNaught <doug(at)mcnaught(dot)org> |
| Cc: | David Parker <dparker(at)tazznetworks(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: To OID or not to OID |
| Date: | 2004-09-29 06:00:31 |
| Message-ID: | 1096437631.28946.1457.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2004-09-29 at 00:23, Doug McNaught wrote:
> Nothing in PG depends on user tables having an OID column. They used
> to be a way to get a primary key before SERIAL came along, but they
> are now deprecated for user tables. WITHOUT OIDS will be the default
> in a future release.
Indeed, that will be the default in 8.1, if we stick to the previous
discussions on -hackers. 8.0 introduces a GUC variable
"default_with_oids" that controls whether OIDs are added to tables by
default. In 8.0 this will be true by default (so 8.0 will behave exactly
the same as earlier releases), but I'll be pushing for it to be set to
false for 8.1.
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Mallete | 2004-09-29 07:10:57 | error: unicode characters greater than or equal to 0x10000 |
| Previous Message | Stephan Szabo | 2004-09-29 05:30:55 | Re: Indexes on Expressions -- Parentheses |