Received: from camel7.mindspring.com (camel7.mindspring.com [207.69.200.57]) by hub.org (8.9.2/8.9.1) with ESMTP id TAA61094 for ; Thu, 25 Feb 1999 19:58:47 -0500 (EST) (envelope-from clark.evans@manhattanproject.com) Received: from manhattanproject.com (pool-207-205-162-7.nwrk.grid.net [207.205.162.7]) by camel7.mindspring.com (8.8.5/8.8.5) with ESMTP id TAA15729 for ; Thu, 25 Feb 1999 19:58:45 -0500 (EST) Sender: clark@mindspring.com Message-ID: <36D5F0F0.A49429A@manhattanproject.com> Date: Fri, 26 Feb 1999 00:55:12 +0000 From: Clark Evans X-Mailer: Mozilla 4.5 [en] (X11; U; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 CC: pgsql-sql@postgreSQL.org Subject: OID Behavior References: <199902251416.JAA22638@m1p17-235.waterauthority.state.fl.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there a summary anywhere describing OID behavior? Specificially, what you can do with the system generated column and what you cannot do? For instance, a) You cannot update it. b) You can index it. From what I remember, someone said that you could export data with OID and then import it. When is the above true? When the import and export are performed on the same database? If you change databases, etc? In particular, knowing how it is used internally would help a great deal. Thank you! Clark Evans