Re: views, primary keys and guru hints

[Miha Radej <miha(dot)radej(at)siix(dot)com>]

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