Re: [gnome-db] gda-postgres doesn't work with postgresql 7.2
- From: Gonzalo Paniagua Javier <gonzalo gnome-db org>
- To: GDA <gnome-db-list gnome org>
- Subject: Re: [gnome-db] gda-postgres doesn't work with postgresql 7.2
- Date: Wed, 6 Mar 2002 02:29:56 +0100
* [ Rodrigo Moya <rodrigo gnome-db org>
* Tue, 05 Mar 2002 22:59:22 +0100 ]
> well, the problem is that the tables whose OIDs we rely on are the
> system tables (pg_attribute).
<begin cut_from_manual>
WITH OIDS or WITHOUT OIDS
This optional clause specifies whether rows of the new table
should have OIDs (object identifiers) assigned to them. The
default is to have OIDs. (If the new table inherits from any
tables that have OIDs, then WITH OIDS is forced even if the
command says WITHOUT OIDS.)
Specifying WITHOUT OIDS allows the user to suppress
generation of OIDs for rows of a table. This may be
worthwhile for large tables, since it will reduce OID
consumption and thereby postpone wraparound of the 32-bit
OID counter. Once the counter wraps around, uniqueness of
OIDs can no longer be assumed, which considerably reduces
their usefulness.
<end cut_from_manual>
Well, I think this does NOT affect us. It's just a matter of
having an OID for each row in a table or not.
Am I missing the point? Am I right?
Cheers!
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]