Re: [HACKERS] Firing trigger if only

Thank you, this done the job.All the best -- View this message in context: http://postgresql.1045698.n5.nabble.com/Firing-trigger-if-only-tp5798484p5799344.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postg

[HACKERS] Firing trigger if only

Good afternoon all.I have some problem with triggers on PostgreSQL 8.4.I have a trigger on specific table(articles) that fires on update statement: CREATE OR REPLACE FUNCTION trigger_articles_update() RETURNS trigger AS $BODY$BEGIN INSERT INTO article_change(article_id,change_type)VALUES(

Re: [HACKERS] Add encoding support to COPY

ions, I can attempt to prepare a patch for the next commitfest. David Blewett I think that I was the one who wondered about that. Our use case is related to moving data between different servers which have different encodings. Ofcourse the encoding should be an option only when COPY involves fi

[HACKERS] Installation of Postgres 32Bit on 64 bit machine

Hello All, I am trying to install PostgreSQL(postgresql-8.2.4-1PGDG.i686.rpm) on a 64 bit machine, when I try to install I get the following error message: :/home/dump/postgres32bit # rpm -ivh postgresql-server-8.2.4-1PGDG.i686.rpm postgresql-8.2.4-1PGDG.i686.rpm postgresql-li

[HACKERS] ES7000 Windows 2003 server 64bit processor

Hello All, We are facing some problems while downloading the Postgresql 8.2.4 version of 64bit processor for both Windows and SUSE Linux ES-7000 partitions. The entire download URL's of PostgreSQL 8.2.4 version are displaying the error message "The webpage can't found". Can you please let m

[HACKERS] INDEX BUG???

hello All I tried the following commands: ponto=# explain select * from horarios where funcionario>1; NOTICE: QUERY PLAN: Seq Scan on horarios (cost=0.00..176.21 rows=2432 width=132) EXPLAIN ponto=# explain select * from horarios where funcionario=1; NOTICE: QUERY PLAN: Index Scan

[HACKERS] Binary Field??

hellow all how can I store Binary values in a table of postgresql database? thanks... ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[HACKERS] Perl,Postmaster and CPU question??

hello all I have a perl script that read a text file and insert the data in a table... but when this script is runing the usage of CPU by postmaster grows to between 79 and 90 percent... there's something to do about it? thanks... ---(end of broadcast)--

[HACKERS] Trigger Function Question...

hello all Anyone knows a way to get the machine that execute the query? thanks ... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] FUNCTION Question...

Hello All, I want to know if there's a way to create a FUNCTION that use a Perl script file? thanks... ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] Update to 7.1.2 Question...

hello all I have a postgresql 7.0 and I'm trying to update to 7.1.2 using rpms but some files is missing like: libcrypto.so.0 libssl.so.0 anyone knows what package i can find this files?? thanks... ---(end of broadcast)--- TIP 4: Don't 'kill -9'

[HACKERS] LOG PgSql ..

hello all. Is there a way to config the postmaster to log in a file all connections and querys to each database? thanks... ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmai

[HACKERS] dump+reload?

hello all How can i do dump and reload in all databases? thanks... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to

[HACKERS] pg_log ??

hello all I don't know what to do... the pg_log file is too big.. anyone can help me? thanks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROT