Christopher Browne cbbrowne
Wed Mar 15 13:12:54 PST 2006
One of our QA guys was doing some testing on this, and was wondering
what output should come from EXECUTE SCRIPT.

After thinking about it, a bit, two conclusions came out:

1.  For 1.1.5, there isn't a valid answer for this.

In 1.1.5, EXECUTE SCRIPT handles the entire script as one query in one
not-entirely-so-swell foop, so that there would only be a notion of
getting one set of command results out of it, however many queries may
have been involved.

2.  For 1.2, we split the query set into individual queries, and run
them one by one.

At that point, "what an idea!", why don't we:

 a) Output the statement to [stdout, for slonik|logs, for slon]
 b) Output the command result to [stdout, for slonik|logs, for slon]

That strikes me as making it *way* less "magical" to users.

Comments?  Suggestions?  Bricks thru windows?
-- 
let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@" [name;tld];;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)



More information about the Slony1-general mailing list