Re: views, primary keys and guru hints - Mailing list pgadmin-support

From Miha Radej
Subject Re: views, primary keys and guru hints
Date
Msg-id 4378DE71.5050906@siix.com
Whole thread Raw
In response to Re: views, primary keys and guru hints  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: views, primary keys and guru hints  (Andreas Pflug <pgadmin@pse-consulting.de>)
List 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


pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: views, primary keys and guru hints
Next
From: "Hiroshi Saito"
Date:
Subject: pgAdmin3-1.4.0/FreeBSD package.