Postgres Pro
Downloads
Home   >   mailing lists

Re: lack of consequence with domains and types - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: lack of consequence with domains and types
Date
Msg-id 2f4958ff0812220453y46236118maf61b5db79e73fe9@mail.gmail.com
Whole thread Raw
In response to lack of consequence with domains and types  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Tree view 
On Mon, Dec 22, 2008 at 1:49 PM, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> but that defeats whole purpose of domains, doesn't it ?
>
> well, on top of that - I could create another domain with default
> (nextval, now), but still....

Well I can't, it doesn't work :(

create domain xyz as footype default(nextval('seq1'), now()) not null;
ERROR:  "xyz" is not a valid base type for a domain


huh....

--
GJ

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: lack of consequence with domains and types
Next
From: "Jonah H. Harris"
Date:
Subject: Re: How are locks managed in PG?