On Tuesday 27 October 2009 01:19:56 pm Christoph Zwerschke wrote: > John schrieb: > > Larry has started a discussion regarding the removal of > > the "pg_table_is_visible" function from the SQL statement. By removing > > it all users are able to see the tables and retrieve field names. Even > > if the users search path does not include the schema. By including the > > statement the getFields method will return nothing if the search path > > does not include the schema. > > > > Note change the search path as follows: > > ALTER USER test SET search_path TO schema1,schema2 > > > > I always want the field names to be available because it has nothing to > > permissions to write or read. The getTables method handles the issue > > regarding access - so I see no reason to prevent reading the column > > properties. > > > > On the other hand I'm open to discussion on the matter. For now I'm > > leaving the statement out of the SQL string. > > The pg_table_is_visible call is not there primarily to control access, > but to make sure that only *one* table is selected (and the right one) > if there are tables with the same name in different schemas. > > However, John is right that the check should be removed in the case when > the schema is explicitly specified. > > It should be fixed now in r5502. > > -- Christoph
It appears to work for me. However, in earlier testing I added dup table names in different schemas without issue. I had not considered that a bizobj contained datasources without schemas Therefore do you think it's better to force 'public' if no schema is provided? I'm thinking that it's either public or you need to pass the schema. To my knowledge it's not possible to create a table without a schema. So defaulting the schema to public allows the developers to just use table names when creating bizobjs. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
