Re: Dropping wrong object

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Cheetah <fastcat(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Dropping wrong object
Date: 2005-01-28 13:45:02
Message-ID: 41FA41DE.1060105@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Cheetah wrote:
> I thought I had seen this reported before, but I'm not finding it, so
> here goes ...
>
> If an object of the same name exists in the user[1] and the public
> schema, then using the delete/drop command on the object in the public
> schema in pgadmin3 (1.2.0) can cause the wrong object to be dropped.
> The cause seems to be not including the schema name in the drop
> command when the schema is public. Since the default search path puts
> the user's schema before the public one, this will drop the wrong item
> in the default config. And who knows what the user might set the
> default search path to in the postgresql.conf.
>
> [1] i.e. the schema with the same name as the logged in user

I hate search_path....

I think we should add an option to suppress the public. prefix if
desired. This may be on by default if no $user (or other schema
preceding public in search_path) exists.
It's in BUGS.txt now.

Regards,
Andreas

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2005-01-28 13:47:39 Re: Version 1.2.0 experiences
Previous Message Vasilev Max 2005-01-28 13:44:19 Re: Trouble with pgadmin installation