Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-11-21 15:23:22
Subject: Re: pg admin bug - view data
Previous:From: Andreas PflugDate: 2003-11-20 09:31:26
Subject: Re: pgAdmin bug? snapshot

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group