Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3D4049FB350; Tue, 31 Oct 2006 13:14:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31984-10; Tue, 31 Oct 2006 13:14:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from exprod6og52.obsmtp.com (exprod6og52.obsmtp.com [64.18.1.185]) by postgresql.org (Postfix) with SMTP id 8E22F9FB33F; Tue, 31 Oct 2006 13:14:00 -0400 (AST) Received: from source ([63.240.6.46]) by exprod6ob52.postini.com ([64.18.5.12]) with SMTP; Tue, 31 Oct 2006 09:13:58 PST Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Tue, 31 Oct 2006 12:13:38 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL02.Mi8.com ([172.16.1.153]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 31 Oct 2006 12:13:37 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Re: [HACKERS] Case Preservation disregarding case Date: Tue, 31 Oct 2006 12:13:31 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [HACKERS] [SQL] Case Preservation disregarding case sensitivity? thread-index: Acb8trFOVQK9VtklReyxjHXzYCJrdgAWP3cg References: <200610271623.37525.beauh@bluefrogmobile.com> <1162003132.687.8.camel@pampa> <200610301928.51255.beauh@bluefrogmobile.com> <23177.1162265010@sss.pgh.pa.us> <24861.1162276496@sss.pgh.pa.us> From: "Chuck McDevitt" To: "Tom Lane" cc: "beau hargis" , pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org X-OriginalArrivalTime: 31 Oct 2006 17:13:37.0333 (UTC) FILETIME=[E7498650:01C6FD0F] X-WSS-ID: 69595BCB3ZW963068-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/58 X-Sequence-Number: 26710 Oh... And Microsoft SQLServer does something similar. At Greenplum, we've already gotten complaints from customers about this when they were switching from MSSQL to GP's PostgreSQL-based database. -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Sent: Monday, October 30, 2006 10:35 PM To: Chuck McDevitt Cc: beau hargis; pgsql-sql@postgresql.org; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] [SQL] Case Preservation disregarding case sensitivity? "Chuck McDevitt" writes: > At Teradata, we certainly interpreted the spec to allow case-preserving, > but case-insensitive, identifiers.