Re: PLPGSQL/EXCEPTION HANDLING

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 6/12/06, renneyt@xxxxxxxxx <renneyt@xxxxxxxxx> wrote:
In a function implemented in 7.4.8 I had the following error when I call
the function:

ERROR:  syntax error at or near "EXCEPTION"

Offending line is:
    EXCEPTION WHEN dup_val_on_index THEN NULL;

When this line is removed, all is well.


that's because that construction was added in 8.0, you have to upgrade to use it

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                      Richard Cook


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux