Skip site navigation (1) Skip section navigation (2)

"CREATE TABLESPACE" cannot run within a Stored Procedure - "Inside a transaction bloc"

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: "CREATE TABLESPACE" cannot run within a Stored Procedure - "Inside a transaction bloc"
Date: 2007-07-18 13:42:38
Message-ID: F8B9B12641FB6B4FAC761BDEF9D63B040DD3A792@tlv-ex-01.adprod.bmc.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

Is there a way to run CREATE TABLESOACE,DATABASE etc. winthin a stored
procedure?

Thanks

Danny

 

pgsql-admin by date

Next:From: Tom LaneDate: 2007-07-18 14:26:32
Subject: Re: Setting usesuper bit for user postgres.
Previous:From: Michael MonnerieDate: 2007-07-18 10:56:57
Subject: Re: syslog: log line length?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group