Re: [GENERAL] ODBC driver issue

2017-07-26 Thread John R Pierce
On 7/26/2017 9:06 PM, Igor Korot wrote: With the char(), is there a "Standard SQL" way to do trimming? trim(trailing from fieldname) but really, if you want a variable length string without padding, don't use CHAR() as a data type. use VARCHAR or TEXT. -- john r pierce, recycling bits i

Re: [GENERAL] ODBC driver issue

2017-07-26 Thread Igor Korot
Hi, John, On Wed, Jul 26, 2017 at 11:08 PM, John R Pierce wrote: > On 7/26/2017 7:25 PM, Igor Korot wrote: >> >> When I tried to query the database table with the column "char(129)" I >> get: >> >> "My field text" >> >> (the text with the bunch of spaces at the end). >> >> The driver is not the c

Re: [GENERAL] ODBC driver issue

2017-07-26 Thread John R Pierce
On 7/26/2017 7:25 PM, Igor Korot wrote: When I tried to query the database table with the column "char(129)" I get: "My field text" (the text with the bunch of spaces at the end). The driver is not the current one - but I don't remember the version. Is this known issue? Maybe its already fixe

Re: [GENERAL] ODBC driver crash

2008-09-30 Thread Russell Smith
Craig Ringer wrote: > Hi > The crash occurs whether a file, system, or user DSN is being used. > I can reproduce this on two different machines. It happens with or > without SSL in use. It affects any Access 2007 database with a > PostgreSQL ODBC connection in use, including a newly created blank >

Re: [GENERAL] ODBC Driver Standards

2004-08-13 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Hi; I am being asked if the ODBC drivers are "compliant to 3.x standards with backwards compatibility to 2. x functions". We are currently using 7.3.5 and the last ODBC driver I downloaded for use on Windows is psqlodbc-07_03_0200.zip I have had a peruse about and not

Re: [GENERAL] ODBC driver for Mac?

2001-07-16 Thread Vince Vielhaber
On Sun, 15 Jul 2001, Randall Perry wrote: > Any plans to work on a Mac version of PgSQL ODBC driver? I don't know anything about mac (besides the lastest os being based on FreeBSD 3.2), but you're using the latest version can't you use iODBC? Also http://www.unixodbc.org has one that may work on

Re: [GENERAL] ODBC driver for 7.1

2001-02-05 Thread Richard Huxton
From: "Vitaliy V. Romanets" <[EMAIL PROTECTED]> > Hi All! > I see that ODBC driver for <=7.0.* is not compatible > to 7.1 version. It does't work. > Can anybody tell me when ODBC driver for 7.1 will be realizable? > > Sorry for my english :) If you want to access pg7.1 from windows, I've been p

Re: [GENERAL] ODBC driver for 7.1

2001-02-05 Thread Adam Lang
The driver has had several updates. The people on the odbc list will have more info. I believe they have been updating the driver for 7.1 ... or was it 7.0.1 ... I forget. :) [EMAIL PROTECTED] Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com - O

Re: [GENERAL] ODBC driver

1998-06-03 Thread David Hartwig
ODBC Connection Checklist ODBC Driver Data Source Checks 1.Valid and resolvable hostname. 2.Valid port number. (default is 5432) 3.Valid and existing database name. 4.Valid user name. 5.Valid password for the sp

Re: [GENERAL] ODBC driver

1998-06-02 Thread Brett W. McCoy
On Tue, 2 Jun 1998, Kevin Heflin wrote: > > Did you create a Postgres user with the 'createuser' tool (usually run by > > the postgres superuser (but not root))? This allows designated users to > > use postgresql databases, and in some cases, create and destroy and even > > set database permissi

Re: [GENERAL] ODBC driver

1998-06-02 Thread Kevin Heflin
On Tue, 2 Jun 1998, Brett W. McCoy wrote: > Did you create a Postgres user with the 'createuser' tool (usually run by > the postgres superuser (but not root))? This allows designated users to > use postgresql databases, and in some cases, create and destroy and even > set database permissions fo