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:
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
--
"Every thing has its own flow"