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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[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(OLD.article_id,2); RETURN NULL; END$BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; ALTER FUNCTION trigger_articles_update() OWNER TO postgres; I have 2 different applications that performs update on table articles(written in Delphi and using ZeosDB). My problem is that I want trigger to fire only when performing update with first application, but not with second.I know that triggers supposed to fire on every change on table, but this is a specific problem that I have.Any hint appreciated. 8) -- View this message in context: http://postgresql.1045698.n5.nabble.com/Firing-trigger-if-only-tp5798484.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Add encoding support to COPY
David Blewett wrote: Today on IRC, someone was wondering what the preferred method of exporting data in a specific encoding via COPY was. They reply was wrapping the COPY command in set client_encoding='foo';, which made me wonder how hard it would be to add an additional WITH parameter to the actual COPY statement to specify the encoding, a la: [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'delimiter' ] [ ENCODING [ AS ] 'charset' ] [ NULL [ AS ] 'null string' ] [ CSV [ HEADER ] [ QUOTE [ AS ] 'quote' ] [ ESCAPE [ AS ] 'escape' ] [ FORCE QUOTE column [, ...] ] Any objections? It seems like a cleaner solution client side than issuing multiple calls to set the client_encoding. If there are no objections, 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 files. -- Nagy Karoly Gabriel Expert Software Group SRL (o__ 417495 Sanmartin nr. 205 //\' Bihor, Romania V_/_ Tel./Fax: +4 0259 317 142, +4 0259 317 143 begin:vcard fn:Nagy Karoly Gabriel n:Nagy;Karoly Gabriel org:Expert Software Group;RD adr:;;Bld. Felix 205;Sanmartin;Bihor;417495;Romania email;internet:nagy.kar...@expert-erp.net title:CVO x-mozilla-html:FALSE url:http://www.expert-erp.net version:2.1 end:vcard smime.p7s Description: S/MIME Cryptographic Signature
[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-libs-8.2.4-1PGDG.i686.rpm warning: postgresql-server-8.2.4-1PGDG.i686.rpm: Header V3 DSA signature: NOKEY, key ID 20579f11 error: Failed dependencies: libcrypto.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 libreadline.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 libssl.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 initscripts is needed by postgresql-8.2.4-1PGDG.i686 libcrypto.so.4 is needed by postgresql-8.2.4-1PGDG.i686 libreadline.so.4 is needed by postgresql-8.2.4-1PGDG.i686 libssl.so.4 is needed by postgresql-8.2.4-1PGDG.i686 libcrypto.so.4 is needed by postgresql-libs-8.2.4-1PGDG.i686 libssl.so.4 is needed by postgresql-libs-8.2.4-1PGDG.i686 This installation is being done on SUSE Linux 10, please let me know if there is any alternative with which I can bypass these errors and make the installation successful. Regards Suresh
[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 know any archives for Postgresql 8.2.4 version of 64bit processor. Postgresql 8.2.4 Win32 Application I am trying to install postgresql-8.2.4 on ES7000 with Windows Server 2003 (pack 1). I tried to install on ES-7000 using postgresql-8.2.msi installer with: I executed the installation as Administrator (user group Administrators). I got the error Failed to run initdb: 128! With an error log that is empty Though PostgreSQL claims that PostgreSQL 8.2.4 win32 application supports Windows 64bit processor. We are assuming PostgreSQL 8.2.4 win32 bit application does not support the ES7000 Windows 2003 server 64bit processor. Can you please help me on this. Regards Suresh
[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 using horarios_func_data on horarios (cost=0.00..55.37 rows=73 width=132) EXPLAIN So my question is why in the first case the postgre did'nt use the index and made a seq scan ?? thanks and sorry about my english... ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[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)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[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' the postmaster
[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 YourEmailAddressHere to [EMAIL PROTECTED])
[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 the mailing list cleanly
[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 PROTECTED])
