You cannot access new values of a particular row within a single UPDATE
statement, but you do see new values done in the same transaction.
This is explain in some detail in the documentation:
http://www.postgresql.org/docs/8.4/interactive/transaction-iso.html#XACT-READ-COMMITTED
I tried
On Sun, Dec 20, 2009 at 2:12 AM, Andrus kobrule...@hot.ee wrote:
You cannot access new values of a particular row within a single UPDATE
statement, but you do see new values done in the same transaction.
This is explain in some detail in the documentation:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey guys,
Albe Laurenz a écrit :
Chris Ernst wrote:
I have a project where I need to be able to capture every query
from a production system into a file such that I can replay
them on a staging system. Does such a thing already exist or
should
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Shoaib Mir a écrit :
On Sun, Dec 20, 2009 at 9:37 AM, Albe Laurenz
laurenz.a...@wien.gv.at mailto:laurenz.a...@wien.gv.at wrote:
Chris Ernst wrote:
I have a project where I need to be able to capture every
query from a
production system into a
On Fri, Dec 18, 2009 at 02:08:07PM -0700, Chris Ernst wrote:
Hi all,
I have a project where I need to be able to capture every query from a
production system into a file such that I can replay them on a staging
system. Does such a thing already exist or should I start writing my
own log
On 20/12/2009 7:59 PM, hubert depesz lubaczewski wrote:
On Fri, Dec 18, 2009 at 02:08:07PM -0700, Chris Ernst wrote:
Hi all,
I have a project where I need to be able to capture every query from a
production system into a file such that I can replay them on a staging
system. Does such a thing
Hi All,
I'm new to Postgres and need a way to test if a transaction is already
in progress.
The test will take place inside a trigger function in pl/pgsql and will
start a new transaction only if one is not in progress ie started by a
previous trigger that cascaded through to this trigger.
On 20/12/2009 9:02 PM, Larry Anderson wrote:
Hi All,
I'm new to Postgres and need a way to test if a transaction is already
in progress.
The test will take place inside a trigger function in pl/pgsql and will
start a new transaction only if one is not in progress
You can't do that, I'm
At 05:44 AM 12/17/2009, Greg Smith wrote:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic (and overdue for an update).
The main thing I intended to put into such an
JGuillaume (ioguix) de Rorthais wrote:
I am currently developing such a beast, it is currently still quite
alpha. If you are interested I can send you a copy. I'll try to
publish it once it is sufficiently beta.
Interesting project, but but I have one big issue under 8.1 and
advanced query
Hi Craig,
Many thanks for the detailed and quick reply. Must admit although I'd
read that every statement was implicitly in a transaction I hadn't
connected that through to the operations in any associated triggers.
Best regards
Larry Anderson
Craig Ringer wrote:
On 20/12/2009 9:02 PM,
You are confusing a few things, and you don't want to hear the
explanations because they are inconvenient.
Andrus wrote:
1. In my case b expression needs values from previous rows updated in this
same command before:
You are confusing to the left of and before.
If you want behaviour that
Hi, Andrus,
First, it does seem that you are expecting PostgreSQL to have the same
behavior as a flat-file manager such as FoxPro (indeed, it seems you'd
like PG to have the behavior of a *specific* flat-file manager).
Despite the superficial similarity in the command syntax, a modern
Le 19 déc. 2009 à 16:20, Chris Ernst a écrit :
Hmm.. That does look very interesting. The only thing that concerns me
is where it says it supports Basic Queries (Extended queries not yet
supported). I'm not sure what is meant by Extended queries. Any idea?
I think it refers to the Extended
On Sun, Dec 20, 2009 at 10:04 AM, Lincoln Yeoh ly...@pop.jaring.my wrote:
At 05:44 AM 12/17/2009, Greg Smith wrote:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic
Lincoln Yeoh wrote:
Ten or so years ago MySQL was better than Postgres95, and it would have
been easy to justify using MySQL over Postgres95 (which was really slow
and had a fair number of bugs). But Postgresql is much better than MySQL
now. That's just my opinion of course.
Really?!?
MySQL
On Sun, Dec 20, 2009 at 3:19 PM, Ron Mayer
rm...@cheapcomplexdevices.com wrote:
Lincoln Yeoh wrote:
Ten or so years ago MySQL was better than Postgres95, and it would have
been easy to justify using MySQL over Postgres95 (which was really slow
and had a fair number of bugs). But Postgresql is
Ron Mayer rm...@cheapcomplexdevices.com writes:
Lincoln Yeoh wrote:
Ten or so years ago MySQL was better than Postgres95, and it would have
been easy to justify using MySQL over Postgres95 (which was really slow
and had a fair number of bugs). But Postgresql is much better than MySQL
now.
The arguments against PG are not technical. The biggest advocate for MySQL is
actually a very sharp engineer who admits that PG is a superior DB. But MySQL
is more popular in the corp and has more formal recognition. So he's saying
that the differences aren't big enoug to justify using PG.
Op 19-12-09 22:20, Jaime Casanova schreef:
are you planning to run this many times? what is wrong with making
this manually?
doesn't seem like something to make automatic...
but if you insist in plpgsql you can execute select version() into
some_text_var and act acordingly
No, this is done
Hi,
I need to know if there is something like Oracle Forms in the Open Source
world that works with PostgreSQL.
If do you know something, please let me know.
Best Regards,
André.
Gauthier, Dave wrote:
The arguments against PG are not technical.
A few more points that I didn't see in this thread yet that might help
answer the non-technical questions:
* There seem to be more commercial vendors providing support
for Postgres than MySQL - because most mysql support came
Andre Lopes wrote:
Hi,
I need to know if there is something like Oracle Forms in the Open
Source world that works with PostgreSQL.
If do you know something, please let me know.
perhaps OpenOffice Data could do what you need. I'm not real familiar
with Oracle Forms, but I know OOo Data
On 12/20/2009 4:13 PM, Andre Lopes wrote:
Hi,
I need to know if there is something like Oracle Forms in the Open
Source world that works with PostgreSQL.
If do you know something, please let me know.
Some quick Googling found this if you are looking for a desktop solution:
Tom, Scott, Alvaro,thanks for the hints on this issue. It looks as if one of
the EOD maintenance jobs which does a few extensive queries does push data out
of memory leading to this behavior.
Is there a way to permanently cash some tables into memory?
ThanksAlex
Date: Sat, 19 Dec 2009
Alex - ainto...@hotmail.com writes:
Tom, Scott, Alvaro,thanks for the hints on this issue. It looks as if one of
the EOD maintenance jobs which does a few extensive queries does push data
out of memory leading to this behavior.
Is there a way to permanently cash some tables into memory?
Hi Raimon,
On Dec 20, 2009, at 2:11 PM, Raimon Fernandez wrote:
I'm not seeing my e-mails on the PostgreSQL General List ...
??
Yes, my last message did not make it to the list yesterday (you obviously
received it). I double checked and it was cc to the list.
I can pack all of
Ron Mayer wrote:
* There are enough large companies that depend entirely
on each of the databases that make either one a save
choice from that point of view (Skype). And the way
Apple and Cisco use it for a number of their programs
Yeah, these are all good examples. Cisco uses
Merlin Moncure wrote:
It was only with the 8.x versions that postgres
really started pulling away.
Today I was re-reading a great reminder of just how true this is:
http://suckit.blog.hu/2009/09/29/postgresql_history
From the baseline provided by 8.0, PostgreSQL increased in speed by
29 matches
Mail list logo