From: | Ted Taylor <ted(at)3shmoos(dot)ca> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Create Database - Owner - 7.4.5 backend |
Date: | 2004-09-18 00:56:36 |
Message-ID: | 414B87C4.7060208@3shmoos.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I am running the snapshot "Version 1.2.0 Post Beta 1 (Sep 17 2004)" on
Windows 2000, fully patched at Windows Update. The backend is
PostgreSQL 7.4.5 on Fedora Core 2 (select version() reports "PostgreSQL
7.4.5 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 20040412
(Red Hat Linux 3.3.3-7)".
This may be a duplicate; I noticed the note on the website "AP
2004-09-17 [new Database] Name/Owner not editable for 7.3/7.4 servers
[Jona]" referring to a fix today in the CVS; I do not know if that fix
has made it to the snapshot I am using.
Symptoms : Right-clicked on 'Databases' on the navigation panel, chose
"New Database". Filled in the database name ("test") and selected a
database owner different than myself ("bug_tracker"). Clicked OK. A
message box appears "ERROR: syntax error at or near "OWNER" at character
92."
The SQL code that was generated by the GUI is:
CREATE DATABASE test
WITH ENCODING='UNICODE'
OWNER=bug_tracker;
ALTER DATABASE test OWNER TO bug_tracker;
I copied the 'CREATE DATABASE' command to the SQL window and created the
database manually. It appears the 'ALTER DATABASE' command is at fault.
Thanks,
Ted.
From | Date | Subject | |
---|---|---|---|
Next Message | Ted Taylor | 2004-09-18 01:07:44 | Can't change server Initial DB property // Refresh server properties |
Previous Message | Andreas Pflug | 2004-09-17 15:36:33 | Re: pgAdmin III bug with transaction failure |