From: | Jeff Davis <list-pgsql-hackers(at)empires(dot)org> |
---|---|
To: | "Pgsql-Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: MySQL vs PostgreSQL. |
Date: | 2002-10-12 04:18:23 |
Message-ID: | 200210112118.23709.list-pgsql-hackers@empires.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
Oh yes, I agree. ALTER TABLE ... DROP COLUMN helps out a lot. I actually don't
use that for much yet because 7.3 is still in beta. However, I certainly
can't complain to the developers for it since it's already developed :)
I am consistantly amazed by every minor version release. If postgres had a
marketing team it would be at version 37.3 by now. In my last email I agreed
with Scott Marlowe that postgres is better off without the casting of an
entire column, since that's kind of a dangeous procedure and can be completed
in a round-about (read: explicit) way by postgres anyway, that doesn't lose
your data until after you've had a chance to look at the new stuff.
Regards,
Jeff
On Friday 11 October 2002 07:16 pm, you wrote:
> On Fri, Oct 11, 2002 at 07:08:18PM -0700, Jeff Davis wrote:
> > And it really is a minor matter of convenience. I end up dropping and
> > recreating all my tables a lot in the early stages of development, which
> > is mildly annoying. Certainly not as bad, I suppose, as if you're led to
> > believe that a feature does something safely, and it kills all your data.
>
> Now that ALTER TABLE DROP COLUMN is implemented, there probably isn't
> any more the need to do such frequent drop/create of tables.
>
> And things just keep getting better and better. This is really amazing.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-12 04:40:55 | Conference in February, Training in January |
Previous Message | Alvaro Herrera | 2002-10-12 02:16:24 | Re: MySQL vs PostgreSQL. |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-10-12 04:20:14 | Re: contrib/fixchar (Was: Large databases, performance) |
Previous Message | Alvaro Herrera | 2002-10-12 02:16:24 | Re: MySQL vs PostgreSQL. |
From | Date | Subject | |
---|---|---|---|
Next Message | Bernd Brenner | 2002-10-12 08:35:28 | Re: pq_recvbuf: recv() failed: Connection reset by peer |
Previous Message | Barry Lind | 2002-10-12 03:31:25 | Re: Out of memory error on huge resultset |