Re: bug in info.c file - incorrect SQL

For some reason Powerbuilder [ invoice control system is Powerbuilder
:-(  ]  calls the info.c functions.  
 
I really appreciate your help.
 
FYI, I am porting an intellectual properties (Patents) company  from
Oracle to Postgresql.
The end goal is to replace 25 Oracle Enterprise servers (some are Sun
E6000, 16 proc boxes).
In the future we will also replace 16 MS SQL servers with Postgresql.
The largest table row count that I am aware of is 162 million rows.
 
Again, thanks for your help.
 
 
 

    -----Original Message----- 
    From: Bruce Momjian 
    Sent: Thu 1/2/2003 6:17 PM 
    To: Hiroshi Inoue 
    Cc: Jim Holliday; pgsql-odbc@postgresql.org 
    Subject: Re: [ODBC] bug in info.c file - incorrect SQL
    
    

    Hiroshi Inoue wrote:
    > > -----Original Message-----
    > > From: Bruce Momjian
    > >
    > > Good catch, patch attached. I found the problems you saw,
plus a few
    > > cases where pg_namespace was referenced in the WHERE but not
FROM ---
    > > not a big problem, but clearer if we specify it both places.
Patch
    > > applied.
    >
    > Unfortunately it doesn't seem a right fix.
    > I would fix it later.
    
    Thanks, Hiroshi.  Also, seems someone is having trouble using
the info
    functions in the current ODBC release, probably because of this
bug.
    Can you roll a new release once you fix it?  Thanks.
    
    --
      Bruce Momjian                        |
http://candle.pha.pa.us
      pgman@candle.pha.pa.us               |  (610) 359-1001
      +  If your life is a hard drive,     |  13 Roberts Road
      +  Christ can be your backup.        |  Newtown Square,
Pennsylvania 19073