Re: [PATCHES] Patch for - Allow server logs to be remotely read

2006-06-09 Thread Andreas Pflug
Alvaro Herrera wrote: Bruce Momjian wrote: Uh, I just added /contrib/adminpack a few weeks ago to CVS, which does this, and more. Sorry I forgot to mark the TODO item as completed. Huh, how do you read files with adminpack? try select * from pg_logdir_ls() as (filetime timestamp,

Re: [PATCHES] Patch for - Allow server logs to be remotely read

2006-06-09 Thread Andreas Pflug
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Tom Lane wrote: I wonder if we should take pg_read_file (and the rest of genfile.c) back out of the backend and stick them into contrib/adminpack. I thought about that but what we have in the backend now is read-only which

[PATCHES] ADD/DROP INHERITS

2006-06-09 Thread Greg Stark
This is where I am with the ADD/DROP INHERITS patch now. 1) The syntax is: ALTER TABLE child INHERIT parent ALTER TABLE child NO INHERIT parent no new reserved words, no conflicts, no complicated grammar productions in gram.y to confuse people in the future. 2) Dependencies are