From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Kilian Koepsell <Kilian(dot)Koepsell(at)desy(dot)de> |
Cc: | pgsql-bugs(at)postgreSQL(dot)org |
Subject: | Re: [BUGS] bug in pg_dump |
Date: | 1999-07-14 14:24:04 |
Message-ID: | 25483.931962244@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Kilian Koepsell <koepsell(at)aei-potsdam(dot)mpg(dot)de> writes:
>> I cannot reproduce this here --- I get Jos\\''e which is what the
>> pg_dump code is supposed to do...
> Oh, you are right. I checked it again and I also got Jos\\''e.
> But I expected to get Jos\\\' (a quoted \ -> \\ and a quoted ' -> \').
> Is '' an other possibility to quote the ' character?
Yes, in fact it is the SQL-standard-approved way. \' is not standard.
pg_dump used to use \', but I changed it to use '' in hopes of improving
compatibility with other RDBMSes.
BTW, now that I look at the code I think that it may have a bug in the
MULTIBYTE case, since pg_dump will be dealing with client-side encodings
but it is not doing anything special to handle multibyte characters.
Can any multibyte guru comment on whether it is OK or not?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Unprivileged user | 1999-07-15 07:52:37 | General Bug Report: Large Object Example testlo fails |
Previous Message | Kilian Koepsell | 1999-07-14 13:59:34 | Re: [BUGS] bug in pg_dump |