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

Is there a way to run CREATE TABLESPACE within a stored procedure?

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Is there a way to run CREATE TABLESPACE within a stored procedure?
Date: 2007-07-19 11:53:50
Message-ID: F8B9B12641FB6B4FAC761BDEF9D63B040DD93B29@tlv-ex-01.adprod.bmc.com (view raw or flat)
Thread:
Lists: pgsql-admin
Fails on: Cannot run inside a transaction block.
Thanks
Danny


Responses

pgsql-admin by date

Next:From: EnderDate: 2007-07-19 12:19:06
Subject: PgAdmin hang on cancel query
Previous:From: Jayakumar_MukundarajuDate: 2007-07-19 11:37:03
Subject: Re: PgAgent Job Scheduling-Backup

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