BUG #8483: Text lengths issue - Mailing list pgsql-bugs

From crush6655@gmail.com
Subject BUG #8483: Text lengths issue
Date
Msg-id E1VPatG-0008Pm-Q3@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8483
Logged by:          Miko
Email address:      crush6655@gmail.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();


)

pgsql-bugs by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: BUG #8455: spanish pgadmin3.mo
Next
From: Tomonari Katsumata
Date:
Subject: Re: BUG #8434: Why does dead lock occur many times ?