pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAccess & Postgres
8+ messages / 4 participants
[nested] [flat]
* Access & Postgres
@ 1998-07-03 10:02 Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
0 siblings, 1 reply; 8+ messages in thread
From: Sferacarta Software @ 1998-07-03 10:02 UTC (permalink / raw)
To: pgsql-hackers@PostgreSQL.org
Hi all,
I have this problem:
This sample query create with Access
SELECT figure.*, utenti.ragione_sociale
FROM figure INNER JOIN utenti ON figure.codice_figura = utenti.azienda;
via-psqlODBC reports this
ERROR: The field being ordered by must appear in the target list'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
Postgres executes this sql query (I find this in Psqlodbc.log file) :
SELECT figure.oid,utenti.azienda
FROM utenti,figure WHERE (figure.codice_figura = utenti.azienda ) ORDER BY figure.codice_figura
Why is there ORDER BY CLAUSE ?
Why is there only "figure.oid" instead of "figure.*" in SELECT
arguments ??????
Best regards,
Marco Pollachini
Sferacarta mailto:sferac@bo.nettuno.it
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [HACKERS] Access & Postgres
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
@ 1998-07-06 20:30 ` David Hartwig <daveh@insightdist.com>
1998-07-08 16:01 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
0 siblings, 1 reply; 8+ messages in thread
From: David Hartwig @ 1998-07-06 20:30 UTC (permalink / raw)
To: Sferacarta Software <sferac@bo.nettuno.it>; pgsql-interfaces
This question may be better posted on the interfaces list.
See: http://www.insightdist.com/psqlodbc
Visit the FAQ. It is one of the last items listed.
Sferacarta Software wrote:
> Hi all,
> I have this problem:
>
> This sample query create with Access
>
> SELECT figure.*, utenti.ragione_sociale
> FROM figure INNER JOIN utenti ON figure.codice_figura = utenti.azienda;
>
> via-psqlODBC reports this
>
> ERROR: The field being ordered by must appear in the target list'
> STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
>
> Postgres executes this sql query (I find this in Psqlodbc.log file) :
>
> SELECT figure.oid,utenti.azienda
> FROM utenti,figure WHERE (figure.codice_figura = utenti.azienda ) ORDER BY figure.codice_figura
>
> Why is there ORDER BY CLAUSE ?
> Why is there only "figure.oid" instead of "figure.*" in SELECT
> arguments ??????
>
> Best regards,
> Marco Pollachini
> Sferacarta mailto:sferac@bo.nettuno.it
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [HACKERS] Access & Postgres
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
@ 1998-07-08 16:01 ` David Hartwig <daveh@insightdist.com>
1998-07-09 04:49 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 8+ messages in thread
From: David Hartwig @ 1998-07-08 16:01 UTC (permalink / raw)
To: Sferacarta Software <sferac@bo.nettuno.it>; pgsql-interfaces
The backend patch is downloadable text file, linked to our FAQ. I think the direct URL is
http://www.insightdist.com/psqlodbc/junkfilter_patch.txt
I know the code works. Let me know, though, if you have trouble retrieving or applying it. The
patch was originally 2 patches. I just cat'ed them together. It should apply properly.
PS: This is the first time I have distributed the patch this way. So could I get an affirmation from
you even if it goes smoothy.
Sferacarta Software wrote:
> Hello David,
>
> Do you remember our problem with ORDER BY not in target list ?
> Well, seems that now we can't go on without your fix.
> Please may you send me it ? Thanks
>
> lunedì, 6 luglio 98, you wrote:
>
> DH> This question may be better posted on the interfaces list.
> DH> See: http://www.insightdist.com/psqlodbc
> DH> Visit the FAQ. It is one of the last items listed.
> H> Sferacarta Software wrote:
>
> >> Hi all,
> >> I have this problem:
> >>
> >> This sample query create with Access
> >>
> >> SELECT figure.*, utenti.ragione_sociale
> >> FROM figure INNER JOIN utenti ON figure.codice_figura = utenti.azienda;
> >>
> >> via-psqlODBC reports this
> >>
> >> ERROR: The field being ordered by must appear in the target list'
> >> STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
> >>
> >> Postgres executes this sql query (I find this in Psqlodbc.log file) :
> >>
> >> SELECT figure.oid,utenti.azienda
> >> FROM utenti,figure WHERE (figure.codice_figura = utenti.azienda ) ORDER BY figure.codice_figura
> >>
> >> Why is there ORDER BY CLAUSE ?
> >> Why is there only "figure.oid" instead of "figure.*" in SELECT
> >> arguments ??????
> >>
> >> Best regards,
> >> Marco Pollachini
> >> Sferacarta mailto:sferac@bo.nettuno.it
>
> Best regards,
> Jose' mailto:sferac@bo.nettuno.it
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] Access & Postgres
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-08 16:01 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
@ 1998-07-09 04:49 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-07-09 13:30 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-07-09 13:42 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-19 04:23 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Bruce Momjian <maillist@candle.pha.pa.us>
0 siblings, 3 replies; 8+ messages in thread
From: Thomas G. Lockhart @ 1998-07-09 04:49 UTC (permalink / raw)
To: David Hartwig <daveh@insightdist.com>; +Cc: Postgres Hackers List <hackers@postgresql.org>
> http://www.insightdist.com/psqlodbc/junkfilter_patch.txt
> I know the code works.
Hi David. Do you have access to the latest cvs development tree for
Postgres? I'm seeing backend crashes from the "junkfilter" regression
test, and have been for some time. I (just this morning) applied some
patches to the tree to fix up type coersion for inserts from other
tables or columns, and this changed code in the "junkfilter" area.
However, the regression test behavior is still bad.
If you have access to the latest tree, and had time to look at this it
would be great. Otherwise, I'll start poking at it. Talk to you soon...
- Tom
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] Access & Postgres
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-08 16:01 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-09 04:49 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Thomas G. Lockhart <lockhart@alumni.caltech.edu>
@ 1998-07-09 13:30 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
2 siblings, 0 replies; 8+ messages in thread
From: Thomas G. Lockhart @ 1998-07-09 13:30 UTC (permalink / raw)
To: David Hartwig <daveh@insightdist.com>; Postgres Hackers List <hackers@postgreSQL.org>
> I'm seeing backend crashes from the "junkfilter" regression test
I think I have a patch for the problem:
postgres=> select c, count(*) from test_missing_target group by 3;
ERROR: ORDER/GROUP BY position 3 is not in target list
Previously this query provoked a core dump. Will do some regression
testing and then commit to the source tree...
- Tom
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] Access & Postgres
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-08 16:01 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-09 04:49 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Thomas G. Lockhart <lockhart@alumni.caltech.edu>
@ 1998-07-09 13:42 ` David Hartwig <daveh@insightdist.com>
1998-07-09 14:25 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Thomas G. Lockhart <lockhart@alumni.caltech.edu>
2 siblings, 1 reply; 8+ messages in thread
From: David Hartwig @ 1998-07-09 13:42 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; +Cc: Postgres Hackers List <hackers@postgresql.org>
Tom,
Yes, I do have access to the cvs tree from home. And, I will check it out
when I get home.
I am curious though. Did you apply the patch, mentioned below, to your
latest 6.4 tree? This patch should have been already part of the latest
6.4. And, to my knowledge, it was already applied completely and
successfully.
Anyway, the intent of the patch on our web site was to allow 6.3 users to
be able to use MS Access cleanly. Now that I think of it, though, this
version of the patch does not include the new "output" and "sql" files
necessary for the regression test. In any case, I should clean that up.
Thomas G. Lockhart wrote:
> > http://www.insightdist.com/psqlodbc/junkfilter_patch.txt
> > I know the code works.
>
> Hi David. Do you have access to the latest cvs development tree for
> Postgres? I'm seeing backend crashes from the "junkfilter" regression
> test, and have been for some time. I (just this morning) applied some
> patches to the tree to fix up type coersion for inserts from other
> tables or columns, and this changed code in the "junkfilter" area.
> However, the regression test behavior is still bad.
>
> If you have access to the latest tree, and had time to look at this it
> would be great. Otherwise, I'll start poking at it. Talk to you soon...
>
> - Tom
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] Access & Postgres
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-08 16:01 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-09 04:49 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-07-09 13:42 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
@ 1998-07-09 14:25 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Thomas G. Lockhart @ 1998-07-09 14:25 UTC (permalink / raw)
To: David Hartwig <daveh@insightdist.com>; +Cc: Postgres Hackers List <hackers@postgresql.org>
> I am curious though. Did you apply the patch, mentioned below, to
> your latest 6.4 tree? This patch should have been already part of
> the latest 6.4. And, to my knowledge, it was already applied
> completely and successfully.
I did my final tests using a fresh cvs tree two days ago just before
committing my big "patch wad". In the last two or three weeks I did have
a "merge problem" with my patches in the resjunk area, which might have
been the patches you are talking about.
> Now that I think of it, though, this version of the patch does not
> include the new "output" and "sql" files necessary for the regression
> test. In any case, I should clean that up.
I am in the process of renaming and moving the "resjunk" test to
"select_implicit". Will try to commit the changes this morning so it is
available to you.
At the moment, all regression tests (except "random") pass on my Linux
box :)
- Tom
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] Re: [HACKERS] Access & Postgres
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-08 16:01 ` Re: [HACKERS] Access & Postgres David Hartwig <daveh@insightdist.com>
1998-07-09 04:49 ` Re: [INTERFACES] Re: [HACKERS] Access & Postgres Thomas G. Lockhart <lockhart@alumni.caltech.edu>
@ 1998-07-19 04:23 ` Bruce Momjian <maillist@candle.pha.pa.us>
2 siblings, 0 replies; 8+ messages in thread
From: Bruce Momjian @ 1998-07-19 04:23 UTC (permalink / raw)
To: lockhart@alumni.caltech.edu; +Cc: daveh@insightdist.com; hackers@postgreSQL.org
> > http://www.insightdist.com/psqlodbc/junkfilter_patch.txt
> > I know the code works.
>
> Hi David. Do you have access to the latest cvs development tree for
> Postgres? I'm seeing backend crashes from the "junkfilter" regression
> test, and have been for some time. I (just this morning) applied some
> patches to the tree to fix up type coersion for inserts from other
> tables or columns, and this changed code in the "junkfilter" area.
> However, the regression test behavior is still bad.
>
> If you have access to the latest tree, and had time to look at this it
> would be great. Otherwise, I'll start poking at it. Talk to you soon...
I have now made the junk filter only run when needed. Perhaps this will
fix the problem.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~1998-07-19 04:23 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-03 10:02 Access & Postgres Sferacarta Software <sferac@bo.nettuno.it>
1998-07-06 20:30 ` David Hartwig <daveh@insightdist.com>
1998-07-08 16:01 ` David Hartwig <daveh@insightdist.com>
1998-07-09 04:49 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-07-09 13:30 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-07-09 13:42 ` David Hartwig <daveh@insightdist.com>
1998-07-09 14:25 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-07-19 04:23 ` Bruce Momjian <maillist@candle.pha.pa.us>
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