PostgeSQL ODBC - What happend to odbc.sql & odbc-drop.sql

Author

What happend to odbc.sql & odbc-drop.sql

Todd Denniston

2006-02-13, 11:23 am

I am attempting to use the directions at
http://kandalaya.org//download/oo-pgsql.html
to configure odbc with pgsql and OpenOffice.org on a Fedora Core 4 system.

I found a message at:
http://archives.postgresql.org/pgsq...09/msg00087.php
which points to the psqlodbc cvs, but that appears empty.

And when I got psqlodbc-08.01.0100.tar.gz (that is the correct one to use with
postgresql-8.0.6 right?) and looked in it, there was no mention of the
odbc.sql & odbc-drop.sql scripts, or even what should replace them.

So is there a reason why these went away?
What should they be replaced with?
Or should I just dig out an old copy of postgresql-7.X and grab them from
there for posterity?

--
Todd Denniston
Crane Division, Naval Surface Warfare Center (NSWC Crane)
Harnessing the Power of Technology for the Warfighter

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Dave Page

2006-02-13, 11:23 am

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston
> Sent: 13 February 2006 15:58
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] What happend to odbc.sql & odbc-drop.sql
>
> I am attempting to use the directions at
> http://kandalaya.org//download/oo-pgsql.html
> to configure odbc with pgsql and OpenOffice.org on a Fedora
> Core 4 system.
>
> I found a message at:
> http://archives.postgresql.org/pgsq...09/msg00087.php
> which points to the psqlodbc cvs, but that appears empty.
>
> And when I got psqlodbc-08.01.0100.tar.gz (that is the
> correct one to use with
> postgresql-8.0.6 right?) and looked in it, there was no
> mention of the
> odbc.sql & odbc-drop.sql scripts, or even what should replace them.
>
> So is there a reason why these went away?
> What should they be replaced with?
> Or should I just dig out an old copy of postgresql-7.X and
> grab them from
> there for posterity?

It was removed because it is no longer required:

http://cvs.pgfoundry.org/cgi-bin/cv...odbc/convert.c?
rev=1.117&content-type=text/x-cvsweb-markup

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Ludek Finstrle

2006-02-13, 1:23 pm

> And when I got psqlodbc-08.01.0100.tar.gz (that is the correct one to use

The psqlodbc-08.01.0200 is the most up to date stable release.
This version (08.01.XXXX has some limitations which older drivers doesn't
have (older = 08.00 and older).

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Todd Denniston

2006-02-13, 8:23 pm

Dave Page wrote:
>
>
>
<SNIP>...[color=darkred]
<SNIP>[color=darkred]
>
>
> It was removed because it is no longer required:
>
> http://cvs.pgfoundry.org/cgi-bin/cv...x-cvsweb-markup
>
> Regards, Dave.
>

So with postgresql-8.0.6 and postgresql-odbc-08.00.0100 as installed by
Fedora, I should be able to just skip section 5.1 of the kandalaya document then?

It might be good to add that little tidbit to your faq.html {patch attached,
but needs spell checked}.

and on the subscription page, the link to the FAQ seems broken too.
http://mail.postgresql.org/mj/mj_ww...xtra=pgsql-odbc

Thanks for the update.
--
Todd Denniston
Crane Division, Naval Surface Warfare Center (NSWC Crane)
Harnessing the Power of Technology for the Warfighter

Dave Page

2006-02-14, 3:23 am

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston
> Sent: 13 February 2006 23:47
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] What happend to odbc.sql & odbc-drop.sql
>
>
> So with postgresql-8.0.6 and postgresql-odbc-08.00.0100 as
> installed by
> Fedora, I should be able to just skip section 5.1 of the
> kandalaya document then?

I would guess so, but I have no knowledge of that document.

> It might be good to add that little tidbit to your faq.html
> {patch attached,
> but needs spell checked}.

Thanks, but as you're the first person I recall to ever ask that
question, I don't think it really counts as a faq :-) An update to the
kandalaya document would seem more appropriate.

> and on the subscription page, the link to the FAQ seems broken too.
> http://mail.postgresql.org/mj/mj_ww...postgresql.org&
> func=lists-long-full&extra=pgsql-odbc

No, that's maintained by Majordomo, the mailer software. I'm not sure if
we can change that - I'll ask the admin.

Thanks, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links