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

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 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 broadcast)---

[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 an