Or SELECT* FROM ��TESTTABLE��'

Guy

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"