Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
SQL Conector postgres
sp_NewPost Add Reply sp_NewTopic Add Topic
December 27, 2012
10:37 pm
Sandro
Guest
Guests

okay.

actually the table name was uppercase and lowercase, solved the problem.

thank you.

December 18, 2012
11:04 pm
Henk Helmantel
Guest
Guests

Hi Sandro,

This error indicates that the table "MessageOut" cannot be found by PostgreSQL. It can mean that the table does not exists but if you are sure you have created it, it is also possible that the tables were created with double quoted names, which makes them case sensitive.

If that is the case it is best to remove the tables and recreate them again using lower case table names and field names or table names without double quotes.

In the online manual you can find some information on how to use PostgreSQL with Diafaan SMS Server.

Regards, Henk

December 18, 2012
10:27 pm
Sandro
Guest
Guests

I'm doing testing using SQL Connector postfgres

I made the connection with the database, everything worked ok.

the test configuration for the fields send SMS

Driver = {PostgreSQL UNICODE}; Server = 127.0.0.1, Port = 5432; Database = SMSServer; Uid = postgres;
Maker PWD = -1;

SELECT id, messageto, MessageText, messagefrom MessageOut FROM WHERE id = '0 '

ERROR [42P01] ERROR: relation "MessageOut" does not exist;
Error while executing the query

after clicking the test button appears above error.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1844

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 551