Re: [BUGS] Incorrect type in pg_cast causes Postmaster to core dump - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: [BUGS] Incorrect type in pg_cast causes Postmaster to core dump
Date
Msg-id CAB7nPqScwANUo3=pgu94Obve4VYZMKOkj=a+LkC6zKF4-oWiRw@mail.gmail.com
Whole thread Raw
In response to [BUGS] Incorrect type in pg_cast causes Postmaster to core dump  (Greg Clough <greg.clough@enterprisedb.com>)
List pgsql-bugs
On Fri, Apr 21, 2017 at 7:28 PM, Greg Clough
<greg.clough@enterprisedb.com> wrote:
> postgres=# INSERT INTO pg_cast (castsource, casttarget, castfunc,
> castcontext, castmethod) VALUES (16,1700,16384,'a','f');
> INSERT 16385 1

You should never, *ever* manipulate catalog tables manually. There is
a DDL command called CREATE CAST, better to use it.
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Irina Mileva
Date:
Subject: [BUGS] ON CONFLICT issie detected
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Incorrect type in pg_cast causes Postmaster to core dump