pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frankie Lam <frankie@ucr.com.hk>
To: pgsql-sql@postgresql.org
Subject: PSQL segmentation fault?
Date: Fri, 28 Feb 2003 12:43:58 +0800
Message-ID: <b3mpcr$269h$1@news.hub.org> (raw)

Hi all,

I've tried to insert a record into a table, which contains only one
column(text),
through ODBC, the record contains a 99,999,999 spaces. I can put it into
table
without problem, but when I executed "select * from tablename" at the PSQL
prompt, miserably PSQL went segmentation fault. :-(

My question is, isn't the length of `text' type theoretically unlimited? How
come
PSQL crashes?
(Is this a PSQL problem? If so, what's its limitation then?)

Thanks a lot,

Frankie

System Env:
Red Hat 7.2
PostgreSQL 7.3
128 MB ram






Message-ID: <b3mpcr$269h$1@news.hub.org>
Permalink:  ../b3mpcr$269h$1@news.hub.org/
Also on:    postgresql.org/message-id/b3mpcr$269h$1@news.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: frankie@ucr.com.hk
  Subject: Re: PSQL segmentation fault?
  In-Reply-To: <b3mpcr$269h$1@news.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox