From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | John Morton <jwm(at)plain(dot)co(dot)nz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unimpletmented features |
Date: | 2000-08-17 14:47:00 |
Message-ID: | 20000817094700.B17023@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Aug 17, 2000 at 01:13:20PM +1200, John Morton wrote:
> > Now John, let's keep it all in perspective: ALTER TABLE / ADD CONSTRAINT
> > not working isn't going to cost you your job or anything, is it?
>
> I've taken my dried frog pills and I'm feeling much better :-)
Yeah, aren't they wonderful? I'm worried about the worldwide depletion of the
amphibian populations, though. ;-)
>
> That much works for me, thanks. I was looking at adding uniqueness across
> fields but I can do that with CREATE INDEX, so it's not a showstopper.
And that's how the backend handles it, anyway.
> If I was trying to add other contraints I'd be having more trouble. I seem
> to recall that the rename/create/fill/delete kludge required rebuilding
> indexes and permissions by hand in 6.5.*; is it the same story in 7.0?
>
'Fraid so. Becareful of any 'serial' fields, as well: the sequences will
need to be moved around by hand.
> Yeah, I guess I can live with that, though I'd be much happier during
> development to have the full array of alter commands at my disposal.
>
That's part of the problem: the ALTER family are really only useful for
development, so they're not targeted as strongly as features that will
affect the daily functioning of a production DB.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-08-17 15:30:39 | Re: Regression Tests |
Previous Message | Andreas Tille | 2000-08-17 14:05:53 | Beginner problems with functions (Was: Is this the wrong list?) |