Ticket #373 (new bug)

Opened 10 months ago

Data view - when query returns error

Reported by: Vjacheslav A. Owned by: dpage
Priority: minor Milestone: 1.16
Component: pgadmin Version: 1.14
Keywords: editgrid Cc:
Platform: all

Description

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');

Note: See TracTickets for help on using tickets.