Zeugswetter Andreas ADI SD escribió: > > > > And I also see a lot of unhappiness from users of system tables > > > when column numbers all over the system tables would not be > > > logical column positions any more. > > > > Right now the fact that attnum presents the logical order but > > not the logical position is a problem for the JDBC driver. > > In the presence of dropped columns there is no easy way to > > get from a pg_attribute entry to logical position. I would > > hope that a new logical position column would reflect the > > actual position and solve this problem. > > I agree, I haven't thought of drop column :-( Drop column should have > relabeled attnum. > Since it was not done then, my comments are probably moot.
We can correct this problem now. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
