Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA04515; Wed, 24 Jun 92 11:16:32 -0700 Message-Id: <9206241816.AA04515@postgres.Berkeley.EDU> From: Stuart Pook Subject: "not enough memory for hashjoin" in simple request To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu Organization: Genethon, 13 Place de Rungis, 75013 Paris, France tel +33 1 45.65.13.00, fax +33 1 45.88.52.20 X-Face: "6o}6kk")qjUnYYq-`3_.vGq;@xj`3>#I/>4>E>DldCv:X#2%Rm+dr9HVN`g'#QgZFgsYsY .Q)bH:AoaW(n~=2B4aY?Q?{)1]&J+:LRX,qB>k{=6`K#2tRitzHKmi_9`}Lx0xdI*r!?MVNj7za"pZ *_QEm})y`y=vyyy~^0GY"HTvSCnv}eP*?{%zJ I am trying to do a simple join from the two system tables "pg_type" and "pg_attribute" in an empty database and I get the error message "not enough memory for hashjoin". I am using a Sun Sparc and POSTGRES v3.1. The screen dump shows you what is happening. What I am heading for is a list of each table and field in the database plus eventually its type. Is there another way to do this? $ /usr/postgres/bin/createdb stuart $ monitor stuart Welcome to the C POSTGRES terminal monitor Go * retrieve (pg_type.typname, pg_attribute.attname) where pg_type.typname !~ "pg.*" and pg_type.typrelid = pg_attribute.attrelid and pg_attribute.attnum > 0 \g Query sent to backend is "retrieve (pg_type.typname, pg_attribute.attname) where pg_type.typname !~ "pg.*" and pg_type.typrelid = pg_attribute.attrelid and pg_attribute.attnum > 0 " WARN:Jun 24 20:08:28:not enough memory for hashjoin. Go * retrieve (pg_type.typname, pg_attribute.attname) where pg_type.typname !~ "pg.*" and pg_type.typrelid = pg_attribute.attrelid \g Query sent to backend is "retrieve (pg_type.typname, pg_attribute.attname) where pg_type.typname !~ "pg.*" and pg_type.typrelid = pg_attribute.attrelid " ----------------------------- | typname | attname | ----------------------------- Go