[ADMIN] Audit Trail

Hi All, As I want to do audit on some tables for Insert Update Delete. So I am trying to create a function. To enable the auditing I need to create this function which I am unable to the error below. Can anybody help with this. Or any documentation link for this particular function. I am

Re: [ADMIN] Audit Trail

On Mon, Aug 13, 2007 at 12:24 AM, in message [EMAIL PROTECTED], Khan, Mahmood Ahram [EMAIL PROTECTED] wrote: To enable the auditing I need to create this function which I am unable to the error below. Add a line like this after you include the PostgreSQL .h files: PG_MODULE_MAGIC; I was

[ADMIN] except command

Hello I tried to use the except command in postgresql 8.1 I don't understand as it works When I read doc , I understand that it was like a difference betwwen two queries However , It looks as if the 2nd part was ignored I tried to test by dblink a query unising except on the same database

Re: [ADMIN] except command

On Mon, Aug 13, 2007 at 12:50 PM, in message [EMAIL PROTECTED], olivier boissard [EMAIL PROTECTED] wrote: I tried to use the except command in postgresql 8.1 I don't understand as it works When I read doc , I understand that it was like a difference betwwen two queries That isn't how I

Re: [ADMIN] entries in serverlog file

Hi Tom, Thanks. I will live a bit dangerously while I strategize what to do with the logfile. I am not sure if 7 day log rotation is really a wise option for now. I will come up with something fitting in time. Thanks for your comment, nonetheless. Regards, Tena Sakai [EMAIL PROTECTED]

[ADMIN] plpgsql question/problem

I'm not sure if this is the correct list for this question, but I'll give it a shot anyway. (If this is not the correct list, please suggest the correct one.) I've written a number of plpgsql functions to convert a database from MS Access into Postgres (v8.2.4 on Windows 2000 SP4) and have

Re: [ADMIN] plpgsql question/problem

Scott Marlowe [EMAIL PROTECTED] writes: On 8/13/07, Hyatt, Gordon [EMAIL PROTECTED] wrote: When I attempt to run insert_a_and_b, insert_b fails with a foreign key violation. I ran your exact same code and it worked fine. Note that I changed one line: Works for me too (with Scott's

Re: [ADMIN] except command

Thanks for your explanation And your small example was better as one page documentation I was totally wrong. So it's like a filter on the first query I think it's useful when we have complex queries . Olivier Kevin Grittner a écrit : On Mon, Aug 13, 2007 at 1:13 PM, in message

[ADMIN] postmaster.pid file

Hi Everybody, I experienced something a bit strange. When I issued, on a linux machine, the following command as user postgres: ~/bin/pg_ctl -D ~/bin reload It wasn't happy. The complaint was: pg_ctl: PID file /usr/local/pgsql/bin/postmaster.pid does not exist Is server running?

Re: [ADMIN] postmaster.pid file

Thank you, Tom. As I typed: ~/bin/pg_ctl -D ~/bin reload I thought I had typed: ~/bin/pg_ctl -D ~/data reload (Had I not copied-and-pasted the actual command, I would have given you the correct line, which would have been really bad!) I was blind! I got the extra file in ~/bin

[ADMIN] postmaster restart on a different dataDir

Hi, I am trying to measure startup time of postmaster. Say I have postmaster running on -D /tmp/d1 and would like to restart it on -D /tmp/d2. If I just say time pg_ctl restart -D /tmp/d2 it will not produce an accurate result because pg_ctl will start postmaster in the background and return