memory error

From: "Oeschey, Lars (I/EK-142, extern)" <extern(dot)Lars(dot)Oeschey(at)AUDI(dot)DE>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: memory error
Date: 2007-10-17 14:45:59
Message-ID: 17A09E9509BB354E95C2FEE5102B0F5F0131569F@audiinsx0036.audi.vwg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have a table with 46 million rows, when I execute the following statement on it, I get an error:

ALTER TABLE ONLY etefas.tbl_ecu ADD CONSTRAINT pk_tbl_ecu PRIMARY KEY (pk_ecu);
HINWEIS: ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index »pk_tbl_ecu« für Tabelle »tbl_ecu«
FEHLER: Speicher aufgebraucht
DETAIL: Fehler bei Anfrage mit GröÃe 268435456.

The statement came not from my head, but from a dump of the database (hence, the restore fails there, too). Am I doing something wrong?

Postgresql is 8.1.9

Lars

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-10-17 16:13:39 Re: memory error
Previous Message Rodrigo De León 2007-10-17 14:13:04 Re: Implementation of a updateable, "temporal" view on data