Re: Fixed width rows faster?

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: pg(at)rbt(dot)ca (Rod Taylor)
Cc: josh(at)agliodbs(dot)com (Josh Berkus), wmoran(at)potentialtech(dot)com (Bill Moran), threshar(at)torgo(dot)978(dot)org (Jeff), pgsql-performance(at)postgresql(dot)org (Postgresql Performance)
Subject: Re: Fixed width rows faster?
Date: 2004-03-07 01:16:31
Message-ID: 200403070116.i271GWPS005869@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2004-03-07 01:22:25 Re: Fixed width rows faster?
Previous Message John Siracusa 2004-03-06 21:55:33 Re: Feature request: smarter use of conditional indexes