Re: Incorrect type in pg_cast causes Postmaster to core dump

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Greg Clough <greg(dot)clough(at)enterprisedb(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Incorrect type in pg_cast causes Postmaster to core dump
Date: 2017-04-21 13:26:09
Message-ID: CAB7nPqScwANUo3=pgu94Obve4VYZMKOkj=a+LkC6zKF4-oWiRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Apr 21, 2017 at 7:28 PM, Greg Clough
<greg(dot)clough(at)enterprisedb(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-04-21 14:36:15 Re: Incorrect type in pg_cast causes Postmaster to core dump
Previous Message Irina Mileva 2017-04-21 11:40:54 ON CONFLICT issie detected