Re: [GNUe-dev] pgsql: CREATE DATABASE cannot be executed from a function or multi-command string

[Reinhard Mueller]

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