On Tue, Nov 18, 2008 at 1:25 PM, Craig Ringer <[EMAIL PROTECTED]>wrote:
> > > You can use savepoints (see the manual) to recover from errors, though > they have some issues if you use hundreds of thousands of savepoints in > a single transaction. It's much better to check the data on INSERT to > make sure it's OK. You can do this with an INSERT ... SELECT (and check > the rowcount), with a PL/PgSQL function that returns a result value, do > it client-side, etc. > can you post an example ? would that also resolve problem with 'rowcount' left unset, if trigger or rule is used on table ? -- GJ
