pg admin bug - view data

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

Responses

Browse pgadmin-support by date

  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