On Thu, Dec 27, 2012 at 7:27 AM, John Fabiani <[email protected]> wrote: > Hi, > I have the following statement in a function. > > UPDATE orderseq > SET orderseq_number = (orderseq_number + 1) > WHERE (orderseq_name='InvcNumber'); > > All it does is update a single record by incrementing a value (int). > > But it never completes. This has to be some sort of bug. Anyone have a > thought what would cause this to occur. To my knowledge it was working and > does work in other databases.
There are many reasons this may or may not be working. Can you create a self-contained test case that reproduces this issue? -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
