On Mon, Sep 22, 2014 at 7:39 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Xiang Gan xiang...@santaitech.com writes:
OK. So a stupid question, whether there is any possibility to run
Postgresql as root? (I know this is forbidden generally. But what I find
out is that in Linux FriendlyArm
On Mon, Sep 22, 2014 at 8:40 AM, John McKown john.archie.mck...@gmail.com
wrote:
On Mon, Sep 22, 2014 at 10:31 AM, Merlin Moncure mmonc...@gmail.com
wrote:
On Fri, Sep 19, 2014 at 7:16 AM, Bill Moran wmo...@potentialtech.com
wrote:
On Fri, 19 Sep 2014 09:32:09 +0200
Marius Grama
Hi all
I've had some issues with how the procedural languages are packaged in
the Windows installer for a while, but I was very surprised to see that
plpython2 appears to be entirely absent in 9.3.
It doesn't seem to be provided via EDB's StackBuilder app either.
What's going on? It looks like
Hello,
I'm trying to import data using a csv file,
but I got an error:
ERROR: column key;daprof;aprof;tipo;valore;note;oid;unit_mis of relation
assorb does not exist
LINE 1: INSERT INTO info_pozzi_hydrocarbon.assorb (key;daprof;a...
^
Hi,
Quotation marks should be around both the name of
each and every column and their values.
Also replace column comas as separation character
for sql insert statement.
What has happened here is that the values from CSV
are directly into sql.
Hope this helps.
Best Regards
Why don't you use COPY ?
Cheers,
Rémi-C
2014-09-23 12:50 GMT+02:00 FarjadFarid(ChkNet)
farjad.fa...@checknetworks.com:
Hi,
Quotation marks should be around both the name of each and every column
and their values.
Also replace column comas as separation character for sql insert
Hi List,
a workaround for my own problems as described below:
In the following system-table-colums (type aclitem[]) I replaced all entries with these non-existing Group-Roles with something like {postgres=arwdDxt/postgres,kniprath=arwdDxt/kniprath}, this resets the privileges to just these two
Hi,
Quotation marks should be around both the name of
each and every column and their values.
As the columns names are all lower case. You may
wish to remove all quotation marks which is much
easier.
But character value needs quotation mark.
Also replace the semi-column as
On Tue, 23 Sep 2014 13:24:40 +0800
Sameer Kumar sameer.ku...@ashnik.com wrote:
I am working with a vendor and planning to deploy their application on
PostgreSQL as backend. They have cautioned the customer that PostgreSQL's
jdbc driver v9.1 (build 900) has issues which causes deadlocks while
I've gone through the same journey myself. Tried to juggle dlls etc.
Apparently python 2 is no longer included in the windows installer.
Since I have lots of python 2.x code with native extensions etc, I thought
about compiling postgres from source on Windows but as usual the process
turned into a
Hi,
I adjusted the csv, changing the semi-column with column and inserting the
quote for character.
Now it seems to be better but I got another error. This last is due to the fact
that oid column in my
postgresql table is a serial and I did not filled it in csv because I was
thinking that
Hi Eugenio,
How you got about resolving this depends on your
project, the size of data.
For a simple case, which this seems to be. Simply
don't insert the serial column. E.g. remove both
name of the column and its corresponding value in
the insert statement.
Postgresql will insert these
Sameer Kumar schrieb am 23.09.2014 um 07:24:
I am working with a vendor and planning to deploy their application
on PostgreSQL as backend. They have cautioned the customer that
PostgreSQL's jdbc driver v9.1 (build 900) has issues which causes
deadlocks while wide record inserts.
Can you be a
On Tue, 23 Sep 2014 14:12:22 +0200
Thomas Kellerer spam_ea...@gmx.net wrote:
Sameer Kumar schrieb am 23.09.2014 um 07:24:
I am working with a vendor and planning to deploy their application
on PostgreSQL as backend. They have cautioned the customer that
PostgreSQL's jdbc driver v9.1 (build
On Fri, Sep 5, 2014 at 11:39 AM, Rich Shepard rshep...@appl-ecosys.com
wrote:
On Fri, 5 Sep 2014, John McKown wrote:
They are excellent. They are _not_ for beginners. The For Smarties
portion is not just a play against the For Dummies series. Joe does some
high powered SQL.
For the
Thank you Farjad,
following your suggestion I'm now able to import my csv and the serial
automatically is inserted in the new records.
Bye
E.
From: farjad.fa...@checknetworks.com
To: frippe12...@hotmail.com; pgsql-general@postgresql.org
Subject: RE: [GENERAL] csv import error
Date: Tue, 23
On Tue, Sep 23, 2014 at 2:29 AM, Abelard Hoffman
abelardhoff...@gmail.com wrote:
Typically, applications open the port as root and then change to low
privilege for the actual service.
See also this thread:
On 09/22/2014 10:21 PM, Joel Avni wrote:
Its version 9.3.5, whats interesting the that the table grew in size after
the vacuum full, which I did to try to see why the auto vacuum wasn¹t
working.
Please do not top post, it makes it difficult to follow the thread.
However, after I stopped the
hi all,
This part looks correct and expected:
$ psql foobar
psql (9.3.5)
Type help for help.
foobar=# select coalesce('{}'::json-'a', 1);
ERROR: COALESCE types json and integer cannot be matched
LINE 1: select coalesce('{}'::json-'a', 1);
^
but
hi,
I've got use cases like
array_remove(array_agg((a-'b')::float), NULL)
It would be nice to replace (a-'b')::float with something like
a-^'b'
that directly returned a numeric... is that in the cards?
Thanks,
Seamus
--
Seamus Abshere, SCEA
https://github.com/seamusabshere
--
Sent
Craig Ringer craig at 2ndquadrant.com writes:
I've had some issues with how the procedural languages are packaged in
the Windows installer for a while, but I was very surprised to see that
plpython2 appears to be entirely absent in 9.3.
It doesn't seem to be provided via EDB's StackBuilder
seamusabshere wrote
hi all,
This part looks correct and expected:
$ psql foobar
psql (9.3.5)
Type help for help.
foobar=# select coalesce('{}'::json-'a', 1);
ERROR: COALESCE types json and integer cannot be matched
LINE 1: select coalesce('{}'::json-'a', 1);
Seamus Abshere sea...@abshere.net writes:
foobar=# select coalesce('{}'::json-'a', 1);
ERROR: COALESCE types json and integer cannot be matched
Right ...
but check it out when I use a string instead of an integer:
foobar=# select coalesce('{}'::json-'a', 'b');
ERROR: invalid input syntax
Seamus Abshere sea...@abshere.net writes:
I've got use cases like
array_remove(array_agg((a-'b')::float), NULL)
It would be nice to replace (a-'b')::float with something like
a-^'b'
that directly returned a numeric... is that in the cards?
I believe we discussed this, along with variants to
Hi all,
I’m trying to implement an spgist index in the PostGIS extension, which seems
like it should work, but is thus far not working for what appear (to me) to be
issues in the way spgist expects to pass pointers to user-defined functions.
Right before anything happens, spgist calls a
Hi Paul,
On 2014-09-23 09:55:32 -0700, Paul Ramsey wrote:
I’m trying to implement an spgist index in the PostGIS extension, which seems
like it should work, but is thus far not working for what appear (to me) to
be issues in the way spgist expects to pass pointers to user-defined
Oh vey, I knew after spending a half-day walking through the debugger it would
turn out to be a trivial mistake on my part. This is always how it is when the
Magic Fails to Work :) Thanks so much for the help! (and now I know a lot more
about the function manager (well, the old one)).
P
--
Hi,
My application runs many concurrent sessions with the same transaction code
starting with an update statement.
I would expect locking and serialization of those transactions. But I get
unexpected deadlocks.
As opposed to *http://momjian.us/main/writings/pgsql/locking.pdf
Quoting Seref Arikan serefari...@gmail.com:
On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer cr...@2ndquadrant.com wrote:
Hi all
I've had some issues with how the procedural languages are packaged in
the Windows installer for a while, but I was very surprised to see that
plpython2 appears to
On Tuesday, September 23, 2014 02:05:48 PM Nick Guenther wrote:
I uninstalled all the postgres subpackages and rebuilt them from
ports, and ended up with an identical plpython2.so, which has these
checksums:
SHA256 (/usr/local/lib/postgresql/plpython2.so) =
On 09/23/2014 11:05 AM, Nick Guenther wrote:
Quoting Seref Arikan serefari...@gmail.com:
On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer cr...@2ndquadrant.com
wrote:
Hi all
I've had some issues with how the procedural languages are packaged in
the Windows installer for a while, but I was
On Tue, Sep 23, 2014 at 11:05 AM, Nick Guenther nguen...@uwaterloo.ca
wrote:
I've struggled with plpython on OpenBSD 5.5-amd64 as well. Could it be
related? Maybe the amount of dependencies python pulls in gets overwhelming
and things break?
$ psql -h localhost -d postgres
psql (9.3.2)
Type
Hello list,
For a big table with more than 1,000,000 records, may I know which
update is quicker please?
(1) update t1
set c1 = a.c1
from a
where pk and
t1.c1a.c1;
..
update t1
set c_N = a.c_N
from a
where pk and
On Tue, Sep 23, 2014 at 8:35 PM, Emi Lu em...@encs.concordia.ca wrote:
Hello list,
For a big table with more than 1,000,000 records, may I know which update is
quicker please?
(1) update t1
set c1 = a.c1
from a
where pk and
t1.c1a.c1;
..
On 09/23/2014 12:35 PM, Emi Lu wrote:
Hello list,
For a big table with more than 1,000,000 records, may I know which
update is quicker please?
(1) update t1
set c1 = a.c1
from a
where pk and
t1.c1a.c1;
..
update t1
set c_N = a.c_N
On September 23, 2014 2:27:29 PM EDT, Adrian Klaver
adrian.kla...@aklaver.com wrote:
On 09/23/2014 11:05 AM, Nick Guenther wrote:
Quoting Seref Arikan serefari...@gmail.com:
On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer
cr...@2ndquadrant.com
wrote:
Hi all
I've had some issues with
Hello list, I need some help with this error:
...
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: [archiver] -C and -c are incompatible options
pg_dump: *** aborted because of error
Process returned exit code 1.
I get this error when i'm trying to create
Carlos Carcamo eazyd...@gmail.com writes:
Hello list, I need some help with this error:
...
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: [archiver] -C and -c are incompatible options
pg_dump: *** aborted because of error
Like it says, you should
On 09/23/2014 04:01 PM, Carlos Carcamo wrote:
Hello list, I need some help with this error:
...
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: [archiver] -C and -c are incompatible options
pg_dump: *** aborted because of error
Process returned exit
Tom Lane-2 wrote
Carlos Carcamo lt;
eazyduiz@
gt; writes:
Hello list, I need some help with this error:
...
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: [archiver] -C and -c are incompatible options
pg_dump: *** aborted because of error
Hi.
Is spaces is nessesary in text presentation of JSONB?
In my data resulting text contains ~12% of spaces.
I'm developing web application, and want to get json-string from pg and
send it to browser without repacking.
--
С уважением,
Ащепков Илья koc...@gmail.com
Thanks Jan.!! Will check and update you all the findings.
Cheers
On Sat, Sep 20, 2014 at 4:17 AM, Jan-Pieter Cornet joh...@xs4all.net
wrote:
On 2014-9-19 20:33 , Adarsh Sharma wrote:
It returns approx *311 MB* data to the client servers.
root netstat -p | grep 45355
tcp0
42 matches
Mail list logo