pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Byron Nikolaidis <byronn@insightdist.com>
To: markh@clockworkweb.com
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] varchar() access
Date: Fri, 29 Jan 1999 09:58:30 -0500
Message-ID: <36B1CC96.7FF45553@insightdist.com> (raw)
References: <36b4a95d.2361109@jupiter.clockworkweb.com>
	<36B0B1B0.3C13B9D3@insightdist.com>
	<36b0fcb9.1568671@jupiter.clockworkweb.com>



Mark Himsley wrote:

> I thought Postgres had a limit of 8K? That's what it says in the docs...
>

Maybe, but the entire statement length also has a limit of 8K!   That's where I think it gets a little ridiculous to try and use in-line sql to
send/retrieve data of these sizes.

The large object interface is perfect for this.  I am going to try to add LongVarChar/Large Object support to the driver soon.  We will need two different
data types now -- one for binary (already have "lo") and one for char (maybe "lo_char").

Byron





view thread (6+ messages)  latest in thread

Message-ID: <36B1CC96.7FF45553@insightdist.com>
Permalink:  ../36B1CC96.7FF45553@insightdist.com/
Also on:    postgresql.org/message-id/36B1CC96.7FF45553@insightdist.com

 · 

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-interfaces@postgresql.org
  Cc: byronn@insightdist.com, markh@clockworkweb.com
  Subject: Re: [INTERFACES] varchar() access
  In-Reply-To: <36B1CC96.7FF45553@insightdist.com>

* 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