2013/1/24 Nikolay Samokhvalov <samokhvalov@gmail.com>:
> some app created tables ussing uppercase letters in table names (this app
> was migrated from mysql). One tries to use \d to search tables info:
>
> ...
>
> Could this be considered as gotcha?
>
> The thing is that Postgres reply is pretty much clear:
> > Did not find any relation named "pnct_Board".
> , but table "pnct_Board" does exist in the system, so Postgres' reply is
> obviously incorrect.
Take a look at this section in the docs:
http://www.postgresql.org/docs/current/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
This is expected behavior.
--
Victor Y. Yegorov