Create Database - Owner - 7.4.5 backend
От | Ted Taylor |
---|---|
Тема | Create Database - Owner - 7.4.5 backend |
Дата | |
Msg-id | 414B87C4.7060208@3shmoos.ca обсуждение исходный текст |
Ответы |
Re: Create Database - Owner - 7.4.5 backend
|
Список | 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.
В списке pgadmin-support по дате отправления: