[ADMIN] Listing rules !!!

2001-05-29 Thread Luis Sousa
How can i know which rules are activate in my database ?? I can see the tables with \d, the views with \dv and so on ..., but for the rules ??? Thanks Luis Sousa ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] postgresql 7.1.1 and textout and textin

2001-05-29 Thread Jaume Teixi
Hello, trying to migrate production servers form 7.0.2 to 7.1.1 now I need to compile an function written in c and when compiling using following includes: #include #include #include #include //now doesn't exist ? here the mistake ? I get following compile errors: c:82:

Re: [ADMIN] postgresql 7.1.1 and textout and textin

2001-05-29 Thread Tom Lane
Jaume Teixi <[EMAIL PROTECTED]> writes: > trying to migrate production servers form 7.0.2 to 7.1.1 now I need to > compile an function written in c and when compiling using following > includes: > c:82: warning: passing arg 1 of `textout' from incompatible pointer type > line 82: src = textout(

[ADMIN] Re: pqReadData() -- backend closed the channel unexpectedly.

2001-05-29 Thread Jeff Barrett
Checked that out, every row has a value and the values are properly formatted. Seems like this may be an issue of not enough ram in the server. The only problem I have with that diagnosis is that I do not get an out of memory error, I just loose the back end. Thanks, Jeff "Tom Lane" <[EMAIL PRO

[ADMIN] Recompiling Non-PostGres apps when upgrading PostGreSQL

2001-05-29 Thread Chris Ruprecht
Hi all,   In the past, I have rebuilt all my "dependant" binaries, every time I installed a new version of Postgres. "Other binaries" means php, ssl and apache. However, I'm wondering if I really have to do that if nothing in the API changes. I know, it might be safe to do it anyway - just in

Re: [ADMIN] Re: pqReadData() -- backend closed the channel unexpectedly.

2001-05-29 Thread Tom Lane
"Jeff Barrett" <[EMAIL PROTECTED]> writes: > Checked that out, every row has a value and the values are properly > formatted. Seems like this may be an issue of not enough ram in the server. If it's a memory leak issue, my advice is still to upgrade to 7.1. regards, tom l

[ADMIN] Can I do a static compilation/installation of postgresql-7.1?

2001-05-29 Thread Dinos
---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html