Re: default schema

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jan 07 2004 - 10:21:29 EST

Next message: Leonardo Queiroz Antunes: "Global Exception"

Previous message: Andrus Adamchik: "Re: set DB Adapter from jdbc-Driver?"
In reply to: Tore Halset: "default schema"
Next in thread: Tore Halset: "Re: default schema"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Jan 5, 2004, at 6:25 AM, Tore Halset wrote:

> Hello.
>
> I have one application that currently uses MS SQL Server. All tables
> are in the default schema called "dbo". I want to use the same
> application with PostgreSQL as well.
>
> I have to create the schema "dbo" in PostgreSQL before creating all
> the tables from CayenneModeler. It would be very nice if it was
> possible to have all tables in the default schema.
>
> The auto_pk_support-table works ok in my application, but it is
> created in the default schema. If cayenne are so strict about schemas,
> perhaps the table-names in auto_pk_support should be prefixed with
> schema as well?
>
> - Tore.

I agree. For this to work Cayenne will need to support schemas per
DataMap (instead of per table), overriding them per table if needed.
Feel free to create a feature request in JIRA:

http://objectstyle.org/cayenne/bugs-features.html

Andrus

Next message: Leonardo Queiroz Antunes: "Global Exception"
Previous message: Andrus Adamchik: "Re: set DB Adapter from jdbc-Driver?"
In reply to: Tore Halset: "default schema"
Next in thread: Tore Halset: "Re: default schema"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Wed Jan 07 2004 - 10:21:33 EST