[ADMIN] Disable access shell command in psql

2007-07-23 Thread Thiago Maluf
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 bu

Re: [ADMIN] Disable access shell command in psql

2007-07-23 Thread Michael Fuhr
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

Re: [ADMIN] Disable access shell command in psql

2007-07-23 Thread Tom Lane
"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 do

Re: [ADMIN] Disable access shell command in psql

2007-07-23 Thread Thiago Maluf
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

Re: [ADMIN] "_" in a serach pattern

2007-07-23 Thread Jessica Richard
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

2007-07-23 Thread Mark Steben
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 wr

[ADMIN] varchar vs text columns

2007-07-23 Thread Jessica Richard
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 G

Re: [ADMIN] varchar vs text columns

2007-07-23 Thread Andrew Sullivan
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 bet

Re: [ADMIN] varchar vs text columns

2007-07-23 Thread Peter Eisentraut
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 posting/re

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

2007-07-23 Thread Nick Urbanik
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?

2007-07-23 Thread Nick Urbanik
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 Her

Re: [ADMIN] update within trigger function

2007-07-23 Thread Jim C. Nasby
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

Re: [ADMIN] "_" in a serach pattern

2007-07-23 Thread Peter Koczan
The only difference is that varchar can have a length limit, text is always unlimited length. There's no significant performance difference between either. For most intents and purposes, they're equal. varchar is better than text in that limits are already built in. You can always impose limit

[ADMIN] Installing PgAdmin package on Linux

2007-07-23 Thread Ashish Karalkar
Hello All, I am having PostgreSQL server 8.2.0 running on Redhat Linux . I want to install PgAdmin GUI on the Linux Server. can anybody please guide me to the appropriate documantation and the prerequisite required for the same . Thanks In Adavnce With Reagrds Ashish...