Wouldn't that kind of defeat the point of abstracting? Shouldn't it emulate schema support somehow, such as through a table prefix, if a schemaname was specified instead of throwing an error?

-Igor

On 12/30/05, Cliff Wells <cliff@develix.com> wrote:
Igor Murashkin wrote:
>
> Something like that on top of being able to set a schemaname in
> sqlmeta would be nice (or maybe just use schemaname = __name__ to
> implement the above)? Of course, in mysql using the schema notation is
> the equivalent from using a different database, so what would be done
> about that?
>
I agree that a standard way to specify the schema/namespace would be
nice, but I think you have conflicted thinking when you mention ANSI and
MySQL  in the same argument ;-)  I'd just make a fat note saying "MySQL
doesn't support this concept" and maybe throw an exception for good measure.

Regards,
Cliff


> On 12/30/05, *Oleg Broytmann* < phd@mail2.phd.pp.ru
> <mailto:phd@mail2.phd.pp.ru>> wrote:
>
>     On Fri, Dec 30, 2005 at 12:01:12AM -0600, Igor Murashkin wrote:
>     > When using PostgreSQL, I noticed you can do
>     >
>     > class sqlmeta:
>     >    table = 'schemaname.tablename'
>     >
>     > However, this almost defeats the purpose of the tablename being
>     > automatically generated from the class name. Is there a way to
>     specify a
>     > schema name, or maybe a prefix? How about some kind of namespace
>     to use the
>     > schema?
>
>        There is no currently.
>
>     > Just seems important, it's in ANSI after all.
>
>        Patches will be gladly accepted.
>
>     Oleg.
>     --
>          Oleg
>     Broytmann            http://phd.pp.ru/            phd@phd.pp.ru
>     <mailto:phd@phd.pp.ru>
>                Programmers don't die, they just GOSUB without RETURN.
>
>
>     -------------------------------------------------------
>     This SF.net email is sponsored by: Splunk Inc. Do you grep through
>     log files
>     for problems?  Stop!  Download the new AJAX search engine that makes
>     searching your log files as easy as surfing the  web.  DOWNLOAD
>     SPLUNK!
>     http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
>     <http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click >
>     _______________________________________________
>     sqlobject-discuss mailing list
>     sqlobject-discuss@lists.sourceforge.net
>     <mailto:sqlobject-discuss@lists.sourceforge.net>
>     https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>     <https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss>
>
>



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss