Received: from serv0.ilse.net (serv0.ilse.nl [194.158.182.236]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA33453 for ; Mon, 13 Dec 1999 19:34:23 -0500 (EST) (envelope-from mathijs@ilse.nl) Received: (from mathijs@localhost) by serv0.ilse.net (8.8.8/8.6.12) id BAA11564; Tue, 14 Dec 1999 01:33:51 +0100 (MET) Date: Tue, 14 Dec 1999 01:33:51 +0100 From: Mathijs Brands To: Drew Whittle Cc: pgsql-sql@hub.org Subject: Re: [SQL] System Attribute Message-ID: <19991214013351.A11540@ilse.nl> References: <12856.945125447@sss.pgh.pa.us> <4.2.0.58.19991214131113.00c5dad0@pern.csarc.otago.ac.nz> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0i In-Reply-To: <4.2.0.58.19991214131113.00c5dad0@pern.csarc.otago.ac.nz>; from drew@albatross.co.nz on Tue, Dec 14, 1999 at 01:14:14PM +1300 X-Unexpected-Header: The Spanish Inquisition On Tue, Dec 14, 1999 at 01:14:14PM +1300, Drew Whittle allegedly wrote: > We have an online order system that I am trying to convert to use postgres > and I noticed a problem with the creation of the DB. > > One of the tables has a field called 'oid', which is fine under lots of > other DB's but postgres doesn't like it. I am in the process of renaming > this field so things will work but I am curious what the error actually means: > > ERROR: create: system attribute named "oid" > > Thanks, > > Drew Every record in a table has a unique OID value. So if you were to insert the same value twice, you would be able to keep them apart using the OID value. Since PostgreSQL uses the oid field internally, you cannot use it. I hope this helps. Mathijs