Re: [BUGS] BUG #6715: 9.2b2 psql \ir does not understand leading ../

2012-07-03 Thread Tom Lane
j...@well.com writes: > When I do > \ir ../bar.sql > I get the bar.sql file in the CWD. AFAICS, it works fine when \ir is used interactively. However, you seem to be using it from a script: > $ psql -aX greg -f foo.sql and then indeed it does not work so well. psql is trying to evaluate the \i

Re: [BUGS] BUG #6708: pgsql_fdw's foreign table cann't used in plpgsql function

2012-07-03 Thread Shigeru HANADA
(2012/06/27 9:02), dig...@126.com wrote: > pgsql_fdw's foreign table "cache lookup failed for type 0" bug when used in > function Thanks for the report! I could reproduce the problem. The cause of error was wrong handling of parameters given by PL/pgSQL for PL/pgSQL variables and parameters. Th

[BUGS] BUG #6715: 9.2b2 psql \ir does not understand leading ../

2012-07-03 Thread jgd
The following bug has been logged on the website: Bug reference: 6715 Logged by: Greg Davidson Email address: j...@well.com PostgreSQL version: Unsupported/Unknown Operating system: OpenSuSe 11.3, PostgreSQL 9.wbeta2 Description: When I do \ir ../bar.sql I get the bar

Re: [BUGS] Meeting schedule

2012-07-03 Thread Jeff Davis
On Mon, 2012-07-02 at 20:29 -0400, Jimmy Creeks wrote: > Hi, > > > As a customer of HM2, I have been trying to install several versions > of postgreSQL, but there is always a slight bug with postgresql.conf. > I am wondering whether I can schedule a online meeting so that we can > resolve my prob

Re: [BUGS] BUG #6593: REASSIGN OWNED fails on extensions

2012-07-03 Thread Emiliano Leporati
Nice, thank you ! on humble behalf of every dba / pg lover. On Tue, Jul 3, 2012 at 9:22 PM, Alvaro Herrera wrote: > > Excerpts from Alvaro Herrera's message of mié abr 18 12:02:25 -0300 2012: > > Excerpts from emiliano.leporati's message of lun abr 16 06:21:53 -0300 > 2012: > > > > > failtest=# c

Re: [BUGS] BUG #6593: REASSIGN OWNED fails on extensions

2012-07-03 Thread Alvaro Herrera
Excerpts from Alvaro Herrera's message of mié abr 18 12:02:25 -0300 2012: > Excerpts from emiliano.leporati's message of lun abr 16 06:21:53 -0300 2012: > > > failtest=# create extension citext; > > CREATE EXTENSION > > failtest=# create table foo(bar integer); > > CREATE TABLE > > failtest=# rea

Re: [BUGS] Meeting schedule

2012-07-03 Thread Bruce Momjian
On Tue, Jul 03, 2012 at 05:18:20PM +0200, Magnus Hagander wrote: > On Tue, Jul 3, 2012 at 2:29 AM, Jimmy Creeks wrote: > > Hi, > > > > As a customer of HM2, I have been trying to install several versions of > > postgreSQL, but there is always a slight bug with postgresql.conf. I am > > wondering w

Re: [BUGS] Meeting schedule

2012-07-03 Thread Magnus Hagander
On Tue, Jul 3, 2012 at 2:29 AM, Jimmy Creeks wrote: > Hi, > > As a customer of HM2, I have been trying to install several versions of > postgreSQL, but there is always a slight bug with postgresql.conf. I am > wondering whether I can schedule a online meeting so that we can resolve my > problem of

[BUGS] Meeting schedule

2012-07-03 Thread Jimmy Creeks
Hi, As a customer of HM2, I have been trying to install several versions of postgreSQL, but there is always a slight bug with postgresql.conf. I am wondering whether I can schedule a online meeting so that we can resolve my problem of installation. Thank you. Thanks, Jimmy