Обсуждение: confirmation of insert/update

Поиск
Список
Период
Сортировка

confirmation of insert/update

От
Pruner Jan
Дата:
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

От
Peter Eisentraut
Дата:
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