Adrian Klaver <adrian.klaver@xxxxxxxxx> writes: > On Thursday 01 July 2010 11:11:29 am Phil Jackson wrote: >> The link says that; >> "Identifier and key word names are case insensitive." >> >> But I have renamed the source table in lowercase and this gets me one >> step further. > You need to go to bottom of that section where you would find :) > ... If you want to write portable applications > you are advised to always quote a particular name or never quote it.) " In particular, what probably bit you here is that you created the tables using a tool that double-quoted the mixed-case names. Once you've done that, you are condemned to always double-quote those names forevermore. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
