Type modifiers for DOMAIN
От
Takahiro Itagaki
Тема
Type modifiers for DOMAIN
Дата
Msg-id
20100106151213.96F9.52131E4D@oss.ntt.co.jp
Список
Дерево обсуждения
Type modifiers for DOMAIN Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Type modifiers for DOMAIN Tom Lane <tgl@sss.pgh.pa.us>
Re: Type modifiers for DOMAIN Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Bug with PATHs having non-ASCII characters Chuck McDevitt <cmcdevitt@greenplum.com>
Re: Bug with PATHs having non-ASCII characters Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Bug with PATHs having non-ASCII characters Magnus Hagander <magnus@hagander.net>
Re: Bug with PATHs having non-ASCII characters Alvaro Herrera <alvherre@commandprompt.com>
Re: Bug with PATHs having non-ASCII characters Greg Stark <gsstark@mit.edu>
Re: Type modifiers for DOMAIN Jaime Casanova <jcasanov@systemguards.com.ec>
Re: Type modifiers for DOMAIN "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Type modifiers for DOMAIN Josh Berkus <josh@agliodbs.com>
Hi, I'm trying to use DOMAIN as just synonym types for database migration. For example, =# CREATE DOMAIN varchar2 AS pg_catalog.varchar; =# CREATE DOMAIN number AS pg_catalog.numeric; Domains were created successfully, but I cannot use type modifiers for them. =# CREATE TABLE tbl (v varchar2(10)); ERROR: type modifier is not allowed for type "varchar2" What reason do we have not to inherit typmodin/typmodout from the base type? I found a comment in DefineDomain(), /* Domains never accept typmods, so no typmodin/typmodout needed */ but can we relax the restriction? This feature would be useful for migration from other DBMSes that have non-standard data types. Regards, --- Takahiro Itagaki NTT Open Source Software Center
В списке pgsql-hackers по дате отправления
