Re: [gnome-db] gda-postgres doesn't work with postgresql 7.2

[Rodrigo Moya <rodrigo gnome-db org>]

On Wed, 2002-03-06 at 02:29, Gonzalo Paniagua Javier wrote:
> * [ 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?
> 
yes, but the problem is still that we are relying on an OID in a system
table. That is, it seems that postgresql-7.2, when it creates the system
tables, does do it without the OIDs, and that is the problem for us,
since to get the description of some fields, we access the pg_attribute
table using an OID.

cheers
-- 
Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com>
http://www.gnome-db.org/ - http://www.ximian.com/