Transactional DDL

From: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Transactional DDL
Date: 2007-08-15 04:02:54
Message-ID: d86a77ef0708142102x242e8a57wf2273b02d29f92f5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I read a few lines about SP compilation in postgres

http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci1179016,00.html

*1. stored procedure compilation is transactional. *
*"You can recompile a stored procedure on a live system, and only
transactions starting after that compilation will see the changes," he said.
"Transactions in process can complete with the old version. Oracle just
blocks on the busy procedure." *

Is this what the Transactional DDL feature of postgresql talks about ?

Thanks
~Harpreet

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lim Berger 2007-08-15 04:07:39 Custom functions for default values for columns on insert
Previous Message Jasbinder Singh Bali 2007-08-15 03:34:08 language interface in postgresql