BUG #14848: simple Query script not work

Started by Nonameover 8 years ago1 messagesbugs

rainersharp@gmail.com

over 8 years ago

The following bug has been logged on the website:

Bug reference: 14848
Logged by: Rainer Sestig
Email address: rainersharp@gmail.com
PostgreSQL version: 10.0
Operating system: Windows 10
Description:

This simple sql Script don't work with pgAdmin4 V2.0 or V1.16.
But ist work fine with pgAdmin3 V1.22

-- Database: angebot

DROP DATABASE IF EXISTS test;

CREATE DATABASE test
WITH OWNER = mk_owner
ENCODING = 'LATIN9'
TABLESPACE = pg_default
TEMPLATE = template0
LC_COLLATE = 'C'
LC_CTYPE = 'C'
CONNECTION LIMIT = -1;
GRANT CONNECT, TEMPORARY ON DATABASE test TO public;
GRANT ALL ON DATABASE test TO mk_owner;
GRANT TEMPORARY ON DATABASE angebot TO mk_user;

COMMENT ON DATABASE test
IS 'Datenbank Test';

ERROR: FEHLER: DROP DATABASE kann nicht aus einer Funktion oder einer
mehrbefehligen Zeichenkette heraus ausgeführt werden

SQL state: 25001

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs