pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Determining Errors
3+ messages / 2 participants
[nested] [flat]

* Determining Errors
@ 2005-10-30 03:17 Mag Gam <magawake@gmail.com>
  2005-10-30 04:58 ` Re: Determining Errors Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 1 reply; 3+ messages in thread

From: Mag Gam @ 2005-10-30 03:17 UTC (permalink / raw)
  To: pgsql-php

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!


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Determining Errors
  2005-10-30 03:17 Determining Errors Mag Gam <magawake@gmail.com>
@ 2005-10-30 04:58 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2005-10-30 13:46   ` Re: Determining Errors Mag Gam <magawake@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Christopher Kings-Lynne @ 2005-10-30 04:58 UTC (permalink / raw)
  To: Mag Gam <magawake@gmail.com>; +Cc: pgsql-php

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Determining Errors
  2005-10-30 03:17 Determining Errors Mag Gam <magawake@gmail.com>
  2005-10-30 04:58 ` Re: Determining Errors Christopher Kings-Lynne <chriskl@familyhealth.com.au>
@ 2005-10-30 13:46   ` Mag Gam <magawake@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Mag Gam @ 2005-10-30 13:46 UTC (permalink / raw)
  To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: pgsql-php

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
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-10-30 13:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-30 03:17 Determining Errors Mag Gam <magawake@gmail.com>
2005-10-30 04:58 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-10-30 13:46   ` Mag Gam <magawake@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox