php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Request #74781 Add the latest PG_DIAG_* const
Submitted: 2017-06-19 13:44 UTC Modified: 2017-08-17 19:07 UTC
Votes:1
Avg. Score:2.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: qschuler at neosyne dot com Assigned: kalle (profile)
Status: Closed Package: PostgreSQL related
PHP Version: 7.2.0alpha1 OS:
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: qschuler at neosyne dot com
New email:
PHP Version: OS:

 

 [2017-06-19 13:44 UTC] qschuler at neosyne dot com 
Description:
------------
The function pg_result_error_field uses some PGSQL_DIAG_* to get information about an error thrown by the database. The existing constants are:

PG_DIAG_SEVERITY
PG_DIAG_SQLSTATE
PG_DIAG_MESSAGE_PRIMARY
PG_DIAG_MESSAGE_DETAIL
PG_DIAG_MESSAGE_HINT
PG_DIAG_STATEMENT_POSITION
PG_DIAG_INTERNAL_POSITION
PG_DIAG_INTERNAL_QUERY
PG_DIAG_CONTEXT
PG_DIAG_SOURCE_FILE
PG_DIAG_SOURCE_LINE
PG_DIAG_SOURCE_FUNCTION

Some other constants has been added since PostgreSQL 9.3:

PG_DIAG_SCHEMA_NAME
PG_DIAG_TABLE_NAME
PG_DIAG_COLUMN_NAME
PG_DIAG_DATATYPE_NAME
PG_DIAG_CONSTRAINT_NAME

And since PostgreSQL 9.6:

PG_DIAG_SEVERITY_NONLOCALIZED

Could we add the this new constants in order to improve the error messages?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2017-08-17 19:07 UTC] kalle@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: kalle
 [2017-08-17 19:07 UTC] kalle@php.net 
I implemented these in master (7.3), its all up to the 7.2 RMs if this should be merged
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jul 30 15:00:03 2025 UTC