PG Bug reporting form <noreply@postgresql.org> writes:
> The following causes the server to close unexpectedly.
> CREATE TYPE char_type;
> CREATE FUNCTION char_type_in(cstring) RETURNS char_type
> LANGUAGE internal IMMUTABLE STRICT AS 'charin';
> CREATE FUNCTION char_type_out(char_type) RETURNS cstring
> LANGUAGE internal IMMUTABLE STRICT AS 'charout';
> CREATE TYPE char_type (
> INPUT = char_type_in,
> OUTPUT = char_type_out,
> LIKE = char
> );
> CREATE TABLE char_table (t char_type);
> INSERT INTO char_table (t)
> VALUES ('t');
This is pilot error, not a server bug: you created a type that's
not compatible with the I/O functions you provided for it.
Admittedly, it's a bit of a gotcha: "LIKE = char" interprets
char as bpchar, a/k/a the SQL CHAR(n) type. But the internal
charin and charout functions are for the single-byte "char"
type. If we didn't have a couple decades worth of backward
compatibility to think about, we'd likely rename the latter
type, since it's a Postgres-ism not standard.
regards, tom lane
