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
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... |