Ok, finally got a minute to actually try it out instead of guessing.
See http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-109 for
details. In short - this is a bug, and it is fixed and will be released
soon.
Workaround: until this is fixed, do not create an empty DataMap before
reengineering. Instead select a postgres DataNode and do reengineer.
Newly created DataMap will contain correct subset of tables.
Andrus
On Mar 23, 2004, at 11:58 AM, Andrus Adamchik wrote:
> Even though I haven't been able to reproduce it on my Postgres
> version, I think I might know what it is. Table info is read via JDBC
> API:
>
> DatabaseMetaData md;
> ResultSet rs = md.getTables(catalog, schemaPattern, tableNamePattern,
> types);
>
> "types" argument seems to always be null, thus pulling all possible
> tables and views. Since this hasn't caused any problems so far (or no
> one bothered to report them), it has been overlooked (looks like my
> test version of Postgres only contains real tables). I will open a bug
> report and investigate further.
>
> Todd, till the fix is implemented, you'll have to manually delete
> those extra tables. And also let me know what version of PostgreSQL
> and JDBC driver you are using.
>
> Thanks
> Andrus
>
>
> On Mar 23, 2004, at 11:41 AM, Mike Kienenberger wrote:
>
>>> On Mar 23, 2004, at 9:26 AM, Todd Blanchard wrote:
>>>> reverse engineer the db.
>>>>
>>>> I was very surprised to find it model each sequence as a table and
>>>> just as surprised to find it had created what looks like a primary
>>>> key
>>>> table for each table. Is this expected?
>>
>> Andrus Adamchik <andru..bjectstyle.org> wrote:
>>> No. Postgres reverse engineering always worked fine producing
>>> entities
>>> for tables and views. What you describe sounds very weird... Do you
>>> have any details?
>>
>> I thought only the Oracle Adaptor supported sequences.
>> Could this be the problem?
>>
>> That would explain the primary key tables.
>> It may also explain the sequence "Entities" created if the modeler
>> didn't
>> realize that they were not standard tables.
>>
>> Obviously, I'm speaking from complete ignorance here, not having used
>> Postgres with Cayenne.
>>
>> -Mike
>
>
This archive was generated by hypermail 2.0.0 : Tue Mar 23 2004 - 14:15:54 EST