Re: [DOCS] [GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

2014-04-10 Thread Rob Sargent
And it also tells you how to stop it --bibtex iirc Sent from my iPhone > On Apr 9, 2014, at 8:41 PM, Amit Langote wrote: > > Hi, > > Currently there is a warning against the following in manual: > > BEGIN; > SELECT * FROM mytable WHERE key = 1 FOR UPDATE; > SAVEPOINT s; > UPDATE mytable SET .

Re: [DOCS] Upgrading doc does not mention pg_restore at all

2014-04-10 Thread Bruce Momjian
On Sat, Jan 11, 2014 at 12:47:43PM +0100, Magnus Hagander wrote: > On Fri, Jan 10, 2014 at 7:18 PM, Josh Berkus wrote: > > Folks: > > http://www.postgresql.org/docs/9.3/static/upgrading.html > > ... no mention of pg_restore of any kind. Is there any reason why > someone (maybe

Re: [DOCS] [GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

2014-04-10 Thread Amit Langote
On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent wrote: > And it also tells you how to stop it --bibtex iirc > Yeah, it's a caution against a potentially harmful usage anyway. Users should not use it at all. I was just wondering if the description of the behavior, that is, potential disappearance o

Re: [DOCS] [GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

2014-04-10 Thread Alvaro Herrera
Amit Langote wrote: > On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent wrote: > > And it also tells you how to stop it --bibtex iirc > > Yeah, it's a caution against a potentially harmful usage anyway. Users > should not use it at all. > > I was just wondering if the description of the behavior, th

Re: [DOCS] [GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

2014-04-10 Thread Amit Langote
On Fri, Apr 11, 2014 at 11:52 AM, Alvaro Herrera wrote: > Amit Langote wrote: >> On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent wrote: >> > And it also tells you how to stop it --bibtex iirc >> >> Yeah, it's a caution against a potentially harmful usage anyway. Users >> should not use it at all. >