[Zope-DB] modifications on a query

Maciej Wisniowski maciej.wisniowski at coig.katowice.pl
Fri Jan 26 03:05:50 EST 2007


> I use zope2.9.4 with postgresql8.1, in my database i have some tables
> are the result  of a query on other tables.
> exe: table1 is the result of table2 with table3
>
> My user can connect to the database and he can modify the  table1,
> this modification should done on the orginals tables table2 and table3
>  my  problem is how  i can  specify the origin of the column in table
> for verifing that table2 and table3 may this modifications?
>
> thanks for all suggetions.
Is table1 a view?
What does 'table2 with table3' mean?
If you have SQL statement like:

select col1, col2, col3 from ....

then you know where columns come from... don't you?

-- 
Maciej Wisniowski


More information about the Zope-DB mailing list