From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | "Jiri Skopik/8BC Ltd(dot)" <skopik(at)8bc(dot)com> |
Subject: | bug in dependency - there is possibility to break a system catalog |
Date: | 2011-10-03 10:47:58 |
Message-ID: | CAFj8pRDtP6XJAJNcv41kr4wQvUK+AqwPDwT2p1amQM-Ho3O_4w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello
our customer reported a broken system dictionary. The following
statements breaks a catalog:
postgres=# CREATE TYPE test_type AS (a integer, b integer);
CREATE TYPE
Time: 61,016 ms
postgres=#
postgres=# CREATE FUNCTION test_func (variadic x text[] =
'{NULL}'::"test_type"[])
postgres-# RETURNS pg_catalog.void AS $body$ BEGIN END; $body$
LANGUAGE 'plpgsql';
CREATE FUNCTION
Time: 24,637 ms
postgres=#
postgres=# DROP TYPE test_type;
DROP TYPE
Time: 6,824 ms
postgres=# \df
ERROR: cache lookup failed for type 16579
postgres=# select version();
version
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────
PostgreSQL 9.2devel on x86_64-unknown-linux-gnu, compiled by gcc
(GCC) 4.6.0 20110603 (Red Hat 4.6.0-10), 64-bit
(1 row)
Time: 2,021 ms
postgres=#
Regards
Pavel Stehule
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Holec | 2011-10-03 11:42:21 | Re: BUG #6233: pg_dump hangs with Access Violation C0000005 |
Previous Message | Thomas Kellerer | 2011-10-03 08:42:08 | Re: [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe |