Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id B72D49FA326 for ; Tue, 26 Dec 2006 23:35:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 92048-05 for ; Tue, 26 Dec 2006 23:35:23 -0400 (AST) X-Greylist: delayed 00:24:58.890917 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id CEC0E9F93A2 for ; Tue, 26 Dec 2006 23:35:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from kgb08.kgbinternet.com (kgb08.kgbinternet.com [66.199.152.35]) by svr4.postgresql.org (Postfix) with ESMTP id 3DA175AF031 for ; Wed, 27 Dec 2006 03:10:30 +0000 (GMT) Received: from [127.0.0.1] (216.19.188.70.novuscom.net [216.19.188.70]) (authenticated bits=0) by kgb08.kgbinternet.com (8.12.10/8.12.8) with ESMTP id kBR3ARZB006959 for ; Tue, 26 Dec 2006 21:10:27 -0600 Message-ID: <4591E420.3040102@williamrosmus.com> Date: Tue, 26 Dec 2006 19:10:24 -0800 From: BillR User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: domains and serial Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200612/191 X-Sequence-Number: 27147 Is it not possible to set up a domain using this construct? I will have a lot of tables using integer and big integer types as primary key identifier fields. It would make things simpler if I can use the serial construct in a domain instead of using an int or bigint in the domain, and then change each field in each table requiring a serial or bigserial construct. I just tried to create a domain using a bigserial type. CREATE DOMAIN Identifier_DM AS bigserial; I received the error message: ERROR: type "bigserial" does not exist SQL state: 42704 I tried to run this in both pgadminIII and in data architect 3.5. Thanks.