From: | leddy <leddy001(at)googlemail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PostgreSQL - bindings were not allocated properly |
Date: | 2011-10-18 10:32:36 |
Message-ID: | 3456c01e-8381-4b70-9823-c98d4efd26b8@ff5g2000vbb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
Wondering if you can help. We have a PostgreSQL database that we are
using to store our data and we are using Access as the front-end. I
have linked all the tables and up to now have had no problem with
creating the forms/queries based on this data. Until now that is. One
of the tables which has around 27 million records (addresses), if I
query it using one Postcode (not unique but indexed), it works fine
and brings back the records. However if I join it to a local table
containing a list of addresses, and link it on the postcode, I get the
error "ODBC- call failed. Bindings were not allocated properly. (#15)"
Then if I try the same query that worked previously (or any other
query on any other table), I get this same error and the only way I
can get round it is by re-linking all the tables and closing and re-
opening the database.
I have no clue what this means and google is not helping much either.
Has anyone got any advice?
Many thanks in advance
leddy
From | Date | Subject | |
---|---|---|---|
Next Message | salah jubeh | 2011-10-18 12:11:22 | many sql file and one transaction |
Previous Message | Andre Lopes | 2011-10-18 09:42:00 | Re: How to correct: ERROR: permission denied: "RI_ConstraintTrigger_24966" is a system trigger |