Обсуждение: Determining Errors

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!

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

http://developer.postgresql.org/docs/postgres/plpgsql-control-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

Very nice!

Thanks, I think I can run with this.



On 10/29/05, Christopher Kings-Lynne <chriskl@familyhealth.com.au> wrote:
> Check example 36-1 at the bottom of this page:
>
> http://developer.postgresql.org/docs/postgres/plpgsql-control-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
>