On 2012-04-12, raghupradeep <raghuprad...@gmail.com> wrote: > Hi , > > I am basically a MySQL DBA and have little idea on PostgreSQL. In our > environment we have an application which is using PostgreSQL as its back > end. The application logs the status of the jobs running in it to a table in > this database i.e when a job starts it inserts a new row to this table and > it keeps on updating the column `status` based on the status of the job > running. So the requirement that we have is I need to capture certain status > values and based on it need to through alert to our centralized monitoring > system. > > What I need to know is it possible to write a trigger which will write the > data of the row whose status column gets updated to a text file?
you mean like "RAISE LOG" does? or do you have specific requirements? -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
