Re: [BUGS] BUG #6533: postgre server crashes by create function (create table as)

2012-03-15 Thread Tom Lane
voz...@gmail.com writes: > The following bug has been logged on the website: > Bug reference: 6533 > Logged by: Alex Sanin > Email address: voz...@gmail.com > PostgreSQL version: 9.0.4 > Operating system: Windows XP sp3 > Description: > Here is the script: This script

Re: [BUGS] BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD

2012-03-15 Thread Bruce Momjian
On Tue, Mar 06, 2012 at 09:08:25PM -0700, Alex Hunsaker wrote: > [ Calling a plperl trigger function from a plperl function ] > > Yeah, there were some optimization done for 9.1 to try and make calls > a bit faster. The problem is we are fetching "_TD" not "main::_TD", > which means we try to find

Re: [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread Bruce Momjian
On Thu, Mar 15, 2012 at 01:13:29PM +, stu...@stuartbishop.net wrote: > The following bug has been logged on the website: > > Bug reference: 6532 > Logged by: Stuart Bishop > Email address: stu...@stuartbishop.net > PostgreSQL version: 9.1.3 > Operating system: Ubuntu > Des

[BUGS] BUG #6533: postgre server crashes by create function (create table as)

2012-03-15 Thread vozhdb
The following bug has been logged on the website: Bug reference: 6533 Logged by: Alex Sanin Email address: voz...@gmail.com PostgreSQL version: 9.0.4 Operating system: Windows XP sp3 Description: Here is the script: drop table if exists test; CREATE TABLE test ( id

[BUGS] BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision"

2012-03-15 Thread barry_bell
The following bug has been logged on the website: Bug reference: 6534 Logged by: Barry Bell Email address: barry_b...@harte-hanks.com PostgreSQL version: 9.1.2 Operating system: Windows Server 2003 Description: Using the lastest of ODBC ANSI driver for windows 32bit

Re: [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread Stuart Bishop
On Thu, Mar 15, 2012 at 9:01 PM, Stuart Bishop wrote: > Yes, it is there. I can see the library with the new name of > plpython2.so, not the old plpython.so from 8.4. createlang installs > the language just fine if I build a cluster and database myself. As expected, symlinking plpython2.so to pl

Re: [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread Stuart Bishop
On Thu, Mar 15, 2012 at 8:54 PM, Andres Freund wrote: > Hi, > > On Thursday, March 15, 2012 02:13:29 PM stu...@stuartbishop.net wrote: >> The 9.1.3 changelog states pg_upgrade's handing of plpython stored >> procedures was fixed, but that does not appear to be the case: >> ... >> access file "$lib

Re: [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread Andres Freund
Hi, On Thursday, March 15, 2012 02:13:29 PM stu...@stuartbishop.net wrote: > The 9.1.3 changelog states pg_upgrade's handing of plpython stored > procedures was fixed, but that does not appear to be the case: > ... > access file "$libdir/plpython": No such file or directory Well. That looks like y

[BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-15 Thread stuart
The following bug has been logged on the website: Bug reference: 6532 Logged by: Stuart Bishop Email address: stu...@stuartbishop.net PostgreSQL version: 9.1.3 Operating system: Ubuntu Description: The 9.1.3 changelog states pg_upgrade's handing of plpython stored pro