changing table owners in postgres from livecode

[Peter Haworth]

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.

No idea whether postgres supports multiple statements in one command.

Pete
lcSQL Software <http://www.lcsql.com>


On Thu, May 2, 2013 at 6:27 PM, Mark Wieder <mwieder at ahsoftware.net> wrote:

> Richard-
>
> Thursday, May 2, 2013, 5:33:17 PM, you wrote:
>
> > I've tried
> > BEGIN TRANSACTION;
> > CREATE TABLE blah bla blah;
> > ALTER TABLE blah OWNER TO dhbk;
> > COMMIT;
>
> Are you trying to put all that into a single sql command? I don't
> think you can do that from LC. That is, I don't think the execute sql
> statement supports multiple catenated statements.
>
> --
> -Mark Wieder
>  mwieder at ahsoftware.net
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>