Re: views, primary keys and guru hints

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: views, primary keys and guru hints
Date: 2005-11-14 18:58:57
Message-ID: 4378DE71.5050906@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

hi!

Andreas Pflug wrote:
> Miha Radej wrote:
>> hi!
>>
>> is it normal for pgadmin3 to display a "you don't have a primary key
>> so i can't edit this table" guru hint when i view data in a view?
>
> Yes. Do we need to suppress this for views?

yes, please. afaik and as far as i've checked the documentation, you
can't place a primary key on a view. and even if a column with a pk is
included in a view, pgadmin cannot know if the column it sees has a
primary key or not. any thoughts on this?

regards,
Miha

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Hiroshi Saito 2005-11-15 04:19:30 pgAdmin3-1.4.0/FreeBSD package.
Previous Message Andreas Pflug 2005-11-14 17:26:20 Re: views, primary keys and guru hints