changing table owners in postgres from livecode
Dr. Hawkins
dochawk at gmail.com
Sat May 4 16:15:47 EDT 2013
And the answer . . .
On Thu, May 2, 2013 at 5:33 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
> Just as I thought I had things under control . . .
> BEGIN TRANSACTION;
> CREATE TABLE blah bla blah;
> ALTER TABLE blah OWNER TO dhbk;
> COMMIT;
It seems that this block of code needs to be placed somewhere where it
actually executes rather than in the sqlite branch of my switch.
Imagine that . . .
This works to change it. (But now I can't get "SET ROLE" to work so
that I can delete the table as a regular user!)
--
Dr. Richard E. Hawkins, Esq.
(702) 508-8462
More information about the use-livecode
mailing list