bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Tue May 28 09:57:43 PDT 2013
http://www.slony.info/bugzilla/show_bug.cgi?id=151

--- Comment #3 from Steve Singer <ssinger at ca.afilias.info> 2013-05-28 09:57:43 PDT ---
I took a look at the code here.
https://github.com/wieck/slony1-engine/commits/execute-script-fixes

The slonik command:


execute script(SQL='insert into foo values (''foo'');', execute only on=1,
event node=1);

gives

PGRES_FATAL_ERROR [insert into foo values (foo);] - ERROR:  column "foo" does
not exist
LINE 1: insert into foo values (foo);

We seem to be eating the two single quotes.

Also

I get an error if I specify EXECUTE ONLY ON , but leave out 'event node'. 
According to the docs (and in slony 2.1) this worked.  (this isn't directly
related to this change.

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.


More information about the Slony1-bugs mailing list