From: | Michael Shapiro <mshapiro(at)ncsa(dot)edu> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | pg admin bug - view data |
Date: | 2003-11-21 14:29:55 |
Message-ID: | 5.2.0.9.2.20031121082600.00bcbc40@pop.ncsa.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2003-11-21 15:23:22 | Re: pg admin bug - view data |
Previous Message | Andreas Pflug | 2003-11-20 09:31:26 | Re: pgAdmin bug? snapshot |