postgis
in the database of your choosing or use PgAdmin
Extensions install 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
-
> 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 and Support
giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it
n index on the path data type or
> do I
> > need to enable an extension for this to work? Thanks in advance for your
> > help.
> In-core contrib modules (and core) do not have yet support for gist
> operator classes for the datatype path as far as I recall.
> Regards,
y -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -fpic -I../../src/interfaces/libpq -I. -I. -I../../src/include
> -D_GNU_SOURCE -c -o bdr_apply.o bdr_apply.c
> bdr_apply.c: In function ‘process_remote_commit’:
> bdr_apply.c:286:2: error: invalid operands to binary &
; \
> ^
> 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
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
? 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
skip 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
he same query. I made a simple check with a very simple
table1 example with ten raws using 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,
vity ka
ON kl.pid = ka.procpid
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.
; and b='goodbye'. Anyway, this is just an example.
I suggest that you look at the CREATE TRIGGER page in the documentation
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 upd
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...@
. Notice that WALs
are collected at the end of the backup, so you need to set
wal_keep_segments 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
wrapper | Access privileges | Type |
Version |FDW Options
| Description
---+---+--+---+--+-----+-
;{print $2}'`; do
kill -9 $x; done
Hope it can help.
Giuseppe.
--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it
#x27;string') < 10 AND LENGTH(dede) BETWEEN x AND y 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-ge
t; you move ahead of zero places instead of one;
therefore you obtain the same 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
as an 'integer'...
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.post
in your postgres.conf - do a check)
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 - 2ndQuadra
0 * * * * psql -c "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 pgs
ASCII, even
if terminal show pairs as 'ñ' or 'Ñ'. So ILIKE operator cannot apply
case insensitive pattern matching to data which does not encode any
string (in the SQL_ASCII encoding) and works as a normal LIKE.
Even if the client which insert data has 8-bit encoding (
eriod but i 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; "
Giusep
the objects
creation, 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
pported, and empty lines are ignored.
This could bring 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@
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.bro
old XIDs are replaced 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.
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: Usin
ed; blockState: STARTED;
> state: INPROGR, xid/subid/cid: 15099/1/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
28 matches
Mail list logo
