changing table owners in postgres from livecode

Dr. Hawkins dochawk at gmail.com
Thu May 2 22:36:19 EDT 2013


On Thu, May 2, 2013 at 7:14 PM, Peter Haworth <pete at lcsql.com> wrote:
> Good point.  The dictionary is kinda confusing on this.  It says "do not
> include a semicolon at the end of the statement", then says "some" sql
> systems are capable of executing multiple statements, which presumably
> means terminating each one with a semicolon.  I guess it means no semicolon
> at the end of the last statement.

Thinking of how psql  does it, it must be appending a semicolon--but
an extra semicolon should be harmless, as well.


> No idea whether postgres supports multiple statements in one command.

The BEGIN/COMMIT is most definitely supported in postgres (and I think
even sqlite has rudimentary support for it)



-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462




More information about the use-livecode mailing list