Обсуждение: Default_with_oids

Поиск
Список
Период
Сортировка

Default_with_oids

От
Joanne Salerno
Дата:
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



Re: Default_with_oids

От
Tom Lane
Дата:
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

Re: Default_with_oids

От
"Joshua D. Drake"
Дата:
-----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-----