Re: PostgreSQL 8.3.4 reproducible crash - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: PostgreSQL 8.3.4 reproducible crash
Date
Msg-id 200901061902.n06J2G927529@momjian.us
Whole thread Raw
In response to PostgreSQL 8.3.4 reproducible crash  ("Dmitry Koterov" <dmitry@koterov.ru>)
List pgsql-hackers
Dmitry Koterov wrote:
> Hello.
> 
> Here is the SQL to reproduce the server crash:
> 
> 
> CREATE SCHEMA bug1 AUTHORIZATION postgres;
> 
> SET search_path = bug1, pg_catalog;
> 
> CREATE FUNCTION bug1.domain_check (integer) RETURNS boolean
> AS
> $body$
> SELECT $1 <> 0
> $body$
> LANGUAGE sql IMMUTABLE STRICT;
> 
> CREATE DOMAIN bug1."domain" AS integer
>         CONSTRAINT "check" CHECK (bug1.domain_check(VALUE));
> 
> CREATE TYPE bug1.composite AS (
>   id domain
> );
> 
> select '(1)'::bug1.composite;

This has been fixed in CVS HEAD but I am unsure if and how far it was
backpatched.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Is it really such a great idea for spi.h to include the world?
Next
From: Martin Pihlak
Date:
Subject: Re: dblink vs SQL/MED - security and implementation details