Обсуждение: [pgAdmin III] #373: Data view - when query returns error

Поиск
Список
Период
Сортировка

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

От
"pgAdmin Trac"
Дата:
#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