Re: [BUGS] BUG #7644: Missing implicit types of Result and failing type-conversion

2012-11-10 Thread Tom Lane
"Bernhard Reutner-Fischer" writes: > Fair enough but what about the failure for the case with the Result > that fails to merge? There I do have a cast No you don't: > select * from (select 'string two' bug ) s2 regards, tom lane -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #7644: Missing implicit types of Result and failing type-conversion

2012-11-10 Thread Tom Lane
rep.dot@gmail.com writes: > select distinct on (bug) bug > from ( > select * from (select 'string one' AS bug from generate_series(0,1)) > s1 > UNION > select * from (select 'string two' bug from generate_series(0,0)) > s2 > ) x > ; > ERROR: could not determine whi

[BUGS] BUG #7644: Missing implicit types of Result and failing type-conversion

2012-11-10 Thread rep . dot . nop
The following bug has been logged on the website: Bug reference: 7644 Logged by: Bernhard Reutner-Fischer Email address: rep.dot@gmail.com PostgreSQL version: 9.1.6 Operating system: debian Description: Hi, According to http://www.postgresql.org/docs/9.1/static/t

Re: [BUGS] BUG #7648: Momentary index corruption while in hot standby

2012-11-10 Thread Peter Geoghegan
On 10 November 2012 00:29, Daniel Farina wrote: > Me too. Database clients finding these unambiguously platform-level > problems and being relied upon to report them to receive treatment is > a long-standing embarrassment to me. However, I've been way too > swamped to even start thinking of how o