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 89C48D1D803 for ; Sun, 7 Mar 2004 01:16:34 +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 63530-04 for ; Sat, 6 Mar 2004 21:16:36 -0400 (AST) Received: from gw.tssi.com (gw.tssi.com [198.147.197.1]) by svr1.postgresql.org (Postfix) with ESMTP id 72A4BD1D779 for ; Sat, 6 Mar 2004 21:16:32 -0400 (AST) Received: from gw.tssi.com (nolan@gw.tssi.com [127.0.0.1] (may be forged)) by gw.tssi.com (8.12.6/8.12.6) with ESMTP id i271GX8S005871; Sat, 6 Mar 2004 19:16:33 -0600 Received: (from nolan@localhost) by gw.tssi.com (8.12.6/8.12.6/Submit) id i271GWPS005869; Sat, 6 Mar 2004 19:16:32 -0600 From: Mike Nolan Message-Id: <200403070116.i271GWPS005869@gw.tssi.com> Subject: Re: Fixed width rows faster? To: pg@rbt.ca (Rod Taylor) Date: Sat, 6 Mar 2004 19:16:31 -0600 (CST) Cc: josh@agliodbs.com (Josh Berkus), wmoran@potentialtech.com (Bill Moran), threshar@torgo.978.org (Jeff), pgsql-performance@postgresql.org (Postgresql Performance) In-Reply-To: <1078530843.57624.24.camel@jester> from "Rod Taylor" at Mar 05, 2004 06:54:04 PM X-Mailer: ELM [version 2.5 PL3] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/78 X-Sequence-Number: 5934 > 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). -- Mike Nolan