SEO

#1 (**permalink**) 04-09-2008, 11:15 PM

What is the proper way for the function of a constraint trigger to signal where or not referential integrity was compromised?

Should it return some sort of value? Should it raise an exception?

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#2 (**permalink**) 04-09-2008, 11:16 PM

On Dec 21, 2007, at 13:12 , Richard Broersma Jr wrote:

> What is the proper way for the function of a constraint trigger to
> signal where or not referential integrity was compromised?
>
> Should it return some sort of value? Should it raise an exception?

The latter.

Michael Glaesemann
grzm seespotcode net

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#3 (**permalink**) 04-09-2008, 11:16 PM

--- On Sat, 12/22/07, Michael Glaesemann <grzm@seespotcode.net> wrote:
> > Should it return some sort of value? Should it raise
> an exception?
>
> The latter.

Thanks Michael!

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Requirements for Constraint Trigger's Function