Hi
I'm new to postgresql.
When logged in as postgres (using psql)the following query returns an error
gsmain_test=# select * from pgadmin_users;
ERROR: pg_shadow: Permission denied.
I can select from pg_user and pg_shadow.
The reason I am trying to run the above query is I had the same error
Seem to have fixed the problem by dropping and re-creating the database.
Thanks.
John
-Original Message-
From: John Hatfield
Sent: Friday, 23 February 2001 11:35 AM
To: 'PostgreSQL Admin News'
Subject:[ADMIN] select * from pgadmin_users; causes error
Hi
Message-
From: Tom Lane
Sent: Friday, 23 February 2001 3:01 PM
To: [EMAIL PROTECTED]
Cc: 'PostgreSQL Admin News'
Subject:Re: [ADMIN] select * from pgadmin_users; causes error
John Hatfield <[EMAIL PROTECTED]> writes:
> When logged in as postgres (using
Hi,
My problem is when running the vacuum with analyze an error occurs but it runs ok
without the analyse.
>From psql
gsmain_test=# vacuum;
VACUUM
gsmain_test=# vacuum analyze;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormal
mat not recognized
(gdb) where
No stack.
(gdb)
gdb does not seem to like the core file format though
Regards,
John
-Original Message-
From: Tom Lane
Sent: Friday, 2 March 2001 11:50 AM
To: [EMAIL PROTECTED]
Cc: 'PostgreSQL Admin'
Subject:Re: [ADMIN] Vacuum
rtld_fini=0x4000df24 <_dl_fini>, stack_end=0xbd2c)
at ../sysdeps/generic/libc-start.c:111
Regards
John
-Original Message-
From: Tom Lane
Sent: Friday, 2 March 2001 12:34 PM
To: [EMAIL PROTECTED]
Cc: 'PostgreSQL Admin'
Subject:Re: [ADMIN] Va
