Re: [HACKERS] Open 6.3 issues (fwd)

Vadim Mikheev <vadim@sable.krasnoyarsk.su>

From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>, PostgreSQL-development <hackers@postgreSQL.org>
Date: 1998-02-19T04:45:00Z
Lists: pgsql-hackers
Thomas G. Lockhart wrote:
> 
> 
> > 'Can not write block blind' error on createdb and regression collision
> 
> This is a show-stopper...

I'll take a look...

> 
> > Check select_views regression test

Imho, it's better to get rid of second query from select_views.sql:

SELECT * FROM iexit ORDER BY 1, 2;
                                ^
2-nd attr is of path type, '<' for path-es compares # of path' points,
there are many 2,3,-points pathes there, ordering is valid but we
can't get the same results on different platforms/-S XXX.

Another way is replace the query with:

SELECT name, #thepath FROM iexit ORDER BY 1, 2;
             ^^^^^^^^ path_npoints()

Vadim