Is there why we allow DDLs inside a transaction and allow it to be rolled back? If we commit the previous transaction, as soon as we encounter a DDL, and commit the DDL too (without waiting for commit) will it be affecting some use cases?
I actually mean to say that DDLs can be declared as self-committing. That would get rid of these exceptions.
Am i missing something?
Thanks,
Gokul.
On Jan 3, 2008 12:02 AM, Andrew Dunstan <
adunstan@postgresql.org> wrote:
Simon Riggs wrote:
> On Tue, 2008-01-01 at 16:09 -0500, Tom Lane wrote:
>
>
>> Paranoia would
>> suggest forbidding *any* form of ALTER TABLE when there are pending
>> trigger events, but maybe that's unnecessarily strong.
>>
>
> That works for me. Such a combination makes no sense, so banning it is
> the right thing to do.
>
>
+1. Doesn't make much sense to me either.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
