[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 KAKOLI SEN

[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'?

Re: [GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread Kakoli Sen
, 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 not exist.(Note that the db name in error is all in lower case). Also \l shows

Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-12 Thread Kakoli Sen
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 for a few days. Today I looged into the machine and restarted

[GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Kakoli Sen
. Thanks Regards, Kakoli KAKOLI SEN Ph:91-80-25341909/215(Extn. 309) C-DAC Knowledge ParkE-mail: #1, Old Madras Road [EMAIL PROTECTED] Bangalore - 560 038

[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