[ADMIN] Disable access shell command in psql

Hello to everyone, I have one database server with postgresql 8.1 and I discovered yesterday one security problem. When I access my server with thought psql I have the possibility execute command in my server using \! or write one file using \e. I want disable these options in my server but I

Re: [ADMIN] Disable access shell command in psql

On Mon, Jul 23, 2007 at 10:59:17AM -0300, Thiago Maluf wrote: I have one database server with postgresql 8.1 and I discovered yesterday one security problem. When I access my server with thought psql I have the possibility execute command in my server using \! or write one file using \e.

Re: [ADMIN] Disable access shell command in psql

Thiago Maluf [EMAIL PROTECTED] writes: I have one database server with postgresql 8.1 and I discovered yesterday one security problem. When I access my server with thought psql I have the possibility execute command in my server using \! or write one file using \e. These are done on the

Re: [ADMIN] Disable access shell command in psql

I`m sorry list. I had one mistake. Thanks for everyone. Thiago 2007/7/23, Tom Lane [EMAIL PROTECTED]: Thiago Maluf [EMAIL PROTECTED] writes: I have one database server with postgresql 8.1 and I discovered yesterday one security problem. When I access my server with thought psql I have

Re: [ADMIN] _ in a serach pattern

Peter, thanks a lot for your reply. Could you please tell me more What is the difference between varchar and text? what is the benefit of each one? and is text alway better than varchar ?--- when it comes to a string column... thanks Peter Koczan [EMAIL PROTECTED] wrote: Hi, Jessica,

[ADMIN] update within trigger function

Hello listers, We have 'table a' which has defined to it an 'after insert or update' trigger function That inserts to 'table b', obviously for every update or insert of table a. The challenge I have now is to update a new date column on 'table a' with a value coming out of Another inhouse

[ADMIN] varchar vs text columns

What is the difference between varchar and text for a string column? What is the benefit of using each one? Is text better than varchar performance wise? Thanks. - Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto

Re: [ADMIN] varchar vs text columns

On Mon, Jul 23, 2007 at 11:33:54AM -0700, Jessica Richard wrote: What is the difference between varchar and text for a string column? What is the benefit of using each one? Is text better than varchar performance wise? From the manual: Tip: There are no performance differences

Re: [ADMIN] varchar vs text columns

Jessica Richard wrote: What is the difference between varchar and text for a string column? Nothing, if you don't use a limit for varchar. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: if

Re: [ADMIN] How overcome wait for vacuum full?

Dear Jim, On 15/05/07 20:28 -0500, Jim C. Nasby wrote: On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote: Dear Alvaro, On 15/05/07 21:12 -0400, Alvaro Herrera wrote: Nick Urbanik wrote: On 15/05/07 18:53 -0400, Alvaro Herrera wrote: You probably need to better configure the FSM

Re: [ADMIN] How overcome wait for vacuum full?

Dear Folks, On 24/07/07 05:31 +1000, Nick Urbanik wrote: Dear Jim, On 15/05/07 20:28 -0500, Jim C. Nasby wrote: On Wed, May 16, 2007 at 11:20:52AM +1000, Nick Urbanik wrote: Dear Alvaro, On 15/05/07 21:12 -0400, Alvaro Herrera wrote: Nick Urbanik wrote: On 15/05/07 18:53 -0400, Alvaro

Re: [ADMIN] update within trigger function

On Mon, Jul 23, 2007 at 02:05:20PM -0400, Mark Steben wrote: We have 'table a' which has defined to it an 'after insert or update' trigger function That inserts to 'table b', obviously for every update or insert of table a. The challenge I have now is to update a new date column on 'table