Re: [GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-23 Thread stefano bonnin
ly installed the dependencies (build-essential > libreadline-dev zlib1g-dev libssl-dev bison flex) > * try to compile the code in the bdr-REL9_4_STABLE git branch > > Anyway, I followed the same procedure you reported in your first email and > it works. > > Giuseppe. > > 2014-12

Re: [GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-22 Thread stefano bonnin
t; \ ^ bdr_apply.c:355:3: note: in expansion of macro ‘ereport’ ereport(LOG, ^ make: *** [bdr_apply.o] Error 1 Regards. 2014-12-23 8:11 GMT+01:00 stefano bonnin : > > Hi Giuseppe, > > gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3 > > a newer version needed? &g

Re: [GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-22 Thread stefano bonnin
Hi Giuseppe, gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3 a newer version needed? 2014-12-22 14:00 GMT+01:00 Giuseppe Broccolo < giuseppe.brocc...@2ndquadrant.it>: > > Hi Stefano, > > Which version of gcc are you using? > > Giuseppe. > > 2014-12-22 9:52 GMT+01:00 stef

[GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-22 Thread stefano bonnin
Hi all, I have followed the wiki about postgresql BDR: OS: Ubuntu 12.04.5 LTS - git clone git://git.postgresql.org/git/2ndquadrant_bdr.git - cd 2ndquadrant_bdr - git checkout bdr/0.7.1 - ./configure --prefix=$HOME/bdr --with-openssl - make - make install To install the BDR ext

Re: [GENERAL] Given N, finding the interval of N hours with max(sum(..))

2010-06-17 Thread stefano bonnin
w functions I get the row with the higher value ... 2010/6/17 stefano bonnin > Hi all, > I'm trying to make a query that, given N and a date, gives me the interval > of N hours with the max(sum(...)). In others words, given the following > table: > > 2010-06-16 00:00:00 | 0

[GENERAL] Given N, finding the interval of N hours with max(sum(..))

2010-06-16 Thread stefano bonnin
Hi all, I'm trying to make a query that, given N and a date, gives me the interval of N hours with the max(sum(...)). In others words, given the following table: 2010-06-16 00:00:00 | 0 2010-06-16 01:00:00 | 2 2010-06-16 02:00:00 | 1 2010-06-16 03:00:00 | 5 2010-06-16 04:00:00 | 7 2010-06-16 05:00

[GENERAL] Temporal query question

2004-11-30 Thread Stefano Bonnin
Hi all,   I have a "simple" question about the following temporal query with "interval" operator:   can I define a query of this type?   select myfield,numeric_field from mytable where temporal_attribute < temporal_attribute - interval numeric_field || ' days'   obviously this syntax is wrong

[GENERAL] Question about indexes

2004-11-15 Thread Stefano Bonnin
Only a simple question   I have a table with       primarykey(field1,field2,field3)   and I want to execure a query like           select * from my_table where field1 = some_value   if I define an index on field1, I increase the query performace or not?   Thanks

[GENERAL] problem with pg_restore and user privileges

2004-09-16 Thread Stefano Bonnin
Hi, I'm a Postgis user, and I have a problem restoring data from 7.4 to 8.0.0beta2.   I use the postgis_restore.pl script that comes with postgis distribution.   I do the following for the dump: pg_dump -Fc mydb >mydb.sql   and the script does the following restore operations: ... some c