[GENERAL] How to cast a general record?

2009-01-01 Thread Gerhard Heift
Hello, I want to log with triggers or in functions, and these logs should be independet of the transaction. Beside i want to have the information which action was commited and which not. So my idea was to log into the same database with dblink, return the primary keys and add them into a commit

Re: [GENERAL] How to cast a general record?

2009-01-01 Thread Martin Gainty
Gerhard- It is good you covered INSERTS but I would replicate the Insert Trigger for Update event Vielen Danke, Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender.

Re: [GENERAL] encoding of PostgreSQL messages

2009-01-01 Thread Peter Eisentraut
On Wednesday 31 December 2008 20:23:47 Tom Lane wrote: The proper fix is probably to include the client encoding in the connection startup message. What of errors occurring before such an option could be applied? Connection errors are handled by the client, which knows the client encoding.

Re: [GENERAL] manage changes to views having depencies

2009-01-01 Thread Berend Tober
Eric Worden wrote: Can anyone recommend a reasonably efficient system for changing a view definition (say by adding a column) when it has a bunch of dependent functions? Right now I work with the output from pg_dump to recreate things after doing DROP VIEW ... CASCADE. But the pg_dump schema

Re: [GENERAL] How to cast a general record?

2009-01-01 Thread Albe Laurenz
Gerhard Heift wrote: I want to log with triggers or in functions, and these logs should be independet of the transaction. Beside i want to have the information which action was commited and which not. So my idea was to log into the same database with dblink, return the primary keys and add