Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] DROP TABLE inside transaction block - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] DROP TABLE inside transaction block
Date
Msg-id 16933.936627252@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] DROP TABLE inside transaction block  (Vadim Mikheev <vadim@krs.ru>)
List pgsql-hackers
Tree view 
Vadim Mikheev <vadim@krs.ru> writes:
>> and we can't get it back.  Solution: only allow DROP TABLE outside
>> BEGIN, so that the user can't try to change his mind later.

> What if table was created inside BEGIN/END?
> Any reason to disallow DROP of local tables?

None, and in fact the code does allow that case, but I forgot to
mention it.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] md.c is feeling much better now, thank you
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] DROP TABLE inside transaction block