Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 458D02E0093 for ; Thu, 21 Feb 2008 13:47:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43363-01-2 for ; Thu, 21 Feb 2008 13:47:32 -0400 (AST) Received: from server2.dns-principal-3.com (server2.dns-principal-3.com [66.7.198.76]) by postgresql.org (Postfix) with ESMTP id 1AB112E00C8 for ; Thu, 21 Feb 2008 13:47:32 -0400 (AST) Received: from [201.231.212.172] (helo=brainmart05) by server2.dns-principal-3.com with esmtpa (Exim 4.68) (envelope-from ) id 1JSFW5-0006s4-BW; Thu, 21 Feb 2008 12:47:29 -0500 From: "Sebastian Rychter" To: Subject: Data layer migration from MSSQL Date: Thu, 21 Feb 2008 15:47:26 -0200 Message-ID: <008801c874b1$d468cad0$7d3a6070$@com.ar> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0089_01C874A1.10DFFAD0" X-Mailer: Microsoft Office Outlook 12.0 Thread-index: Ach0sdHWVGXaBHY+TKeqz1Ot0sa5pQ== Content-Language: es X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - server2.dns-principal-3.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anvet.com.ar X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/153 X-Sequence-Number: 30244 Este es un mensaje con varias partes en formato MIME. ------=_NextPart_000_0089_01C874A1.10DFFAD0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I'm working on migrating a data layer from MS SQL Server to PostgreSQL 8.2 and found that some reserved words should only be written between quotes and thus are case sensitive (actually only happened with a table field named "order"). Is there any way to bypass this case sensitivity or at least determine that I am going to use certain reserved words as table fields (or any other possible solutions) ? Thanks, Sebastian ------=_NextPart_000_0089_01C874A1.10DFFAD0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi, I’m working on = migrating a data layer from MS SQL Server to PostgreSQL 8.2 and found that some reserved words = should only be written between quotes and thus are case sensitive (actually = only happened with a table field named “order”). Is there any way to = bypass this  case sensitivity or at least determine that I am going to use certain = reserved words as table fields (or any other possible solutions) = ?

 

Thanks,

 

Sebastian

------=_NextPart_000_0089_01C874A1.10DFFAD0--