Re: [ADMIN] Two tables with same name in different user not allowed

2002-02-05 Thread Bruce Momjian
Kumar, Lakshmi (Cognizant) wrote: > Hi , > I have two users in my database x & y. > I tried to create a table abc in y which is there in x with the same > name.Ofcourse i logged in as user y and tried. > Even then am not allowed to create throwing error that "object already > exist". > Can any

[ADMIN] Probs with libapache-auth-pgsql on Mac OSX

2002-02-05 Thread David Stanaway
Hi there, I wonder if anyone here has tried the combination of libapache-auth-pgsql and php4 modules for apache on Mac OSX 10.1.2? When I start apache with both modules loaded, I get conflicting definitions of the symbol _DLAddHead from the pgauth module and the php4 module. Does anyone know

[ADMIN] Probs with libapache-auth-pgsql on Mac OSX

2002-02-05 Thread David Stanaway
Hi there, I wonder if anyone here has tried the combination of libapache-auth-pgsql and php4 modules for apache on Mac OSX 10.1.2? When I start apache with both modules loaded, I get conflicting definitions of the symbol _DLAddHead from the pgauth module and the php4 module. Does anyone know

[ADMIN] Two tables with same name in different user not allowed ?

2002-02-05 Thread Kumar, Lakshmi (Cognizant)
Hi , I have two users in my database x & y. I tried to create a table abc in y which is there in x with the same name.Ofcourse i logged in as user y and tried. Even then am not allowed to create throwing error that "object already exist". Can anybody xplain this comparing Oracle-schema with th

Re: [ADMIN] postgresql 7.1.3

2002-02-05 Thread Tom Lane
[EMAIL PROTECTED] (Srinivasa Rao Chava) writes: > I have postgresql7.1.2 on system now(sunOs5.6). I downloaded > postgresql7.1.3 from one of the ftp mirror site. When I try to gunzip > it, it is giving the following error > gunzip: postgresql-7.1.3.tar.gz: invalid compressed data--format > violat

Re: [ADMIN] postgresql 7.1.3

2002-02-05 Thread Zhang, Anna
try: $tar xzpf postgresql-7.1.3.tar.gz Anna Zhang -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 12:51 PM To: [EMAIL PROTECTED] Subject: [ADMIN] postgresql 7.1.3 Hi, I have postgresql7.1.2 on system now(sunOs5.6). I downloaded po

[ADMIN] postgresql 7.1.3

2002-02-05 Thread Srinivasa Rao Chava
Hi, I have postgresql7.1.2 on system now(sunOs5.6). I downloaded postgresql7.1.3 from one of the ftp mirror site. When I try to gunzip it, it is giving the following error # gunzip postgresql-7.1.3.tar.gz gunzip: postgresql-7.1.3.tar.gz: invalid compressed data--format violated # What is the r

Re: [ADMIN] Where can I get Users and Roles information in PostgreSQL

2002-02-05 Thread Henshall, Stuart - WCP
Have a look at the system views pg_user and pg_group - Stuart > -Original Message- > From: Andy Ruhl [mailto:[EMAIL PROTECTED]] > Sent: 04 February 2002 13:33 > To: sreedhar > Cc: PostgreSQL > Subject: Re: Where can I get Users and Roles information in PostgreSQL > > > On Mon, 4 Feb 200

[ADMIN] Privilégios sobre colunas

2002-02-05 Thread Sandro Joel Eller
Oi Estou tentando dar ao usuarios alguns privilégios sobre algumas colunas da tabela. Na documentção especifica que é compativel com o Padrão SQL92 - o qual permiti este tipo de operação - mas o postgres não esta aceitando o comando "grant update on usuarios (codigo, nome) to sandro". Como eu p