Re: [GENERAL] Backup DB not getting connected

2006-10-16 Thread J S B
i changed my connection string as follows keeping newDB in double quotesEXEC SQL CONNECT TO tcp:postgresql://192.168.1.1:5432/"newDB"Unfortunately these doulbe quotes lead to syntax error.Can you tell me what is the right syntax for the same. ThanksOn 10/13/06, Tom Lane <[EMAIL PROTECTED]> wrote: "

Re: [GENERAL] Backup DB not getting connected

2006-10-13 Thread Tom Lane
"J S B" <[EMAIL PROTECTED]> writes: > well, newDB is the name of the database and that what I'm tryin to connect. > I'm tryin to keep it the same case in ECPG code as it is in the Database. > Do u mean to say that combination of upper and lower case is not allowed? No, I mean to say that names wil

Re: [GENERAL] Backup DB not getting connected

2006-10-13 Thread J S B
well, newDB is the name of the database and that what I'm tryin to connect. I'm tryin to keep it the same case in ECPG code as it is in the Database. Do u mean to say that combination of upper and lower case is not allowed? in newDB , 'new' is all lower case and 'DB' is all upper.   Thanks, Jas  On

Re: [GENERAL] Backup DB not getting connected

2006-10-13 Thread Tom Lane
"J S B" <[EMAIL PROTECTED]> writes: > The user in the client machine is usrxyz (a unix user role) and user role > that owns newDB is userxyz (a db user role) I notice you keep spelling it as "newDB" ... is there a case-folding issue here perhaps? regards, tom lane ---

Re: [GENERAL] Backup DB not getting connected

2006-10-13 Thread J S B
The only diff b/w the two DBs  is that the one getting connected has ACL value as blank and the one that doesn't get connected has the same ACL property values = {}On 10/13/06, Shane Ambler <[EMAIL PROTECTED]> wrote: J S B wrote:> Hi,> I took a back up of my database and restored it in a new DB..W

Re: [GENERAL] Backup DB not getting connected

2006-10-13 Thread J S B
The user in the client machine is usrxyz (a unix user role) and user role that owns newDB is userxyz (a db user role)works fine with another database in the same database server with same user role combination. Don't know whats going wrong..On 10/13/06, Shane Ambler <[EMAIL PROTECTED]> wrote: J

Re: [GENERAL] Backup DB not getting connected

2006-10-13 Thread Shane Ambler
J S B wrote: Hi, I took a back up of my database and restored it in a new DB..When I'm trying to connect to the new DB from a client machine using ECPG connection techniques, it says newDB doesn't exist. There's another DB in the same DB server and if I try and connect to that DB then it does