Very nice! Thanks, I think I can run with this. On 10/29/05, Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx> 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> ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
