Re: [ADMIN] privilege & user

2005-07-11 Thread Alvaro Herrera
On Mon, Jul 11, 2005 at 02:20:52PM -0600, Lee Wu wrote: > Here is my test, I think the privilege should be revoked automatically. Long-standing known bug. Fixed in 8.1. -- Alvaro Herrera () "La persona que no quería pecar / estaba obligada a sentarse en duras y empinadas sillas/ desprovis

[ADMIN] privilege & user

2005-07-11 Thread Lee Wu
Hi,   Here is my test, I think the privilege should be revoked automatically. Otherwise, it is a dangerous thing:   bash-2.05b$ createdb dod CREATE DATABASE bash-2.05b$ psql dod Welcome to psql 8.0.3, the PostgreSQL interactive terminal.   Type:  \copyright for distribution terms

Re: [ADMIN]

2005-07-11 Thread Benjamin GASSMANN
Hello, have you used a template (for example template1), which contains functions? Le Mon, 11 Jul 2005 16:22:17 +0200, Aris Aridis <[EMAIL PROTECTED]> a écrit: Hello, I have the following problem. Using PgAdminIII when I create a new DB I have no functions in the functions list. I did a t

[ADMIN]

2005-07-11 Thread Aris Aridis
Hello,   I have the following problem. Using PgAdminIII when I create a new DB I have no functions in the functions list. I did a typical configuration of both PostgreSQL 8.0.3 and PgAdminIII.   Any help would be very much appreciated. Thank you. Χρησιμοποιείτε Yahoo! Βαρεθήκατε τα ενοχλητικά

Re: [ADMIN] where with NULL values are not selected

2005-07-11 Thread Düster Horst
The problem is solved. The coalesce() function was the solution. Thank you very much for your input. With best regards Horst Düster -   Dr. Horst Düster GIS-Koordinator /Amtschef Stv. Kanton Solothurn  Amt für Geoinformation Abteilung SO!GIS Koordination Werkhof

[ADMIN] Regarding a backup scenario

2005-07-11 Thread nandan bsd
Hi all, I want some information regarding backups. The scenario is I have got a master server which has Linux as OS and postgres as Database Other than this server i have got 5 client servers(same configuration as All the transactions are done at different client locations and the data is ins