From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | dmitry(at)koterov(dot)ru |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PostgreSQL 8.3.4 reproducible crash |
Date: | 2009-01-06 19:02:16 |
Message-ID: | 200901061902.n06J2G927529@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Pihlak | 2009-01-06 19:04:11 | Re: dblink vs SQL/MED - security and implementation details |
Previous Message | Bruce Momjian | 2009-01-06 18:56:18 | Re: Is it really such a great idea for spi.h to include the world? |