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



* [ 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]