Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Forums @ Existanze
Hello again, I looked into slony, I have a question though, how would I go about controlling slony via a jdbc driver? See this whole problem has arisen because for some reason my client wants to keep to separate databases in two separate locations with the same data. So he would call this parti

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Andrew Sullivan
On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote: > > I looked into slony, I have a question though, how would I go about > controlling slony via a jdbc driver? See this whole problem has arisen > because for some reason my client wants to keep to separate databases in two > sepa

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Forums @ Existanze
Hello again andrew, Actually man I do need to be able to write to both databases, and keep them synchronized, and all this because of the recurring xenofobia for technology and the fear of "hackers" (I know the difference between hackers and crackers) on the internet, I actually said, it will cost

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Joe
Andrew Sullivan wrote: On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote: I looked into slony, I have a question though, how would I go about controlling slony via a jdbc driver? See this whole problem has arisen because for some reason my client wants to keep to separate databa

[SQL] Joins between int and int[]

2006-06-27 Thread Rodrigo Sakai
  Hi,     I want to use the system catalog tables/views to query some things, and one of the queries I have to do is joining pg_attribute and pg_constraint to know what constraint belongs to which table.attribute. My question is how can I write the join clause between a int (pg_attribute.

[SQL] Schema management tool

2006-06-27 Thread Kyle Bateman
I just saw this very old post and thought I'd respond for the benefit of the list: Patrick, > Could someone give me some advice or point me to an article that would help > manage views? I have a view that I use in conjunction with other views, > and since I have to drop the view and then rec

Re: [SQL] Schema management tool

2006-06-27 Thread Josh Berkus
Kyle, Nice to hear from you guys again! Action Target was one of the pioneers of production open source in manufacturing; nice to know that you're still doing well with it. --Josh ---(end of broadcast)--- TIP 9: In versions below 8.0, the plan

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Andrew Sullivan
On Tue, Jun 27, 2006 at 02:48:38PM +0300, Forums @ Existanze wrote: > Hello again andrew, > > Actually man I do need to be able to write to both databases, and keep them > synchronized, and all this because of the recurring xenofobia for technology Then sorry, but this can't be done out of the bo

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Andrew Sullivan
On Tue, Jun 27, 2006 at 08:14:34AM -0400, Joe wrote: > > But with file-based log shipping (see > http://linuxfinances.info/info/logshipping.html) one could write a Java > app to control when the updates are applied. Well, sure. I mean, if you decide first, "I'll use Java," and then start askin

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Richard Broersma Jr
> > Actually man I do need to be able to write to both databases, and keep them > > synchronized, and all this because of the recurring xenofobia for technology > > Then sorry, but this can't be done out of the box by anything. You > have all manner of race conditions here. Doesn't PGcluster al

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Alvaro Herrera
Richard Broersma Jr wrote: > I thought that Mammoth replicator might support synchronous masters > but it appears to be an Asynchronous system like Slony. > http://www.commandprompt.com/products/mammothreplicator You are right, Mammoth Replicator is asynchronous single master, just like Slony. -

[SQL] i need solution to this problem

2006-06-27 Thread Penchalaiah P.
Hi good morning to all……..   I have tables like 1) emp_table (personal_no integer (foreign key), cdacno varchar (primary key),name varchar);     2) Rank_table (rank_id varchar (primary key), rank_name varchar);   3) Rank_date_table (rank_id (foreign key), rank_dat