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

2012-11-12 Thread Bernhard Reutner-Fischer
On 10 November 2012 16:58, Tom Lane wrote: > "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 > >

[BUGS] BUG #7653: Minor problem with join condition

2012-11-12 Thread stefano
The following bug has been logged on the website: Bug reference: 7653 Logged by: Stefano Baccianella Email address: stef...@sportilia.com PostgreSQL version: 9.2.1 Operating system: Linux CentOS Description: Don't know if this is a bug or a correct behaviour, but in a

Re: [BUGS] BUG #7653: Minor problem with join condition

2012-11-12 Thread Tom Lane
stef...@sportilia.com writes: > Don't know if this is a bug or a correct behaviour, but in a query like > this: > SELECT t1.* FROM > table1 t1 JOIN > table2 t2 ON t1.id = t2.t1id JOIN > table3 t3 ON t1.id = t2.t1id > The parser should return an error because we are joining a table without > using

[BUGS] Bug in postgres 9.2 installation: pg_archivecleanup: command not found

2012-11-12 Thread Niels Kristian Schjødt
I have installed postgres 9.2 on ubuntu 12.04 like this: sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get install postgresql-9.2 However after this, i get the following error: 2012-11-12 17:49:38 GMT WARNING: archive_cleanup_command "pg_archivecleanup /var/lib/post

[BUGS] Bug in postgres 9.2 installation

2012-11-12 Thread Niels Kristian Schjødt
I have installed postgres 9.2 on ubuntu 12.04 like this: sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get install postgresql-9.2 However after this, i get the following error: 2012-11-12 17:49:38 GMT WARNING: archive_cleanup_command "pg_archivecleanup /var/lib/post

Re: [BUGS] Bug in postgres 9.2 installation: pg_archivecleanup: command not found

2012-11-12 Thread Devrim Gündüz
Hi, You probably need to install -contrib subpackage as well. Regards, "Niels Kristian Schjødt" wrote: >I have installed postgres 9.2 on ubuntu 12.04 like this: > >sudo add-apt-repository ppa:pitti/postgresql >sudo apt-get update >sudo apt-get install postgresql-9.2 > >However after this, i ge

Re: [BUGS] Bug in postgres 9.2 installation: pg_archivecleanup: command not found

2012-11-12 Thread Niels Kristian Schjødt
I found this is the manual: http://www.postgresql.org/docs/9.1/static/pgarchivecleanup.html F.25.4. Supported Server Versions pg_archivecleanup is designed to work with PostgreSQL 8.0 and later when used as a standalone utility, or with PostgreSQL 9.0 and later when used as an archive cleanup