On 21 Feb 2014, at 4:16 PM, Tudor Girba <tudor@tudorgirba.com> wrote:

Hi,

On Fri, Feb 21, 2014 at 7:33 AM, Sven Van Caekenberghe <sven@stfx.eu> 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 <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"

www.tudorgirba.com

"Every thing has its own flow"