Re: [GENERAL] Using incorrect default-value type

2012-10-15 Thread Arturo Pie Joa
e are just overloading "text". Thanks, Arturo From: Tom Lane To: Arturo Pie Joa Cc: "pgsql-general@postgresql.org" Sent: Sunday, October 14, 2012 4:35:07 PM Subject: Re: [GENERAL] Using incorrect default-value type Arturo Pie Joa writes:

[GENERAL] Using incorrect default-value type

2012-10-14 Thread Arturo Pie Joa
Hello, I have found a strangeĀ behaviorĀ in postgreSQL when adding columns with defaults of a domain type in a schema different from public. This is the example to reproduce it: CREATE SCHEMA schema_1; CREATE DOMAIN schema_1.text AS text; SET search_path TO schema_1, pg_catalog; CREATE TABLE te