From: Tom Lane <tgl@sss.pgh.pa.us>
To: Karen Huddleston <khuddleston@pivotal.io>
cc: pgsql-bugs@postgreSQL.org
Subject: Re: BUG #14706: Dependencies not recorded properly for base types
In-reply-to: 
 <CADewMCny3SSoUsWnXAT9sV=B2mj4HTY6gVCWgvm1AD35eg-LJA@mail.gmail.com>
References: <20170614232259.1424.82774@wrigleys.postgresql.org>
 <22824.1497487336@sss.pgh.pa.us>
 <CADewMCny3SSoUsWnXAT9sV=B2mj4HTY6gVCWgvm1AD35eg-LJA@mail.gmail.com>
Comments: In-reply-to Karen Huddleston <khuddleston@pivotal.io>
	message dated "Wed, 14 Jun 2017 17:50:50 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <23629.1497488548.1@sss.pgh.pa.us>
Date: Wed, 14 Jun 2017 21:02:28 -0400
Message-ID: <23630.1497488548@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

Karen Huddleston <khuddleston@pivotal.io> writes:
> I didn't actually realize it was deprecated style. I'm not super familiar
> with the syntax for creating types and functions. Which part is deprecated
> and what should it be instead?

The way you're supposed to make a new type nowadays is

CREATE TYPE base_type;   -- make a shell type

CREATE FUNCTION base_fn_in(cstring) returns base_type as ...
CREATE FUNCTION base_fn_out(base_type) returns cstring as ...

-- convert shell to real type
CREATE TYPE base_type(input=base_fn_in, output=base_fn_out);

In this way the function signatures are legal from the get-go,
and the dependencies are right too.  The business with "opaque"
as a placeholder has been deprecated for circa 15 years; did
you find that example in any modern documentation?

			regards, tom lane


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