Re: [GENERAL] DROP column: documentation unclear

2010-03-09 Thread Tom Lane
Harald Fuchs writes: > Martijn van Oosterhout writes: >> What you're missing is that in postgres NULLs are stored as a bit in >> the header and there is no data. So in a sense NULLs take no space >> (well, one bit) which means both statements are true. > But if you already have eight nullable co

Re: [GENERAL] DROP column: documentation unclear

2010-03-09 Thread Harald Fuchs
In article <20100308213549.gb...@svana.org>, Martijn van Oosterhout writes: >> "subsequent ... will store a null value" would imply that deleted columns >> will still take some place, while "the space will be reclaimed ..." would >> suggest that new rows (insert or updates in mvcc) don't have t

Re: [GENERAL] DROP column: documentation unclear

2010-03-08 Thread Martijn van Oosterhout
On Mon, Mar 08, 2010 at 05:09:14PM +0100, Adrian von Bidder wrote: > Hi, > > The documentation about DROP COLUMN is a bit unclear: > > | The DROP COLUMN form does not physically remove the column, but simply > | makes it invisible to SQL operations. Subsequent insert and update > | operations in

[GENERAL] DROP column: documentation unclear

2010-03-08 Thread Adrian von Bidder
Hi, The documentation about DROP COLUMN is a bit unclear: | The DROP COLUMN form does not physically remove the column, but simply | makes it invisible to SQL operations. Subsequent insert and update | operations in the table will store a null value for the column. Thus, | dropping a column is qu

Re: [GENERAL] Drop Column with Foreign Key Problem

2004-07-03 Thread Thomas Chille
Hi Tom! Thanx again for your fast help. And its helps indeed. You pointed out the problem correct! I could delete these triggers after scanning the system-tables by hand. Unfortunately this can happen in the futrue again and thatswhy i tried applying the adddepend script on a fresh restored db

[GENERAL] Drop Column with Foreign Key Problem

2004-07-01 Thread Thomas Chille (spoon)
Hello! I have a Problem. A table with a ForeignKeyRef exits. The Name of the field with this FK-Constraint is 'id_employee' because it is referencing the field 'id_employee' in 'public.sd_employee'. I drop this column of the table with cascade in a script: ALTER TABLE public.sd_messaging_parti

[GENERAL] drop column

2001-10-18 Thread Peter Pilsl
is there a trick to drop a column in a table ? or do I need to recreate the table and drop the old one ? thnx, peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available ---(end of broadc

Re: [GENERAL] drop column?

2000-10-04 Thread Poul L. Christiansen
You don't :) Currently you can't drop an column from a table, but I think you can in version 7.1. So you have to wait to november. In the mean time, just rename it. Andrew Gould wrote: > > How do you drop a column from a table? I'm using > PostgreSQL 7.0.2. > > Thanks, > > Andrew Gould > >

Re: [GENERAL] drop column?

2000-10-04 Thread Jason C. Wells
On Wed, 4 Oct 2000, Andrew Gould wrote: > How do you drop a column from a table? I'm using > PostgreSQL 7.0.2. >From the FAQ. 4.5) How do you remove a column from a table? We do not support ALTER TABLE DROP COLUMN, but do this: SELECT ... -- select all columns but the one you w

Re: [GENERAL] drop column?

2000-10-04 Thread Adam Lang
ober 04, 2000 10:39 AM Subject: [GENERAL] drop column? > How do you drop a column from a table? I'm using > PostgreSQL 7.0.2. > > Thanks, > > Andrew Gould > > __ > Do You Yahoo!? > Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! > http://photos.yahoo.com/

[GENERAL] drop column?

2000-10-04 Thread Andrew Gould
How do you drop a column from a table? I'm using PostgreSQL 7.0.2. Thanks, Andrew Gould __ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/