bug in dependency - there is possibility to break a system catalog

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

Responses

Browse pgsql-bugs by date

  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