Project

General

Profile

Bug #1430

postgres backend and circular relations

Added by Boris Nagaev about 8 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
09/08/2012
Due date:
% Done:

0%

Estimated time:

Description

Hello!

Session::createTables() creates constraints at the same time when table is created. Postgres prohibits referencing non-existing tables in constraints. So tables which are referencing each other can not be created.

It is likely that Wt::Dbo One-2-One relation does nt work in Postgres (I have not tried).

SQLite3 does not allow to add constraints to existing tables. So current constraints creating method (as part of the table creation statement) should be used for sqlite. For Postgres (and probably firebird and mysql) constraints should be added after creating all tables.

#1

Updated by Koen Deforche about 8 years ago

  • Status changed from New to InProgress
  • Assignee set to Koen Deforche

Hey,

I think it's true that a circular dependency will not work in the createTables() statement, however a One-to-One relation does not create a circular dependency (one of the sides is resolved using a query rather than a stored reference).

Regards,

koen

#2

Updated by Koen Deforche almost 8 years ago

  • Status changed from InProgress to Resolved
  • Assignee changed from Koen Deforche to Michael Vilsker
  • Target version set to 3.3.0
#3

Updated by Koen Deforche over 7 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF