more than one row returned by a subquery used as an expression
Started by Andrusover 19 years ago2 messagesgeneral
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
(mingw-special)"
PgAdmin 1.6 beta 3
Windows XP
Andrus.
Re: more than one row returned by a subquery used as an expression
"Andrus" <eetasoft@online.ee> 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?
regards, tom lane