Re: [ADMIN] How to get the DML Commands exceuted from functions

CREATE OR REPLACE FUNCTION xyz() returns int4 as $body$ DECLARE BEGIN IF (TG_OP = 'DELETE') THEN n_id = OLD.campaign_id; EXECUTE 'DELETE FROM cn_mapping WHERE campaign_id = '||quote_literal(n_id); RETURN 0; END IF; END; $body$ LANGUAGE 'plpgsql' VOLATILE;

[ADMIN] How to get the DML Commands exceuted from functions

Hi All, There are a few plpgsql functions in our application, When the functions are called, I would like to see the commands executed from the functions ( the selects, inserts, updates and Deletes written in the function body) I am from SQL server world and there exists a tool SQL Profiler for

Re: [ADMIN] slony with diff PostgreSQL versions

[EMAIL PROTECTED] ("Ezequiel Luis Pellettieri") writes: > Hi guys, I know I'm out of topic, but have you ever tried using > Slony with PostgreSQL 8.2x as master and PostgreSQL 7.4.x as slave? I've done it with 7.4.x as master, and 8.1.x as slave, the point of the exercise being that I wanted to up

Re: [ADMIN] Encoding problems

show client_encoding displays the encoding to which the server currently is converting. With set client_encoding to UNICODE; you can change the client_encoding on the fly and check if the results becomes better. I am not sure how to adjust the client_encoding in pgAdmin so that this will be set

[ADMIN] slony with diff PostgreSQL versions

Hi guys, I know I'm out of topic, but have you ever tried using Slony with PostgreSQL 8.2x as master and PostgreSQL 7.4.x as slave? Thanks in advance, Pelle,.-

Re: [ADMIN] unsubscribe

Zitat von olive Mckenzie <[EMAIL PROTECTED]>: olive Mckenzie <[EMAIL PROTECTED]> wrote: Please remove me from this site Regards Olive You really should have read the welcome mail List-Archive: List-Help: List

Re: [ADMIN] unsubscribe

olive Mckenzie <[EMAIL PROTECTED]> wrote: Please remove me from this site Regards Olive - Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. ---

[ADMIN] Accidental message

Hi I accidentally sent the last message by accident. Obviously not finished. Sorry about this. Best regards, Bjarni Ragnarsson ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.p

[ADMIN] Encoding problems

Hi everyone. I have some encoding problems like many others. I'm using Python (and Django) with my PostgreSQL 8.2 and pgAdmin 1.6.2 on Windows XP Pro. The default encoding here in Iceland is win1252. I have a database with that encoding. The problem is that pgAdmin seems to use utf8 no matte