Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sat, 2015-10-03 at 08:18 -0400, Steve Petrie, P.Eng. wrote:
> Greetings To <pgsql-general@xxxxxxxxxxxxxx>:
>  
> 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



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux