[ADMIN] Circular Dependency in Tables and Deletion of Data

2006-07-24 Thread Mans
Hello, Note: I know that its not a very good db design. But what if a senario comes in front of you? I have created an uncommon database design. Which is as follows: Created 2 Tables :- Emp1 and Emp2 TableA with 2 Attributes A1 and A2. A1 is the primary key. TableB with 2 Attributes B1

Re: [ADMIN] Circular Dependency in Tables and Deletion of Data

2006-07-24 Thread Peter Eisentraut
Am Montag, 24. Juli 2006 14:53 schrieb Mans: Isnt it a crazy thing?? Yes, but with deferrable constraints and transactions blocks, it should be no problem to manage the data. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of

Re: [ADMIN] Circular Dependency in Tables and Deletion of Data

2006-07-24 Thread Mans
Hi Peter, Can you please give some detailed information about it? Regards, Mans Peter Eisentraut wrote: Am Montag, 24. Juli 2006 14:53 schrieb Mans: Isnt it a crazy thing?? Yes, but with deferrable constraints and transactions blocks, it should be no problem to manage the data. --

Re: [ADMIN] Circular Dependency in Tables and Deletion of Data

2006-07-24 Thread Stephan Szabo
On Mon, 24 Jul 2006, Mans wrote: Hello, Note: I know that its not a very good db design. But what if a senario comes in front of you? I have created an uncommon database design. Which is as follows: Created 2 Tables :- Emp1 and Emp2 TableA with 2 Attributes A1 and A2. A1 is the