Skip site navigation (1) Skip section navigation (2)

Missing data in Information Schema

From: George Weaver <gweaver(at)shaw(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Missing data in Information Schema
Date: 2005-11-02 17:57:29
Message-ID: 009a01c5dfd6$e8160600$6400a8c0@Dell4500 (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I'm running version 8.0 on Windows XP on a laptop.  

This morning while trying to generate a file of metadata I found that most of the views in Information_Schema are empty, for example referential_constraints, table_constraints, etc.

Any idea what may be causing this?

Thanks,
George

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-11-02 18:23:33
Subject: Re: Missing data in Information Schema
Previous:From: Tom LaneDate: 2005-11-02 14:36:03
Subject: Re: Update Rule

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group