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 <[email protected]> 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"
