ecpg problem - Mailing list pgsql-hackers

From Dr. Michael Meskes
Subject ecpg problem
Date
Msg-id 19980814104901.A1022@online-club.de
Whole thread Raw
Responses Re: [HACKERS] ecpg problem  (Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>)
List pgsql-hackers
I just found this one on my TODO list:

The error message for "no data" in an exec sql insert select from statement
has to be 100.

It seems I cannot get that kind of information from libpq other than
checking for the result being 0 tuples. But is this correct? Or are there
possibilities to get 0 tuples? That is I get PQcmdTuples(results) = 0 with
the return code being PGRES_COMMAND_OK.

Also I wonder if PGRES_COMMAND_OK could come from other statements for which
setting the not found marker makes no sense. I think it does make sense for
insert, delete and update.

On the other hand returning NOT_FOUND on other commands doesn't do hany harm
though since the whenever not found isn't checked for other commands.

Michael
--
Dr. Michael Meskes        meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!    Use Debian GNU/Linux!

pgsql-hackers by date:

Previous
From: "Dr. Michael Meskes"
Date:
Subject: Define command
Next
From: Lendvary Gyorgy
Date:
Subject: Transactions