Mark Stosberg mark
Thu Jan 18 11:33:36 PST 2007
slonik_execute_script has a "-c" option to give a single command to run
on the command line, which is convenient.

I ran something like this:

slonik_execute_script -c 'ALTER TABLE a RENAME to b' set3 | slonik

This silently failed. Slonik accepted the command, but nothing happened.
The reason is there is no trailing semicolon, so slonik interpreted this
as "0 commands".

I addressed this in the script by adding a trailing semicolon if there
is not one given with the "-c" option.

However, I think "slonik" should also be updated to at least provide a
warning if it receives "0 commands" to process.

   Mark
-------------- next part --------------
A non-text attachment was scrubbed...
Name: execute_script.patch
Type: text/x-patch
Size: 388 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20070118/14f52a2f/attachment-0001.bin 



More information about the Slony1-general mailing list