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

Re: Discussion - Search Objects

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Discussion - Search Objects
Date: 2011-06-01 07:59:35
Message-ID: BANLkTimDfx9AqTPg_8n0bKMo6RpZL=H_FA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Wed, Jun 1, 2011 at 7:53 AM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
>
> One is allowed to drop the information_schema system catalog? I didn't
> know that. I guess it's all right 'cause you don't really need it.

I'm surprised you didn't know that :-). pgAdmin doesn't let you drop
it because it disables drop for all catalogs (I guess thats a minor
bug), but Postgres itself doesn't care because as you note, it's not
needed by the system and it's recognised that users may not want it
cluttering up their databases.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgadmin-hackers by date

Next:From: Jasmin DizdarevicDate: 2011-06-01 08:05:14
Subject: Re: Discussion - Search Objects
Previous:From: Guillaume LelargeDate: 2011-06-01 07:53:46
Subject: Re: Discussion - Search Objects

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