Hi I just tried following your steps and had the exact same issues. What I now tried is connecting to default DB which seems to be your USER name which worked for me. So in your scenario connect to girba as DB instead of testdb and you should succeed.
Cheers Carlo On 21 Feb 2014, at 4:16 PM, Tudor Girba <[email protected]> wrote: Hi, On Fri, Feb 21, 2014 at 7:33 AM, Sven Van Caekenberghe <[email protected]> wrote: Weird, you seem to have a DB connection. Exactly. So, that is good :) Try something that does not need a table, like select current_time; Thanks for the suggestion. Funny enough, this worked fine. Did you create 'testdb' and was 'testable' actually created there ? Can you connect to the DB on the command line ? $ psql testdb The DB seems to be created: girba=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+-------------+-------------+------------------- girba | girba | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | girba | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | girba | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/girba + | | | | | girba=CTc/girba template1 | girba | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/girba + | | | | | girba=CTc/girba testdb | girba | UTF8 | en_US.UTF-8 | en_US.UTF-8 | (5 rows) And the table seems to be created, too. I have: girba=# \dt List of relations Schema | Name | Type | Owner --------+-----------+-------+------- public | testtable | table | girba (1 row) Anything else I could test? Doru On 21 Feb 2014, at 06:55, 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" -- www.tudorgirba.com "Every thing has its own flow"
