Thread: confirmation of insert/update

confirmation of insert/update

From
Pruner Jan
Date:
hi,
    I've got a text file with exported tuples from various tables
(export from Sybase Anywhere).
Some of these values are for insert, some for update => I cannot use COPY.
How can I get confirmation, that insert/update was successful?
Is there something like @@error in postgresql?

Thanks,

Jan Pruner

Re: confirmation of insert/update

From
Peter Eisentraut
Date:
Pruner Jan writes:

> Some of these values are for insert, some for update => I cannot use COPY.
> How can I get confirmation, that insert/update was successful?
> Is there something like @@error in postgresql?

Each client interface has its own way of reporting errors.  See the
documentation of the interface you're using.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter