Scott Marlowe wrote:
Charles Mortell wrote:
Using PG 8.0 on Windows, I have a table 'business_list' with a two column
primary key. It's a linking table and it's primary keys are the keys from
the two tables I am linking: item_id and business.
Should I be able to update one of those primary key fi
Beautiful, Scott. You nailed it. Thanks for the help!
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Monday, November 12, 2007 5:10 PM
To: Charles Mortell
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] update record with two-column primary key
OK, a
OK, a followup. The problem is that your where clause in your update
rule isn't selective enough, so you're actually trying to update all
the rows that match just the one column in your where clause. Here's
an example:
Note that I've disabled your pk so you can see what's happening:
drop table
Please keep replies on the list, it's more likely to find an answer
with many eyes on the problem.
On Nov 12, 2007 4:13 PM, Charles Mortell <[EMAIL PROTECTED]> wrote:
> Thanks for your response, Scott.
> The primary keys of projectdata.business_list are item_id and business. They
> are from the tw
On Nov 12, 2007 10:41 AM, Charles Mortell <[EMAIL PROTECTED]> wrote:
> Using PG 8.0 on Windows, I have a table 'business_list' with a two column
> primary key. It's a linking table and it's primary keys are the keys from
> the two tables I am linking: item_id and business.
> Should I be able to upd
Using PG 8.0 on Windows, I have a table 'business_list' with a two column
primary key. It's a linking table and it's primary keys are the keys from
the two tables I am linking: item_id and business.
Should I be able to update one of those primary key fields?
Here is the SQL:
UPDATE projectdata.bus
