Re: db commands elicit no response - Mailing list pgsql-admin

From David G. Johnston
Subject Re: db commands elicit no response
Date
Msg-id CAKFQuwYXtdUJ3RF4gn=2nnF9+US+8C96hbFdLFRQSweUHn69ag@mail.gmail.com
Whole thread Raw
In response to db commands elicit no response  ("Fred Parkinson" <FredP@abag.ca.gov>)
Responses Re: db commands elicit no response  ("Fred Parkinson" <FredP@abag.ca.gov>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "Fred Parkinson"
Date:
Subject: db commands elicit no response
Next
From: "Fred Parkinson"
Date:
Subject: Re: db commands elicit no response