...

I'm trying to do some error handling with  Postgres, ie.=20
Query failed: ERROR: Cannot insert a duplicate key into a unique index=20

I know what the problem is but don't know how to handle the error.

In Oracle pl/sql I would use 'exception <error#> | <error msg>'

but with postgres and can't find any doc on how to work around this.

Any help would be greatly appreciated.

Doug...

doug@the-bridge.net