X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 20B52528C3 for ; Thu, 23 Jun 2005 21:12:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85703-01 for ; Fri, 24 Jun 2005 00:12:30 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id 291405288E for ; Thu, 23 Jun 2005 21:12:29 -0300 (ADT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0IIK00901B84NK@asu.edu> for pgsql-admin@postgresql.org; Thu, 23 Jun 2005 17:12:04 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0IIK004Q8B84TW@asu.edu> for pgsql-admin@postgresql.org; Thu, 23 Jun 2005 17:12:04 -0700 (MST) Received: from teancum.pp.asu.edu (teancum.pp.asu.edu [129.219.69.212]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id j5O0C3j5020760 for ; Thu, 23 Jun 2005 17:12:03 -0700 (MST) Received: by teancum.pp.asu.edu (Postfix, from userid 1000) id 6CD0C724; Thu, 23 Jun 2005 17:12:03 -0700 (MST) Date: Thu, 23 Jun 2005 17:12:03 -0700 From: David Bear Subject: stupid insert error To: pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20050624001203.GL398@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200506/183 X-Sequence-Number: 17938 I guess I'm too stupid to see the error, but I don't understand why the following fails. insert into person3 (asuid, fname, lname, addedby, addedon, slopbucket) values ("123455", "name", "name", "entered", "12/12/2004", NULL); ERROR: column "123455" does not exist is the double quote byting me? -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"