Rodrick Hales wrote:
We have two machines that run a C application that interfaces with a Postgres database. They are our development and production machines. The version is PostgreSQL 8.3.7 on i686-redhat-linux-gnu, complied by GCC gcc (GCC) 4.1.2.20071124 (Red Hat 4.1.2-42) . On the development machine, I don't get notices and warnings related to Postgres SQL commands. COMMIT and ABORT are likely the culprits. On the production machine I do.
The message you mention would be to a COMMIT/ROLLBACK being issued without a BEGIN. I think the setting you are after is probably client_min_messages (ch 18 of the manuals). One machine is probably set to NOTICE and one to WARNING.
Some useful commands: SHOW client_min_messages; ALTER DATABASE db1 SET client_min_messages = 'WARNING'; ALTER USER u1 SET client_min_messages = ... -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
