On 10/16/2014 07:58 AM, holger.friedrich-fa-triva...@it.nrw.de wrote:
Adrian Klaver wrote:
Library mismatch. Looks like rtpostgis-2.0.so is looking for something that
/lib64/libldap_r-2.4.so.2 is not providing. So, if I am following correctly
that would be the OpenSCG version. From the looks o
On 10/16/2014 07:58 AM, holger.friedrich-fa-triva...@it.nrw.de wrote:
Adrian Klaver wrote:
Library mismatch. Looks like rtpostgis-2.0.so is looking for something that
/lib64/libldap_r-2.4.so.2 is not providing. So, if I am following correctly
that would be the OpenSCG version. From the looks o
On Wed, Oct 15, 2014 at 2:03 AM, Alban Hertroys wrote:
>
> On 15 Oct 2014, at 4:33, Abelard Hoffman wrote:
>
> > I believe this query is well optimized, but it's slow if the all the
> blocks aren't already in memory.
> >
> > Here's example explain output. You can see it takes over 7 seconds to
>
On Wed, Oct 15, 2014 at 5:03 AM, Alban Hertroys wrote:
> A CLUSTER would help putting rows with the same to_id together. Disk access
> would be less random that way, so it would help some.
>
> According to your query plan, accessing disks (assuming that’s what made the
> difference) was 154 (770
On 10/16/2014 11:17 AM, Steve Wampler wrote:
On 10/16/2014 10:44 AM, Rob Sargent wrote:
On 10/16/2014 11:38 AM, David G Johnston wrote:
COPY is dumb but fast. If you need logic you need to add it yourself.
Either before the copy or copy into a temporary UNLOGGED table and write
smart SQL to mi
On 10/16/2014 12:09 AM, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
Appreciate any replies on this.
It has been answered, see Tom Lanes link below. In particular you are
looking for PG_DIAG_SQLSTATE.
/rK
-Original Message-
From: Roopeshakumar Narayansa Shalgar (rshalgar)
Sen
Hello,
Two options for data (>1M), may I know which one better please?
(1) copyOut (JDBC copyManager)
t1 into a.csv
delete t2 where pk.cols in t1
copyIn t2 from a.csv
(2) set
Alvaro Melo writes:
> I have a peculiar situation here. I'm optimizing some queries and I
> noticed that EXPLAIN doesn't always show the tables involved in the
> query. Below is a little example, but I have other examples with longer
> queries. Note that the tables tabela_documento_fiscal and p
Hi,
I have a peculiar situation here. I'm optimizing some queries and I
noticed that EXPLAIN doesn't always show the tables involved in the
query. Below is a little example, but I have other examples with longer
queries. Note that the tables tabela_documento_fiscal and pessoa aren't
considere
On 10/16/2014 06:56 AM, Conover, Paul W wrote:
Hello,
I have a Virtual database connection to Teiid using PostgreSQL ODBC
driver 8.04.02.00. When running my SQL queries everything complets
successfully, but the Column Names are all coming back lower case. I did
quite a bit of research on this an
On 10/16/2014 10:44 AM, Rob Sargent wrote:
On 10/16/2014 11:38 AM, David G Johnston wrote:
COPY is dumb but fast. If you need logic you need to add it yourself.
Either before the copy or copy into a temporary UNLOGGED table and write
smart SQL to migrate from that to the live table.
You can al
On Thu, 16 Oct 2014 10:02:08 -0700
snacktime wrote:
> I'm confused about how deadlock detection and breaking deadlocks works.
> Googling around it seems that the server should be detecting deadlocks and
> aborting one of the queries.
>
> But I'm getting occasional deadlocks that literally hang f
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of snacktime
Sent: Thursday, October 16, 2014 1:02 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Misunderstanding deadlocks
I'm confused about how deadlock detection and breaking deadlocks wo
On 10/16/2014 11:52 AM, David G Johnston wrote:
On Thu, Oct 16, 2014 at 11:44 AM, lup [via PostgreSQL] <[hidden email]
>wrote:
I appreciate the vastness of bigserial but I think it starts at
1. Are negative numbers even allowed?
http://www.postgresql.org/docs/9.3/static/sql-create
Hi
2014-10-16 15:27 GMT+02:00 Naveen Krishna :
> Respected Sir,
>
> i want to use postgresql DataBase. but when i am trying to execute
> script it is showing me error in extensions, i tried in many ways but i am
> not able to execute script, please tell me how to install Extension in
> postgr
On Thu, Oct 16, 2014 at 11:44 AM, lup [via PostgreSQL] <
ml-node+s1045698n5823292...@n5.nabble.com> wrote:
>
>
> I appreciate the vastness of bigserial but I think it starts at 1. Are
> negative numbers even allowed?
http://www.postgresql.org/docs/9.3/static/sql-createsequence.html
A DEFAULT
Naveen Krishna wrote:
> Respected Sir,
>
> i want to use postgresql DataBase. but when i am trying to execute script
> it is showing me error in extensions, i tried in many ways but i am not able
> to
> execute script, please tell me how to install Extension in postgresql. i am
> waiting fo
On 10/16/2014 11:38 AM, David G Johnston wrote:
Steve Wampler wrote
Let me generalize the problem a bit: How can I specify that the default
value of a column
is to be used with a COPY command when some rows have values for that
column and
some don't?
If you provide a value for a column, includ
On 10/16/2014 11:04 AM, Steve Wampler wrote:
On 10/16/2014 09:42 AM, Rob Sargent wrote:
On 10/16/2014 10:33 AM, Steve Wampler wrote:
This is with Postgresql 9.3.5.
I'm looking at using a COPY command (via jdbc) to do bulk inserts
into a table that
includes a BIGSERIAL column. Is there a wa
Steve Wampler wrote
> Let me generalize the problem a bit: How can I specify that the default
> value of a column
> is to be used with a COPY command when some rows have values for that
> column and
> some don't?
If you provide a value for a column, including NULL, the default expression
is not e
Hello,
I have a Virtual database connection to Teiid using PostgreSQL ODBC driver
8.04.02.00. When running my SQL queries everything complets successfully, but
the Column Names are all coming back lower case. I did quite a bit of research
on this and am finding that if the alias is in Double Qu
Respected Sir,
i want to use postgresql DataBase. but when i am trying to execute
script it is showing me error in extensions, i tried in many ways but i am
not able to execute script, please tell me how to install Extension in
postgresql. i am waiting for your kind replay
With Regards
M N
Appreciate any replies on this.
/rK
-Original Message-
From: Roopeshakumar Narayansa Shalgar (rshalgar)
Sent: Wednesday, October 15, 2014 10:19 PM
To: 'Tom Lane'; pgsql-...@postgresql.org; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Any postgres API available to get errorcode for
On 10/16/2014 09:42 AM, Rob Sargent wrote:
On 10/16/2014 10:33 AM, Steve Wampler wrote:
This is with Postgresql 9.3.5.
I'm looking at using a COPY command (via jdbc) to do bulk inserts into a table
that
includes a BIGSERIAL column. Is there a way to mark the data in that
column so it gets as
I'm confused about how deadlock detection and breaking deadlocks works.
Googling around it seems that the server should be detecting deadlocks and
aborting one of the queries.
But I'm getting occasional deadlocks that literally hang forever. I'm
assuming they are deadlocks because they show up wh
On 10/16/2014 10:33 AM, Steve Wampler wrote:
Hi,
This is with Postgresql 9.3.5.
I'm looking at using a COPY command (via jdbc) to do bulk inserts into
a table that
includes a BIGSERIAL column. Is there a way to mark the data in that
column so it gets assigned a new value on entry - akin to
Hi,
This is with Postgresql 9.3.5.
I'm looking at using a COPY command (via jdbc) to do bulk inserts into a table
that
includes a BIGSERIAL column. Is there a way to mark the data in that
column so it gets assigned a new value on entry - akin to the use of 'default'
in an INSERT? Some of t
Hello Adrian,
Yes, I am aware of it. I even used to use Debian pg_createcluster and other
tools before.
Even so, thank you for your comment.
Best regards.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-start-several-PostgreSQL-clusters-at-boot-time-on-a-Debian-O
Adrian Klaver wrote:
> Library mismatch. Looks like rtpostgis-2.0.so is looking for something that
> /lib64/libldap_r-2.4.so.2 is not providing. So, if I am following correctly
> that would be the OpenSCG version. From the looks of it, that library is not
> recent enough.
For the record: Appar
29 matches
Mail list logo