Обсуждение: Default_with_oids
I recently went from Postgres 7.4.8 to 8.2.1 (Linux Platform). After conversion I noticed my forms created with the utility PGACCESS failed. I found since then that PGACCESS requires oids to perform as I used it prior to the conversion. If I set "default_with_oids = true" then the forms work in 8.2.1. My questions: Why is "default_with_oids =false" the default in 8.2.1 ? Does the use of oids effect database performance? Is "default_with_oids" set per server, database, or by table? Thank you. -- Joanne R. Salerno
Joanne Salerno <joanne.salerno@noaa.gov> writes: > Why is "default_with_oids =false" the default in 8.2.1 ? Putting OIDs in user tables has been deprecated for quite some time now. I suggest looking for a newer version of PgAccess... regards, tom lane
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 18 Jan 2008 15:08:43 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote: > Joanne Salerno <joanne.salerno@noaa.gov> writes: > > Why is "default_with_oids =false" the default in 8.2.1 ? > > Putting OIDs in user tables has been deprecated for quite some time > now. I suggest looking for a newer version of PgAccess... IIRC PgAccess is long dead. They really need to move to PgAdmin or OOBase or something like that. Joshua D. Drake > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- TIP 4: Have you searched our > list archives? > > http://archives.postgresql.org/ > - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHkQpOATb/zqfZUUQRAtUoAJ99EGdA1J/HhLSuIXjKYwMDDx3bdACeMSM/ MB0vMMEjOEnAdzHeVp7gp3g= =PmWd -----END PGP SIGNATURE-----