Thread: views, primary keys and guru hints

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?

thanks,
Miha

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?

Regards,
Andreas

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

Miha Radej wrote:
> 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.

Fixed in svn.

Regards,
Andreas