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