[SQL] Foresee any problems with this? postgres-failover (long)

2000-09-07 Thread Ingram, Bryan
A couple weeks back I wrote in with a few questions and comments asking about the possibilities of creating a re-do log in Postgres for the purpose of creating a Standby database. That is, a database that would be reasonably current (within 5 minutes) and available to take over within one minute

Antw: [SQL] Join

2000-09-07 Thread Gerhard Dieringer
>>> Craig May <[EMAIL PROTECTED]> 08.09.2000 02.59 Uhr >>> > Hi, > I'm having trouble with this statement, could someone help out please. > Select g.ID From Grouping g join Entity_Grouping eg on g.ID=eg.Group_ID where > eg.Entity_ID=1 > The error message is: > ERROR: transfromExpr: does not k

Re: [SQL] Join

2000-09-07 Thread Kristofer Munn
> I'm having trouble with this statement, could someone help out please. > > Select g.ID From Grouping g join Entity_Grouping eg on > g.ID=eg.Group_ID where eg.Entity_ID=1 Try select g.ID from Grouping g, Entity_Grouping eg where g.ID = eg.Group_ID and eg.Entity_ID = 1; That's not the join sy

[SQL] Join

2000-09-07 Thread Craig May
Hi, I'm having trouble with this statement, could someone help out please. Select g.ID From Grouping g join Entity_Grouping eg on g.ID=eg.Group_ID where eg.Entity_ID=1 The error message is: ERROR: transfromExpr: does not know hot to transfrom node 501 (internal error) Craig May Enth Dimensi

[SQL] Database Link

2000-09-07 Thread Gerhard Dieringer
A question for the postgreSQL gurus: Some RDBMSs, for example Oracle, have a feature named 'Database Link' - at least in Oracle - It's something like a view, thats lets you access a table, that is located within another DB. AFAIK, postgreSQL doesn't have this feature. Are there any plans to imp