Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread hubert depesz lubaczewski
On nie, wrz 29, 2013 at 02:09:54 +0100, António M. Rodrigues wrote: > The code is the following: > > - > DO $$ > DECLARE > i integer; > BEGIN > FOR i IN (select nn from numeros) > LOOP > EXECUTE > 'create table contagio' || i || ' as > SELECT

Re: [GENERAL] Trouble installing psycopg2

2013-09-29 Thread Adrian Klaver
On 09/29/2013 11:06 AM, Augori wrote: Hmm maybe you're right. I just tried starting over again from a directory under joshmoe, following the tutorial again, but I get permssions errors at every turn. # wgethttp://python.org/ftp/python/2.7.3/Python-2.7.3.tar.bz2 # tar xf Python-2.7.3.tar.bz2 # c

Re: [GENERAL] Trouble installing psycopg2

2013-09-29 Thread Augori
Hmm maybe you're right. I just tried starting over again from a directory under joshmoe, following the tutorial again, but I get permssions errors at every turn. # wget http://python.org/ftp/python/2.7.3/Python-2.7.3.tar.bz2 # tar xf Python-2.7.3.tar.bz2 # cd Python-2.7.3 # ./configure --prefix=/

Re: [GENERAL] multiple databases vs multiple clusters on the same host

2013-09-29 Thread John R Pierce
On 9/29/2013 8:21 AM, Eugene Ostrovsky wrote: This works fine for a single database. But for different databases different relations between permissions-groups-users are requested. E.g. different set of permissions for “Manager” group or different group membership for a given user. This doesn’

Re: [GENERAL] Trouble installing psycopg2

2013-09-29 Thread Augori
No, sorry. I just checked that again and I can yum. I guess I remembered that incorrectly. But the thing is, I'm worried that I have all this stuff set up and working --postgresql, virtualenv, psycopg2 in root; then if I try another install under joshmoe it could cause even more more chaos. On

Re: [GENERAL] Trouble installing psycopg2

2013-09-29 Thread Augori
You're right, I installed the virtualenv as user root into /root. The reason for this is that I can't run 'yum' and probably many of the other commands from joshmoe, so I gave up on that route. But I'm open for suggestions...do you think it would be better to try to get access to these commands?

Re: [GENERAL] Trouble installing psycopg2

2013-09-29 Thread Adrian Klaver
On 09/29/2013 09:38 AM, Augori wrote: Thanks to Adrian for pointing to this site. http://toomuchdata.com/2012/06/25/how-to-install-python-2-7-3-on-centos-6-2/ I was able to get the virtual environment set up and install psycopg2 from there. Now things seem to be working well when I'm logged in

Re: [GENERAL] PostgreSQL 9.2.4 temp files never released?

2013-09-29 Thread Tomas Vondra
On 28 Září 2013, 23:25, Edson Richter wrote: > Em 28/09/2013 18:12, Tomas Vondra escreveu: >> Do you realize the counters in pg_stat_database (temp_files, temp_bytes) >> are counters tracking all the temp files created since the last reset of >> the stats (possible since the cluster was created)? >

Re: [GENERAL] Trouble installing psycopg2

2013-09-29 Thread Augori
Thanks to Adrian for pointing to this site. http://toomuchdata.com/2012/06/25/how-to-install-python-2-7-3-on-centos-6-2/ I was able to get the virtual environment set up and install psycopg2 from there. Now things seem to be working well when I'm logged in as root. But I need to be able to use th

Re: [GENERAL] Building with MinGW issue

2013-09-29 Thread Adrian Klaver
On 09/28/2013 10:09 PM, Muhammad Bashir Al-Noimi wrote: On 09/27/2013 10:57 PM, Adrian Klaver wrote: Did you try the override method shown in this message?: http://www.postgresql.org/message-id/ovpbg9.x5ovpbg9.pq9n.w333.g...@asuka.myrkraverk.com I found it very comlicated and made things wor

Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread Adrian Klaver
On 09/29/2013 08:31 AM, António M. Rodrigues wrote: Thanks for your reply. If I substitute double quotes with single quotes (or with double dollar sign", and run the code: DO $$ DECLARE i integer; BEGIN FOR i IN (select nn from numeros) LOOP EXECUTE 'create table contagio' || i || ' as SEL

Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread António M . Rodrigues
Thanks for your reply. If I substitute double quotes with single quotes (or with double dollar sign", and run the code: DO $$ DECLARE i integer; BEGIN FOR i IN (select nn from numeros) LOOP EXECUTE 'create table contagio' || i || ' as SELECT * FROM pgr_drivingdistance(' SELECT gid AS i

Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread Adrian Klaver
On 09/29/2013 06:09 AM, António M. Rodrigues wrote: Hi all, I have a problem with quotes which I can't find a solution. Inside a query string I have another query string; I used for the later double quotes, but it is still complaining The problem is with the function pgr_drivingdistance (from

[GENERAL] Quotes, double quotes...

2013-09-29 Thread António M . Rodrigues
Hi all, I have a problem with quotes which I can't find a solution. Inside a query string I have another query string; I used for the later double quotes, but it is still complaining The problem is with the function pgr_drivingdistance (from pgrouting extension). The code is the following: ---

[GENERAL] Re: pg_upgrade unrecognized configuration parameter “unix_socket_directory”

2013-09-29 Thread Clodoaldo Neto
Someone claims to have fixed it patching pg_upgrade: http://dba.stackexchange.com/a/50714/6978 Quoting: *"My solution is to rebuild the pg_upgrade from sources, with update to file contrib/pg_upgrade/server.c:199 where pg_upgrade checks for server version:* * * *199: (GET_MAJOR_VERSION(cl

Re: [GENERAL] Building with MinGW issue

2013-09-29 Thread Martijn van Oosterhout
On Sun, Sep 29, 2013 at 07:09:40AM +0200, Muhammad Bashir Al-Noimi wrote: > On 09/27/2013 10:57 PM, Adrian Klaver wrote: > >Did you try the override method shown in this message?: > > > >http://www.postgresql.org/message-id/ovpbg9.x5ovpbg9.pq9n.w333.g...@asuka.myrkraverk.com > > I found it very co