Manage pgsql exception in php

Question

I use Postgres DB 8.4, PHP 5 and php5-pgsql. How can I handle pgsql exceptions and sql error code? I read that php library does not handle pgsql error codes.

Frank Heikens · Accepted Answer · 2011-03-10 18:39:46Z

1

I read that php library does not handle pgsql error codes.

Who told you that? That person has never read any manual because PHP has great support for error handling in combination with PostgreSQL and it's all in the fine manual.

Use pg_result_error() and you will see that you get all the details about what happend. If you're using stored procedures and these throw custom error messages and/or hints to solve the problem, you will get these as well.

The error codes you will catch, can be found in the PostgreSQL manual.

edited Mar 10, 2011 at 18:39

answered Mar 10, 2011 at 17:39

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

teosantoro Over a year ago

Thanks, pg_send_query() and pg_result_error_field() is exactly what I wanted.

Collectives™ on Stack Overflow

Manage pgsql exception in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related