Thread: Problem
PgAdmin4
Version1.0-beta2
CopyrightCopyright 2013 - 2016, The pgAdmin Development Team
Python Version2.7.11 (v2.7.11:6d1b6a68f775, Dec 5 2015, 20:32:19) [MSC v.1500 32 bit (Intel)]
Flask Version0.10.1
Application 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;
BEGIN
i:=0;
while (i<=10)
loop
BEGIN
RAISE 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,
fulltext
FROM film;
i=i+1;
END;
end loop;
END
$$;
Sincerly yours
Cuneyd Tanriverdi
