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

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

From: "Willy-Bas Loos" <willybas(at)gmail(dot)com>
To: Csaba Együd <csegyud(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Date: 2008-11-28 11:04:37
Message-ID: 1dd6057e0811280304m2c8b6d24tc1fd283bf2a9de2d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-general
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

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2008-11-28 11:11:23
Subject: Re: Separate Sessions?? (View data <-> Query tool)
Previous:From: Csaba EgyüdDate: 2008-11-28 09:14:58
Subject: Re: Separate Sessions?? (View data <-> Query tool)

pgsql-general by date

Next:From: Serge FonvilleDate: 2008-11-28 11:08:04
Subject: Re: [NOOB] try tu put a number with pqexecprepare
Previous:From: Michael MeierDate: 2008-11-28 11:03:08
Subject: How to design for cheap reliability with PostgreSQL?

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