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
-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
‘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
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
@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
/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
, 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
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
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
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
, 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
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
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
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
'...
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
)
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
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
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
Hope it can help.
Giuseppe.
--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it
| 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
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
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
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
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
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
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
? 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
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
28 matches
Mail list logo