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?
- --
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-----