Re: temp sequence

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: temp sequence
Date: 2010-05-05 13:31:23
Message-ID: addd90641985f84c6eb95a9c84299d7c@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> 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.

This last bit is probably solveable: can you post the code? You should be
able to cast the other side if not the array itself.

If you are inside a function, you already have built in iteration tools,
so you may not even need to use a sequence at all. Again, seeing some
code would go a long way here.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201005050928
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkvhcwIACgkQvJuQZxSWSshkmACgtAXOeMoRaED4hKMk3SCHS4bf
cDIAoNvJnWZ+FtNUZiUXm7YCW8gksZuu
=DU+w
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-05-05 13:57:00 Re: database Benchmark, TPC, PostgreSQL and TPC-E
Previous Message Scott Marlowe 2010-05-05 12:52:45 Re: temp sequence