Kristis Makris wrote:
>
> Hello Again,
>
> I've also tried the following from the psql command-line client:
>
> ******************************************************************************************
> wats=# begin;
> BEGIN
> wats=# select vendor_remove(1);
> ERROR: <unnamed> referential integrity violation - key in vendor still
> referenced from vendorforwellagreement
> wats=# commit;
> COMMIT
> ******************************************************************************************
>
> psql reports the error when I issue the SELECT statement, not when I
> issue the commit. Shouldn't I be able to capture an exception when I do
> an ExecuteSQL() from VC++, instead of a CommitTrans() ?
Could you show me a reproducible example ?
regards,
Hiroshi Inoue