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.) Josh
test.sql
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
