Re: [syslog-ng] sql() and pgsql

On Tue, 2010-07-27 at 12:36 -0600, syslogng@feystorm.net wrote:

"bar.baz" is the proper way of doing this but was not handled properly in the syslog-ng code. I filed a bug report on this and the fix has been incorporated into 3.2 (https://bugzilla.balabit.com/show_bug.cgi?id=73 item number 2). So, you have 3 options 1) you can download the patch on that bug and manually build the fix into your code and build it yourself 2) add an alias so it knows which schema that table is in 3) wait for 3.2

perhaps try 3.2 :) Your patch also adds "session_statements()" option that makes it possible to add SQL statements executeed before doing anything else. This may also be of use here. -- Bazsi