Re: [GENERAL] pg_upgrade ?deficiency - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [GENERAL] pg_upgrade ?deficiency
Date
Msg-id 20131122215253.GH17400@alap2.anarazel.de
Whole thread Raw
In response to Re: [GENERAL] pg_upgrade ?deficiency  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: [GENERAL] pg_upgrade ?deficiency
List pgsql-hackers
On 2013-11-22 13:34:18 -0800, Kevin Grittner wrote:
> Oddly, it didn't complain about creating users within a read-only
> transaction.  That seems like a potential bug.

There's lots of things that escape XactReadOnly. I've thought (and I
think suggested) before that we should put in another layer of defense
by also putting a check in AssignTransactionId(). Imo the compatibility
woes (like not being able to run SELECT txid_current();) are well worth
the nearly ironclad guarantee that we're not writing.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: AK
Date:
Subject: Re: Why is UPDATE with column-list syntax not implemented
Next
From: Kevin Grittner
Date:
Subject: Re: [GENERAL] pg_upgrade ?deficiency