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

[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

Re: [HACKERS] Add encoding support to COPY

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 files. -- Nagy Karoly Gabriel Expert Software Group SRL (o__ 417495

[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

[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 me

[HACKERS] INDEX BUG???

hello All I tried the following commands: ponto=# explain select * from horarios where funcionario1; 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

[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

[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

[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