Thread: Problems with select ... into ...

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 :-)