pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedDetermining 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