SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 09:13 PM
| ||||
| ||||
 Status of interactive psql's error handling? What's the current status on psql handling typos and interrupts more usefully by automatically encapsulating every statement in a savepoint? I'm just curious whether it's already in for 8.1 or if it got stalled. I ask because I just got bit again by a typo where I accidently deleted the wrong data and would dearly love to be able to start using autocommit=off so I can double check my ad-hoc database work before committing. I adopted this when I was working with Oracle and it saved my life more times than I can remember. But it's really not feasible if every typo requires starting from scratch. -- greg ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
|
04-08-2008, 09:13 PM
| ||||
| ||||
| Re: Status of interactive psql's error handling? Greg Stark wrote: > > What's the current status on psql handling typos and interrupts more usefully > by automatically encapsulating every statement in a savepoint? I'm just > curious whether it's already in for 8.1 or if it got stalled. > > I ask because I just got bit again by a typo where I accidently deleted the > wrong data and would dearly love to be able to start using autocommit=off so I > can double check my ad-hoc database work before committing. I adopted this > when I was working with Oracle and it saved my life more times than I can > remember. But it's really not feasible if every typo requires starting from > scratch. psql in 8.1 will have: \set ON_ERROR_ROLLBACK interactive -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
Linear Mode
