| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Joseph Molnar" <josephmolnar(at)hotmail(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Question on oid's |
| Date: | 2002-04-10 16:02:07 |
| Message-ID: | web-1234330@davinci.ethosmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Joe,
> I am also new to Postgresql though not ORDBMS systems ... why should
> you not
> use OIDs as a primary key in Postgresql?
1. OIDs are not normally backed up, and it requires special pg_dump
options to backup and restore them, and there can be problems in this
process.
2. If you have a very large database with a lot of activity, the OID
counter will "roll over" which is not a problem for the system, but
will be for any OID-based primary keys.
3. It's not great design to make a column which is normally hidden in
queries your primary key.
-Josh Berkus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Hatcher | 2002-04-10 16:45:08 | Perl query error |
| Previous Message | Joseph Molnar | 2002-04-10 15:56:29 | Re: Question on oid's |