Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

2006-07-25 Thread Chris Browne
[EMAIL PROTECTED] (Tom Lane) writes: > Chris Browne <[EMAIL PROTECTED]> writes: >> Unfortunately (perhaps) standards_conforming_strings does not appear >> to be exported, so I'm not sure how to do this otherwise. > > Perhaps your problem is one of spelling? It's > "standard_conforming_strings", an

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

2006-07-25 Thread Tom Lane
Chris Browne <[EMAIL PROTECTED]> writes: > Unfortunately (perhaps) standards_conforming_strings does not appear > to be exported, so I'm not sure how to do this otherwise. Perhaps your problem is one of spelling? It's "standard_conforming_strings", and it's certainly a global variable. You still

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

2006-07-25 Thread Chris Browne
[EMAIL PROTECTED] (Peter Eisentraut) writes: > Chris Browne wrote: >> In support of PG 8.2, we need to have the log trigger function do the >> following: >> - Save value of standards_conforming_string >> - Set value of standards_conforming_string to FALSE >> - proceed with saving data to sl_l

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

2006-07-24 Thread Tom Lane
Chris Browne <[EMAIL PROTECTED]> writes: > In support of PG 8.2, we need to have the log trigger function do the > following: > - Save value of standards_conforming_string > - Set value of standards_conforming_string to FALSE This is a good idea why exactly? What are you even expecting it to

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

2006-07-24 Thread Peter Eisentraut
Chris Browne wrote: > In support of PG 8.2, we need to have the log trigger function do the > following: > - Save value of standards_conforming_string > - Set value of standards_conforming_string to FALSE > - proceed with saving data to sl_log_? > - Recover value of standards_conforming_str

[HACKERS] Help! - Slony-I - saving/setting/restoring GUC

2006-07-24 Thread Chris Browne
In support of PG 8.2, we need to have the log trigger function do the following: - Save value of standards_conforming_string - Set value of standards_conforming_string to FALSE - proceed with saving data to sl_log_? - Recover value of standards_conforming_string The variable, standards_co