capturing errors
am 29.01.2010 17:06:03 von Jaime Casanova--0015174c0c38e7b01a047e4fd00b
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Hi,
I'm trying to capture the error from php to show an informative
message to the user but i haven't managed to get it...
i'm using pg_result_error_field() but when i print it i get nothing,
is there something i have to configure or what i'm doing bad.
attached a little php script for testing and here is the schema the
script is using (obviously the error i'm trying to catch here is
unique violation)
"""
create table t1_fk1(col1 integer primary key);
insert into t1_fk1 values(1);
"""
--=20
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
AsesorÃa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--0015174c0c38e7b01a047e4fd00b
Content-Type: application/x-php; name="prueba.php"
Content-Disposition: attachment; filename="prueba.php"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_g51639nj0
PD9waHAKCSRkYmNvbm4gPSBwZ19jb25uZWN0KCJkYm5hbWU9cHJ1ZWJhcyBo
b3N0PWxvY2FsaG9zdCB1c2VyPXBvc3RncmVzIHBhc3N3b3JkPXBvc3RncmVz
Iik7CgoJJHJlc3VsdCA9IEBwZ19xdWVyeSgkZGJjb25uLCAiaW5zZXJ0IGlu
dG8gdDFfZmsxIHZhbHVlcyAoMSkiKTsKIAkkc3FsX3N0YXRlID0gcGdfcmVz
dWx0X2Vycm9yX2ZpZWxkKCRyZXN1bHQsIFBHU1FMX0RJQUdfU1FMU1RBVEUp
OwoJZWNobyAkc3FsX3N0YXRlOwoJaWYgKCEkcmVzdWx0KSB7CgkJJHJlczEg
PSBwZ19nZXRfcmVzdWx0KCRkYmNvbm4pOwoJCWVjaG8gcGdfcmVzdWx0X2Vy
cm9yX2ZpZWxkKCRyZXMxLCBQR1NRTF9ESUFHX1NFVkVSSVRZKTsKCQllY2hv
IHBnX3Jlc3VsdF9lcnJvcl9maWVsZCgkcmVzMSwgUEdTUUxfRElBR19TUUxT
VEFURSk7CiAgICAgICAgZWNobyBwZ19yZXN1bHRfZXJyb3JfZmllbGQoJHJl
czEsIFBHU1FMX0RJQUdfTUVTU0FHRV9QUklNQVJZKTsKICAgICAgICBlY2hv
IHBnX3Jlc3VsdF9lcnJvcl9maWVsZCgkcmVzMSwgUEdTUUxfRElBR19NRVNT
QUdFX0RFVEFJTCk7CiAgICAgICAgZWNobyBwZ19yZXN1bHRfZXJyb3JfZmll
bGQoJHJlczEsIFBHU1FMX0RJQUdfTUVTU0FHRV9ISU5UKTsKICAgICAgICBl
Y2hvIHBnX3Jlc3VsdF9lcnJvcl9maWVsZCgkcmVzMSwgUEdTUUxfRElBR19T
VEFURU1FTlRfUE9TSVRJT04pOwogICAgICAgIGVjaG8gcGdfcmVzdWx0X2Vy
cm9yX2ZpZWxkKCRyZXMxLCBQR1NRTF9ESUFHX0lOVEVSTkFMX1BPU0lUSU9O
KTsKICAgICAgICBlY2hvIHBnX3Jlc3VsdF9lcnJvcl9maWVsZCgkcmVzMSwg
UEdTUUxfRElBR19JTlRFUk5BTF9RVUVSWSk7CiAgICAgICAgZWNobyBwZ19y
ZXN1bHRfZXJyb3JfZmllbGQoJHJlczEsIFBHU1FMX0RJQUdfQ09OVEVYVCk7
CiAgICAgICAgZWNobyBwZ19yZXN1bHRfZXJyb3JfZmllbGQoJHJlczEsIFBH
U1FMX0RJQUdfU09VUkNFX0ZJTEUpOwogICAgICAgIGVjaG8gcGdfcmVzdWx0
X2Vycm9yX2ZpZWxkKCRyZXMxLCBQR1NRTF9ESUFHX1NPVVJDRV9MSU5FKTsK
ICAgICAgICBlY2hvIHBnX3Jlc3VsdF9lcnJvcl9maWVsZCgkcmVzMSwgUEdT
UUxfRElBR19TT1VSQ0VfRlVOQ1RJT04pOyAKCX0KPz4K
--0015174c0c38e7b01a047e4fd00b
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
--=20
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
--0015174c0c38e7b01a047e4fd00b--