Case? Postgres is painful about case. 'SELECT * FROM testtable:â ?? I have V2 and V3 working on Mac OS X Mavericks. pgadmin installs easily and will allow you to examine you test db in more detail. On 21/02/2014, at 6:55 pm, Tudor Girba <tudor@tudorgirba.com> wrote:
Hi,
I am trying to get the Postgres support to work on Mac, but I have difficulties and I would need a bit of help.
Here is what I do:
1. Install Postgres from http://postgresapp.com
2. Open the psql console and create a test table: CREATE TABLE TESTTABLE ( ID int, TEXT varchar(255) );
3. In Pharo, load PostgresV2: Gofer new smalltalkhubUser: 'PharoExtras' project: 'PostgresV2'; configuration; load. (#ConfigurationOfPostgresV2 asClass project version: '2.0-baseline') load
4. In a Workspace: | conn | conn := PGConnection new. conn connectionArgs: (PGConnectionArgs hostname: 'localhost' portno: 5432 databaseName: 'testdb' userName: 'girba' password: ''). conn startup.
This works fine and the PGResult is good (if I use a wrong user, it tells me that the user does not exist).
5. However:
conn execute: 'SELECT * FROM TESTTABLE;'
==> PGErrorResponse(value='ERROR: relation "testtable" does not exist at character 15 ')
What am I missing?
Doru
-- www.tudorgirba.com
"Every thing has its own flow"