[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [GNUe-dev] pgsql: CREATE DATABASE cannot be executed from a function
From: |
Reinhard Mueller |
Subject: |
Re: [GNUe-dev] pgsql: CREATE DATABASE cannot be executed from a function or multi-command string |
Date: |
Mon, 10 Nov 2008 09:33:40 +0100 |
Dear Aaron,
Am Dienstag, den 04.11.2008, 12:12 -0500 schrieb Aaron S. Hawley:
> Newer version of Postgres have changed the ability to send a CREATE
> DATABASE function in a block with other statements.
>
> I noticed this error message when running gnue-schema --createdb,
> something that gnue-setupdb uses.
>
> http://archives.postgresql.org/pgsql-hackers/2007-09/msg00933.php
>
> Looks like line 122 needs to change.
>
> <http://www.gnuenterprise.org/cgi-bin/viewcvs.cgi/trunk/gnue-common/src/datasources/drivers/sql/postgresql/Behavior.py?view=markup>
>
> <http://svn.gnuenterprise.org/gnue/trunk/gnue-common/src/datasources/drivers/sql/postgresql/Behavior.py>
Thank you very much for this info.
Do I understand correctly that we just have to split the
"ABORT; CREATE DATABASE %s WITH OWNER %s ENCODING = 'UNICODE'; BEGIN"
into 3 separately sent statements?
Thanks,
Reinhard
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil