Skip site navigation (1) Skip section navigation (2)

Create Database - Owner - 7.4.5 backend

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 (view raw or flat)
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.

Responses

pgadmin-support by date

Next:From: Ted TaylorDate: 2004-09-18 01:07:44
Subject: Can't change server Initial DB property // Refresh server properties
Previous:From: Andreas PflugDate: 2004-09-17 15:36:33
Subject: Re: pgAdmin III bug with transaction failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group