Skip site navigation (1) Skip section navigation (2)

Re: lack of consequence with domains and types

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: lack of consequence with domains and types
Date: 2008-12-22 12:53:58
Message-ID: 2f4958ff0812220453y46236118maf61b5db79e73fe9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Mon, Dec 22, 2008 at 1:49 PM, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)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

In response to

pgsql-general by date

Next:From: Jonah H. HarrisDate: 2008-12-22 13:13:55
Subject: Re: How are locks managed in PG?
Previous:From: Grzegorz JaśkiewiczDate: 2008-12-22 12:49:49
Subject: lack of consequence with domains and types

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group