Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgresql7.3: after dropping a column a .............pg.dropped............ column exists

Postgresql7.3: after dropping a column a .............pg.dropped............ column exists

From
Erwin Moller
Date:
Hi all,

According to RedHat Database Administrator A column named
............pg.dropped........... exists in my table.
I use Postgresql7.3
According to psql that column doesn't exist.

Did anybody else encounter this behaviour?
Should I worry?

Regards,
Erwin

Re: Postgresql7.3: after dropping a column a

From
Stephan Szabo
Date:
On Thu, 30 Jan 2003, Erwin Moller wrote:

> Hi all,
>
> According to RedHat Database Administrator A column named
> ............pg.dropped........... exists in my table.
> I use Postgresql7.3
> According to psql that column doesn't exist.
>
> Did anybody else encounter this behaviour?
> Should I worry?

Probably not.  The tool (or at least whatever version you are using) is
probably not ignoring columns that have attisdropped set to true.

Re: Postgresql7.3: after dropping a column a .............pg.dropped............ column exists

From
Tom Lane
Date:
Erwin Moller <erwin@_removespam_dexus.nl> writes:
> According to RedHat Database Administrator A column named
> ............pg.dropped........... exists in my table.
> I use Postgresql7.3

RHDB Admin is not yet 7.3-savvy.  In particular it doesn't know to
ignore attisdropped columns.

There should be a beta release of the 7.3 version later this month.

            regards, tom lane
            Red Hat Database project