Skip site navigation (1) Skip section navigation (2)

Re: for psqlodbc developers: [ psqlodbc-Bugs-1000507 ]

From: "Campbell, Greg" <greg(dot)campbell(at)us(dot)michelin(dot)com>
To: Ludek Finstrle <luf(at)pzkagis(dot)cz>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: for psqlodbc developers: [ psqlodbc-Bugs-1000507 ]
Date: 2005-12-27 16:20:56
Message-ID: 43B169E8.3030703@us.michelin.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Agree with Dave and Luf's instinct whole heartedly.
The driver should support things in the SQL and ODBC standards, particularly DML (INSERT,UPDATE, DELETE, 
SELECT).

Hopefully the application developer builds a Data Access Layer to handle the variations of PostgreSQL, MS 
SQL Sever, Oracle, MySQL, etc.

Dave Page wrote:
> This would require fully parsing statements and would lead to an endless
> stream of similar requests for rewriting other quirky syntaxes IMHO. This is
> not something we can support.
> 
> Regards, Dave
> 
> 
> On 27/12/05 9:11 am, "Ludek Finstrle" <luf(at)pzkagis(dot)cz> wrote:
> 
> 
>>I ask other developers: what's your opinion?
>>
>>I know the man may need it but I don't think we want it. We
>>have to support Oracle, Informix, MySQL, ... special commands than.
>>
>>I hope we don't need parse statements before execute them
>>in new development version so it could be slowdown in the future.
>>
>>Regards,
>>
>>Luf
>>
>>
>>>Summary: MSSQL syntax
>>>
>>>Initial Comment:
>>>MSSQL have a command that Postgresql don't support:
>>>
>>>@@spid
>>>
>>>This command returns MSSQL connection pid.
>>>
>>>I've a application that uses this query. I can't change code, but
>>>i need that psqlodbc ignore this command.
>>>
>>>----------------------------------------------------------------------
>>>
>>>
>>>>Comment By: Ludek Finstrle (luf)
>>>
>>>Date: 2005-12-27 10:01
>>>
>>>Message:
>>>I don't know if we want this behaviour. When you move to other DB
>>>do you think they will add support for this?
>>>
>>>I need to talk about it with other developers. I'm againist this
>>>kind of support.
>>>
>>>@@spid is whole command or is it located inside statements?
>>>
>>>If you're a little bit familiar with C you can hack it into psqlodbc
>>>code yourself (I think in PGAPI_Prepare and PGAPI_ExecDirect).
>>>
>>>----------------------------------------------------------------------
>>>
>>>Comment By: Nobody (None)
>>>Date: 2005-12-27 02:25
>>>
>>>Message:
>>>can psqlodbc to transform all "@@xyz" syntax in:
>>>
>>>xyz()
>>>
>>>?????
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: explain analyze is your friend
> 
> 
> Regards, Dave 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq

Attachment: greg.campbell.vcf
Description: text/x-vcard (241 bytes)

In response to

pgsql-odbc by date

Next:From: noreplyDate: 2005-12-27 19:12:52
Subject: [ psqlodbc-Bugs-1000510 ] Access the rdoResultset┬┤s column is NULL in the second access
Previous:From: noreplyDate: 2005-12-27 15:20:41
Subject: [ psqlodbc-Bugs-1000510 ] Access the rdoResultset┬┤s column is NULL in the second access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group