[GENERAL] GRANT giving error on sequence in 7.4.19

2008-03-14 Thread Kakoli Sen
Hello all, I'm giving the query GRANT ALL PRIVILEGES ON SEQUENCE object_seq TO tester; ERROR: syntax error at or near "object_seq" at character 34. \ds is listing out the sequence. Regards, Kakoli ________

Re: [GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread Kakoli Sen
blem with GRANT in 7.4.19 > > > am Thu, dem 13.03.2008, um 15:09:18 +0530 mailte Kakoli Sen folgendes: > > Dear all, > > The command GRANT ALL PRIVILEGES ON DATABASE casDatabase to tester; > > is giving error: > > ERROR: database "casdatabase" does

[GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread Kakoli Sen
Dear all, The command GRANT ALL PRIVILEGES ON DATABASE casDatabase to tester; is giving error: ERROR: database "casdatabase" does not exist.(Note that the db name in error is all in lower case). Also \l shows that casDatabase exists. Why is 'casDatabase' being changed to 'casdatabase'? Reg

Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Kakoli Sen
March 12, 2008 11:09 AM > To: Kakoli Sen > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19 > > > Kakoli Sen wrote: > > Hello all, > > It was running fine initially and the database was > lying idle f

[GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Kakoli Sen
ions is not feasible. Thanks & Regards, Kakoli ________ KAKOLI SEN Ph:91-80-25341909/215(Extn. 309) C-DAC Knowledge ParkE-mail: #1, Old Madras Road [EMAIL PROTEC

[GENERAL] Initdb failed in PostgreSQL 7.3.21

2008-02-18 Thread Kakoli Sen
/pg_xlog... ok creating directory /usr/local/pgsql/data/pg_clog... ok creating template1 database in /usr/local/pgsql/data/base/1... initdb failed. Where is the problem? Regards, Kakoli KAKOLI SEN Ph