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
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
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
Hi,
I'm testing my program and got an interesting issue.
I have an OSX 10.8 with iODBC manager and PostgreSQL ODBC driver.
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 dri
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
>
Hi
I'm currently encountering an interesting issue with the PostgreSQL ODBC
driver on Windows. I'm unlucky enough to have to use MS Access 2007 for
a project at the moment, with PostgreSQL providing the storage through
ODBC. It all works as well as can be expected from Access, except that
the appl
Hello list,
What ODBC client driver should I use to connect a pg81 server running in
windows, I have tried the latest psqlodbc-08_01_0200 but it only
installs psqlodbca.dll and psqlodbcw.dll, the old psqlodbc.dll is
missing any idea what could I doing wrong or what's the right ODBC
driver I s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I suppose this should really be on the ODBC driver list, but as I spend
so much time sorting through mail already, I'm rather hoping not to
need to subscribe to yet another list for this one issue...
I'm trying to use a commercial handheld sync pro
Hi all,
I've had a couple issues with the ODBC driver that ships with
Postgres. I am using Access 2000 to link tables Postgres.
Of the two issues, one is small: after I enabled row version in the
ODBC driver - to fix a problem updating certain tables - the column xmin
began appearing in al
[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
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 found any info about
st
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
Any plans to work on a Mac version of PgSQL ODBC driver?
--
Randy Perry
sysTame
Mac Consulting/Sales
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [
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
- Original Message -
From: "Vitaliy V. Romanets" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 9:26 AM
Subject: [GENERAL] ODBC driver for 7.1
> Hi All!
> I see that ODBC driver for <=7.0.* is not compatible
> to 7.1 version. It
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 :)
Vitaliy.
I knew I needed to check my work before bringing the ODBC driver problems
out in the open. Here's what I've found.
I was designing a simple query using MS-Access having already defined
an external data source to a PostgreSQL database just to make sure
things work as I expected. The database is bi
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
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
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
I downloaded and installed the ODBC driver for Postgres. I have a linux
box on the network and the postgres server is running on it. I am
trying to connect to the sample database mydb from a Windows NT ver 4.0
machine though ODBC with C++ Builders BDE.
I get the following errors:
Unknown user
21 matches
Mail list logo