Re: [GENERAL] ODBC driver issue

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

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

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 to emulate mysql for end programs

On 06/02/2015 04:16 AM, Mimiko wrote: Thanks for response. I've tried to connect the application to postgres with odbc. Arised 2 problems: 1) mysql widelly uses case-insensitive naming for schemas,tables,columns. Actually that is not true as I found out the hard way. See here for all the way

Re: [GENERAL] odbc to emulate mysql for end programs

On Tue, Jun 02, 2015 at 01:31:55PM +0200, Thomas Kellerer wrote: > > 2) as program double-quotes the schema,table and column names. > > Don't use quoted identifiers. Neither in Postgres nor in MySQL (or any other > DBMS) I think a better rule of thumb is either always to use them (and spell eve

Re: [GENERAL] odbc to emulate mysql for end programs

Mimiko schrieb am 02.06.2015 um 13:16: > 1) mysql widelly uses case-insensitive naming for > schemas,tables,columns. So does Postgres. FOO, foo and Foo are all the same name > But postgres use case-sensitive when doulbe-quoting Which is what the SQL standard requires (and this was required *lo

Re: [GENERAL] odbc to emulate mysql for end programs

Thanks for response. I've tried to connect the application to postgres with odbc. Arised 2 problems: 1) mysql widelly uses case-insensitive naming for schemas,tables,columns. But postgres use case-sensitive when doulbe-quoting or lowers the names without quoting. Is there a configure option

Re: [GENERAL] odbc to emulate mysql for end programs

On 6/1/2015 12:04 PM, Mimiko wrote: I have several programs which can use mysql,access,oracle DB as a front-end DB via odbc. Is there a method to emulate or hide the back-end DB so for program it will be seen as mysql, but real DB will be on postgres? ODBC *is* that method. you just need

Re: [GENERAL] odbc to emulate mysql for end programs

Hello, PostgreSQL has a fully standards compliant ODBC driver (See: https://odbc.postgresql.org/). Any application designed to communicate with DBMS over ODBC connection should be able to use that driver to communicate with PostgreSQL. Most applications that interact with databases come with ODBC

Re: [GENERAL] odbc to emulate mysql for end programs

On 06/01/2015 12:04 PM, Mimiko wrote: Hello. I have several programs which can use mysql,access,oracle DB as a front-end DB via odbc. Is there a method to emulate or hide the back-end DB so for program it will be seen as mysql, but real DB will be on postgres? On a theoretical level you could

Re: [GENERAL] ODBC constructs

On 5/21/2013 1:11 AM, Dev Kumkar wrote: Thanks for the comments. Yes objective is to work in C and found libpq useful but am not sure about psqlODBC. It would be really great to get comments from community here regarding comparison between both of them and also performance perspective. Based on

Re: [GENERAL] ODBC constructs

On 5/20/2013 11:04 PM, Atri Sharma wrote: Also,is it only me,or are we all a bit wary of ODBC? its clumsy.getting software working well with it requires more work. its promise of portability only holds true if you restrict yourself to SQL that works the same on different servers, and if

Re: [GENERAL] ODBC constructs

Sent from my iPad On 21-May-2013, at 11:24, John R Pierce wrote: > libpq lets you talk directly to postgres in its native tongue. > > ODBC implements a sort of abstraction. IMHO, its like trying to type with > mittens on. > Also,I see no point in working using ODBC with Postgres if you

Re: [GENERAL] ODBC constructs

On 5/20/2013 10:11 PM, Dev Kumkar wrote: On Mon, May 20, 2013 at 9:12 PM, Atri Sharma > wrote: If you wish to work in C,then,I would suggest libpq.I would wait for more replies on this,as I have little knowledge about psqlODBC. Thanks for the comments.

Re: [GENERAL] ODBC constructs

On Mon, May 20, 2013 at 9:12 PM, Atri Sharma wrote: > > If you wish to work in C,then,I would suggest libpq.I would wait for more > replies on this,as I have little knowledge > about psqlODBC. > Thanks for the comments. Yes objective is to work in C and found libpq useful but am not sure about p

Re: [GENERAL] ODBC constructs

Sent from my iPad On 21-May-2013, at 6:15, Dev Kumkar wrote: > Hello, > > My objective is to work with postgres from my linux box using C. Am not sure > whether psqlODBC or libpq should be used. > I was playing and used libpq successfully but not sure which route to go and > whats the diffe

Re: [GENERAL] ODBC constructs

Also adding the pgsql-admin alias. Regards...

Re: [GENERAL] ODBC constructs

Hello, My objective is to work with postgres from my linux box using C. Am not sure whether psqlODBC or libpqshould be used. I was playing and used libpq successfully but not sure which route to go and whats the difference. Also Can you please

Re: [GENERAL] [ODBC] pgsql ODBC text escaping issue

Have you tried one of the newer ODBC drivers? Also, you may want to look into enabling standard_conforming_strings or disabling the warning messages with escape_string_warning. Jon From: Zhidong She To: pgsql-o...@postgresql.org, pgsql-general@postgresql.org, Zhidong She Date: 07/

Re: [GENERAL] [ODBC] resultset metadata libpq

Hi, I had referred below link I could not able to locate or identify api to retrieve information like precision, scale, nullability. Thanks, Ravi Katkar -Original Message- From: willfurn...@googlemail.com [mailto:willfurn...@googlemail.com] On Behalf Of William Furnass Sent: Tuesd

Re: [GENERAL] [ODBC] resultset metadata libpq

On 27 July 2010 13:43, Ravi Katkar wrote: > > From: Ravi Katkar > Sent: Tuesday, July 27, 2010 5:45 PM > To: 'pgsql-general@postgresql.org'; 'pgsql-o...@postgresql.org' > Subject: resultset metadata libpq > > I wanted to retrieve the below metadata information for a column from > resultset. > > Co

Re: [GENERAL] ODBC mac os

Thank you very much ;) Enrico 2010/1/29 Dave Page : > On Fri, Jan 29, 2010 at 1:29 PM, Enrico Pirozzi wrote: >> Hi, >> I would like to find an odbc driver for mac os x, >> where I can find it? >> >> Thanks to all > > If you're running the one-click PG installer, you can install the ODBC > driver

Re: [GENERAL] ODBC mac os

On Fri, Jan 29, 2010 at 1:29 PM, Enrico Pirozzi wrote: > Hi, > I would like to find an odbc driver for mac os x, > where I can find it? > > Thanks to all If you're running the one-click PG installer, you can install the ODBC driver using StackBuilder. -- Dave Page EnterpriseDB UK: http://www.e

Re: [GENERAL] (odbc) multiple step ole db generated error - date/timestamp column

ok i brought it in as varchar and cast as date. On Sun, Mar 22, 2009 at 12:27 PM, zach cruise wrote: > On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer > wrote: >> zach cruise wrote: >>> when importing from oracle 10g >> >> Importing how? CSV dump and load? DB link of some sort? > > odbc (see email

Re: [GENERAL] (odbc) multiple step ole db generated error - date/timestamp column

On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer wrote: > zach cruise wrote: >> when importing from oracle 10g > > Importing how? CSV dump and load? DB link of some sort? odbc (see email) specifically Microsoft OLE DB Provider for Oracle > Operating system and version? Oracle version? windows 2k3

Re: [GENERAL] (odbc) multiple step ole db generated error - date/timestamp column

zach cruise wrote: > when importing from oracle 10g Importing how? CSV dump and load? DB link of some sort? Operating system and version? Oracle version? > i get "multiple step ole db generated > error". >From what program ? Where? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsq

Re: [GENERAL] ODBC limitation??

On Saturday, March 14, 2009, Adrian Klaver wrote: > On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > > When I run the following query through psql, it executes successfully. > > However, when I run it through ODBC (via OpenOffice Base), I get the > > error > > > > SQL Status: HY000 > >

Re: [GENERAL] ODBC limitation??

On Saturday, March 14, 2009, Dann Corbit wrote: > > -Original Message- > > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > > ow...@postgresql.org] On Behalf Of Carl Sopchak > > Sent: Saturday, March 14, 2009 5:41 PM > > To: pgsql-general@postgresql.org > > Subject: [GENE

Re: [GENERAL] ODBC limitation??

On Saturday, March 14, 2009, Adrian Klaver wrote: > On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > > When I run the following query through psql, it executes successfully. > > However, when I run it through ODBC (via OpenOffice Base), I get the > > error > > > > SQL Status: HY000 > >

Re: [GENERAL] ODBC limitation??

kla...@comcast.net > To: pgsql-general@postgresql.org; carl.sopc...@cegis123.com > Subject: Re: [GENERAL] ODBC limitation?? > Date: Sat, 14 Mar 2009 18:36:51 -0700 > > On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > > When I run the following query through psql, it executes s

Re: [GENERAL] ODBC limitation??

On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > When I run the following query through psql, it executes successfully. > However, when I run it through ODBC (via OpenOffice Base), I get the error > > SQL Status: HY000 > Error code: 1000 > > syntax error, unexpected $end, expecting BETWEE

Re: [GENERAL] ODBC limitation??

> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Carl Sopchak > Sent: Saturday, March 14, 2009 5:41 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] ODBC limitation?? > > When I run the following query thr

Re: [GENERAL] [ODBC] Error in Adding All Table

Hello, What PostgreSQL server and ODBC driver version do you use? salman Sheikh wrote: Hi freinds, i wanted to add my all tables once in MFC application,normally we add it one by one. If i add all table by pressing control and click on all table ,i can add them,but by debugging it shows me alw

Re: [GENERAL] ODBC driver crash

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, access, and joins

=-- On Fri, 11/23/07, Tom Hart <[EMAIL PROTECTED]> wrote: > The problem I'm having is that anything defined as a "text" datatype in > > postgres gets converted to a "memo" datatype in access, and when we > attempt to perform a join query on thatfield access starts complaining > > about not bein

Re: [GENERAL] ODBC, access, and joins

On Fri, Nov 23, 2007 at 03:48:01PM -0500, Tom Hart wrote: > The problem I'm having is that anything defined as a > "text" datatype in postgres gets converted to a "memo" datatype in > access, and when we attempt to perform a join query on that field access > starts complaining about not being ab

Re: [GENERAL] odbc parameters

am Wed, dem 11.07.2007, um 14:55:28 +0200 mailte Zlatko Matic folgendes: > I have already tried COPY. > But, it has problems with type castings. > For example, COPY operation fails because PostgreSQL can't copy value > 7.844,000 into NUMERIC field... Either copy such values into a temp. table wi

Re: [GENERAL] odbc parameters

t: Wednesday, July 11, 2007 2:31 PM Subject: Re: [GENERAL] odbc parameters am Wed, dem 11.07.2007, um 14:15:02 +0200 mailte Zlatko Matic folgendes: Hello, please don't hijack other threads. If you only change the subject for a new question, your mail will be sorted completely wrong. (within

Re: [GENERAL] odbc parameters

am Wed, dem 11.07.2007, um 14:15:02 +0200 mailte Zlatko Matic folgendes: > Hello, please don't hijack other threads. If you only change the subject for a new question, your mail will be sorted completely wrong. (within modern email-clients such thunderbird or mutt) > > I use MS Access for data

Re: [GENERAL] odbc with encrypted ssl key?

Hi! You may try https://projects.commandprompt.com/public/odbcng/. This PostgreSQL ODBC driver's connection string can contain parameters you need: SSL_CERTIFICATE=[string] - path to SSL certificate file SSL_PRIVATE_KEY=[string] - your SSL private key SSL_PASSPHRASE=[str

Re: [GENERAL] odbc can't edit postgresql database ?? -- Small example

I have a clue to this problem, see below. On 3/11/07, Geoff Russell <[EMAIL PROTECTED]> wrote: Hi all, I have postgresql 8.1, unixodbc and openoffice on a Ubuntu 6.06.1 machine and can connect to my postgresql databases fine --- but can't edit data, only view. pgadmin3 also only allows viewing

Re: [GENERAL] [ODBC] information request on postgresql --> oracle

Ragnar schrieb: On mán, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote: i'm looking for a method to connect natively a postgresql db to oracle ( maybe via odbc ? ) with something similar to the oracle dblink. I connected successfully a oracle instance to a postgresql instance using unix-odb

Re: [GENERAL] [ODBC] information request on postgresql --> oracle

On mán, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote: > i'm looking for a method to connect natively a postgresql db to oracle > ( maybe via odbc ? ) with something similar to the oracle dblink. > > I connected successfully a oracle instance to a postgresql instance > using unix-odbc, now i

Re: [GENERAL] odbc problem

"P.MO" <[EMAIL PROTECTED]> writes: > I've just recompiled a postgres 8.1.3 on freebsd 5.4 and since > then, I can no more access it with odbc. What happens exactly when you try? Does it still work from other clients, eg psql? regards, tom lane ---

Re: [GENERAL] [ODBC] Problem using ODBC from .NET framework

--- Ludek Finstrle <[EMAIL PROTECTED]> wrote: > Feel free to re-post the message if 08.01.0200 is still boken. I'll > appreciate if you include mylog output (from 08.01.0200 driver). > Using 08.01.0200, I'm still receiving the same error. However, I've managed to narrow the case when it happens

Re: [GENERAL] [ODBC] Problem using ODBC from .NET framework

--- Ludek Finstrle <[EMAIL PROTECTED]> wrote: > > Hi all. I having an issue with the 8.01.01.02 ODBC driver that is > > installed via the 8.1.x Windows installer. > > ... > > > Anyone have any ideas whats going on or how I can get back to the > 8.0.x > > behavior? > > There is newer 08.01 ps

Re: [GENERAL] ODBC connection problems!

Francesco Lilley wrote: Hello, i've just dowloaded and installed Postgres 8.1 and i've installed the latest version of Odbc Drivers 8.01.0103 and created the Odbc on Windows. But i have some connections problems...the first time i wrote a C-like program in order to make some concurrent simultaneu

Re: [GENERAL] ODBC Layer and the now() function

Hi, I hope the following link will help you. http://www.postgresql.org/docs/8.0/static/plpgsql-expressions.htmlOn 12/5/05, Byrne Kevin-kbyrne01 <[EMAIL PROTECTED]> wrote: Has anyone seen any strange behaviour as regards the now() function when accessing a db via odbc layer. The behaviour I have

Re: [GENERAL] ODBC Layer and the now() function

Byrne Kevin-kbyrne01 <[EMAIL PROTECTED]> writes: > Moserver receives the event - timestamps it as 't1' > -- time lapse before moserver computes the transaction and gives it to odbc. > Txn_begin- now() gets frozen to 't2' > Insert - now() should put it as 't2' > Txn_end()- done. > So firstly t2 sh

Re: [GENERAL] ODBC Layer and the now() function

Hi,the following link might help you.http://www.postgresql.org/docs/8.0/static/plpgsql-expressions.htmlOn 12/5/05, Byrne Kevin-kbyrne01 <[EMAIL PROTECTED]> wrote: Has anyone seen any strange behaviour as regards the now() function when accessing a db via odbc layer. The behavio

Re: [GENERAL] odbc in postgresql and php

ODBC has nothing to do with this -- you compile postgreSQL support directly into PHP when you configure PHP just before the install...   ./Configure --with-postgres --without-mysql     After that -- you need to join a PHP newsgroup for PHP questions     ""Bob Powell"" <[EMAIL PROTECT

Re: [GENERAL] odbc in postgresql and php

Bob Powell wrote: Hello everyone, Has anyone installed the postgres php driver. I would like to know how to install it on Linux and then what the proper way to access it is from a php web page. I have been unable to find actual code for php and doing this. Please help. Thanks. Almost

Re: [GENERAL] [ODBC] versions of oDBC driver

Hello. After I tried different things, I finally figured out where is the problem with connection string: "Driver={PostgreSQL}" must be changed to "Driver={PostgreSQL Unicode}". Now it works. But this new connection string works only with Postgres 8.1, while it doesn't work with Postgres 8.0..

Re: [GENERAL] [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL

What version of Access? Confirm that Access is interpreting the target field as MEMO, (either look at the linked table in design mode, or use Tools->Analyze->Documenter). For the query, determine the "type" of the parameter - Query menu->Parameters. Be sure you are using type MEMO. By the way,

Re: [GENERAL] ODBC and inappropriate select *

On Thu, 2005-09-01 at 13:58, Steve Crawford wrote: > We have an old legacy app that connects to our PostgreSQL (7.4.6) > database. It is an old Visual Basic/Business Objects (VB 6.0, MDAC > 2.5) program that selects a group of records and locks them by > setting a field to an "in-progress" statu

Re: [GENERAL] ODBC and inappropriate select *

On Thu, 2005-09-01 at 15:21, Steve Crawford wrote: > > Is that select * being used to COUNT the number of rows? If so, > > then do a "select count(*)" which will take the db engine about as > > long, but it won't need to transfer the data across. > > Beats me. WE are not requesting a "select *" a

Re: [GENERAL] ODBC and inappropriate select *

Steve Crawford <[EMAIL PROTECTED]> writes: > Somewhere in the black box that is VB/BusinessObjects/ODBC something > is deciding that a "select *" is necessary for reasons unknown and > then choking on (well, not actually choking but digesting slowly) the > data returned. > I'm just trying to fi

Re: [GENERAL] ODBC and inappropriate select *

> Is that select * being used to COUNT the number of rows? If so, > then do a "select count(*)" which will take the db engine about as > long, but it won't need to transfer the data across. Beats me. WE are not requesting a "select *" at all in the VB code. We are selecting and updating the rows

Re: [GENERAL] ODBC issue with aggregate fields (SUM)

The column is decimal(16,2). Thanks. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] ODBC issue with aggregate fields (SUM)

On Wed, Aug 10, 2005 at 10:08:20AM -0400, Tim Nelson wrote: > So the size of SUM("str_sls_totals"."strsl_net_dly") is 20. When we > change the year to 2004 the size is returned as 30 ! ! ! Is this by > design or a bug. What is the type of that column? I'm thinking, if it's numeric, then it's

Re: [GENERAL] [ODBC] how to unsubscribe

Send email to the list address, but add -request to the end of the first part. EG: send email to [EMAIL PROTECTED] with the subject: unsubscribe On Tue, 2005-05-24 at 09:51 -0400, [EMAIL PROTECTED] wrote: > I went to the link given to unsubscribe... (someone said it was > SIMPLER), and I did no

Re: [GENERAL] ODBC connection string-constants A,B,C ?

Zlatko Matic wrote: Hello. When building ODBC connection string for PostgreSQL there are constants beginning with A, B and C. Where can I find description of each of these ? There is a HowTo on the psqlODBC site that mentions those codes. Keep in mind that those are MS-Access specific abrevatio

Re: [GENERAL] [ODBC] retrieving images stored by php / pgsql

Apologies - sent this to the wrong list by accident. R. On 30 Apr 2005 at 20:56, Raymond O'Donnell wrote: > On 23 Apr 2005 at 12:43, Gerard H. Pille wrote: > > > Now I would like to retrieve (and show) these images, but using > > unixODBC. I have no problem retrieving them using pgsql, but the

Re: [GENERAL] [ODBC] retrieving images stored by php / pgsql

On 23 Apr 2005 at 12:43, Gerard H. Pille wrote: > Now I would like to retrieve (and show) these images, but using > unixODBC. I have no problem retrieving them using pgsql, but the > images are damaged when I try to do it with odbc. Correct me if I'm wrong, but I think there's a limit (32k or s

Re: [GENERAL] [ODBC] Adventures with P2P and Scripts in Windows

Jeff Eckermann wrote: --- [EMAIL PROTECTED] wrote: I DID Succeed in doing the sort of things I want in VBA script in MSAccess, but that does me no good at work because we cant get the money to purchase copies of Access. I own a copy of Visual Basic, and if I could find a good example of

Re: [GENERAL] [ODBC] Adventures with P2P and Scripts in Windows

--- [EMAIL PROTECTED] wrote: > I DID Succeed in doing the sort of things I want in > VBA script in MSAccess, > but that does me no good at work because we cant get > the money to purchase > copies of Access. > > I own a copy of Visual Basic, and if I could find a > good example of > acce

Re: [GENERAL] [ODBC] delphi access question?

On 30 Mar 2005 at 15:15, Joel Fradkin wrote: > I can run a sql statement ok, even in sql builder I see all the fields. > But the returned result set appears to be missing some of the fields. Probably a silly question, but do you have all the fields SELECTed in the SQL statement in the TQuery (or

Re: [GENERAL] [ODBC] ODBC (win32) X PostgreSQL(Linux)

On Wednesday 26 January 2005 07:07 am, Eric E wrote: > Hi Fabricio, > > fbbsantos wrote: > > What details do you need? > > I need to know enough that if I sat down at your computer I could > find the problem. > For example, what language or application are you using? > Are you using a DSN, or a DS

Re: [GENERAL] [ODBC] ODBC (win32) X PostgreSQL(Linux)

Hi Fabricio, fbbsantos wrote: What details do you need? I need to know enough that if I sat down at your computer I could find the problem. For example, what language or application are you using? Are you using a DSN, or a DSN-less connection? What connection string have you used in your ap

Re: [GENERAL] ODBC

On Wed, 2004-10-13 at 11:17 -0400, Alexander Cohen wrote: > Hi, > > Im looking for instructions on installing the postgresql ODBC driver on > mac osx and windows. Is there any reference for that. Any help is > apprecitaed. BTW, i need to compile it and install it wihtout using the > windows ins

Re: [GENERAL] ODBC for PostgreSQL 7.4

Astha Raj wrote: Hi All, I want to connect to PostgreSQL 7.4 from my Windows machine. What ODBC version is needed? Is there any other important settings required? I am very new to this database. Search on google: "odbc postgresql" and I'm feeling lucky. Regards Gaetano Mendola

Re: [GENERAL] ODBC Driver Standards

[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] FUD!! ODBC will not be supported by Microsoft in the future

Hi, this might be actually offtopic, but its always time to fight some FUD :-) > Microsoft will be doing away with the OLEDB to ODBC bridge in the near > future. Funny enough if I use __Microsoft__ SQL Query Analyzer which directly connects to SQL Server and somehow shut the SQL Server down whi

Re: [GENERAL] ODBC Issue

I realize that you guys are working on this voluntarily. All I asked was where can I go to get some questions answered. ""scott.marlowe"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Fri, 5 Sep 2003, Relaxin wrote: > > > How do we get someone from PG to respond to the questions

Re: [GENERAL] ODBC Issue

On Fri, 5 Sep 2003, Relaxin wrote: > How do we get someone from PG to respond to the questions in the ODBC > newsgroup? > Is the someone we can email directly? I believe your question was already answered. The issue is that in ODBC you can set it to use a cursor / fetch with a checkbox, or you

Re: [GENERAL] ODBC query problem AGAIN

Try to EXPLAIN SELECT ..., if it crash you most likely have to recompile postgres with that strxfrm fix and it's have nothing to do with your data. Basically in my case, SunOS 5.8 ( dunno what Solaris version is that, probably 8 ) PG was crashing during cost calculation, long before any data acces

Re: [GENERAL] ODBC query problem

I've moved all data to a new location using pg_dum/pg_restore, Things seems to be working properly so far, data seems to be where it should be and complete, I did the initdb once again using es_MX as locale. This was the first time I face such a problem with this Solaris installation after 14 mon

Re: [GENERAL] ODBC query problem

Mail List Subject: Re: [GENERAL] ODBC query problem I've moved the database to a third location in the same disk using pg_dumpall, the new location works with no errors, the initdb was made without localization. The production db was inited with es_MX locale, may that has something to do w

Re: [GENERAL] ODBC query problem

I've moved the database to a third location in the same disk using pg_dumpall, the new location works with no errors, the initdb was made without localization. The production db was inited with es_MX locale, may that has something to do with the problem ?. On Wed, 2003-07-16 at 12:40, Andrew Sull

Re: [GENERAL] ODBC query problem

or DB cluster? > > -Original Message- > From: Luis Magaña [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 16, 2003 10:37 AM > To: Andrew Sullivan > Cc: Postgresql General Mail List > Subject: Re: [GENERAL] ODBC query problem > > > I've compiled postgresql

Re: [GENERAL] ODBC query problem

Forgotten to ask, what is locale for DB cluster? -Original Message- From: Luis Magaña [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 10:37 AM To: Andrew Sullivan Cc: Postgresql General Mail List Subject: Re: [GENERAL] ODBC query problem I've compiled postgresql in 32bit

Re: [GENERAL] ODBC query problem

On Wed, Jul 16, 2003 at 12:36:34PM -0500, Luis Maga?a wrote: > I've already moved database to a diferent partition nad got the same > results, I wonder, if it is a hardware problem, why can I access both > tables individually with no problem at all ?. Doesn't sound like hardware, then. I think yo

Re: [GENERAL] ODBC query problem

I've compiled postgresql in 32bit mode, although I'm using the --enable-integer-datetimes flag when configuring. I've already moved database to a diferent partition nad got the same results, I wonder, if it is a hardware problem, why can I access both tables individually with no problem at all ?.

Re: [GENERAL] ODBC query problem

It very much looks like a problem I had before do you have back trace, I will say for sure. -Original Message- From: Luis Magaña [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 10:12 AM To: Andrew Sullivan Cc: Postgresql General Mail List Subject: Re: [GENERAL] ODBC query problem

Re: [GENERAL] ODBC query problem

On Wed, Jul 16, 2003 at 12:04:25PM -0500, Luis Maga?a wrote: > Thanks, > > yes, it's running solaris 8 on a SPARC with SCSI disk. Hmm. 64 bit? There've been plenty of bugs in the 64 bit libraries, AFAICT. We've even discovered some of 'em ourselves, and I got so leery that we still use a 32-b

Re: [GENERAL] ODBC error

Michelle Murrain wrote: > I'm trying to isolate a problem - using Cold Fusion, and sending to pg > a large text block, I'm getting an error: > > ODBC Error Code = 08S01 (Communication link failure) > > Error while executing the query; Query string is too long > > Is this a Cold Fusion problem

Re: [GENERAL] ODBC driver for Mac?

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 3.0 functions (UCASE, LCASE, etc.)

This is clearly a good idea. It is easy to create SQL functions as synonyms for existing functions. You can even alter the arguments. I would encourage anyone who wants to start coding an SQL file of compatibility functions. > On Thu, 3 May 2001, Bruce Momjian wrote: > > > > > This sounds g

Re: [GENERAL] ODBC 3.0 functions (UCASE, LCASE, etc.)

OK, I am quoting at the top because I don't want to delete any of this. I think this is a great idea. In final form, it would be good to have a layer pre-parse the query string and rewrite Oracle-isms or MySQL-isms before they get to the parser, but as a first step, have a plug-in that would ad

Re: [GENERAL] ODBC 3.0 functions (UCASE, LCASE, etc.)

You might want to send this to -hackers and/or -odbc. Joel Burton writes: > There are number of functions defined by ODBC 3 that we support, > but not using the exact same name or order of arguments as ODBC 3.0. It's hard to tell how to proceed without a list of the proposed functions. -- Pet

Re: [GENERAL] ODBC

> I never install our version of postgresql7.0 on this Red Hat Linux > machine, but I need to connect to the database with ODBC. >Is there any way > I can tell if the ODBC driver has been installed? Run this command: % rpm -q postgresql-odbc Brent ---(end of broa

Re: [GENERAL] ODBC with Visio

Hi, This syntax is also available with Oracle regarding user grants on tables. I have made a program who can parse Pg and Oracle database so I have met this problem. Fortunally I have the source code so I simply hack the code :-) I don't know about Visio but seeing the operating system you probab

Re: [GENERAL] ODBC driver for 7.1

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

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 drivers for linux

Trond Eivind Glomsrød wrote: > > Kevin Heflin <[EMAIL PROTECTED]> writes: > > > I've used postgresql for a few years, running on Linux.. using PHP with > > apache to connect to postgresql.. after finding an ODBC drivers for use on > > windowsNT, I also use PHP and tango with IIS to connect to po

Re: [GENERAL] ODBC drivers for Macintosh?

> Do the ODBC drivers compile for Macintosh? Actually, I've looked > at the source and it doesn't look like Mac was taken into > account, but, before my Macintosh CodeWarrior C compiler arrives > and I start hacking, has anyone attempted this? I think not. But we would welcome compatible patches

Re: [GENERAL] ODBC Question for 7.0

Replying to myself in the event that anyone was curious. Ended up closing down StarOffice and starting it back up. Everything works fine now. Go figure. Can't really do/see relationships in Star Office, although that may be more a StarOffice thing than ODBC driver. Sam "Samuel A. Mullen" wr

Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?

oh! this was for old releases, now I'm using the following: create function MsBool(bool,int4) returns bool as ' declare     bool_int int4; begin     if $1 is NULL then     return NULL;     end if;     if $1 is TRUE then if $2 <> 0 then ret

RE: [GENERAL] ODBC with 6.5beta1

There was a brief period of time during 6.5 where the ODBC and JDBC interfaces were broken. It could very well have existed when beta 1 was created. This is fixed in the current code. Hopefully beta2 will be available soon. -Original Message- From: Bogus User [SMTP:[E

Re: [GENERAL] odbc-drv wouldn't install under win nt

Christian Steindl wrote: > is there anyone who can tell me how to install the odbc-drv under win nt 4.0 > i downloaded the last version 6-30-0245 but the setup-program does > nothing?!!? > is there a way to adapt the registry by hand? > PS: as i read before the 32-bit version of the odbc-drv sh

  1   2   >