Thread

1. Alias to rollback keyword

   Matthew Altus <maltus@internode.com.au> — 2010-04-01T00:42:14Z

   Hey,
   
   After dealing with a production fault and having to rollback all the time, I 
   kept typing a different word instead of rollback.  So I created a patch to 
   accept this word as an alias for rollback.  Obviously it's not part of the sql 
   standard, but could be a nice extension for postgresql.  See the patch for 
   more details.
   
   Cheers
   Matt
   

2. Re: Alias to rollback keyword

   David E. Wheeler <david@kineticode.com> — 2010-04-01T02:33:49Z

   On Mar 31, 2010, at 5:42 PM, Matthew Altus wrote:
   
   > After dealing with a production fault and having to rollback all the time, I 
   > kept typing a different word instead of rollback.  So I created a patch to 
   > accept this word as an alias for rollback.  Obviously it's not part of the sql 
   > standard, but could be a nice extension for postgresql.  See the patch for 
   > more details.
   
   +100
   
   Best,
   
   David
   
   
   

3. Re: Alias to rollback keyword

   Bruce Momjian <bruce@momjian.us> — 2010-04-01T02:34:41Z

   Matthew Altus wrote:
   > Hey,
   > 
   > After dealing with a production fault and having to rollback all the time, I 
   > kept typing a different word instead of rollback.  So I created a patch to 
   > accept this word as an alias for rollback.  Obviously it's not part of the sql 
   > standard, but could be a nice extension for postgresql.  See the patch for 
   > more details.
   
   Applied.
   
   -- 
     Bruce Momjian  <bruce@momjian.us>        http://momjian.us
     EnterpriseDB                             http://enterprisedb.com
   
   

4. Re: Alias to rollback keyword

   Robert Haas <robertmhaas@gmail.com> — 2010-04-01T02:38:42Z

   On Wed, Mar 31, 2010 at 10:34 PM, Bruce Momjian <bruce@momjian.us> wrote:
   > Matthew Altus wrote:
   >> Hey,
   >>
   >> After dealing with a production fault and having to rollback all the time, I
   >> kept typing a different word instead of rollback.  So I created a patch to
   >> accept this word as an alias for rollback.  Obviously it's not part of the sql
   >> standard, but could be a nice extension for postgresql.  See the patch for
   >> more details.
   >
   > Applied.
   
   You know, I was about to write a rant about this, until I realized
   what day it will be soon (or already is, UTC).
   
   ...Robert
   
   

5. Re: Alias to rollback keyword

   Bruce Momjian <bruce@momjian.us> — 2010-04-01T02:39:36Z

   Robert Haas wrote:
   > On Wed, Mar 31, 2010 at 10:34 PM, Bruce Momjian <bruce@momjian.us> wrote:
   > > Matthew Altus wrote:
   > >> Hey,
   > >>
   > >> After dealing with a production fault and having to rollback all the time, I
   > >> kept typing a different word instead of rollback. ?So I created a patch to
   > >> accept this word as an alias for rollback. ?Obviously it's not part of the sql
   > >> standard, but could be a nice extension for postgresql. ?See the patch for
   > >> more details.
   > >
   > > Applied.
   > 
   > You know, I was about to write a rant about this, until I realized
   > what day it will be soon (or already is, UTC).
   
   CVS is GMT-based.
   
   -- 
     Bruce Momjian  <bruce@momjian.us>        http://momjian.us
     EnterpriseDB                             http://enterprisedb.com
   
   

6. Re: Alias to rollback keyword

   Ross J. Reedstrom <reedstrm@rice.edu> — 2010-04-01T14:39:04Z

   On Wed, Mar 31, 2010 at 10:34:41PM -0400, Bruce Momjian wrote:
   > Matthew Altus wrote:
   > > Hey,
   > > 
   > > After dealing with a production fault and having to rollback all the time, I 
   > > kept typing a different word instead of rollback.  So I created a patch to 
   > > accept this word as an alias for rollback.  Obviously it's not part of the sql 
   > > standard, but could be a nice extension for postgresql.  See the patch for 
   > > more details.
   > 
   > Applied.
   
   Hmm, a careful review of the patch leads me to believe that this is one
   of the few times that a keyword might benefit from localization. Seems
   l10n efforts in this area have mostly focused on the filtering case, but
   I'm sure we can repurose such lists. Licensing might be an issue.
   Clearly this needs to be controlled by the client locale, not the
   server. Any need for a guc? 
   
   Ross
   -- 
   Ross Reedstrom, Ph.D.                                 reedstrm@rice.edu
   Systems Engineer & Admin, Research Scientist        phone: 713-348-6166
   The Connexions Project      http://cnx.org            fax: 713-348-3665
   Rice University MS-375, Houston, TX 77005
   GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E  F888 D3AE 810E 88F0 BEDE