#1926 pg.dropped after dropping columns

1.170
closed
5
2005-01-27
2005-01-27
Anonymous
No

After dropping columns using "ALTER TABLE ... DROP ..."
command, columns are dropped but in the "Edit Table"
page columns named "........pg.dropped.x........" are
showed (where x is an integer value).
I also use phpPgAdmin; in that columns are properly
showed.

More specifically, the whole transaction I used is like:
BEGIN;
ALTER TABLE clienti ADD COLUMN new_col varchar(80);
UPDATE clienti SET new_col = CAST(ragione_sociale AS
varchar(80));
ALTER TABLE clienti DROP COLUMN ragione_sociale;
ALTER TABLE clienti RENAME new_col TO
ragione_sociale;
COMMIT;

I attached a screenshot.

Discussion

  • Jamie Cameron

    Jamie Cameron - 2005-01-27

    Logged In: YES
    user_id=129364

    Those pg.dropped fields must be some internal columns
    created by Postgresql when a field is deleted. I will add
    code to ignore them in the next Webmin release ..

     
  • Jamie Cameron

    Jamie Cameron - 2005-01-27
    • status: open --> closed
     

Log in to post a comment.