Re: [GENERAL] Determining that a schema has changed for purpose of monitoring

2012-10-03 Thread Chris
On 04/10/12 01:48, Thor Michael Støre wrote: Hello. Is there a way in PostgreSQL for a client to determine that a database schema may have changed since it checked it earlier, for example to get the transaction ID or timestamp of the last successfully committed transaction that included DDL c

[GENERAL] Determining that a schema has changed for purpose of monitoring

2012-10-03 Thread Thor Michael Støre
Hello. Is there a way in PostgreSQL for a client to determine that a database schema may have changed since it checked it earlier, for example to get the transaction ID or timestamp of the last successfully committed transaction that included DDL commands and compare them over time? For a while