[ADMIN] Help desperately needed: reoccurring invalid page header

Hi, Problem environment: Database-server: - Fedora Core 1 under virtuozzo virtual server running on Fujitsu-siemens hardware - Kernel: Linux claymountain.planeetta.com 2.4.20-021stab028.5.777-enterprise #1 SMP Tue Feb 22 17:44:46 MSK 2005 i686 i686 i386 GNU/Linux - Postgresql 7.4.6 (from rpm by

Re: [ADMIN] catalog of postgres

On Wed, Apr 27, 2005 at 03:57:41PM -0400, Mario Soto Cordones wrote: > SELECT nspname as esquema, relname as objeto, > (CASE relkind > WHEN 'v' THEN 'Vista' > WHEN 'i' THEN 'Indice' > WHEN 'S' THEN 'Secuencia' > WHEN 'r' THEN 'Tabla' > WHEN 'c' THEN 'Tipo' > END) as tipo > FROM > pg_

Re: [ADMIN] catalog of postgres

OK i have a big mistake, i saw bad, now my new query is SELECT nspname as esquema, relname as objeto, (CASE relkind WHEN 'v' THEN 'Vista' WHEN 'i' THEN 'Indice' WHEN 'S' THEN 'Secuencia' WHEN 'r' THEN 'Tabla' WHEN 'c' THEN 'Tipo' END) as tipo FROM pg_class bc, pg_attribute ta, p

Re: [ADMIN] PostgreSQL 8.0.x on Windows XPe

> Hello, > > Has anyone tried using PostgreSQL 8.0.x on Windows XPe? XPe as in XP Embedded? I haven't heard of any. > I tried installing and it failed on the "Initialise database > cluster" step saying that it could not open the "Secondary > Logon service". The message indicated that the spe

[ADMIN] unsusbscribe

---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] catalog of postgres

This might help, got it from a project run by Great Bridge Software, now defunct, to create an Oracle like data dictionary for PostGreSql: CREATE VIEW all_objects AS SELECT UPPER(pg_get_userbyid (cls.relowner)) AS owner ,UPPER(cls.relname) AS object_name ,CASE WHEN cls.relk

Re: [ADMIN] catalog of postgres

Yeah, same here... Here is a test case where tables and views show up with the same relkind... :) $ psql test -c "create table table1(id int); create view view1 as select * from table1;" CREATE VIEW $ psql test -c "select relname, relkind from pg_class where relname in ('table1', 'view1');" |

Re: [ADMIN] catalog of postgres

Mario Soto Cordones <[EMAIL PROTECTED]> writes: > OK but views and tables for example have the same one relkind Not for many years now (certainly not in any release that has pg_namespace). regards, tom lane ---(end of broadcast)---

Re: [ADMIN] catalog of postgres

OK but views and tables for example have the same one relkind thank 2005/4/27, Alvaro Herrera <[EMAIL PROTECTED]>: > On Wed, Apr 27, 2005 at 02:02:09PM -0400, Mario Soto Cordones wrote: > > > with this query I obtain the schema name and the objects of this it , but > > like I can know that t

Re: [ADMIN] catalog of postgres

On Wed, Apr 27, 2005 at 02:02:09PM -0400, Mario Soto Cordones wrote: > with this query I obtain the schema name and the objects of this it , but > like I can know that they are, that is to say if they are tables, > views, functions, sequences, etc See pg_class.relkind. -- Alvaro Herre

[ADMIN] catalog of postgres

Hi guys i have a following query: SELECT nspname as schema, relname as objeto FROM pg_class bc, pg_attribute ta, pg_namespace ns, pg_type ty WHERE ta.attrelid = bc.oid and ta.attnum > 0 and not ta.attisdropped and nspname <> 'information_schema' and nspname not like 'pg_%' and

Re: [ADMIN] Client Authentication problem

On Wed, Apr 27, 2005 at 12:13:14PM -0500, Scott Marlowe wrote: > On Wed, 2005-04-27 at 11:43, Vaneet Sharma wrote: > > > > "Error connecting to the server: could not connect to the server: No > > route to host ( 0X2751/10065). > > Is the server running on host 212.xx.xxx.xxx and accepting TCP/I

Re: [ADMIN] security via views

Enrico Weigelt <[EMAIL PROTECTED]> writes: > Most of the database access works over views and functions. > For functions its possible to run them with separate privileges > than the calling user. But is this also possible with views ? > I've noticed that for views also GRANT is necessary (AFAIK a

Re: [ADMIN] Client Authentication problem

On Wed, 2005-04-27 at 11:43, Vaneet Sharma wrote: > Hello, > > I am using postgreSQL 8.0.2 > > I configured the database, started postmaster. It is running well. I > can check and see it with ps anx command. > > I am running postgreSQL on centos 3.4 and Centos 4.0 machines > > Well, I created a

[ADMIN] Client Authentication problem

Title: Client Authentication problem Hello, I am using postgreSQL 8.0.2 I configured the database, started postmaster. It is running well. I can check and see it with ps anx command. I am running postgreSQL on centos 3.4 and Centos 4.0 machines Well, I created a database called test a

Re: [ADMIN] security via views

Hello, yes this works. Just drop the rights on the table and grand the rights on the view. Peter Am Mittwoch, 27. April 2005 17:52 schrieb Enrico Weigelt: > Hi folks, > > we've got a larger project with several subsystems, which should > run in their own security context / users. > > Most of th

[ADMIN] PostgreSQL 8.0.x on Windows XPe

Hello, Has anyone tried using PostgreSQL 8.0.x on Windows XPe? I tried installing and it failed on the "Initialise database cluster" step saying that it could not open the "Secondary Logon service". The message indicated that the specified service does not exist as an installed service. The prob

[ADMIN] security via views

Hi folks, we've got a larger project with several subsystems, which should run in their own security context / users. Most of the database access works over views and functions. For functions its possible to run them with separate privileges than the calling user. But is this also possible wit