Re: cannot remove column + no error msg

am  Mon, dem 11.12.2006, um 16:11:24 +0100 mailte Bram Kuijper folgendes:
> Hi all,
>
> sorry for the clutter, but cannot find a good answer to this problem in
> the mailinglist archives:
>
> If I execute either of both commands (I run postgresql 8.1.4 on Ubuntu
> GNU/linux):
>
> # ALTER TABLE table_name DELETE COLUMN column
> # ALTER TABLE table_name DROP COLUMN column

You are in the psql-tool?

The first syntax is wrong, the latter are okay, but you need a ';' on
the linend.


>
> nothing happens... if I do
>
> # \d table_name,

test=# \d foobar
    Table "public.foobar"
 Column |  Type   | Modifiers
--------+---------+-----------
 id     | integer |
 a      | integer |
 b      | integer |
 c      | integer |

test=# alter table foobar drop column c;
ALTER TABLE
test=*# \d foobar
    Table "public.foobar"
 Column |  Type   | Modifiers
--------+---------+-----------
 id     | integer |
 a      | integer |
 b      | integer |




Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net