Re: default schema

From: Tore Halset (halse..vv.ntnu.no)
Date: Mon Jan 12 2004 - 03:14:20 EST

  • Next message: Jim Menard: "rollbackChanges in a unit test"

    On Jan 5, 2004, at 12:25, Tore Halset wrote:

    > 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.

    It is possible, and very easy. Only setting the Schema of every
    db-entity in the modeler to "". It couldnt be easier.

    > 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?

    This is still valid, but not important for me.

    I have updated the feature-request.
    http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-72

    Regards,
      - Tore.



    This archive was generated by hypermail 2.0.0 : Mon Jan 12 2004 - 03:14:37 EST