On 6/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Jaime Casanova wrote:
> On 6/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Tue, Jun 13, 2006 at 04:28:47PM -0400, [EMAIL PROTECTED] wrote:
>> Does pg_get_serial_sequence() exist as plpgsql code? Where may I find
>> it? I would like to retrofit it into a 7.4.8 PG database.
> No, but it shouldn't be terribly hard to do it
On Tue, Jun 13, 2006 at 04:28:47PM -0400, [EMAIL PROTECTED] wrote:
> Does pg_get_serial_sequence() exist as plpgsql code? Where may I find
> it? I would like to retrofit it into a 7.4.8 PG database.
No, but it shouldn't be terribly hard to do it in plpgsql; you just need
to build the right sequ
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 04:51:18PM -0400, [EMAIL PROTECTED] wrote:
I am trying to move some data from an 8.0.7 instance to a 7.4.8
instance. I did a pg_dump and then did a pg_restore.
For the most part the data transferred through to the older instance but
I h
Jaime Casanova wrote:
On 6/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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