And the answer . . .
On Thu, May 2, 2013 at 5:33 PM, Dr. Hawkins 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
actua
On Thu, May 2, 2013 at 8:07 PM, Peter Haworth wrote:
> I assume psql is the command line interface for postgres? If dbhk is a
> string value, it needs delimiters around it otherwise it will be treated as
> an identifier. It's possible psql supplies them but lc won't.
but a table name doesn't see
I assume psql is the command line interface for postgres? If dbhk is a
string value, it needs delimiters around it otherwise it will be treated as
an identifier. It's possible psql supplies them but lc won't.
On May 2, 2013 7:11 PM, "Dr. Hawkins" wrote:
> On Thu, May 2, 2013 at 5:59 PM, Peter Ha
On Thu, May 2, 2013 at 7:14 PM, Peter Haworth 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
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 e
On Thu, May 2, 2013 at 6:27 PM, Mark Wieder wrote:
>
> 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.
Do either the executeSql or revDataFromQuery() actua
On Thu, May 2, 2013 at 5:59 PM, Peter Haworth wrote:
> Not familiar with postgres but maybe single quotes around dhbk?
>
No, not needed--this is the command I use from psql, and that works.
(I do find some of when quotes are required & prohibited inconsistent . . .)
--
Dr. Richard E. Hawkins
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 s
On Thu, May 2, 2013 at 5:33 PM, Dr. Hawkins wrote:
> I've tried
> BEGIN TRANSACTION;
> CREATE TABLE blah bla blah;
> ALTER TABLE blah OWNER TO dhbk;
> COMMIT;
>
> and also a second transaction of just the ALTER, but I still own the
> tables.
>
Not familiar with postgres but maybe single quotes a
Just as I thought I had things under control . . .
All of my tests were with me as users.
I created the role dhbk, and made it the owner of the database.
I created roles inside of that for myself and my assistant.
It seems, though, that I am the owner of tables as they are created.
I can chang
10 matches
Mail list logo
