7.4 ERROR: CREATE LOCAL TEMPORARY TABLE ... ON COMMIT DROP inside a function

[ezra epstein]

I found a post about something similar in an older release:
http://archives.postgresql.org/pgsql...8/msg00151.php

Here's the issue. Inside a function I'm calling
CREATE LOCAL TEMPORARY TABLE ds_copy_item_meta ( LIKE
merchandise.item_meta EXCLUDING DEFAULTS ) on COMMIT DROP;

Of course it might be that the ON COMMIT DROP is redundant, I don't know
enough about temp tables. Here's the problem, however, the first call of
the table works fine. The second call it complains about a bad OID. Could
it be that the bug that was fixed for regular temporary tables (without an
on commit modifier) somehow didn't get fixed for this construct?

The work-around has been to just not use the modifier, but I was surprised
by the OID error and think it might be incorrect behavior.

== Ezra Epstein.

[ezra epstein]

Typo, see below:

"ezra epstein" <ee***************@prajnait.com> wrote in message
news:xl********************@speakeasy.net...

I found a post about something similar in an older release:
http://archives.postgresql.org/pgsql...8/msg00151.php

Here's the issue. Inside a function I'm calling
CREATE LOCAL TEMPORARY TABLE ds_copy_item_meta ( LIKE
merchandise.item_meta EXCLUDING DEFAULTS ) on COMMIT DROP;

Of course it might be that the ON COMMIT DROP is redundant, I don't know
enough about temp tables. Here's the problem, however, the first call of
the table works fine. The second call it complains about a bad OID. Could

that should read: the first call of the function.
it be that the bug that was fixed for regular temporary tables (without an
on commit modifier) somehow didn't get fixed for this construct?

The work-around has been to just not use the modifier, but I was surprised
by the OID error and think it might be incorrect behavior.

== Ezra Epstein.