From: | "Anton A(dot) Patrushev" <anton(at)orkney(dot)co(dot)jp> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3648: Server crashes when trying to create a table |
Date: | 2007-10-04 00:47:07 |
Message-ID: | 1191458827.3357.50.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Alvaro,
In the function I'm trying to drop this table if it already exists:
BEGIN
DROP TABLE vertices_tmp;
EXCEPTION
WHEN UNDEFINED_TABLE THEN
END;
CREATE TABLE vertices_tmp ( id serial );
...
Thanks,
Anton.
> Anton wrote:
>
> >
> > CREATE TABLE vertices_tmp(id serial);
> >
> > It's working fine with PostgreSQL 8.2.4 but crashes with segfault at
> > versions 8.1.9 and 8.2.5.
>
> Works for me:
>
> alvherre=# create function test_anton() returns void language plpgsql as $$ begin create table anton(a serial); end; $$;
> CREATE FUNCTION
> alvherre=# select test_anton();
> NOTICE: CREATE TABLE will create implicit sequence "anton_a_seq" for serial column "anton.a"
> CONTEXT: SQL statement "create table anton(a serial)"
> PL/pgSQL function "test_anton" line 1 at SQL statement
> test_anton
> ------------
>
> (1 row)
>
> alvherre=# select version();
> version
> ---------------------------------------------------------------------------------------------------------------------------
> PostgreSQL 8.2.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc-4.1 (GCC) 4.1.3 20070831 (prerelease) (Debian 4.1.2-16)
> (1 row)
>
> My guess is you are doing something else on the function that you
> aren't showing. Whatever you do after the CREATE TABLE perhaps.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Anton A. Patrushev | 2007-10-04 01:00:09 | Re: BUG #3648: Server crashes when trying to create a table |
Previous Message | Tom Lane | 2007-10-03 17:33:58 | Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field |