Postgres Pro
Downloads
Home   >   mailing lists

more than one row returned by a subquery used as an expression - Mailing list pgsql-general

From Andrus
Subject more than one row returned by a subquery used as an expression
Date
Msg-id ek6dab$1pn1$3@news.hub.org
Whole thread Raw
Responses Re: more than one row returned by a subquery used as an expression  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: IN clause
Next
From: "Andrus"
Date:
Subject: How to clone a table so that primay and foreign keys remain