Re: [BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-05-31 Thread Adrian Klaver
27;pg_upgrade libraries check' In other words determining who is responsible for tracking library changes? -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-05-31 Thread Adrian Klaver
involve checking for public schema functions who's names and probin match pg_pltemplate entries. Either will fix pg_upgrade. I would say the pg_dump fix. That one gets rid of the duplicates for everyone, not just those folks using pg_upgrade. -- Adrian Klaver adrian.kla...@gmail.com -- Sen

Re: [BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-05-29 Thread Adrian Klaver
On 05/29/2012 05:44 PM, Bruce Momjian wrote: On Sun, May 27, 2012 at 11:49:31AM -0700, Adrian Klaver wrote: If you can help me find out how these got defined this way, I might be able to prevent this problem for the next person. After reading the above thread here is what the queries

Re: [BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-05-28 Thread Adrian Klaver
On 05/27/2012 01:35 PM, Tom Lane wrote: Adrian Klaver writes: After reading the above thread here is what the queries mentioned return: production=# SELECT nspname,proname,probin FROM pg_proc,pg_namespace WHERE probin LIKE '%python%' and pg_proc.pronamespace=pg_namespace.oid;

Re: [BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-05-27 Thread Adrian Klaver
On 05/27/2012 01:35 PM, Tom Lane wrote: Adrian Klaver writes: After reading the above thread here is what the queries mentioned return: production=# SELECT nspname,proname,probin FROM pg_proc,pg_namespace WHERE probin LIKE '%python%' and pg_proc.pronamespace=pg_namespace.oid;

Re: [BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-05-27 Thread Adrian Klaver
On 05/26/2012 07:24 PM, Bruce Momjian wrote: > On Sat, May 26, 2012 at 11:42:09PM +, adrian.kla...@gmail.com wrote: >> The following bug has been logged on the website: >> >> Bug reference: >> Logged by: Adrian Klaver >> Email addr

[BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-05-26 Thread adrian . klaver
The following bug has been logged on the website: Bug reference: Logged by: Adrian Klaver Email address: adrian.kla...@gmail.com PostgreSQL version: 9.0.7 Operating system: Linux/OpenSuse 12.1 Description: I thought this was fixed in: http://git.postgresql.org

Re: [BUGS] [SQL] pg_dump: aborting because of server version mismatch

2012-05-11 Thread Adrian Klaver
e path in your script. *pg_dump: aborting because of server version mismatch* -e All database backups complete! -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] BUG #5783: plpythonu bool behavior change

2010-12-05 Thread Adrian Klaver
On Sunday 05 December 2010 9:10:06 am Peter Eisentraut wrote: > On sön, 2010-12-05 at 00:25 +0000, Adrian Klaver wrote: > > Seems there was a change in behavior for plpythonu with regards to > > boolean fields from 8.4 to 9.0. Previously, setting a field inside a > > plp

[BUGS] BUG #5783: plpythonu bool behavior change

2010-12-04 Thread Adrian Klaver
The following bug has been logged online: Bug reference: 5783 Logged by: Adrian Klaver Email address: adrian.kla...@gmail.com PostgreSQL version: 9.0.1 Operating system: Linux Ubuntu 10.04 Description:plpythonu bool behavior change Details: Seems there was a change

Re: [BUGS] [GENERAL] postgresql-8.4 error

2010-11-29 Thread Adrian Klaver
/8.4/main/postgresql.conf" : Are you trying to start Postgres as root? If so Postgres will not run as root, you will need to start it as the Postgres superuser, usually that is postgres. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgr