Re: BUG #3662: Seems that more than one run of a functions causes an error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3662: Seems that more than one run of a functions causes an error
Date
Msg-id 28005.1192061537@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3662: Seems that more than one run of a functions causes an error  ("Robins Tharakan" <tharakan@gmail.com>)
List pgsql-bugs
Oh, there's another solution I forgot to mention: you could write the
nextval call as
    nextval('s'::text)
which would force a runtime lookup of 's' on each call.  On the whole
though, numbering the rows yourself with a local counter is going to
run a lot faster.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3662: Seems that more than one run of a functions causes an error
Next
From: "huanghongdong"
Date:
Subject: BUG #3669: cann't use UTF8 as server side encoding