Thread: Bug #932: some system tables are not accessible

Raouf (raimeur@cisco.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
some system tables are not accessible

Long Description
Platform: Windows 2ooo professional workstation
posgresql : PgSQL731wina1.exe
postgresql version:  PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (pre release)

description:
Some system tables are not accessible, for instance:
1- pg_user
2- pg_tables

I have not tried all the system tables so probably others are missing.

output:
testCoverage=# select * from pg_tables;
less: not found
testCoverage=#

thanks,




Sample Code


No file was uploaded with this report

On Thu, 3 Apr 2003 pgsql-bugs@postgresql.org wrote:

> Raouf (raimeur@cisco.com) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> some system tables are not accessible
>
> description:
> Some system tables are not accessible, for instance:
> 1- pg_user
> 2- pg_tables
>
> I have not tried all the system tables so probably others are missing.
>
> output:
> testCoverage=# select * from pg_tables;
> less: not found
> testCoverage=#

This seems to be saying your pager isn't there, not anything about
the table itself.

Try doing
\pset pager off

before your query and see if it still fails.