Re: [GENERAL] How to see function & triggers definition?

2006-07-15 Thread ALI ÇELIK
Hi, this can be help you; XYZ: function/trigger name   SELECT p.proname AS name, p.oid, p.proargtypes AS args, ds.description , p.prorettype AS rettype, p.proretset, p.proisstrict AS strict, p.prosrc AS body, l.lanname AS lang, u.usename, p.prosecdef, p.provolatile, p.proisagg, n.nspname, pr

[GENERAL] Limited Availability

2006-07-15 Thread Joshua D. Drake
Hello, I will have extremely limited availability from the 17th through the 20th of this month. If you need to reach me and you don't have my cell, call the 800 number in my sig. I will likely not be checking email. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Pr

Re: [GENERAL] apparent wraparound

2006-07-15 Thread Florian G. Pflug
Gregory S. Williamson wrote: You need to edit the postgresql.conf file and increase the max_fsm_pages and > max_fsm_relations parameters and then restart postgres (I think you > have to actually stop and restart, as opposed to a reload, but I could be > wrong). You may end up needing to adjust t

Re: [GENERAL] apparent wraparound

2006-07-15 Thread Joshua D. Drake
Florian G. Pflug wrote: Gregory S. Williamson wrote: You need to edit the postgresql.conf file and increase the max_fsm_pages and > max_fsm_relations parameters and then restart postgres (I think you > have to actually stop and restart, as opposed to a reload, but I could be > wrong). You

Re: [GENERAL] troubleshooting 8.1.2

2006-07-15 Thread Ed L.
On Tuesday July 11 2006 3:16 pm, Tom Lane wrote: > "Ed L." <[EMAIL PROTECTED]> writes: > > We are wondering if our swap space was too small, and when > > the swap reservation failed, the OS was sending SIGINT?? > > You'd have to check your OS documentation ... I thought HPUX > would just return EN

[GENERAL] Log actual params for prepared queries: TO-DO item?

2006-07-15 Thread Ed L.
We'd like to attempt some log replay to simulate real loads, but in 8.1.2, it appears the formal parameters are logged ('$') instead of the actuals for prepared queries, e.g.: EXECUTE [PREPARE: UPDATE sessions SET a_session = $1 WHERE id = $2] Thoughts on making this a to-do item? Ed ---