From sandhyar@amiindia.co.in Wed Mar 15 11:13:48 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8DDBE9DC97F for ; Wed, 15 Mar 2006 07:13:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92034-08 for ; Wed, 15 Mar 2006 07:13:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 49F7B9DC8A5 for ; Wed, 15 Mar 2006 07:13:39 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k2FB6nWn023942 for ; Wed, 15 Mar 2006 16:37:08 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id D4CEF33280C; Wed, 15 Mar 2006 16:17:37 +0530 (IST) Message-ID: <03ce01c6481f$7c228160$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: reg:FilePath error Date: Wed, 15 Mar 2006 16:28:41 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_03CB_01C6484D.85DAD2B0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:33.89235 C:22 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.14 required=5 tests=[AWL=0.138, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.14 X-Spam-Level: X-Archive-Number: 200603/124 X-Sequence-Number: 20881 This is a multi-part message in MIME format. ------=_NextPart_000_03CB_01C6484D.85DAD2B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi.... When i am trying to insert a string data into my table which has few = escape sequence characters...The entire string is not getting inserted. Like Ex: If my String data is=20 C:\ProgramFiles\SampleFiles\General\back.doc C:\ProgramFiles\SampleFiles\General\rback.gif C:\ProgramFiles\SampleFiles\General\nback.rar etc like this. But in my table the string is getting stored as, C:ProgramFilesSampleFilesGeneraack.doc=20 Where as the other Strings without these characters are getting inserted = fine.How is this happening?How the Strings are getting stored into the = Tables? Bcoz of this \b,\n and \r characters..I am unable to store my data into = the database and retrieve it. Is there any Solution that we have?Or we need to Take care of these = situations/cases? Please give me your Suggestions to resolve this issue.. Thank you very much.. Regards, Sandhya R ------=_NextPart_000_03CB_01C6484D.85DAD2B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi....
 
When i am trying to insert a string = data into=20 my table which has few escape sequence characters...The = entire=20 string is not getting inserted.
Like Ex:
If my String data is
 
C:\ProgramFiles\SampleFiles\General\back.doc
 
C:\ProgramFiles\SampleFiles\General\rback.gif
 
C:\ProgramFiles\SampleFiles\General\nback.rar etc like this.
 
But in my table the string is getting stored = as,
 
C:ProgramFilesSampleFilesGeneraack.doc=20
 
Where as the other Strings without these characters = are=20 getting inserted fine.How is this happening?How the Strings are getting = stored=20 into the Tables?
 
Bcoz of this \b,\n and \r characters..I am unable to = store my=20 data into the database and retrieve it.
 
Is there any Solution that we have?Or we need to = Take care of=20 these situations/cases?
 
Please give me your Suggestions to resolve this=20 issue..
Thank you very much..
Regards,
Sandhya R
 
=
------=_NextPart_000_03CB_01C6484D.85DAD2B0-- From kthusi@yahoo.com Wed Mar 15 11:49:54 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0321E9DCC84 for ; Wed, 15 Mar 2006 07:49:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98843-05 for ; Wed, 15 Mar 2006 07:49:57 -0400 (AST) X-Greylist: delayed 00:06:40.649569 by SQLgrey- Received: from web34409.mail.mud.yahoo.com (web34409.mail.mud.yahoo.com [66.163.178.158]) by postgresql.org (Postfix) with SMTP id 99AEB9DCC15 for ; Wed, 15 Mar 2006 07:49:51 -0400 (AST) Received: (qmail 57434 invoked by uid 60001); 15 Mar 2006 11:43:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=pvhbCAObsW+W160mwCtpA86NMQxGHtV6HrWIZWeIQW7L7/wSYqmwx7DXYHAk2Isuxo0jEfODsWpf/rlRYJYgA+XVR+XE+E+LvtrX+rKJt9zct7mMxbdZW8wWPNeqx3NFZ5o6lKmzyUCaSlSFF/W/iZXozUNjEnNKKZkpFJIAzME= ; Message-ID: <20060315114313.57432.qmail@web34409.mail.mud.yahoo.com> Received: from [203.115.30.220] by web34409.mail.mud.yahoo.com via HTTP; Wed, 15 Mar 2006 03:43:13 PST Date: Wed, 15 Mar 2006 03:43:13 -0800 (PST) From: Thusitha Kodikara Subject: Re: reg:FilePath error To: sandhya , Postgres Cc: sandhya In-Reply-To: <03ce01c6481f$7c228160$cd00000a@sandhyar> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.358 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.358 X-Spam-Level: * X-Archive-Number: 200603/125 X-Sequence-Number: 20882 Hi Sandhya, Try using two "\" characters if you want to insert on "\". For example use "C:\\ProgramFiles\\SampleFiles\\General\\back.doc" \b, \r, \t ... have special meanings. Please refer http://www.postgresql.org/docs/8.1/static/functions-matching.html Regards, -Thusitha --- sandhya wrote: > Hi.... > > When i am trying to insert a string data into my > table which has few escape sequence characters...The > entire string is not getting inserted. > Like Ex: > If my String data is > > C:\ProgramFiles\SampleFiles\General\back.doc > > C:\ProgramFiles\SampleFiles\General\rback.gif > > C:\ProgramFiles\SampleFiles\General\nback.rar etc > like this. > > But in my table the string is getting stored as, > > C:ProgramFilesSampleFilesGeneraack.doc > > Where as the other Strings without these characters > are getting inserted fine.How is this happening?How > the Strings are getting stored into the Tables? > > Bcoz of this \b,\n and \r characters..I am unable to > store my data into the database and retrieve it. > > Is there any Solution that we have?Or we need to > Take care of these situations/cases? > > Please give me your Suggestions to resolve this > issue.. > Thank you very much.. > Regards, > Sandhya R > From Kevin.Grittner@wicourts.gov Sat Mar 18 13:52:20 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6FEFB9DC801 for ; Sat, 18 Mar 2006 09:52:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39994-01 for ; Sat, 18 Mar 2006 09:52:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 153CB9DC857 for ; Sat, 18 Mar 2006 09:52:17 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Sat, 18 Mar 2006 07:52:21 -0600 Message-Id: <441BBC2D02000025000022E2@gwmta.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0 Date: Sat, 18 Mar 2006 07:52:13 -0600 From: "Kevin Grittner" To: Cc: Subject: Re: reg:FilePath error Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.101 required=5 tests=[AWL=0.101] X-Spam-Score: 0.101 X-Spam-Level: X-Archive-Number: 200603/142 X-Sequence-Number: 20899 If you can't easily use the PostgreSQL extension to SQL, but need to have string literal behavior conform to the ANSI and ISO standards, I have submitted a patch for the 8.2 TODO item to support this. Since we needed it in production mode now, the patch I submitted was relative to the 8.1 stable branch. As far as I know, it has not been reviewed, so there may be issues I missed, but I can say that we have been using in production for several weeks, with maybe 20 million database transactions per day across 8 servers runing on Windows and Linux, and have not seen any problems with it. If you search the lists for it, be sure to take the last patch from the patches list, there were several iterations to this, and you don't want the earlier ones. -Kevin >>> "sandhya" >>> Hi.... When i am trying to insert a string data into my table which has few escape sequence characters...The entire string is not getting inserted. Like Ex: If my String data is C:\ProgramFiles\SampleFiles\General\back.doc C:\ProgramFiles\SampleFiles\General\rback.gif C:\ProgramFiles\SampleFiles\General\nback.rar etc like this. But in my table the string is getting stored as, C:ProgramFilesSampleFilesGeneraack.doc Where as the other Strings without these characters are getting inserted fine.How is this happening?How the Strings are getting stored into the Tables? Bcoz of this \b,\n and \r characters..I am unable to store my data into the database and retrieve it. Is there any Solution that we have?Or we need to Take care of these situations/cases? Please give me your Suggestions to resolve this issue.. Thank you very much.. Regards, Sandhya R