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"

Reply via email to