Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA14142 for postgres-redist; Fri, 10 Feb 1995 07:37:02 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199502101537.HAA14142@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from RASAM.NDIM.EDRC.CMU.EDU (RASAM.NDIM.EDRC.CMU.EDU [128.2.214.234]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id HAA14131 for ; Fri, 10 Feb 1995 07:37:01 -0800 Received: from Messages.8.5.N.CUILIB.3.45.SNAP.NOT.LINKED.rasam.ndim.edrc.cmu.edu.pmax.ul4 via MS.5.6.rasam.ndim.edrc.cmu.edu.pmax_ul4; Fri, 10 Feb 1995 10:36:12 -0500 (EST) Message-ID: Date: Fri, 10 Feb 1995 10:36:12 -0500 (EST) From: Robert.Patrick@cs.cmu.edu To: postgres@postgres.Berkeley.EDU Subject: Re: creation problem CC: postgres@postgres.Berkeley.EDU In-Reply-To: <9502100310.AA23565@dec324.aist-nara.ac.jp> References: <9502100310.AA23565@dec324.aist-nara.ac.jp> X-Sender: rp2y@RASAM.NDIM.EDRC.CMU.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Fri, 10 Feb 95 07:37:02 -0800 Resent-XMts: smtp Excerpts from internet.postgres: 10-Feb-95 Re: creation problem Drunkard Terry@is.aist-n (2052*) > dec324[281]% monitor -TN -c "append ticket (number="3", status="open", > opener="yutaka-i")" ntemp > WARN:Feb 10 12:01:56:typeid_get_relid: Invalid type - oid = 357 Try quoting the quotes. % monitor -TN -c "append ticket (number = 3, status=\"open\", opener=\"yutaka-i\")" ntemp I left out the quotes on the number 3 because quotes aren't needed for numbers (unless they are stored as strings). Robert ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/