From: cuneyd tanriverdi <cunay@yahoo.com>
To: pgadmin-support@postgresql.org <pgadmin-support@postgresql.org>
Subject: Problem
Date: Tue, 28 Jun 2016 12:08:04 +0000 (UTC)
Message-ID: <2045057125.3101914.1467115684150.JavaMail.yahoo@mail.yahoo.com> (raw)
References: <2045057125.3101914.1467115684150.JavaMail.yahoo.ref@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgadmin-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=
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-supportAttachments:Pgadmin4_problem.JPG (image/jpeg, 105.7K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgadmin-support@postgresql.org
Cc: cunay@yahoo.com
Subject: Re: Problem
In-Reply-To: <2045057125.3101914.1467115684150.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox