From: Manuel Lemos <mlemos@acm.org>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Francisco Reyes <lists@natserv.com>
Cc: PostgresSQL PHP list <pgsql-php@postgresql.org>
Subject: Re: "SQL" REPLACE SYNTAX
Date: Wed, 23 Jan 2002 03:26:14 -0200
Message-ID: <3C4E4976.E0C4EE5A@acm.org> (raw)
References: <GNELIHDDFBOCMGBFGEFOGECICBAA.chriskl@familyhealth.com.au>
Hello,
Christopher Kings-Lynne wrote:
>
> > Actually only two: a SELECT and a depending on that, a INSERT or an
> > UPDATE. You may want to try to look at Metabase implementation to see
> > how it works.
>
> Read my previous post. How does MetaBase know which fields are the primary
> key!?!?!?!?
Look at Metabase implementation. Metabase comes with a driver
conformance test that verifies if features like this work properly in
all supported databases. Don't you think that I would release a version
of Metabase that would not pass that test if all databases?
The application needs to hint it as it is something that does not change
at runtime, so there is no penalty of figuring that by querying the
database server and some database do not provide a way to tell you which
fields are the primary key.
Regards,
Manuel Lemos
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: mlemos@acm.org, chriskl@familyhealth.com.au, lists@natserv.com
Subject: Re: "SQL" REPLACE SYNTAX
In-Reply-To: <3C4E4976.E0C4EE5A@acm.org>
References: <GNELIHDDFBOCMGBFGEFOGECICBAA.chriskl@familyhealth.com.au> <3C4E4976.E0C4EE5A@acm.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox