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

[pgAdmin III] #373: Data view - when query returns error

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #373: Data view - when query returns error
Date: 2012-07-25 20:57:06
Message-ID: 054.7a9f34b9c47e990d70ba1a2b0971de2f@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#373: Data view - when query returns error
---------------------------+------------------------------------------------
 Reporter:  Vjacheslav A.  |       Owner:  dpage
     Type:  bug            |      Status:  new  
 Priority:  minor          |   Milestone:  1.16 
Component:  pgadmin        |     Version:  1.14 
 Keywords:  editgrid       |    Platform:  all  
---------------------------+------------------------------------------------
 Hi,

 in data view when a query returns error, message isn't displayed, create 2
 table table1 and table2, then open table1 data view with filter:
 id=(SELECT table1_id FROM table2), an empty grid appears, maybe better to
 display error message (query has an error: "more than one row returned by
 a subquery used as an expression").

 (PGAdmin 1.14.3, PostgreSQL 9.1.4, Windows XP x86)


 here is sql for table and data:

 CREATE TABLE table1
 (
   id serial NOT NULL,
   description character varying(50),
   CONSTRAINT table1_pkey PRIMARY KEY (id )
 )
 WITH (
   OIDS=FALSE
 );
 CREATE TABLE table2
 (
   id serial NOT NULL,
   table1_id integer NOT NULL,
   description character varying(50),
   CONSTRAINT table2_pkey PRIMARY KEY (id )
 )
 WITH (
   OIDS=FALSE
 );
 INSERT INTO table1 (description) VALUES ('a');
 INSERT INTO table1 (description) VALUES ('b');
 INSERT INTO table1 (description) VALUES ('c');

 INSERT INTO table2 (table1_id, description) VALUES (1, 'aa');
 INSERT INTO table2 (table1_id, description) VALUES (2, 'bb');
 INSERT INTO table2 (table1_id, description) VALUES (3, 'cc1');
 INSERT INTO table2 (table1_id, description) VALUES (4, 'cc2');

-- 
Ticket URL: <http://code.pgadmin.org/trac/ticket/373>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

pgadmin-hackers by date

Next:From: Vinicius SantosDate: 2012-07-26 15:37:59
Subject: Re: More information about the selected objects
Previous:From: pgAdmin TracDate: 2012-07-25 20:52:52
Subject: [pgAdmin III] #372: Add a "query tool" button to the edit view

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