Re: Fixed width rows faster?

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

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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2004-03-07 01:32:08 Re: Fixed width rows faster?
Previous Message Mike Nolan 2004-03-07 01:16:31 Re: Fixed width rows faster?