Hello hackers, I noticed in the TODO that there is an item requesting a function which returns the uptime of the postmaster. I've wanted that as well. So, I've added just such a thing: server_start_time(). This function returns the time when the postmaster was started; a simple now() - server_start_time() returns the uptime.
The below patches are for four files: * postmaster.c: Now calls a new function, MarkServerStartTime(), before calling ServerLoop(). * timestamp.h/timestamp.c: New functions: MarkServerStartTime() (called from postmaster.c) and server_start_time(), a new SQL function which may be called. * pg_proc.h: Added DATA and DESCR to the very end of the list (OID=2557) for the server_start_time function. I didn't bother to include the generated fmgroids.h and fmgrtab.c. Since they are small, I've attached the four unified diffs against the 8.0.1 code. Let me know if there's anything different the code should have done. --Eric
pg_proc.h.diff
Description: Binary data
postmaster.c.diff
Description: Binary data
timestamp.c.diff
Description: Binary data
timestamp.h.diff
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
