Postgres Pro
Downloads
Home   >   mailing lists

Transactional DDL - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject Transactional DDL
Date
Msg-id d86a77ef0708142102x242e8a57wf2273b02d29f92f5@mail.gmail.com
Whole thread Raw
Responses Re: Transactional DDL  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Transactional DDL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
 
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
 

pgsql-general by date:

Previous
From: "Jasbinder Singh Bali"
Date:
Subject: language interface in postgresql
Next
From: "Lim Berger"
Date:
Subject: Custom functions for default values for columns on insert