Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > too many warnin...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 15530 of 17437
Post > Topic >>

too many warnings

by paumarc@[EMAIL PROTECTED] ("Pau Marc Munoz Torres") May 13, 2008 at 06:11 PM

------=_Part_6730_18961943.1210695117380
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi everybody

i get a lot of warnings when i try to execute a postgresql from a script

the warrning is

HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
LINE 1: ...9.table.viewentry_general_old.txt' WITH DELIMITER '\ '; DROP...

the problem is thet this script was done by anothey guy, so i cant change
this. by the way it is possible to change somthing at postgresql.conf that
allows use \ as scape?

i found this variable

standard_conforming_strings

 but i didn't find it at postgresql.conf

pau

--=20
Pau Marc Mu=F1oz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

tel=E8fon: 93 5812807
Email : paumarc.munoz@[EMAIL PROTECTED]
 text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi everybody<br><br>i get a lot of warnings when i try to execute a
postgre=
sql from a script<br><br>the warrning is<br><br>HINT:&nbsp; Use the escape
=
string syntax for escapes, e.g., E&#39;\r\n&#39;.<br>WARNING:&nbsp;
nonstan=
dard use of escape in a string literal<br>
LINE 1: ...9.table.viewentry_general_old.txt&#39; WITH DELIMITER &#39;\
&#3=
9;; DROP...<br><br>the problem is thet this script was done by anothey
guy,=
 so i cant change this. by the way it is possible to change somthing at
pos=
tgresql.conf that allows use \ as scape?<br>
<br>i found this variable<br><br>
standard_conforming_strings<br><br>&nbsp;=
but i didn&#39;t find it at postgresql.conf<br><br>pau<br
clear=3D"all"><br=
>-- <br>Pau Marc Mu=F1oz Torres<br><br>Laboratori de Biologia
Computacional=
 <br>
Institut de Biotecnologia i Biomedicina Vicent Villar <br>Universitat
Auton=
oma de Barcelona<br>E-08193 Bellaterra (Barcelona)<br> <br>tel=E8fon: 93
58=
12807<br>Email : paumarc.munoz@[EMAIL PROTECTED]

 




 2 Posts in Topic:
too many warnings
paumarc@[EMAIL PROTECTED]  2008-05-13 18:11:57 
Re: too many warnings
tgl@[EMAIL PROTECTED] (T  2008-05-13 12:34:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 13:07:47 CST 2008.