On Fri, Jul 12, 2002 at 07:19:58AM -0400, [EMAIL PROTECTED] wrote:
> Long Description
> It looks as if automatic created indexes can in some cases not be referenced to
>because long names are truncated. See example SQL statement below.
There's a typo in your statement.
The sequence name gets tr
val
-
7
(1 row)
So 'currval' increased due to an INSERT that was aborted.
(Yes, the insert is definately not in the table).
I'm not sure if one can call this a bug, but it is unexpected behaviour
-- to me, at least.
Regards,
Hugo Jonker.
PS: My apologies about