Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aYe6e-0000Y6-6B for pgsql-admin@arkaria.postgresql.org; Wed, 24 Feb 2016 18:24:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aYe6d-00052g-9i for pgsql-admin@arkaria.postgresql.org; Wed, 24 Feb 2016 18:24:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aYe6c-00052T-Pf for pgsql-admin@postgresql.org; Wed, 24 Feb 2016 18:24:10 +0000 Received: from pp-ag2.abag.ca.gov ([198.31.87.12]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aYe6Z-0000yr-2M for pgsql-admin@postgresql.org; Wed, 24 Feb 2016 18:24:10 +0000 Received: from pps.filterd (pp-ag2.abag.ca.gov [127.0.0.1]) by pp-ag2.abag.ca.gov (8.15.0.59/8.15.0.59) with SMTP id u1OIO3tE003128 for ; Wed, 24 Feb 2016 10:24:03 -0800 Received: from gwia1.abag.ca.gov ([172.16.1.27]) by pp-ag2.abag.ca.gov with ESMTP id 216pmrgak2-1 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NOT) for ; Wed, 24 Feb 2016 10:24:03 -0800 Received: from d02-MTA by gwia1.abag.ca.gov with Novell_GroupWise; Wed, 24 Feb 2016 10:24:02 -0800 Message-Id: <56CD84BE020000A700033475@gwia1.abag.ca.gov> X-Mailer: Novell GroupWise Internet Agent 14.0.1 Date: Wed, 24 Feb 2016 10:23:58 -0800 From: "Fred Parkinson" To: "David G. Johnston" Cc: Subject: Re: db commands elicit no response References: <56CD8288020000A700033470@gwia1.abag.ca.gov> In-Reply-To: Mime-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2016-02-24_09:,, signatures=0 X-Pg-Spam-Score: -4.2 (----) Content-Type: multipart/alternative; boundary="=__Part281FBE2E.3__=" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__Part281FBE2E.2__= Content-Type: multipart/alternative; boundary="=__Part281FBE2E.3__=" --=__Part281FBE2E.3__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable 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" wrote: On Wednesday, February 24, 2016, Fred Parkinson 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. --=__Part281FBE2E.3__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML =0A=0A=0A=0A
<= div>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
=0A
Application Programmer
=0AAssociation of Bay Area Governments=0A
510-464-7931



= >>> On 2/24/2016 at 10:20 AM, "David G. Johnston" <david.g.john= ston@gmail.com> wrote:
=0AOn Wednesday, February 24, = 2016, Fred Parkinson <FredP@abag.ca= .gov> wrote:

=0A= =0A=0A=0A
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:
p= sql 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(#

Th= is 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.
=0A --=__Part281FBE2E.3__=-- --=__Part281FBE2E.2__=--