[ADMIN]

2011-05-07 Thread Didik Prasetyo
I want to ask how to make GRANT, where users can only perform SELECT on all the TABLE, in the database, which I have done the following login as: root root@203.142.85.52's password: Last login: Fri May 6 11:32:08 2011 from 10.10.5.22 cd /us [root@dev ~]# cd /usr/local/pgsql/bin/ [root@dev

Re: [ADMIN] (unknown)

2011-05-07 Thread Thomas Kellerer
Didik Prasetyo wrote on 07.05.2011 09:28: I want to ask how to make GRANT, where users can only perform SELECT on all the TABLE, in the database, which I have done the following You might consider upgrading, because since 9.x you can do: GRANT SELECT ON ALL TABLES IN SCHEMA public; Thomas

Re: [ADMIN] 'SGT DETAIL: Could not open file pg_clog/05DC: No such file or directory' - what to do now?

2011-05-07 Thread Tomasz Chmielewski
On 06.05.2011 10:42, Tomasz Chmielewski wrote: On 04.05.2011 22:27, Tomasz Chmielewski wrote: Then another pg_clog file disappeared. OK, I have: bookstor=# SELECT * FROM core_wot_seq; sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled |