BUG #8483: Text lengths issue

From: crush6655(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8483: Text lengths issue
Date: 2013-09-27 16:27:38
Message-ID: E1VPatG-0008Pm-Q3@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8483
Logged by: Miko
Email address: crush6655(at)gmail(dot)com
PostgreSQL version: 9.3.0
Operating system: windows 8
Description:

Hello,

I have a table with a 'text' column.

When I insert a 'short' (length: 1400) string, it works well.
When I try to insert a loner (length: 16500) string, it doesn't work (not
visible in the 'View Data' of the table).

Notice, in the query, I place more variables after this string, and they get
inserted well, but the text column remains empty.

I've searched and notices the size limit of 'text' is 1GB, but I'm not even
close to that.

I'll be glad if you can reply an e-mail to me and tell me if it's a bug or
if I'm doing something wrong.

Thanks.

(I'm using ASP.NET MVC 4, using the code below to insert:

NpgsqlConnection connection = new NpgsqlConnection(connectionString);

connection.Open();

(new NpgsqlCommand("The query", connection)).ExecuteNonQuery();

connection.Close();

)

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomonari Katsumata 2013-09-28 01:39:11 Re: BUG #8434: Why does dead lock occur many times ?
Previous Message Guillaume Lelarge 2013-09-27 07:05:23 Re: BUG #8455: spanish pgadmin3.mo