By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,663 Members | 1,375 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,663 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.