Re: views, primary keys and guru hints

Поиск
Список
Период
Сортировка
От Miha Radej
Тема Re: views, primary keys and guru hints
Дата
Msg-id 4378DE71.5050906@siix.com
обсуждение исходный текст
Ответ на Re: views, primary keys and guru hints  (Andreas Pflug <pgadmin@pse-consulting.de>)
Ответы Re: views, primary keys and guru hints  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: views, primary keys and guru hints
Следующее
От: "Hiroshi Saito"
Дата:
Сообщение: pgAdmin3-1.4.0/FreeBSD package.