Re: [ADMIN] src equivelant of postgresql-python

2008-01-22 Thread Tom Lane
Kevin Kempter <[EMAIL PROTECTED]> writes: > What's the source equivelant of postgresql-python. Is it a client interface ? > Is it the same as "./configure --with-python" ? Probably depends on whose packaging you're talking about ... but in the current Red Hat and PGDG packaging, that's the pygresq

[ADMIN] src equivelant of postgresql-python

2008-01-22 Thread Kevin Kempter
Hi List; What's the source equivelant of postgresql-python. Is it a client interface ? Is it the same as "./configure --with-python" ? Thanks in advance. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http:

Re: [ADMIN] views from another schema

2008-01-22 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 22 Jan 2008 15:11:30 -0300 "fernando gamba" <[EMAIL PROTECTED]> wrote: > i need to know if i can make a view which get data from another schema > or a link wich point to a table in another schema. Sure... assume the following: create schema

[ADMIN] views from another schema

2008-01-22 Thread fernando gamba
i need to know if i can make a view which get data from another schema or a link wich point to a table in another schema. thanks in advance ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [ADMIN] no entry on pg_database for a live database

2008-01-22 Thread Shane Ambler
Mark Steben wrote: I'm running version 7.4.5. Do I have to do a drop-recreate or is there Some other way around this? There has been mention that some of the old versions of 7.x had data critical issues that are fixed in newer updates. My first suggestion would be to try it with 7.4.

Re: [ADMIN] no entry on pg_database for a live database

2008-01-22 Thread Tom Lane
"Mark Steben" <[EMAIL PROTECTED]> writes: > I have a live postgres database with 4 application tables. I can access it > through PSQL. > But there is no record of this database on the PG_DATABASE catalog table. Try vacuuming pg_database. If that works, it means your routine vacuuming procedures

[ADMIN] no entry on pg_database for a live database

2008-01-22 Thread Mark Steben
I have a situation I thought was impossible. I have a live postgres database with 4 application tables. I can access it through PSQL. But there is no record of this database on the PG_DATABASE catalog table. And I therefore cannot perform a PG_DUMP backup because it errors with, You guesse

Re: [ADMIN] how to create a limited user

2008-01-22 Thread hubert depesz lubaczewski
On Mon, Jan 21, 2008 at 03:49:55PM -0800, Guillermo Arias wrote: > Hi, i have a question: > > I have a database and i want to create a administrator user with total > control and another that only could make queries and could not see nor > modify the functions. > > The reason is that in the datab

Re: [ADMIN] how to create a limited user

2008-01-22 Thread PostgreSQL Admin
Did you even look for the information on postgresql.org? http://www.postgresql.org/docs/8.2/interactive/sql-createuser.html ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] how to create a limited user

2008-01-22 Thread Guillermo Arias
Hi, i have a question: I have a database and i want to create a administrator user with total control and another that only could make queries and could not see nor modify the functions. The reason is that in the database that i will distribute are the functions with a big part of the software lo