Problems with select ... into ... - Mailing list pgsql-general

From Gabriel Fernandez
Subject Problems with select ... into ...
Date
Msg-id 388879E9.9148DA69@unica.edu
Whole thread Raw
List pgsql-general
Hi !

I've just had problems trying to use the 'select into' command.

For example (a very simple one):
-I have one small table:

CREATE TABLE idioma (
  contador int4 NOT NULL,
  nombre varchar(200),
  codigo varchar(5) DEFAULT '' NOT NULL,
  PRIMARY KEY (contador)
);

- It has 105 rows. And then I try:

select nombre into table aux from idioma \g

- and i obtain the following message:

biblio=> select nombre into table aux from idioma \g
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible.  Terminating.

- Things happen exacctly the same way if it try the select into TEMP ...

Does it run Ok in your versions ? Is there any known problem with this ?

Thanks a million.

Gabi :-)



pgsql-general by date:

Previous
From: Konrad.Pscheidl@RSD.rsd.de
Date:
Subject: pg_log
Next
From: "Culberson, Philip"
Date:
Subject: RE: [GENERAL] Too many open files...