RE: smsd and postgres with schemas problem

[Rogers, Paul]

Jan

Thanks for the prompt reply.  No, we never used the schemas in MySQL,
just seperte databases.  I'll try the diff this afternoon and let you
know how it goes.

Many thanks again

Paul 

-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Jan Derfinak
Sent: 29 January 2006 23:56
To: Discussion forum for gnokii users.
Subject: Re: smsd and postgres with schemas problem


On Thu, 26 Jan 2006 address@hidden wrote:

> Dear All
>  
> We have been using smsd on mysql and now wish to change the underlying

> database to postgres so the sms functionality is available to other 
> applications we use.  The smd daemon connects the database but is 
> unable to find the outbox table. I think that the problem is that the 
> database uses schemas so while I can specify the database name using 
> the -d option I am unable to specify the schema.

Please try the attached patch and let me know the result. Specify schema
with -s or --schema.

Did you use schemas with mysql? I searched documentation but schema in
mysql is only alias to database.

jan

-------------------------------------------------------------------
This email and any attachments transmitted with it are confidential (and 
potentially legally privileged) and intended solely for the use of the 
individual or entity to whom they are addressed. If you have received this 
email in error please notify the sender and do not store, copy or disclose the 
content to any other person.
It is the responsibility of the recipient to ensure that opening this message 
and/or any of its attachments will not adversely affect its systems. No 
responsibility is accepted by the sender.
-------------------------------------------------------------------