X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 11F82D1D108 for ; Sun, 7 Mar 2004 01:21:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 61118-02 for ; Sat, 6 Mar 2004 21:21:45 -0400 (AST) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 09CCCD1D105 for ; Sat, 6 Mar 2004 21:21:42 -0400 (AST) Received: from [134.22.71.174] (dyn-71-174.tor.dsl.tht.net [134.22.71.174]) by tht.net (Postfix) with ESMTP id D3B0B76A37; Sat, 6 Mar 2004 20:21:49 -0500 (EST) Subject: Re: Fixed width rows faster? From: Rod Taylor To: Mike Nolan Cc: Josh Berkus , Bill Moran , Jeff , Postgresql Performance In-Reply-To: <200403070116.i271GWPS005869@gw.tssi.com> References: <200403070116.i271GWPS005869@gw.tssi.com> Content-Type: text/plain Message-Id: <1078622544.57624.26.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sat, 06 Mar 2004 20:22:25 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/79 X-Sequence-Number: 5935 On Sat, 2004-03-06 at 20:16, Mike Nolan wrote: > > Actually, I don't. Good reason to have a check constraint on it though > > (hint, check constraints can be changed while column types cannot be, at > > this moment). > > Is there a way to copy a table INCLUDING the check constraints? If not, > then that information is lost, unlike varchar(n). No, not constraints.