[BUGS] Bug #692: corrupt rpms

2002-06-14 Thread pgsql-bugs
Chris ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description corrupt rpms Long Description Your redhat-6.2 rpms for postgresql latest trashed my rpm database and corrupted it which was unfixable and now have no ability to utilize the

Re: [BUGS] Bug #692: corrupt rpms

2002-06-14 Thread Lamar Owen
On Friday 14 June 2002 05:43 am, [EMAIL PROTECTED] wrote: > Short Description > corrupt rpms > Long Description > Your redhat-6.2 rpms for postgresql latest trashed my rpm database and > corrupted it which was unfixable and now have no ability to utilize the use > of rpm, which had been operating

[BUGS] pg_dump fails for views with UNION and SELECT DISTINCT

2002-06-14 Thread Sam O'Connor
If I create a view like this: CREATE VIEW v AS SELECT i FROM a UNION SELECT DISTINCT i FROM b It functions as expected but it causes pg_dump to produce bad output. "ORDER BY b.i" is added to the view definition. On restore this causes: ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be o

Re: [BUGS] pg_dump fails for views with UNION and SELECT DISTINCT

2002-06-14 Thread Tom Lane
"Sam O'Connor" <[EMAIL PROTECTED]> writes: > If I create a view like this: > CREATE VIEW v AS > SELECT i FROM a > UNION > SELECT DISTINCT i FROM b > It functions as expected but it causes pg_dump to produce > bad output. "ORDER BY b.i" is added to the view definition. This appears to be fixed al