On 2013-01-08, aasat satri...@veranet.pl wrote:
Hi,
I want to store clickmap points (X, Y and hits value) for website
I currently have table like this
CREATE TABLE clickmap (
page_id integer,
date date,
x smallint,
y smallint,
hits integer
)
But this generated about 1M
Hello,
from some time I have a very strange problem with my postgresql 9.2.2
64bit.
I make a few changes with an plp function:
BEGIN
UPDATE table SET X = X where id = aid;
UPDATE table_2 SET Y=Y where id = aid;
IF aid 0 THEN
SELECT INTO ids id FROM table_3 WHERE x = x;
IF aid
On 1/14/2013 12:15 AM, Condor wrote:
When I call the function from php everything it's seems to work,
but some time modify records just disappear. I don't have any ideas
for the moment
what is the problem in my postgresql or in my php code. I'm sure there
was a recording was made.
I run in
On 1/14/2013 12:45 AM, John R Pierce wrote:
On 1/14/2013 12:15 AM, Condor wrote:
When I call the function from php everything it's seems to work,
but some time modify records just disappear. I don't have any ideas
for the moment
what is the problem in my postgresql or in my php code. I'm sure
On 01/14/2013 05:15 PM, Condor wrote:
Hello,
from some time I have a very strange problem with my postgresql 9.2.2
64bit.
I make a few changes with an plp function:
BEGIN
UPDATE table SET X = X where id = aid;
UPDATE table_2 SET Y=Y where id = aid;
IF aid 0 THEN
SELECT INTO ids id
On 14/01/13 01:13, sub3 wrote:
Hi,
I am having an issue upgrading a really old 8.2 db up to 9.2.2. One of the
tables contains a bytea field. When I backup restore using pgadmin from
my 9.2.2 install, it doesn't convert this field correctly.
Could this be due to your bytea_output setting?
On 2013-01-14 10:53, Vlad Arkhipov wrote:
On 01/14/2013 05:15 PM, Condor wrote:
Hello,
from some time I have a very strange problem with my postgresql
9.2.2 64bit.
I make a few changes with an plp function:
BEGIN
UPDATE table SET X = X where id = aid;
UPDATE table_2 SET Y=Y where id =
On Sun, Jan 13, 2013 at 8:27 PM, Shaun Thomas stho...@optionshouse.comwrote:
Hey guys,
I'm not sure the last time I saw this discussion, but I was somewhat
curious: what would be your ideal Linux distribution for a nice solid
PostgreSQL installation? We've kinda bounced back and forth
On 1/14/2013 12:15 AM, Condor wrote:
IF aid 0 THEN
SELECT INTO ids id FROM table_3 WHERE x = x;
IF aid IS NULL THEN
oh, I see a logical error here too... if aid /is/ in fact NULL then
that inner code will never be executed, because NULL can not be 0, it
has no value. For
On 2013-01-14 10:45, John R Pierce wrote:
On 1/14/2013 12:15 AM, Condor wrote:
When I call the function from php everything it's seems to work,
but some time modify records just disappear. I don't have any ideas
for the moment
what is the problem in my postgresql or in my php code. I'm sure
On 1/14/2013 1:34 AM, Condor wrote:
It's a standalone statements without BEGIN TRANSACTION. An update is
easy to explain with another
but insert with missing row and there is no DELETE command in whole
code and no one other have access to server.
No any error logs, only access log system insert
On Sun, Jan 13, 2013 at 8:54 PM, Edson Richter edsonrich...@hotmail.com wrote:
Em 14/01/2013 01:46, Scott Marlowe escreveu:
My preference personally is for debian based distros since they
support the rather more elegant pg wrappers that allow you to run
multiple versions and multiple clusters
On 2013-01-14 11:41, John R Pierce wrote:
On 1/14/2013 1:34 AM, Condor wrote:
It's a standalone statements without BEGIN TRANSACTION. An update is
easy to explain with another
but insert with missing row and there is no DELETE command in whole
code and no one other have access to server.
No
unregister
461246131
I am using 2 threads, each declares seperate PGconn conenction object.
It connects e.g. 60 times, one connection from one thread, the other connection
from the other thread, usually one after each other.
And it fails at 61'st connection with access violation.
I already tried with PQconnect and
An access violation means that you're trying to access memory that doesn't
belong to your process. I'm not sure where it's originating, that could be
the server but I suspect the issue is at the client-side.
You're probably just forgetting to free memory somewhere.
On 14 January 2013 13:50,
On Mon, Jan 14, 2013 at 8:28 AM, Alban Hertroys haram...@gmail.com wrote:
An access violation means that you're trying to access memory that doesn't
belong to your process. I'm not sure where it's originating, that could be
the server but I suspect the issue is at the client-side.
You're
Tom Lane wrote:
Consider sticking the nextval() into a WITH.
This is also a reminder that PG's nextval() differs on this from
the SQL standard, which says:
If there are multiple instances of next value expressions
specifying the same sequence generator within a single
SQL-statement,
Hi,
I have a plpython stored procedure which sometimes fails when I run my
applications automated test suite. The procedure is called hundreds of
times during the tests but only fails a few times, often with the
following ImportError:
Traceback (most recent call last):
File
On 14/01/13 22:24, Hendrik Visage wrote:
On Sun, Jan 13, 2013 at 8:27 PM, Shaun Thomas
stho...@optionshouse.com mailto:stho...@optionshouse.com wrote:
Hey guys,
I'm not sure the last time I saw this discussion, but I was
somewhat curious: what would be your ideal Linux
On 01/14/2013 08:30 AM, Brian Sutherland wrote:
Hi,
I have a plpython stored procedure which sometimes fails when I run my
applications automated test suite. The procedure is called hundreds of
times during the tests but only fails a few times, often with the
following ImportError:
Edson Richter wrote:
Do you have any fact that support RHEL being slower than others?
I would like to improve our servers if we can get some ideas - so far,
we have tried Ubuntu LTS servers, and seems just as fast as RHEL for
PostgreSQL (tests made by issuing heavy queries).
On
Using Postgres 9.1
(1)
Simulate a power failure by hitting Restart on my VMware Workstation.
(2)
Turn on the VM (without any script removing lock or socket file).
(3)
Try to start postgres.
$ pgsql/bin/pg_ctl start -D pgdata
server starting
2013-01-14 FATAL: lock file /tmp/.s.PGSQL.5432.lock
On Mon, Jan 14, 2013 at 09:05:09AM -0800, Adrian Klaver wrote:
On 01/14/2013 08:30 AM, Brian Sutherland wrote:
Hi,
I have a plpython stored procedure which sometimes fails when I run my
applications automated test suite. The procedure is called hundreds of
times during the tests but only
On 1/13/13, Chris Angelico ros...@gmail.com wrote:
On Mon, Jan 14, 2013 at 3:37 PM, Robert James srobertja...@gmail.com
wrote:
Thanks. But how do I do that where I have many literals? Something like:
INSERT INTO seltest (id, a, b) SELECT (1,2,3),(4,5,6),(7,8,9) WHERE b
IN (SELECT ...)
You
Sahagian, David david.sahag...@emc.com writes:
Using Postgres 9.1
(1)
Simulate a power failure by hitting Restart on my VMware Workstation.
(2)
Turn on the VM (without any script removing lock or socket file).
(3)
Try to start postgres.
$ pgsql/bin/pg_ctl start -D pgdata
server starting
On Tue, Jan 15, 2013 at 5:26 AM, Robert James srobertja...@gmail.com wrote:
On 1/13/13, Chris Angelico ros...@gmail.com wrote:
On Mon, Jan 14, 2013 at 3:37 PM, Robert James srobertja...@gmail.com
wrote:
Thanks. But how do I do that where I have many literals? Something like:
INSERT INTO
RESOLVED
--
Dear all,
Thank you for your great help and multiple advices.
I discovered the problem and I have to say that it is very stupid and strange.
Here is what happened.
From all advices I tried first partial index. The index was built and there
was no change in the speed of the slow
On 15/01/13 09:43, Chris Angelico wrote:
On Tue, Jan 15, 2013 at 5:26 AM, Robert James srobertja...@gmail.com wrote:
On 1/13/13, Chris Angelico ros...@gmail.com wrote:
On Mon, Jan 14, 2013 at 3:37 PM, Robert James srobertja...@gmail.com
wrote:
Thanks. But how do I do that where I have many
Le lundi 14 janvier 2013 à 18:03 +0100, Daniel Verite a écrit :
On Debian/Ubuntu, the default behavior is to have SSL enabled out
of the box, including for TCP connections to localhost.
It is in Ubuntu, but not in Debian.
To the OP : I maintain three servers using Debian stable, each facing
On 01/14/2013 04:19 PM, Vincent Veyron wrote:
The only downtime I had in over two years was due a forced bios upgrade
by the hosting service, and I have no formal training in server
administration. Debian stable certainly works.
My personal server is on Debian too, with a similar uptime. But
Hi Guys
anyone know where I can zip or tar version of PostgreSQL 8.4 ?
Thanks!
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
2013/1/15 Martin Gainty mgai...@hotmail.com:
Hi Guys
anyone know where I can zip or tar version of PostgreSQL 8.4 ?
Here?
http://www.postgresql.org/ftp/source/v8.4.15/
Ian Lawrence Barwick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 01/14/2013 02:51 PM, Martin Gainty wrote:
Hi Guys
anyone know where I can zip or tar version of PostgreSQL 8.4 ?
http://www.postgresql.org/ftp/source/v8.4.15/
Thanks!
Martin Gainty
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list
On 01/14/2013 09:55 AM, Brian Sutherland wrote:
Changing the order in which the tests are run, or running tests
individually makes the error move/change or disappear. The behaviour is
the same with PostgreSQL versions 9.2.2 and 9.1.7.
I have tried (but failed) to reproduce this error in a
Hey guys,
I'm not sure the last time I saw this discussion, but I was somewhat curious:
what would be your ideal Linux distribution for a nice solid PostgreSQL
installation? We've kinda bounced back and forth between RHEL, CentOS, and
Ubuntu LTS, so I was wondering what everyone else
On 15.01.2013, at 00:28, Rich Shepard rshep...@appl-ecosys.com wrote:
On Tue, 15 Jan 2013, T. E. Lawrence wrote:
When forced on Linux we like Debian because it is so conservative (which
can sometimes drive one crazy, especially if one needs some cutting edge
feature).
T.
Take a look
Hi,
I am new to PG Streaming Replication and I have a simple question hopefully
someone can answer this easily.
I setup a Primary Hot Standby and they are connecting each other without
problem.
Looking at the wal sender process, both servers pointing to the same
location as follow:
Primary:
On Monday, January 14, 2013, T. E. Lawrence wrote:
RESOLVED
--
Dear all,
Thank you for your great help and multiple advices.
I discovered the problem and I have to say that it is very stupid and
strange.
Here is what happened.
...
So I decided to try the whole thing properly from
On Sun, Jan 13, 2013 at 10:37 PM, Robert James srobertja...@gmail.comwrote:
On 1/13/13, Ian Lawrence Barwick barw...@gmail.com wrote:
2013/1/14 Robert James srobertja...@gmail.com:
I have a lot of VALUES I want to INSERT. But only a subset of them -
only those that meet a JOIN criteria
On 2013.01.13 6:00 PM, Robert James wrote:
I have a lot of VALUES I want to INSERT. But only a subset of them -
only those that meet a JOIN criteria involving another table.
I could INSERT them into a temp table, and then do a SELECT INTO. But
do I need to do that? Is there any way to do a
41 matches
Mail list logo