| 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 04:11:27 |
| Message-ID: | 1191471087.3357.55.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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 THEN
> > END;
> >
> > CREATE TABLE vertices_tmp ( id serial );
> >
> > ...
>
> It still works for me. Can you try my function on your system? Does it
> crash?
>
> create or replace function test_anton() returns void language plpgsql
> as $$
> begin
> begin
> drop table anton;
> exception
> when undefined_table then
> end;
> create table anton(a serial);
> end; $$;
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Kleemann | 2007-10-04 16:11:40 | BUG #3652: quiet / VERBOSITY=terse does not silence PKEY NOTICE message |
| Previous Message | Alvaro Herrera | 2007-10-04 02:41:54 | Re: BUG #3648: Server crashes when trying to create a table |