Hi,
I am getting an error while retrieving the values from xml and converting
into date format
when I execute this query
select history from KM_REL_FF_USR_DATA whereUSERID in (53008) and
SHARE_WORKING_GROUP =15683
output is
HISTORY TYPE=DATAENTRYTYPE USERSUBMITEDDATA ID=1
The table definition:
CREATE TABLE isi.isi_l1_publication
(
article_id character varying(15),
journal_id character varying(7),
volume character varying(10),
issue character varying(10),
publication_year character varying(4),
publication_date character varying(20),
id bigint NOT NULL
Sorry for waisting your time. I just now saw the missing period between A
and publication_year which is causing the problem and explains the
'strange' result.
Regards
Johann
On 3 October 2013 10:08, Johann Spies johann.sp...@gmail.com wrote:
The table definition:
CREATE TABLE
Johann Spies johann.sp...@gmail.com wrote:
SELECT A.article_id, A publication_year
I have seen it once before and could not figured out what is causing it.
The point is the missing point between A and publication_year ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will
Hello Friends,
How to know cpu and memory utilization in postgres.
We require this information to show it on our Application using any postgres
command or tool.
Regards
Tarkeshwar
On 10/3/2013 1:50 AM, M Tarkeshwar Rao wrote:
How to know cpu and memory utilization in postgres.
We require this information to show it on our Application using any
postgres command or tool.
the CPU usage would be the total of CPU used by the various postgres
server processes.
Hello,
I am dealing with the old decision about hiw to store data objects and
trying to understand deep the postgre system including toast,
pg-largedataobject table and so on.
My real doubt right now is why bytea does not gets processed by toast
system even when is grow enough. Since ive read
Johann Spies wrote:
SELECT A.article_id, A publication_year
You are missing a . between in what you think is the second
column (after the A).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
saritha N wrote
ERROR: invalid value {0 for dd
DETAIL: Value must be an integer.
The leading { in the data is the big give away. This is how a string
representation of an array looks. From the documentation:
http://www.postgresql.org/docs/9.3/interactive/functions-xml.html
The
Hello
I was doing a performance test with pgbench with a pretty long queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Client 0 aborted in state 0: ERROR: syntax error at end of input
LINE 1: ...(abc.persones.provincia = abc.poblacions.cod_provinc
^
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Client 0 aborted in state 0: ERROR: syntax error at end of input
LINE 1:
On 10/03/2013 07:11 AM, Simeó Reig wrote:
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long
queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Client 0 aborted in state 0: ERROR: syntax
A 2013-10-03 16:16, Adrian Klaver escrigué:
On 10/03/2013 07:11 AM, Simeó Reig wrote:
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long
queries
and I have the next error:
$
On 10/03/2013 07:23 AM, Simeó Reig wrote:
You have not shown the query, but could you be running into the belwo:
http://www.postgresql.org/docs/9.3/interactive/pgbench.html
The format of a script file is one SQL command per line; multiline
SQL commands are not supported. Empty lines and
On Thu, Oct 3, 2013 at 1:50 AM, M Tarkeshwar Rao
m.tarkeshwar@ericsson.com wrote:
How to know cpu and memory utilization in postgres.
We require this information to show it on our Application using any
postgres command or tool.
pg_activity works pretty well:
A 2013-10-03 16:40, Adrian Klaver escrigué:
On 10/03/2013 07:23 AM, Simeó Reig wrote:
You have not shown the query, but could you be running into the
belwo:
http://www.postgresql.org/docs/9.3/interactive/pgbench.html
The format of a script file is one SQL command per line; multiline
SQL
Il 03/10/2013 16:11, Simeó Reig ha scritto:
A 2013-10-03 15:51, Adrian Klaver escrigué:
On 10/03/2013 06:21 AM, Simeó Reig wrote:
Hello
I was doing a performance test with pgbench with a pretty long
queries
and I have the next error:
$ pgbench -n -c1 -T 3 -f veins_pgbench.sql pdn
Thanks a lot,It worked for me.
Thanks Regards,
Saritha
On Thu, Oct 3, 2013 at 6:40 PM, David Johnston pol...@yahoo.com wrote:
saritha N wrote
ERROR: invalid value {0 for dd
DETAIL: Value must be an integer.
The leading { in the data is the big give away. This is how a string
Giuseppe Broccolo wrote:
The format of the script file has to be one SQL command per line;
multiline SQL commands are not supported, and empty lines are
ignored. This could bring to errors. Could this be your case?
Multiline SQL commands are not supported? Well that sucks, because only
Alvaro Herrera alvhe...@2ndquadrant.com writes:
Multiline SQL commands are not supported? Well that sucks, because only
BUFSIZ chars are read from each line. In my platform that's 8192, but
maybe in Simeó's case it's shorter .. or maybe his query really is
longer than 8192 bytes.
This
-- Forwarded message --
From: Shahzad Bashir shahzadbashir4...@hotmail.com
Date: Thu, Oct 3, 2013 at 5:43 AM
Subject: RE: [ADMIN] Database replication to 50-80 nodes
To: Jaime Casanova ja...@2ndquadrant.com
hi,
I am very much new to postgres, infact just started... can
Thanks for all suggestions. based on the constraints I had with network, I
could able to set up the warm stand by. I am seeing the following log file
I don't know to how to handle.
2013-10-03 17:52:00 GMT [27636]: [457-1] user=,db=LOG: restored log file
000101F60003 from archive
Hi all,
We partition the data in postgres in a per-month basis and run a script
to delete old partitions. Sometimes this script fails and the delete
doesn't happen because of a deadlock, today I noticed that it was the
autovacuumer that fighting with the script.
Is it possible to stop the
On Thu, Oct 3, 2013 at 11:48 AM, Michael Graham mgra...@bloxx.com wrote:
Hi all,
We partition the data in postgres in a per-month basis and run a script
to delete old partitions.
Does delete = drop?
Sometimes this script fails and the delete
doesn't happen because of a deadlock, today
On Thu, 2013-10-03 at 11:53 -0700, bricklen wrote:
On Thu, Oct 3, 2013 at 11:48 AM, Michael Graham mgra...@bloxx.com
wrote:
Hi all,
We partition the data in postgres in a per-month basis and run
a script
to delete old partitions.
Does delete
On 10/3/2013 11:53 AM, bricklen wrote:
Are you uninheriting the partition before attempting to get rid of it?
Eg.
ALTER TABLE your_partition NO INHERIT the_parent_table;
in a completely different but similar scenario, we've tried this, but NO
INHERIT also blocks and and can deadlock if
Hello,
I have a problem on my pg 9.2.4 setup (OpenSuse 12.2, kernel 3.2.13).
My pg_xlog directory is growing uncontrolably untill it fills the partition.
The database is under heavy write load and is spread on two tablesapces one on
a ssd software raid1 partition and a second one on a hdd
Try setting the following in your postgresql.conf:
wal_keep_segments = 0
On Thu, Oct 3, 2013 at 2:56 PM, Michal TOMA m...@sicoop.com wrote:
Hello,
I have a problem on my pg 9.2.4 setup (OpenSuse 12.2, kernel 3.2.13).
My pg_xlog directory is growing uncontrolably untill it fills the
2013/10/4 Jaime Casanova ja...@2ndquadrant.com:
what version of postgres is this? starting in 9.3 you can create
foreign tables between postgres databases, before that you can create
a foreing server and use the functions from th dblink module to
connect to that server and query the table on
On Thu, Oct 3, 2013 at 5:40 PM, Ian Lawrence Barwick barw...@gmail.com wrote:
2013/10/4 Jaime Casanova ja...@2ndquadrant.com:
what version of postgres is this? starting in 9.3 you can create
foreign tables between postgres databases, before that you can create
a foreing server and use the
I have it set to 0 already.
On Friday 04 October 2013 00:16:28 Ken Brush wrote:
Try setting the following in your postgresql.conf:
wal_keep_segments = 0
On Thu, Oct 3, 2013 at 2:56 PM, Michal TOMA m...@sicoop.com wrote:
Hello,
I have a problem on my pg 9.2.4 setup (OpenSuse 12.2,
32 matches
Mail list logo
