select * from information_schema.key_column_usage
returns
ERROR: more than one row returned by a subquery used as an expression
SQL state: 21000
How to reconstruct primay and foreign key statements ?
Andrus.
PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
Andrus [EMAIL PROTECTED] writes:
select * from information_schema.key_column_usage
returns
ERROR: more than one row returned by a subquery used as an expression
There's a known bug of that ilk in 8.2beta, but I don't see how it could
happen in 8.1 ... you sure you're seeing this on 8.1.1?
I'm trying to get this query to work:
update sectors set companies =(select companies from
industries where sector_id =sectors.id);
PG returns:
ERROR: more than one row returned by a subquery used
as an expression
Column companies is just a count of rows in the
related companies table.
On Thu, Oct 13, 2005 at 05:05:56PM -0700, CSN wrote:
I'm trying to get this query to work:
update sectors set companies =(select companies from industries
where sector_id =sectors.id);
PG returns:
ERROR: more than one row returned by a subquery used as an
expression
It's doing what