From: Fred Parkinson <FredP@abag.ca.gov>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: db commands elicit no response
Date: Wed, 24 Feb 2016 10:23:58 -0800
Message-ID: <56CD84BE020000A700033475@gwia1.abag.ca.gov> (raw)
In-Reply-To: <CAKFQuwYXtdUJ3RF4gn=2nnF9+US+8C96hbFdLFRQSweUHn69ag@mail.gmail.com>
References: <56CD8288020000A700033470@gwia1.abag.ca.gov>
<CAKFQuwYXtdUJ3RF4gn=2nnF9+US+8C96hbFdLFRQSweUHn69ag@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Right you are! Somehow copy-paste lost the right-paren, put it back in and away we go!
Thanks for your prompt reply, now I can go back to work.
(I was right it was stupid)
Fred Parkinson
Application Programmer
Association of Bay Area Governments
510-464-7931
>>> On 2/24/2016 at 10:20 AM, "David G. Johnston" <david.g.johnston@gmail.com> wrote:
On Wednesday, February 24, 2016, Fred Parkinson <FredP@abag.ca.gov> wrote:
I must be doing something stupid but I can't figure it out.
**I logged into our database server (8.4.17) and did the following:
psql template1 **to get in
CREATE DATABASE planning_services **database created
**logged out of template1
psql planning_services **now in planing_services database with prompt
planning_services(#
This prompt indicates that you are in line-continuation mode. Don't know how you got there but everything you are typing is being added to a command buffer.
create table policies (
"id" serial primary key,
"description" varchar(100)
;
So, you have an open parentheses here but never closed it...which would explain the above.
David J.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: FredP@abag.ca.gov, david.g.johnston@gmail.com
Subject: Re: db commands elicit no response
In-Reply-To: <56CD84BE020000A700033475@gwia1.abag.ca.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox