On Tue, Jan 6, 2015 at 12:39 AM, Manuel Kniep <man...@adjust.com> wrote:
> Hi,
>
> we are running postges 9.3.5 on gentoo linux kernel 3.16.5, compiled with gcc
> 4.8.3
> Any ideas ?
> #17 0x000000000062bb9d in SPI_execute_with_args (
src=0x22b880bb0 "\n CREATE TEMPORARY TABLE
> [...]
> #33 0x00007f363555ab97 in plpgsql_exec_function (func=0xd888c8,
> fcinfo=0x7ffffaa89a60) at pl_exec.c:321
> #34 0x00007f36355552be in plpgsql_call_handler (fcinfo=0x7ffffaa89a60) at
> pl_handler.c:129
> [...]
> #46 0x000000000072e4eb in exec_simple_query (
> query_string=0xd633b0 "SELECT 'event' as item, '2014-12-30' as date,
> 'Backends::Backend9' as backend, '33' as bucket, * FROM
> materialize_events('2014-11-20', '2014-12-30')") at postgres.c:1048
>From the backtrace you are showing, you are creating a temporary table
with CREATE TABLE AS within a plpgsql function. Could you provide a
self-contained test case?
--
Michael
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
