Re: [ADMIN] problems with user rights

2005-03-31 Thread Zouari Fourat
anyone can help me with a sample of pg_hba.conf On Wed, 30 Mar 2005 09:47:31 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Wed, Mar 30, 2005 at 11:14:38AM -0500, John DeSoi wrote: > > On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote: > > > > >is it rea

Re: [ADMIN] problems with user rights

2005-03-30 Thread Zouari Fourat
is it really secure in a shared hosting environnement case ? do you advise me to offer pgsql in a shared hosting ? On Wed, 30 Mar 2005 08:04:00 -0500, John DeSoi <[EMAIL PROTECTED]> wrote: > > i've just added a new user called xxx : > > > > create user xxx with password zzz; > > > > now am creati

Re: [ADMIN] problems with user rights

2005-03-30 Thread Zouari Fourat
no one can help me over here ? On Mon, 28 Mar 2005 15:32:32 +0200, Zouari Fourat <[EMAIL PROTECTED]> wrote: > Hello, > i've just added a new user called xxx : > > create user xxx with password zzz; > > now am creating it's database : > > create datab

[ADMIN] problems with user rights

2005-03-28 Thread Zouari Fourat
Hello, i've just added a new user called xxx : create user xxx with password zzz; now am creating it's database : create database db_xxx with owner xxx; it works fine althought when logging with the user xxx i can still view other databases contents especially pg_catalog schems. is it the rig

Re: [ADMIN] is it a bug or it's my mistake ?

2005-02-28 Thread Zouari Fourat
no one got this kind of error ? On Sat, 26 Feb 2005 16:15:40 +0100, Zouari Fourat <[EMAIL PROTECTED]> wrote: > here's what logs contain : > ATTENTION: Laisse de côté les caractères UTF-8 inconvertibles 0xc389 > ATTENTION: Laisse de côté les caractères UTF-8 inconvertibles

Re: [ADMIN] is it a bug or it's my mistake ?

2005-02-26 Thread Zouari Fourat
longueur nulle sur 0/7C05940 TRACE: ré-exécution faite à 0/7C05918 TRACE: le système de bases de données est prêt On Sat, 26 Feb 2005 15:40:34 +0100, Zouari Fourat <[EMAIL PROTECTED]> wrote: > Hello, > When selecting (from php) using this select : > > SELECT msgid,content,timecr

[ADMIN] lowercase function

2005-02-24 Thread Zouari Fourat
Hello, Am looking for a 'tolowercase' function that returns lowercase string that can be used like this : SELECT lowercase(column) FROM table; anyone can help me ? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregiste

[ADMIN] psql work but not phppgadmin neither pgadmin3

2005-02-22 Thread Zouari Fourat
Hello; I've just installed the pgsql 8 on a fedora core 3 server, and when attempting to connect with psql -Ueserve -W i got it workin (eserve is a username i've created) and with pgadmn3 or phppgadmin i didnt get it working ---(end of broadcast)-

[ADMIN] postgres user, forgotten password

2005-02-22 Thread Zouari Fourat
Hello, i forgot the postgres user password, how to resolve this problem. once i have my postgres user working, how to list all users on the server ? thanks a bunch ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index

[ADMIN] newbie : START TRANSACTION

2005-02-15 Thread Zouari Fourat
Hello am new to transactional sql (just moved from mysql) and would like to use transactions and i want to ask about it here, when am in a transaction block can i execute other queries on the server (that table exactly) or shoudl i commit the transaction to free the table ? ---