Yupee! That worked fine. Thanks. I can move on now. Any idea how to connect to a non-default DB?
Doru On Fri, Feb 21, 2014 at 3:22 PM, Carlo <snoob...@gmail.com> wrote: > 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 <tu...@tudorgirba.com> wrote: > > Hi, > > > > > On Fri, Feb 21, 2014 at 7:33 AM, Sven Van Caekenberghe <s...@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 <tu...@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" > > -- www.tudorgirba.com "Every thing has its own flow"