Re: [GENERAL] What is the difference between cmin and cmax

2013-07-02 Thread Luca Ferrari
On Tue, Jul 2, 2013 at 5:19 AM, 高健 luckyjack...@gmail.com wrote: Hello: I looked into the source code, and I think I now understand it: cmin and cmax are same! The documentation is too old now. Yes, you figured it out. For short: cmin and cmax are overlapped fields and are used within the same

Re: [GENERAL] (Default) Group permissions

2013-07-02 Thread Albe Laurenz
Michael Orlitzky wrote: I want to be able to create a database, set up the (default) group permissions, and have them work, even when a new user is added to one of the groups. Right now I don't know of a way to get default group permissions. There is none, as far as I can say. You have two

Re: [GENERAL] PostgreSQL archiving last replayed WAL after recovery

2013-07-02 Thread Daniel Blanco
I'm having the same problem. In my case, and as recommended in the official documentation, my archive command checks that the file exists first, before archiving it:After a successful recovery, the last WAL file replayed from the base archive is still in the pg_xlog directory, so when it tries to

[GENERAL] Analyzing last run query in psql

2013-07-02 Thread Joe Van Dyk
I frequently need to analyze the last query in psql: select * from table where id = 1; explain analyze select * from table where id = 1; It would be nice to be able to do this: explain analyze $LAST (or can I do something like that already?) I'm not using psql interactively, I pipe