On Tuesday 29 June 2004 07:19 pm, Phil Endecott wrote:
> Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> > in my app i have a table where the id serves as a foreign key for
> > one or more other tables. if i want to delete a row in the table,
> > i currently search the other tables where this table
Anslag
"Stephan Szabo" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Wed, 19 May 2004, Jie Liang wrote:
>
> > According to the document of rule:
> >
> > CREATE RULE rulename AS ON delete TO mytablename DO
> > (
> > delete from aaa where id=OLD.id;
> > Delete from bbb where id=OL
Although postgres itself doesn't seem to have a thing such as Informix' "synonym"
which allows more-or-less transparent access to a table in a remote database, there is
a utility in contrib directory of the postgres source called dblink, which allows
access to different instance of postgres by o
On Wed, 2004-06-30 at 18:54, Garth Thompson wrote:
> I am in the process of migrating the databases for an application from mysql
> to postgres. The application is uses several different databases. From
> what I have read, postgres still does not support queries across multiple
> databases. If t
I am in the process of migrating the databases for an application from mysql
to postgres. The application is uses several different databases. From
what I have read, postgres still does not support queries across multiple
databases. If this is still true, does anyone have any tricks to get arou
Alvaro Sanchez-Mariscal <[EMAIL PROTECTED]> writes:
>> I suppose there's some other factor involved in the problem that
>> you didn't show us.
> But... what? :-S
If I knew, I could've reproduced the problem ...
>> As far as finding the bug, you need to provide a complete,
>> self-contained test
