On Tue, 11 Dec 2012 18:58:58 -0700 Josh Kupershmidt <schmi...@gmail.com> wrote:
> On Tue, Dec 11, 2012 at 6:01 PM, David Gould <da...@sonic.net> wrote: > > > > I'm sure I've had a stroke or something in the middle of the night and just > > didn't notice, but I'm able to reproduce the following on three different > > hosts on both 9.2.1 and 9.2.2. As far as I know the only difference between > > these queries is whitespace since I just up-arrowed them in psql and > > deleted a space or <lf>. And as far as I can tell none of these errors are > > correct. > > > > Complete transcript, freshly started 9.2.2. > > > > dg@jekyl:~$ psql > > psql (9.2.2) > > Type "help" for help. > > > > dg=# CREATE TABLE t ( > > i INTEGER, > > PRIMARY KEY (i) > > ); > > ERROR: type "key" does not exist > > LINE 3: PRIMARY KEY (i) > > Hrm, although I didn't see such characters in your above text, perhaps > you have some odd Unicode characters in your input. For example, the > attached superficially similar input file will generate the same error > message for me. (The odd character in my input is U+2060, 'Word > Joiner', encoded 0xE2 0x81 0xA0.) Thank you. I got the example via cut and paste from email and pasted it into psql on different hosts. od tells me it ends each line with: \n followed by 0xC2 0xA0 and then normal spaces. The C2A0 thing is apparently NO-BREAK SPACE. Invisible, silent, odorless but still deadly. Which will teach me not to accept text files from the sort of people who write code in Word I guess. -dg -- David Gould 510 282 0869 da...@sonic.net If simplicity worked, the world would be overrun with insects. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
