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

2012-07-04 Thread Josh Kupershmidt
On Tue, Jul 3, 2012 at 11:41 PM, Tom Lane wrote: > 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 in

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-04 Thread Bruce Momjian
On Mon, Jul 02, 2012 at 01:28:36PM -0400, Bruce Momjian wrote: > This is the trimmed-down code block: > > if (!binary_upgrade) > { > appendPQExpBuffer(q, "CREATE EXTENSION IF NOT EXISTS %s WITH SCHEMA > %s;\n", > qextname, fmtId(extinfo->namespace)); >

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-04 Thread Tom Lane
Bruce Momjian writes: >>> address the points I made about reproducing the previous state in cases >>> where the admin removed the language or changed its permissions. >> Well, it still does the create extension in binary mode like before --- >> not sure what the problem is. > Applied and back-pa

[BUGS] BUG #6716: memory of Autovacuum leak?

2012-07-04 Thread runner . mei
The following bug has been logged on the website: Bug reference: 6716 Logged by: runner.mei Email address: runner@gmail.com PostgreSQL version: 9.1.3 Operating system: win2003 Description: My program using a postgresql9.1.3, and running in win2003. Generally have

[BUGS] BUG #6718: Cannot delete, create or check existence of extension

2012-07-04 Thread gary . haran
The following bug has been logged on the website: Bug reference: 6718 Logged by: Gary Haran Email address: gary.ha...@gmail.com PostgreSQL version: 9.1.4 Operating system: OS X Description: development=# select version();

[BUGS] BUG #6717: bad file

2012-07-04 Thread stevec
The following bug has been logged on the website: Bug reference: 6717 Logged by: Steve Commanda Email address: ste...@nfn.ca PostgreSQL version: 9.1.4 Operating system: suse 11.4 Description: downloaded latest version. opened it up and some game came up. -- Sent vi

Re: [BUGS] BUG #6717: bad file

2012-07-04 Thread Craig Ringer
On 07/04/2012 11:02 PM, ste...@nfn.ca wrote: The following bug has been logged on the website: Bug reference: 6717 Logged by: Steve Commanda Email address: ste...@nfn.ca PostgreSQL version: 9.1.4 Operating system: suse 11.4 Description: downloaded latest version. opened it

Re: [BUGS] BUG #6718: Cannot delete, create or check existence of extension

2012-07-04 Thread Craig Ringer
On 07/05/2012 02:05 AM, gary.ha...@gmail.com wrote: development=# create extension hstore; ERROR: type "hstore" already exists development=# drop extension hstore; ERROR: extension "hstore" does not exist development=# CREATE EXTENSION IF NOT EXISTS hstore; ERROR: type "hstore" already exists