From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | sferac(at)bo(dot)nettuno(dot)it |
Cc: | Postgres Hackers List <hackers(at)postgresql(dot)org> |
Subject: | Re: [QUESTIONS] impossible insert data into VARCHAR |
Date: | 1998-02-05 15:18:27 |
Message-ID: | 34D9D842.98A82F17@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> There's an error while inserting data into a column defined as VARCHAR without
> length in PostgreSQL 6.3.
> Take a look:
>
> postgres=> CREATE TABLE prova ( uno VARCHAR(10) );
> CREATE
> postgres=> INSERT INTO prova VALUES ( 'OK' );
> INSERT 153042 1
>
> postgres=> CREATE TABLE prova2 ( uno VARCHAR );
> CREATE
> postgres=> INSERT INTO prova2 VALUES ( 'NOT OK' );
> PQexec() -- Request was sent to backend, but backend closed the channel before responding.
> This probably means the backend terminated abnormally before or while processing the request.
Jose, please post problem reports to hackers, not to questions, on not-yet-released versions. I've moved
this to hackers.
btw, I saw this too but in a different context and wasn't certain if it was a new problem:
postgres=> select char_length('hi'::text);
length
------
2
(1 row)
postgres=> select character_length('hi'::varchar);
PQexec() -- Request was sent to backend, but backend closed the channel before responding.
This probably means the backend terminated abnormally before or while processing the request.
- Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-02-05 15:22:46 | Re: [HACKERS] Linux: linux.s / tas.s not found... |
Previous Message | Peter T Mount | 1998-02-05 15:15:38 | Re: [HACKERS] connection troubles |