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"