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

Reply via email to