From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: temp sequence |
Date: | 2010-05-05 12:52:45 |
Message-ID: | t2wdcc563d11005050552t361587cem1ae1b751ab26b86a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/5/5 Sim Zacks <sim(at)compulab(dot)co(dot)il>:
> I am using 8.2.14
>
> I am trying to use a temp sequence in a function and I'm having a lot of
> trouble.
> I create the temp sequence and then I have to drop it at the end of the
> function, because it stays alive for the whole session and not just the
> function.
> I want to use the nextval function in an update statement so it gives a
> sequence number to each row it updates.
> If I drop the sequence and recreate it I get an OID not found error.
> I tried to run the update statement dynamically, but part of the update
> stmt is an int array variable and it won't cast it to text.
>
> My goal in the end is that every row that is updated will be numbered
> sequentially per update.
>
> Do you have any ideas?
Can you manipulate the sequence instead of dropping it? i.e. select
setval('seqname',1); kind of thing?
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2010-05-05 13:31:23 | Re: temp sequence |
Previous Message | Scott Marlowe | 2010-05-05 12:51:18 | Re: alter table alter type CASCADE |