Determining Errors

SXMgdGhlcmUgYSB3YXkgdG8gYXZvaWQgdGhpcyBlcnJvci93YXJuaW5nICBt
ZXNzYWdlCgpXYXJuaW5nOiBwZ19xdWVyeSgpOiBRdWVyeSBmYWlsZWQ6IEVS
Uk9SOiBkdXBsaWNhdGUga2V5IHZpb2xhdGVzCnVuaXF1ZSBjb25zdHJhaW50
ICJjYXRlZ29yeV9uYW1lX2tleSIgaW4gZm9vLnBocCBvbiBsaW5lIDEyCgpJ
IHdvdWxkIGxpa2Ugc29tZXRoaW5nIGxpa2UsIHRoaXMgYWxyZWFkeSBleGlz
dHMsIHBsZWFzZSByZXRyeS4KU29tZXRoaW5nIHNpbXBsZSBsaWtlIHRoYXQu
Li4uCkV2ZW4gYSBwb3B1cCBib3ggd291bGQgYmUgbmljZSB3aGVuIHByZXNz
ICdzdWJtaXQnIGJ1dHRvbi4KCgpUSUEhCgotLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0oZW5kIG9mIGJyb2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0KVElQIDU6IGRvbid0IGZvcmdldCB0byBpbmNyZWFzZSB5b3Vy
IGZyZWUgc3BhY2UgbWFwIHNldHRpbmdzCg==

Re: Determining Errors

Check example 36-1 at the bottom of this page:

http://developer.postgresql.org/docs/postgres/plpgsql-contro l-structures.html#PLPGSQL-ERROR-TRAPPING

Chris

Mag Gam wrote:
> Is there a way to avoid this error/warning message
>
> Warning: pg_query(): Query failed: ERROR: duplicate key violates
> unique constraint "category_name_key" in foo.php on line 12
>
> I would like something like, this already exists, please retry.
> Something simple like that....
> Even a popup box would be nice when press 'submit' button.
>
>
> TIA!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Determining Errors

VmVyeSBuaWNlIQoKVGhhbmtzLCBJIHRoaW5rIEkgY2FuIHJ1biB3aXRoIHRo
aXMuCgoKCk9uIDEwLzI5LzA1LCBDaHJpc3RvcGhlciBLaW5ncy1MeW5uZSA8
Y2hyaXNrbEBmYW1pbHloZWFsdGguY29tLmF1PiB3cm90ZToKPiBDaGVjayBl
eGFtcGxlIDM2LTEgYXQgdGhlIGJvdHRvbSBvZiB0aGlzIHBhZ2U6Cj4KPiBo
dHRwOi8vZGV2ZWxvcGVyLnBvc3RncmVzcWwub3JnL2RvY3MvcG9zdGdyZXMv
cGxwZ3NxbC1jb250cm9sLXN0cnVjdHVyZXMuaHRtbCNQTFBHU1FMLUVSUk9S
LVRSQVBQSU5HCj4KPiBDaHJpcwo+Cj4gTWFnIEdhbSB3cm90ZToKPiA+IElz
IHRoZXJlIGEgd2F5IHRvIGF2b2lkIHRoaXMgZXJyb3Ivd2FybmluZyAgbWVz
c2FnZQo+ID4KPiA+IFdhcm5pbmc6IHBnX3F1ZXJ5KCk6IFF1ZXJ5IGZhaWxl
ZDogRVJST1I6IGR1cGxpY2F0ZSBrZXkgdmlvbGF0ZXMKPiA+IHVuaXF1ZSBj
b25zdHJhaW50ICJjYXRlZ29yeV9uYW1lX2tleSIgaW4gZm9vLnBocCBvbiBs
aW5lIDEyCj4gPgo+ID4gSSB3b3VsZCBsaWtlIHNvbWV0aGluZyBsaWtlLCB0
aGlzIGFscmVhZHkgZXhpc3RzLCBwbGVhc2UgcmV0cnkuCj4gPiBTb21ldGhp
bmcgc2ltcGxlIGxpa2UgdGhhdC4uLi4KPiA+IEV2ZW4gYSBwb3B1cCBib3gg
d291bGQgYmUgbmljZSB3aGVuIHByZXNzICdzdWJtaXQnIGJ1dHRvbi4KPiA+
Cj4gPgo+ID4gVElBIQo+ID4KPiA+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLQo+ID4gVElQIDU6IGRvbid0IGZvcmdldCB0byBpbmNyZWFzZSB5b3Vy
IGZyZWUgc3BhY2UgbWFwIHNldHRpbmdzCj4KCi0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLShlbmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLQpUSVAgMjogRG9uJ3QgJ2tpbGwgLTknIHRoZSBwb3N0bWFz
dGVyCg==