Skip site navigation (1) Skip section navigation (2)

Re: Separate Sessions?? (View data <-> Query tool)

From: Csaba Együd <csegyud(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Date: 2008-11-28 13:54:49
Message-ID: ggot77$2fn6$1@news.hub.org (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-general
""Willy-Bas Loos"" <willybas(at)gmail(dot)com> a következoket írta üzenetében 
news:1dd6057e0811280304m2c8b6d24tc1fd283bf2a9de2d(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
Only, it's too bad that you can't update the records from the "view data" 
dialog.
It works in access2000, it doesn't know the difference between views and 
tables (the difference is actually very small).
You probably get some annoying error when you try to edit a normal select 
view from access, though.

I guess pg_admin assumes that views cannot be edited, which is incorrect in 
this case.
Maybe this is something that could be enhanced in a future release?


oh, i see i forgot:
revoke all on view_firm1 from amy;
revoke all on view_firm1 from firm2;
revoke all on view_firm2 from john;
revoke all on view_firm2 from firm1;

Cheers,
WBL

-- 
"Patriotism is the conviction that your country is superior to all others 
because you were born in it." -- George Bernard Shaw

--------------------------------------------

Guys, you are great! Thank you!

View data: Yes I thought the same - maybe pgAdmin treats views as read only 
by default.
BTW, I use Access only to visualize database structure (manually). If I knew 
a product which can reverse engineering postgres database along with 
constraints and other object and can visualize them I would use that instead 
and would forget Access...

Many thanks!

-- Csaba 


In response to

pgadmin-support by date

Next:From: Willy-Bas LoosDate: 2008-11-28 14:25:53
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Previous:From: Willy-Bas LoosDate: 2008-11-28 11:20:28
Subject: Re: Separate Sessions?? (View data <-> Query tool)

pgsql-general by date

Next:From: Hiroshi SaitoDate: 2008-11-28 14:12:03
Subject: Re: pglib.dll for windows ce
Previous:From: Julius TuskenisDate: 2008-11-28 13:07:11
Subject: Re: pglib.dll for windows ce

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group