Re: BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?

On Sat, 2015-10-03 at 08:18 -0400, Steve Petrie, P.Eng. wrote:
> Greetings To <pgsql-general(at)postgresql(dot)org>:
>
> I am migrating a PHP web application to use PostgreSQL instead of
> MySQL.
>
> And I have never used PostgreSQL before.
>
> I have two questions about function pg_result_error_field(...);
>
> An extensive search of the web, did not yield a solution to my
> problem.
>
> * * *
> * * *
>
> My PHP program is using the PHP pg_* PostgreSQL functions.
>
> The test environment is Windows XP SP3 with: PostgreSQL 9.3, Apache
> 2.2.14 and PHP 5.3.1.
>
> The file php.ini has a line extension = php_pgsql.dll
>
> phpinfo() shows (when my PHP program is not running):
> ...
> pgsql
> PostgreSQL Support enabled
> PostgreSQL(libpq) Version 8.4.1
> Multibyte character support enabled
> SSL support enabled
> Active Persistent Links 0
> Active Links 0
>

I'm a Linux user. However, libpq version 8.4.1 doesn't jell with
version 9.3 of PostgreSql.

So, are you trying to obtain the failure "reason" when a "BEGIN",
"COMMIT" or "ROLLBACK" fails?

Cheers,
Rob