<div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><span style="font-family:monospace,monospace">Hello Alex,<br><br></span></div><span style="font-family:monospace,monospace">Thank you for your prompt reply.<br><br></span></div><span style="font-family:monospace,monospace">Actually I am sure that the Postgres database and table do exist. <br><br></span></div><div><span style="font-family:monospace,monospace">I am also fairly sure that the user 'admin' (who is running the Ur/Web server) has permissions to access the database.<br><br></span></div><div><span style="font-family:monospace,monospace">(I realize there is sometimes confusion between the *Postgres* user 'admin' and the *Linux* user 'admin'. I may have not configured that properly. But I did later grant permissions on database 'urboard' to 'public' - which would seem to allow *any* user to access the database 'urboard').<br></span></div><div><span style="font-family:monospace,monospace"><br></span></div><span style="font-family:monospace,monospace">This existence of the database 'urboard' can be verified by inspecting the relevant portions of the transcript included in the question originally posted, namely:<br><br>postgres=# grant all on database urboard to admin;<br>GRANT<br>postgres=# \l<br>                              </span><span style="font-family:monospace,monospace">    List of databases<br>   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges<br>-----------+----------+-------</span><span style="font-family:monospace,monospace">---+-------------+------------</span><span style="font-family:monospace,monospace">-+-----------------------<br> crud1     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =CTc/postgres        +<br>           |          |          |             |             | postgres=CTc/postgres+<br>           |          |          |             |             | admin=CTc/postgres<br> postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |<br> template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +<br>           |          |          |             |             | postgres=CTc/postgres<br> template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +<br>           |          |          |             |             | postgres=CTc/postgres<br> test      | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres         +<br>           |          |          |             |             | postgres=CTc/postgres+<br>           |          |          |             |             | admin=CTc/postgres<br> urboard   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =CTc/postgres        +<br>           |          |          |             |             | postgres=CTc/postgres+<br>           |          |          |             |             | admin=CTc/postgres<br>(6 rows)<br><br>postgres=# \c urboard<br>You are now connected to database "urboard" as user "postgres".<br>urboard=# \d<br>                List of relations<br> Schema |       Name        |   Type   |  Owner<br>--------+-------------------+-</span><span style="font-family:monospace,monospace">---------+----------<br> public | uw_board_board    | table    | postgres<br> public | uw_board_boardseq | sequence | postgres<br> public | uw_board_forum    | table    | postgres<br> public | uw_board_forumseq | sequence | postgres<br> public | uw_board_post     | table    | postgres<br> public | uw_board_postseq  | sequence | postgres<br> public | uw_user_user      | table    | postgres<br> public | uw_user_userseq   | sequence | postgres<br>(8 rows)<br><br></span></div><span style="font-family:monospace,monospace">So it seems that there is something else going on.<br><br></span></div><span style="font-family:monospace,monospace">As far as I can see:<br><br></span></div><span style="font-family:monospace,monospace">- The database 'urboard' exists<br></span></div><span style="font-family:monospace,monospace">- The Postgres user 'admin' has been granted all privileges on database 'urboard'<br></span></div><span style="font-family:monospace,monospace">- (However, I'm not sure if the *Linux* user 'admin' also needs to be granted some privileges.)<br></span></div><span style="font-family:monospace,monospace">- To be extra certain, I granted all privileges on database 'urboard' to 'public' - then recompiled, and re-ran the sql script - and still got the same error.<br><br></span></div><span style="font-family:monospace,monospace">This makes me suspect that something might be going wrong involving camelcase versus lowercase in Postgres versus MySQL on Windows versus Linux.<br><br></span></div><span style="font-family:monospace,monospace">In this case, I am using Linux (Debian 8 Jessie) and Postgres (9.4.1).<br><br></span></div><span style="font-family:monospace,monospace">The most suspicious-looking thing to me is:<br><br></span></div><span style="font-family:monospace,monospace">The sql script uses *camelcase* for the table name - but the error message uses *lowercase*.<br><br></span></div><span style="font-family:monospace,monospace">I think some changes were made to the Ur/Web compiler recently, to handle certain issues regarding camelcase versus lowercase using MySQL on Windows or Linux.<br><br></span></div><span style="font-family:monospace,monospace">I am wondering if those changes may have inadvertently impacted Postgres on Linux as well?<br><br>###<br><br></span><div><div><span style="font-family:monospace,monospace"><br><br></span></div></div></div>