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

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: more than one row returned by a subquery used as an expression
Date: 2006-11-24 09:16:25
Message-ID: ek6dab$1pn1$3@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-11-24 09:29:01 Re: IN clause
Previous Message surabhi.ahuja 2006-11-24 09:12:30 IN clause