Problem

From: cuneyd tanriverdi <cunay(at)yahoo(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Problem
Date: 2016-06-28 12:08:04
Message-ID: 2045057125.3101914.1467115684150.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

PgAdmin4Version1.0-beta2CopyrightCopyright 2013 - 2016, The pgAdmin Development TeamPython Version2.7.11 (v2.7.11:6d1b6a68f775, Dec 5 2015, 20:32:19) [MSC v.1500 32 bit (Intel)]Flask Version0.10.1Application ModeDesktop
Windows 7 Professional Service Pack 1

Issue:
I have downloaded pgadmin4 and I liked the main shape. 
But at the query pane I tried to run a while loop script two times at the same session. At first run it worked and commited the result. But when I tried to execute second time on the sam session, at the messeage pane I got a warning.
Then I opened a new query pane and paste the script, then executed it worked without any problem. At the second attemp again warning.
You can see the problem at the accahtment.
By the way I used pagila dvdrental demo database  and I have a stream replication cluster structure on two separete VM.
The script I use as the following:
DO $$
DECLARE i integer;
BEGINi:=0;while (i<=10)loopBEGINRAISE NOTICE 'number %', i;INSERT INTO film_yedek( title, description, release_year, language_id, rental_duration, rental_rate, length, replacement_cost, rating, last_update, special_features, fulltext)SELECT title, description, release_year, language_id, rental_duration, rental_rate, length, replacement_cost, rating, last_update, special_features, fulltextFROM film;i=i+1;
END;
end loop;END$$;

Sincerly yoursCuneyd Tanriverdi

Attachment Content-Type Size
Pgadmin4_problem.JPG image/jpeg 105.7 KB

Browse pgadmin-support by date

  From Date Subject
Next Message Chris Benenati 2016-06-28 22:33:26 Running pgadmin on Windows 7; SSL tunneling
Previous Message rmikeuk 2016-06-28 11:16:25 Re: pgAdmin4 10-beta2 for Mac - error/freeze on start