Bug #3583

pgsql please add more errors in errorCode()

Details

Request #3583	pgsql please add more errors in errorCode()
Submitted	2005-02-24 16:29 UTC
From	brian at onlineinfo dot net
Assigned	danielc
Status	Closed
Package	DB
PHP Version	4.3.10
Roadmaps	(Not assigned)

Comments

[2005-02-24 16:29 UTC] brian at onlineinfo dot net

Description:
------------
The following errors returned by postgres are not mapped in DB_pgsql resulting in 'Unknown error'. Please add support for these error messages.

invalid input syntax for type numeric

column reference "active" is ambiguous

value too long for type character varying(50)

value "50000" is out of range for type shortint

column "p_id" specified in USING clause does not exist in left table

column p.p_name does not exist

[2005-02-24 17:56 UTC] brian at onlineinfo dot net

I am using PostgreSQL 7.4.5

For the following, does the value get inserted anyway but get
truncated, or does the insert fail all together?
value too long for type character varying(50)

The insert fails.

I'm not sure what to put this one under. The closest one I can think of is a syntax error. Your thoughts?
column reference "active" is ambiguous

syntax error seems correct to me.

Thanks for addressing this so promptly!