[pgadmin-support] pg admin bug - view data

[Michael Shapiro]

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 

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org