Alvaro Herrera wrote:
>
> Froggy / Froggy Corp. wrote:
> >
> >
> > Alvaro Herrera wrote:
> > >
> > > Froggy / Froggy Corp. wrote:
> > > > Hello everyone,
> > > >
> > > > It is the second time i got this error
Alvaro Herrera wrote:
>
> Froggy / Froggy Corp. wrote:
> > Hello everyone,
> >
> > It is the second time i got this error message (sorry, its french, i
> > prefer to c/p this one than making a bad translation) :
> >
> > ---8<8<
Hello everyone,
It is the second time i got this error message (sorry, its french, i
prefer to c/p this one than making a bad translation) :
---8<8<---8<---
pg_dump: ERREUR: Impossible d'accéder au statut de la transaction
892415538
DETAIL: Impossible d'ouvrir l
Its my plan in fact, it was to make some optimisation, because i need to
copy all the test from the BEFORE statement to the AFTER.
Thx for your help,
Regards,
Tom Lane wrote:
>
> "Froggy / Froggy Corp." <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >
Tom Lane wrote:
>
> "Froggy / Froggy Corp." <[EMAIL PROTECTED]> writes:
> > PG7 dont make recursiv, it wait for the end of the trigger BEFORE_UPDATE
> > to call the new UPDATE stat and forgot the 3rd AFTER_UPDATE. PG8 is
> > better, it call trigger like rea
Hello,
I got some problem on trigger which call them self for UPDATE
BEFORE/AFTER.
Here is some test :
The UPDATE test function/table :
--8<8<8<--
CREATE SEQUENCE id_my_table_seq;
CREATE table "my_table" (
"id_my_table"
Hi everyone,
I made a tetris under pl/pgsql and i encounter some problem with this
non commun use of pl/pgsql. For each problem, i didn't see information
about them, so my report :
- Array problem (7.4.7 & 8.0.1) :
I got a lot of problem with using array, like i saw under the ML,
multidi
persistantes.
>
> Actuellement, je n'utilise plus de connexion persistantes. Mais au final
> je me demande si ce n'ai pas juste un problème de tuning car après la
> suppression/restauration d'une table utilisateur, j etais passé d'un
> load de 3-4 à moins de 1.
&
--- Begin Message ---
Il me parait un peu illusoire de contester un test alors que CleverAge a
pris la peine de contacter la communauté francophone de PostgreSQL et que
personne ne s'est déplacée (pour des raisons que je ne critique pas).
Donc à partir de ce moment là, je trouve abhérant de conte
Hello,
In fact the problem seems to come from the "INSERT INTO". I delete
everything from the function and only keep the "INSERT INTO" and get the
same problem.
Thx in advance for answers,
regards,
Stephan Szabo wrote:
>
> On Tue, 20 Apr 2004, F
Hello everyone,
I try to see if i can make a recursive function with a trigger set on
INSERT and doing an insert under my trigger function.
So i wrote a test function :
CREATE OR REPLACE FUNCTION testfunc() RETURNS SETOF RECORD AS '
DECLARE
use_t RECORD;
BEGIN
Hello (again),
I read some documentation about tuning postgresql.conf but i didn't
find information clearly about how to use GeQo. It seems to help planner
but using a lot of CPU, and is usefull only for big join.
Per default, geqo = true, but in which case, geqo is usefull and in
Hello,
I'am using postgresql to make different web site with differente
database for each, but with same table/link/...
So, i change from 7.2 to 7.4 and try to use template function to create
each new DB more easier (with user posgres):
CREATE DATABASE myowntemplate TEMPLA
gards,
"scott.marlowe" wrote:
>
> On Wed, 18 Feb 2004, Froggy / Froggy Corp. wrote:
>
> > The problem is that on "fire time", the load go to > 1 and stay long
> > time. But with top (i use top -d 1 to have "real" load average) i can
> >
Hello,
I asked one time for more "benchmark" soft to know where is the cpu
average, and read the post about optimising the postgresql.conf (and use
them), but i allways get a load > 1 on fire time (dunno the right name,
"coup de feu" in french (10h00 -> 14h00, 18h00 -> 21h00).
For
15 matches
Mail list logo
