I had this error and the same condition listed
and solved the problem including an extra parameter when calling the program
postgresql-8.4.2-1-windows.exe --install_runtimes 0
(substitute by the right exe)
I hope solve your problem too,
Josi Perez
2010/10/7 Kiswono Prayogo
>
>
abase user, no problem: the
pgpass.conf is read.
But, if I use (-u postgres) as a Windows user too (like the postgreSQL
service), I think that pgAgent does not read the pgpass.conf. I tried to use
the variable PGPASSFILE without success.
Any sugestions?
Thank you,
Josi Perez
Thank you for your answer.
Without considering the errors, the transaction should not start after the
AFTER INSERT?
Josi Perez
2010/8/12 Tom Lane
> "Josi Perez (3T Systems)" writes:
> > If I write a trigger AFTER INSERT and I have one error in this trigger,
> the
> &
Josi Perez
nside the TG_OPER DELETE for each table, but, I really appreciate to know
if there is a solution for this.
Thank you in advance,
Josi Perez
2010/5/24 Josi Perez (3T Systems)
> Thank you.
>
> The trigger:
> CREATE OR REPLACE FUNCTION logdata()
> RETURNS trigger AS
> $BODY
userexc ='||
current_user ||' where '||quote_ident(arg_id)||' =
OLD.'||quote_ident(arg_id)||';';
--update opcao set dtexc = 'now', userexc = current_user
-- where idopcao = OLD.idopcao;
return NULL;*
else
return OLD;
end if;
end if;
Sorry for the inconvenience, but no one have ideas to solve this problem? Am
I in the wrong list to ask this?
Need I create triggers for each table?
Thanks in advance for any suggestions.
Josi Perez
2010/5/19 Josi Perez (3T Systems)
> To avoid to delete registers I created one trig
7;||TG_ARGV[1];
but when "EXECUTE qry" I lost the OLD.variable.
I can't send the bigint id to delete in trigger parameters.
Any suggestions?
Thanks in advance,
Josi Perez
oogle search and looks like no one have problems with pg_ctl
register.
Probably I am doing a stupid thing, but I can not see what.
Sugestions?
Thank you in advance,
Josi Perez
2010/4/24 BlackSkaven
> Hello Josi,
>
> Well - I happen to have Windows 7 on my personal PC.
>
> -switched
PostgreSQL* 8.4 p5430" password= mypass
*sc* start pgsql-8.4
All commands above give me "Access denied".
Anyone have a tip? Am I in a wrong list to ask about this?
Thanks in advance,
Josi Perez
2010/4/19 Josi Perez (3T Systems)
> Hi,
>
> I'm trying to start au
hese commands at startup and worked, but
I needed an icon to stop the processes.
Help.
How can I start these 3 data base areas as a service in Windows?
Thanks in advance.
Josi Perez
De: Sonia Perez Peña
Enviado el: viernes, 04 de abril de 2008 9:31
Para: '[EMAIL PROTECTED]'
Asunto: instalacion del PHPPGADMIN
Al fin pude bajar algo para administrar postgres desde FEDORA
Hola amigosL
Alguien me puede decir por que no me puedo conectar, les cuento que ya
Imagino que si lo que descargaste es el .RPM sería algo como esto: rpm -i
pgadmin3-1.8.2.rpm.
Salu2
Ing. Reynier Pérez Mira
Grupo Soporte al Desarrollo - Dirección Técnica IP
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Sonia Perez Peña
De: Sonia Perez Peña
Enviado el: miércoles, 02 de abril de 2008 3:38
Para: 'pgsql-admin@postgresql.org'; '[EMAIL PROTECTED]'
Asunto: instalacion de pgadmin
Amigos ya baje el pgadmin3-1.8.2 gracias a un colega de la lista ¿Cómo lo debo
instalar en FEDORA
Amigos ya baje el pgadmin3-1.8.2 gracias a un colega de la lista ¿Cómo lo debo
instalar en FEDORA
De: Sonia Perez Peña
Enviado el: jueves, 27 de marzo de 2008 9:09
Para: '[EMAIL PROTECTED]'; pgsql-admin@postgresql.org
Asunto: herramienta administracion de Postgre para Linux
Hola, necesito instalar en Linux una herramienta de administración para
Postgree cual me recomiendan
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Tom Lane) wrote:
> Alternatively you can just configure postgres --without-readline.
> psql is a lot less pleasant to use without it, but if you don't
> use psql much you may not care.
>
> regards, tom lane
That's what I d
Setting the verbose mode (which usually uses to be very usefull ;) ), showed me
something like this while restoring :
BEGIN, still in transaction (more or less)
which made me think that the autocommit was disabled. This feature in series 7.3.x
is very usefull to me but, as I check
Hi guys,
I still have a problem to start the database server as I wrote in the first mail. I read many and many tutorials, but nothing is working to start the postmaster.
1. When I create the database cluster I get this message:
(everything is installed correctly)
Success. You can now start the
Hi all,
I try to start PostgreSQL, but it doesn't work. I installed it
successfully and now I try to launch the server. This is what I did:
1. Set the path
$ set path = ( /usr/local/pgsql/bin $path )
2. Create the cluster
$ initdb -D /usr/local/pgsql/data
3. Start the database server
$ post
t;
> su postgres -c "postmaster -i -D /var/lib/pgsql >/var/lib/pgsql/pg.stdout
> >&/var lib/pgsql/pg.stderr"
>
> Then start up the system, shut it down. Revert to the old
> startup script and send the pg.stdout and pg.stderr files.
>
>regards,
>
>
more load. (in this case, load
means a lot of simultaneous conexions)
Please, I thank anything you can say me ...
--
Eng. Lucio Andres Perez
NewMedia Director
Telesat S.A.
Cali-Colombia-SouthAmerica
http://www.telesat.com.co
22 matches
Mail list logo
