Query string is too long - PostgreSQL Database

Dino Nardini

Hey folks,

I've been migrating a content management system from MS SQL Server 7 over
to PostgreSQL. I used the EMS DataPump utility
(http://www.ems-hitech.com/index.phtml) to migrate the database, but
noticed that in the process it truncated a few large text blocks. I then
plugged the ColdFusion web application into the PG database and ran into
problems trying to insert large text blocks into the database. Error as
follows:

"Error while executing the query; Query string is too long"

The entry fields are set to "text" datatype, so should easily handle the
web page content. I'm thinking that the problem may be related to the
driver. The content management system manages pages of text on client
websites. A query string limitation wouldn't go over well with the
clients, heh :)

I'm wondering if the problem is related to the outdated unixODBC driver
that was included with ColdFusion 5, or perhaps there is a setting that I
am overlooking in PG? The fact that the EMS DataPump truncated the large
text causes some concern.

I've also posted a similiar message in the ColdFusion Forum at the
Macromedia site.... and I'm just now compiling the latest unixODBC
driver. I have a test box that I can play around with. I'm hoping to
replace the current unixODBC driver that was included with CF 5 with the
latest driver. Hope for the best :)

For the record, I'm running ColdFusion 5 and PostgreSQL 7.4.1 on a (heavily
patched) RH 7.2 box.

Any suggestions would be greatly appreciated.

Sadly, my Friday nights have been reduced to this... ha :)

Cheers... Dino
_______________ _______________ _______
Rivendell Software - Dynamic Web Solutions
http://www.rivendellsoftware.com
Tel 902.461.1697
Fax 902.461.3765

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1

Subscribe Reply

3699

Doug McNaught

Dino Nardini <di**@rivendell software.com> writes:

"Error while executing the query; Query string is too long"

The entry fields are set to "text" datatype, so should easily handle
the web page content. I'm thinking that the problem may be related to
the driver. The content management system manages pages of text on
client websites. A query string limitation wouldn't go over well with
the clients, heh :)

I'm wondering if the problem is related to the outdated unixODBC
driver that was included with ColdFusion 5, or perhaps there is a
setting that I am overlooking in PG? The fact that the EMS DataPump
truncated the large text causes some concern.
There is (pretty much) no query size limit in modern versions of PG.
It used to be 8k or so, and some old drivers still try to enforce that
limit in order to avoid database errors.
I've also posted a similiar message in the ColdFusion Forum at the
Macromedia site.... and I'm just now compiling the latest unixODBC
driver. I have a test box that I can play around with. I'm hoping to
replace the current unixODBC driver that was included with CF 5 with
the latest driver. Hope for the best :)
Sounds like the best approach--good luck.
Sadly, my Friday nights have been reduced to this... ha :)

I feel your pain--I just got back from 12+ hours at work doing a
software upgrade...

-Doug

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #2

Similar topics

5382

asp query form

by: Harvey | last post by:

Hi, I try to write an asp query form that lets client search any text-string and display all pages in my web server that contain the text. I have IIS 6.0 on a server 2003. The MSDN site says there is a sample file called Ixtrasp.asp, but I could not find it in my system although I installed indexing service. I followed the steps in MSDN site to create a basic .asp query form (too long to post it here), but it always displays: No...

ASP / Active Server Pages

3506

same mysql query doesn't always return a result

by: Bob Bedford | last post by:

We have no access to a mysql NG on my provider's server, so we ask here: We have a long query (long in text) with a UNION between 2 select. We have been informed that some times the query doesn't return any result. We have tried on our server and we always get a result. BUT, trying on the hosting server, many times the query doesn't return any result and doesn't get any error. Any idea ? does Union have any problem ? how to check if...

PHP

2956

Executing Long Query Strings

by: Justin Koivisto | last post by:

I am attempting to execute a *long* query string via a ADODB.Recordset.Open (queryStr) call. Most of the time, the query string will be less than 100 characters, but in some cases, it may be up to 2000 chracters. Right now the code looks like this: Private Sub Command3_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim rslt As ADODB.Recordset, rslt2 As ADODB.Recordset Dim sqlstr As String, sqlstr2 As String Dim...

Microsoft Access / VBA

2430

Query results in a form

by: teddyparnell | last post by:

I have a slight problem as i am a bit weak on access skills, I am trying to run a query by selecting the criteria value from a combo box. I have got that to work and it produces results from the query. However i would like to display these results in a form so that it is more user friendly. How do i do this? Also I am using a procedure in my database that looks for the username of the current user logged on using some api thing, looks...

Microsoft Access / VBA

3038

How to use OutputTo with named query?

by: deko | last post by:

When using OutputTo with a query, the 'File name' window in the 'Output To' dialog gets populated with the name of the query by default. This makes the exported file self-describing if the query is named on the fly. The benefit is consistent file naming, and users don't have to enter a file name when exporting. The problem is the query has to be renamed every time, and I don't know how to find it in the QueryDefs collection other than...

Microsoft Access / VBA

2235

how to programmatical read the current sql statement if cuurent query ins't saved?

by: sghi | last post by:

Hi All, I'm new to this group and quite new to access/vba. So, shortly after beginning to write a simple application for my wife, I came across a blocking problem: I need to intercept the sql statement that stay behind a current, but not yet saved query. When I work on saved queries I use: strCurrentName = CurrentObjectName Dim dbsCurrent As Database Set dbsCurrent = CurrentDb

Microsoft Access / VBA

2663

How to solve Complex Query Error !

by: arun | last post by:

Query is too complex -------------------------------------------------------------------------------- Hi, I was trying to solve this problem since last two days but couldn't find any solution. I wanted to execute a query which is retrieving the records from table1 by checking the condition for a long long string . I'm using where clause and checking the condition as-

Microsoft Access / VBA

2091

Executing a query and reading the column sizes

by: Oenone | last post by:

I have a project that creates a SqlDataAdapter and uses its Fill method to fill a DataTable with data from a user-provided query. From there I can obviously access details about the rows and columns returned by the query. However, I need to be able to determine the size of the varchar fields that are returned by the query. The obvious answer appeared to be to check the DataColumn.MaxLength property. However, after using the Fill method,...

Visual Basic .NET

12713

How to query with a space ' ' in the LIKE clause

by: henryrhenryr | last post by:

Perhaps this should be in the PHP forum but I'll try here first... I'm trying to search some fields for complete words. The word can be in the middle of a string of text. My solution (perhaps there is a better one) is to use the following query: SELECT id, string FROM string_table WHERE string LIKE ('%This is my very long test string%') OR string LIKE ('% This %') OR string LIKE ('% very %') OR long LIKE ('% long %') OR test LIKE ('%...

MySQL Database

2887

Easy way* to cast an object in a LINQ query? Methinks not*

by: raylopez99 | last post by:

Inspired by Chapter 8 of Albahari's excellent C#3.0 in a Nutshell (this book is amazing, you must get it if you have to buy but one C# book) as well as Appendix A of Jon Skeet's book, I am going through some LINQ queries. But how to cast? ( See the below, modified from somebody else's code. The problem is the query 'stops' (throws a cast exception) at "3", and never gets to "violet".

C# / C Sharp

8705

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8364

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8504

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7193

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4092

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4197

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2625

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1808

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1511

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General