I think there is a bug in the pgadmin view data option for a table. If the
table does not have a primary key, pgadmin issues an invalid select. Here
is the table definition:
CREATE TABLE data_tbl
( packet_rec_id numeric(38) NOT NULL, tag varchar(32) NOT NULL, subtag varchar(32), seq int4 NOT NULL, value text,
CONSTRAINT data_uk UNIQUE (packet_rec_id, tag, subtag, seq)
) WITHOUT OIDS;
Here is the SQL that PgAdmin issues (from the log file). Notice that the
ORDER BY clause does not specify any columns:
2003-11-21 08:24:36 INFO : Running query SELECT * FROM data_tbl ORDER BY ASC
2003-11-21 08:24:36 QUERY : Thread Query SELECT * FROM data_tbl ORDER BY ASC
2003-11-21 08:24:36 QUERY : DEBUG: StartTransactionCommand
2003-11-21 08:24:36 QUERY : DEBUG: AbortCurrentTransaction
---
Michael
