Received: from symcom.com ([209.11.41.82]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1RCasx40381 for ; Tue, 27 Feb 2001 07:36:54 -0500 (EST) (envelope-from pgsql@symcom.com) Message-Id: <200102271236.f1RCasx40381@mail.postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Tue, 27 Feb 2001 07:43:11 -0500 Date: Tue, 27 Feb 2001 07:43:11 -0500 From: "postgresql" To: "PgSQL-SQL" Subject: underscore problem X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200102/411 X-Sequence-Number: 1616 Is there anywhere in the docs that says we should not use an underscore in a table name? table FC_Client_Info exists with a record where jobno 1234 has info: select acode from FC_Client_Info where jobno = '1234'; fails with a warning that fc_client_info does not exist notice the lower case. If I quote the table select acode from "FC_Client_Info" where jobno = '1234'; the select works fine What's the problem here? This should be easy. Ted