Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id XAA17740 for postgres-redist; Tue, 11 Jul 1995 23:02:28 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199507120602.XAA17740@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 tristero.io.com (tristero.io.com [199.170.88.11]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id XAA17730 for ; Tue, 11 Jul 1995 23:02:27 -0700 Received: from dialup-221.austin.io.com (dialup-221.austin.io.com [199.170.90.43]) by tristero.io.com (8.6.12/8.6.12) with SMTP id BAA00439 for ; Wed, 12 Jul 1995 01:02:05 -0500 Date: Wed, 12 Jul 1995 01:02:05 -0500 Message-Id: <199507120602.BAA00439@tristero.io.com> X-Sender: mskc@io.com Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: postgres@postgres.Berkeley.EDU From: mskc@io.com (Casey Claiborne) Subject: weird select results X-Mailer: Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Tue, 11 Jul 95 23:02:28 -0700 Resent-XMts: smtp Hello - I have a database that I created. I added data to it (that works). I then try the first query: retrieve (info.all) that brings up everything fine ------ BUT ----- when I try retrieve (info.all) where name="casey" I get the following error: WARN: Jul 12 00:26:12: type_id lookup of 362 failed This is just a simple select statement. I do not understand why it fails to return data :( What is wrong with what I am doing? Casey Claiborne mskc@io.com One must note the importance of setting reasonable and achievable goals for "If you aim for nothing, you'll hit it every time" ============================================================================== 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/