Has the attribute name for oid changed in pgsql 7.3 ?

From: Guy Fraser <guy(at)incentre(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Has the attribute name for oid changed in pgsql 7.3 ?
Date: 2003-02-19 16:38:55
Message-ID: 3E53B31F.5010902@incentre.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is the error I am getting.

select oid,* from "decstop" limit 25 offset 0 failed : \
ERROR: Attribute "oid" not found

This used to work, but doesn't anymore.

How can I get the oid for a record now. I use them to collect the first record
of entries with duplicated data. The records have different delay fields so
they can not be selected with distinct. The records are inserted into a table
then removed from the holding table, I then insert all remaining records into
a table that holds all duplicate records then remove them from the holding table.

I need the oid to be able to efficiently "move" records from one table to
another since I only store the oid of matches into a temporary table for use
with the insert and delete queries.

I had not noticed anything about this change in the documentation, but maybe I
missed something.

Guy

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2003-02-19 16:44:33 Concurrency and locks
Previous Message jerome 2003-02-19 16:35:37 SQL query...