On 2013-01-08, aasat 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 rows pe
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 I
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 mi
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?
h
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 = a
On Sun, Jan 13, 2013 at 8:27 PM, Shaun Thomas 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 distribution for a nice solid
> PostgreSQL installation? We've kinda bounced back and forth between RHEL,
> CentOS, an
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. F
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
t
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 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 of those versio
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 any
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 P
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, Asia
On Mon, Jan 14, 2013 at 8:28 AM, Alban Hertroys 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 probably just forg
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 s
specifying the same sequence generator within a single
SQL-statement, all those instances re
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 "/Users/jint
On 14/01/13 22:24, Hendrik Visage wrote:
On Sun, Jan 13, 2013 at 8:27 PM, Shaun Thomas
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 distribution for
a nice sol
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:
Traceba
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.lo
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 b
On 1/13/13, Chris Angelico wrote:
> On Mon, Jan 14, 2013 at 3:37 PM, Robert James
> 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 can use WITH clauses in cr
"Sahagian, David" 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
> 2013-01
On Tue, Jan 15, 2013 at 5:26 AM, Robert James wrote:
> On 1/13/13, Chris Angelico wrote:
>> On Mon, Jan 14, 2013 at 3:37 PM, Robert James
>> 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)
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 q
On 15/01/13 09:43, Chris Angelico wrote:
On Tue, Jan 15, 2013 at 5:26 AM, Robert James wrote:
On 1/13/13, Chris Angelico wrote:
On Mon, Jan 14, 2013 at 3:37 PM, Robert James
wrote:
Thanks. But how do I do that where I have many literals? Something like:
INSERT INTO seltest (id, a, b) SELE
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 w
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
s
2013/1/15 Martin Gainty :
> 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 subscription:
http://w
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 (pgsql-general@postg
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 simp
> 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 els
On 15.01.2013, at 00:28, Rich Shepard 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 at Slackware
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:
postg
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 pro
On Sun, Jan 13, 2013 at 10:37 PM, Robert James wrote:
> On 1/13/13, Ian Lawrence Barwick wrote:
> > 2013/1/14 Robert James :
> >> 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
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 IN
41 matches
Mail list logo
