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

From rob stone
Subject Re: BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?
Date
Msg-id 1443894860.6721.3.camel@gmail.com
Whole thread Raw
In response to BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value?  ("Steve Petrie, P.Eng." <apetrie@aspetrie.net>)
List pgsql-general
On Sat, 2015-10-03 at 08:18 -0400, Steve Petrie, P.Eng. wrote:
> Greetings To <pgsql-general@postgresql.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



pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Replication with 9.4
Next
From: Madovsky
Date:
Subject: Re: Replication with 9.4