Thanks Alvaro,
I found the reason. The problem was after the table creation.
Anton.
> Anton A. Patrushev wrote:
> > 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 TH
Anton A. Patrushev wrote:
> 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_tm
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 wro
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 wro
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; $$;
C
The following bug has been logged online:
Bug reference: 3648
Logged by: Anton
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5 and 8.1.9
Operating system: CentOS 5 and Xubuntu 7.04
Description:Server crashes when trying to create a table
Details:
I have a
