Thread: more than one row returned by a subquery used as an expression

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.

"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