Re: CREATE DOMAIN json vs built-in json

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE DOMAIN json vs built-in json
Date: 2012-03-20 13:52:56
Message-ID: 24204.1332251576@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> writes:
> I've noticed our plv8 regression test now fails. It has CREATE DOMAIN
> json AS text ... and validates text via v8's JSON.parse(), which was
> working before introducing built-in json type. The test itself can be
> solved simply by creating schema, but my surprise is that we allow a
> domain whose name is the same as other base type. Is it intentional?

Sure. The built-in type is in the pg_catalog schema, but your domain
is (most likely) being created in the public schema.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2012-03-20 14:44:21 Re: Error trying to compile a simple C trigger
Previous Message Tom Lane 2012-03-20 13:31:28 Re: Memory usage during sorting