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"
Weird, you seem to have a DB connection. Try something that does not need a table, like select current_time; Did you create 'testdb' and was 'testable' actually created there ? Can you connect to the DB on the command line ? $ psql testdb ? 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"
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"
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 <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"
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 <snoobabk@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 <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"
-- www.tudorgirba.com "Every thing has its own flow"
In psql you could try: \c testdb Then create the table. \conninfo will tell you which db you are connected to. Carlo On 21 Feb 2014, at 4:25 PM, Tudor Girba <tudor@tudorgirba.com> wrote: 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 <snoobabk@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 <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" -- www.tudorgirba.com "Every thing has its own flow"
hi It's a Postgres case problem. postgres translate any sentence to lowercase. For use uppercase you need use the " character. for example 'select * from TESTABLE' postgres execute 'select * from testable' and TESTABLE doesn't exists error. If you want uppercase you need reformulate sentence like this 'select * from "TESTABLE" ;' :( best regards jmdc On Fri, Feb 21, 2014 at 11:28 AM, Carlo <snoobabk@gmail.com> wrote:
In psql you could try: \c testdb
Then create the table. \conninfo will tell you which db you are connected to.
Carlo
On 21 Feb 2014, at 4:25 PM, Tudor Girba <tudor@tudorgirba.com> wrote:
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 <snoobabk@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 <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"
-- www.tudorgirba.com
"Every thing has its own flow"
Yeah, it must be a permission/access thing. You could also try to access a system table, like select * from pg_stat_activity; On 21 Feb 2014, at 15:22, Carlo <snoobabk@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 <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"
Case? Postgres is painful about case. 'SELECT * FROM testtable:â ?? I have V2 and V3 working on Mac OS X Mavericks. pgadmin installs easily and will allow you to examine you test db in more detail. 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"
On 21 Feb 2014, at 08:32, Guy Bloomfield <guy@healthqualitynz.com> wrote:
Postgres is painful about case.
No, its's not, AFAIK: t3-network=# Select session_ID,stArt,stOp from SESSION_LOGS limiT 1; session_id | start | stop ------------+----------------------------+---------------------------- 1814835731 | 2013-10-07 15:15:34.039+02 | 2013-10-07 15:15:48.522+02 (1 row)
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"
participants (5)
-
Carlo -
Guy Bloomfield -
Juan -
Sven Van Caekenberghe -
Tudor Girba