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

Started by Erwin Mollerabout 23 years ago3 messagesgeneral
Jump to latest
#1Erwin Moller
erwin@_removespam_dexus.nl

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

#2Stephan Szabo
sszabo@megazone23.bigpanda.com
In reply to: Erwin Moller (#1)
Re: Postgresql7.3: after dropping a column a

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.

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Erwin Moller (#1)
Re: Postgresql7.3: after dropping a column a .............pg.dropped............ column exists

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