pg admin bug - view data
От | Michael Shapiro |
---|---|
Тема | pg admin bug - view data |
Дата | |
Msg-id | 5.2.0.9.2.20031121082600.00bcbc40@pop.ncsa.uiuc.edu обсуждение исходный текст |
Ответы |
Re: pg admin bug - view data
|
Список | 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
В списке pgadmin-support по дате отправления: