Re: [GENERAL] template_postgis issue

2015-05-15 Thread Giuseppe Broccolo
feature which we will cover in this tutorial. http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 Regards, -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it

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

2014-12-23 Thread Giuseppe Broccolo
-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 stefano bonnin stefano.bon...@gmail.com: Hi all, I have followed the wiki about

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

2014-12-22 Thread Giuseppe Broccolo
‘TimestampTz’ and ‘int’) bdr_apply.c:355:3: error: invalid operands to binary (have ‘TimestampTz’ and ‘int’) make: *** [bdr_apply.o] Error 1 Any help appreciated. Thanks. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www

Re: [GENERAL] GiST index question

2014-09-04 Thread Giuseppe Broccolo
for the datatype path as far as I recall. Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services

Re: [GENERAL] How to get PG 9.3 for a RaspberryPI (Debian Wheezy)?

2014-08-05 Thread Giuseppe Broccolo
@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it

Re: [GENERAL] How to turn off DEBUG statements from psql commends

2014-02-10 Thread Giuseppe Broccolo
/1, nestlvl: 1, children: CREATE SCHEMA gis_demo=# You have set the client_min_messages to debug level. If you launch SET client_min_messages TO notice; You should obtain just the CREATE SCHEMA message. Giuseppe. - -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services

Re: [GENERAL] Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?

2014-01-03 Thread Giuseppe Broccolo
, there is no reason to expect advantage splitting 8k buffers (i.e. a page content size) in my opinion. Giuseppe. - -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -BEGIN PGP SIGNATURE- Comment: Using GnuPG

Re: [GENERAL] vacuum_freeze_table_age for 9.3.2

2013-12-05 Thread Giuseppe Broccolo
by FrozenXID. vacuum_freeze_table_age is a parameter with context 'user', meaning that you can set it during a session and run a vacuum freeze with the modified setting. Giuseppe. - -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it

Re: [GENERAL] vacuum_freeze_table_age for 9.3.2

2013-12-05 Thread Giuseppe Broccolo
is a parameter with context 'user', meaning that you can set it during a session and run a vacuum freeze with the modified setting. Giuseppe. - -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -BEGIN PGP

Re: [GENERAL] pgbench

2013-10-03 Thread Giuseppe Broccolo
to errors. Could this be your case? Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] CREATE DATABASE Š [ TEMPLATE [=] template ] [ TABLESPACE [=] tablespace_name ]

2013-09-26 Thread Giuseppe Broccolo
, independently it's done from a template or not. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it

Re: [GENERAL] remove everything before the period

2013-09-17 Thread Giuseppe Broccolo
want to show everything after the period select volume, substring(volume from 1 for position('.' in volume) - 1) as column from MyTable; Try with: SELECT volume, substring(volume from position('.' in volume) + 1) AS column FROM MyTable; Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy

Re: [GENERAL] problem with query

2013-09-13 Thread Giuseppe Broccolo
database cannot convert strings anyway, and problem remains. The best way is to work with a UTF8 encoded database. Is there a particular reason to work with SQL_ASCII encoding? Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc

Re: [GENERAL] Risk of set system wise statement_timeout

2013-09-12 Thread Giuseppe Broccolo
SELECT cancel_after_2hours(); to be sure that it will be executed in automatic way. Hope it can help, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] plpgsql code doen't work

2013-09-10 Thread Giuseppe Broccolo
'... Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] FW: Single Line Query Logging

2013-09-10 Thread Giuseppe Broccolo
) LOCAL0.*-/var/log/pgsql and in the catch all log files area add LOCAL0.none then restart syslog (sudo /etc/init.d/rsyslog restart). I've tried it, and it works! Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support

Re: [GENERAL] FETCH FORWARD 0 and cursor can only scan forward error

2013-09-04 Thread Giuseppe Broccolo
record *that was yet fetched* by the previous FETCH statement. If the cursor is declared with the NO ROLL options, this operation is forbidden, and an error is raised, as in your case. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc

Re: [GENERAL] Query on a record variable

2013-08-19 Thread Giuseppe Broccolo
AND plainto_tsquery('string') @@ vectors; Hope it can help. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Alter table never finishes

2013-07-30 Thread Giuseppe Broccolo
Hope it can help. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it

Re: [GENERAL] postgres FDW cost estimation options unrecognized in 9.3-beta1

2013-07-29 Thread Giuseppe Broccolo
| postgres_fdw | | | | (host 'cuda-db10', dbname 'nightly', port '5432', use_remote_estimate 'true') | (1 row) Hope this can help. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc

Re: [GENERAL] How to do incremental / differential backup every hour in Postgres 9.1?

2013-07-26 Thread Giuseppe Broccolo
parameter high enough that the log is not removed before the end of the backup. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Rule Question

2013-07-25 Thread Giuseppe Broccolo
http://www.postgresql.org/docs/9.2/static/sql-createtrigger.html as you can also consider conditional triggers to be executed, for example, only when the b column is updated. Hope it can help. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support

Re: [GENERAL] Rule Question

2013-07-25 Thread Giuseppe Broccolo
Unrelated to the OP's question, the suggestion above could be more simply rewritten as TG_OP = 'UPDATE' AND NEW.b IS DISTINCT FROM OLD.b You're right! :) Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www

Re: [GENERAL] process deadlocking on its own transactionid?

2013-07-24 Thread Giuseppe Broccolo
ON bl.transactionid = kl.transactionid AND bl.pid != kl.pid WHERE NOT bl.granted; Hope it can help. Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql

Re: [GENERAL] Index for Levenshtein distance (better format)

2013-07-22 Thread Giuseppe Broccolo
EXPLAIN ANALYSE to exploit the performances: query time changes from 1.077 ms to 0.677 ms after gist index creation. Hope it helps, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it |www.2ndQuadrant.it -- Sent via

Re: [GENERAL] last_vacuum field is not updating

2013-07-15 Thread Giuseppe Broccolo
over any tables that the calling user does not have permission to vacuum. Are you sure you are the table's owner? Regards, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql

Re: [GENERAL] pg recovery

2013-07-11 Thread Giuseppe Broccolo
? Any view/function? The only way to be sure that your configuration file is read is to stop and restart the PostgreSQL service. Regards, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it

Re: [GENERAL] Removing duplicates

2013-07-10 Thread Giuseppe Broccolo
Dear Johann, I tried (with PostgreSQL 9.2) to run the two DELETE statements you describe in your mail (the first based on the id field, the second on the ctid) and they work! I have to point out that if you use the DELETE based on the id field YOU'LL DELETE ALL RECORDS having at least one