RE: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-03-02 Thread Dave Page


 -Original Message-
 From: Hiroshi Inoue [mailto:[EMAIL PROTECTED]]
 Sent: 01 March 2001 02:05
 To: Patrick Welche
 Cc: Tom Lane; [EMAIL PROTECTED]; 
 [EMAIL PROTECTED]; [EMAIL PROTECTED]; 
 [EMAIL PROTECTED]
 Subject: Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...
 
 
 Patrick Welche wrote:
  
  On Wed, Feb 28, 2001 at 08:53:31AM +0900, Hiroshi Inoue wrote:
  ...
   I think I've fixed this bug at least for MS-Access.
   You could get the latest win32 driver from
 ftp://ftp.greatbridge.org/pub/pgadmin/stable/psqlodbc.zip .
   Please try it.
  
  How can I just install that file? (ie., M$ Access - 
 psqlodbc.dll - real OS)
  
 
 I don't know if M$-access requires MDAC now(it didn't require
 MDAC before). I use ADO and don't use M$-access other than
 testing. ADO requires MDAC and pgAdmin uses ADO AFAIK.

Yes, pgAdmin does use MDAC, currently v2.6 

  = aside:
  
  I just tried installing pgAdmin - the installer says:
  
  This setup requires at least version 2.5 of the Microsoft 
 Data Access
  Components (MDAC) to be installed first. If the MDAC installer
  (mdac_typ.exe) is not provided with this setup, you can 
 find it on the
  Microsoft web site (www.microsoft.com)
  
  And after searching said website,
  http://www.microsoft.com/data/download2.htm
  shows:
  
  Microsoft Data Access Components MDAC 2.1.1.3711.11   2.5...
  
 
 I can see the following at http://www.microsoft.com/data/download.htm
 
 Data Access Components (MDAC) redistribution releases.
 Five releases of MDAC are available here: The new MDAC
 2.6, two of MDAC 2.5, and two of MDAC 2.1. You can

The message stating that you need MDAC 2.5 is generated by the MS Installer
- I cannot change. The pgAdmin notes on the website (which I wrote)
recommend v2.6 of MDAC which is indeed available at www.microsoft.com/data/

Regards, Dave.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-03-02 Thread Patrick Welche

On Wed, Feb 28, 2001 at 08:53:31AM +0900, Hiroshi Inoue wrote:
... 
 I think I've fixed this bug at least for MS-Access.
 You could get the latest win32 driver from
   ftp://ftp.greatbridge.org/pub/pgadmin/stable/psqlodbc.zip .
 Please try it.

How can I just install that file? (ie., M$ Access - psqlodbc.dll - real OS)

= aside:

I just tried installing pgAdmin - the installer says:

This setup requires at least version 2.5 of the Microsoft Data Access
Components (MDAC) to be installed first. If the MDAC installer
(mdac_typ.exe) is not provided with this setup, you can find it on the
Microsoft web site (www.microsoft.com)

And after searching said website,
http://www.microsoft.com/data/download2.htm
shows:

Microsoft Data Access Components MDAC 2.1.1.3711.11   2.5...

Cheers,

Patrick

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-03-02 Thread Thomas Lockhart

   I've got a clue for ApplixWare, if you happen to have that package
   (US$90).
 Please post it, Thomas.
 I got nowhere following their instructions.

Have you looked at *our* instructions in the chapter on ODBC? I haven't
done much with it in quite a while, but afaik it all should still work.

I would have expected Cary O'Brien (sp? name?? Done from memory: sorry
"aka Cary" :/ to have spoken up if things have broken, so the
instructions should still be good.

   - Thomas

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Release in 2 weeks ...

2001-03-01 Thread Peter Mount

At 11:52 26/02/01 -0400, The Hermit Hacker wrote:

Morning all ...

 Are there any major outstandings that ppl have on their plates,
that should prevent a release?  I'd like to put out an RC1 by Friday this
week, with a full release schedualed for March 15th ... this would give
Thomas his two weeks for the docs freeze ...

It will also give me a little extra time. This week has been a tad busy 
work wise for me I've not been able to do anything at all (only now have I 
been able to find time to download the 800 emails that were waiting for me 
:-( )


 Basically, RC1 would say to ppl that we're ready to release, there
will be no more core changes that will require an initdb ... feel
comfortable using this version in production, with the only major changes
between now and release being docs related ...

 Does this work?  Or is there something earth-shattering that still
has to be done?

Not on my front except:

JDBC1.2 driver needs testing (still can't get JDK1.1.8 to install here).
The JDBC 2.1 Enterprise Edition driver also needs some testing.

The JDBC2.1 Standard Edition driver is ready. Some new patches to look at.

PS: Did you know we are only 1 thing short of being JDBC compliant with the 
JDBC2.1 SE driver?

The other not implemented bits are extras not technically (according to the 
spec) needed for compliance. But then there's not many of them either 
(about 11 at last count excluding CallableStatement - which isn't required 
which I was surprised about when I check it last weekend).

Peter




Re: [HACKERS] Release in 2 weeks ...

2001-03-01 Thread Peter Mount

At 17:54 27/02/01 +0100, Peter Eisentraut wrote:
The Hermit Hacker writes:

Are there any major outstandings that ppl have on their plates,
  that should prevent a release?  I'd like to put out an RC1 by Friday this
  week, with a full release schedualed for March 15th ... this would give
  Thomas his two weeks for the docs freeze ...

I'm interested to know what exactly takes two weeks with the docs and what
could be done to speed it up.


Isn't it the typsetting for the postscript/pdf docs? docbook doesn't handle 
tables too well in those cases and its easier to do them by hand?

Peter


--
Peter Eisentraut  [EMAIL PROTECTED]   http://yi.org/peter-e/




Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-02-28 Thread Hiroshi Inoue
Patrick Welche wrote:
 
 On Wed, Feb 28, 2001 at 08:53:31AM +0900, Hiroshi Inoue wrote:
 ...
  I think I've fixed this bug at least for MS-Access.
  You could get the latest win32 driver from
ftp://ftp.greatbridge.org/pub/pgadmin/stable/psqlodbc.zip .
  Please try it.
 
 How can I just install that file? (ie., M$ Access - psqlodbc.dll - real OS)
 

I don't know if M$-access requires MDAC now(it didn't require
MDAC before). I use ADO and don't use M$-access other than
testing. ADO requires MDAC and pgAdmin uses ADO AFAIK.

 = aside:
 
 I just tried installing pgAdmin - the installer says:
 
 This setup requires at least version 2.5 of the Microsoft Data Access
 Components (MDAC) to be installed first. If the MDAC installer
 (mdac_typ.exe) is not provided with this setup, you can find it on the
 Microsoft web site (www.microsoft.com)
 
 And after searching said website,
 http://www.microsoft.com/data/download2.htm
 shows:
 
 Microsoft Data Access Components MDAC 2.1.1.3711.11   2.5...
 

I can see the following at http://www.microsoft.com/data/download.htm

Data Access Components (MDAC) redistribution releases.
Five releases of MDAC are available here: The new MDAC
2.6, two of MDAC 2.5, and two of MDAC 2.1. You can

Regards,
Hiroshi Inoue


Re: [HACKERS] Release in 2 weeks ...

2001-02-27 Thread Emmanuel Charpentier

The Hermit Hacker wrote:
 
 Morning all ...
 
 Are there any major outstandings that ppl have on their plates,
 that should prevent a release?  I'd like to put out an RC1 by Friday this
 week, with a full release schedualed for March 15th ... this would give
 Thomas his two weeks for the docs freeze ...
 
 Basically, RC1 would say to ppl that we're ready to release, there
 will be no more core changes that will require an initdb ... feel
 comfortable using this version in production, with the only major changes
 between now and release being docs related ...
 
 Does this work?  Or is there something earth-shattering that still
 has to be done?


Yep ! As of beta4, the ODBC driver is still seriously broken (the
original libpsqlodbc.so.0.26 doesn't even connect. A version patched by
Nick Gorham allows some connectivity (you can query the DB), but still
has some serious breakage (i. e. no "obvious" ways to see views from
StarOffice or MS-Access)).

And I have not yet had any opportunity to test the JDBC driver.

[ Explanation : I follow the Debian packages prepared by Oliver Elphick,
I'm not versed enough in Debian to recreate those packages myself, and I
do *not* want to break Debian dependencies by installing Postgres "The
Wrong Way (TM)". Hence, I'm stuck with beta4, a broken ODBC and no JDBC.
Unless some kind soul can send me a JD. 1.1 .jar file ...

Furthermore, I've had some serious hardware troubles (a dying IDE disk).
I wasn't even able to fulfill Tom Lane's suggestion to try to add -d2 to
my postmaster to debug the ODBC connection. I'll try to do that Real
Soon Now (TM, again), but not for now : my day-work backlog is ...
impressive. ]

These issues might seem small change to you die-hard plpgsql hackers. To
a lmot of people using Postgres for everyday office work through "nice"
interface, it's bread-and-butter, and these issues *should* be fixed
*before* release ...

[ crawling back under my rock ... ]

Emmanuel Charpentier



Re: [HACKERS] Release in 2 weeks ...

2001-02-27 Thread Tom Lane

Emmanuel Charpentier [EMAIL PROTECTED] writes:
 Yep ! As of beta4, the ODBC driver is still seriously broken (the
 original libpsqlodbc.so.0.26 doesn't even connect. A version patched by
 Nick Gorham allows some connectivity (you can query the DB), but still
 has some serious breakage (i. e. no "obvious" ways to see views from
 StarOffice or MS-Access)).

I'd be willing to work harder on ODBC if I had any way to test it ;-).

I have a copy of OpenOffice for LinuxPPC but have not figured out how to
tell it to connect to Postgres.  If someone can slip me a clue on how to
configure it and do simple database stuff with it, I'll try to clean up
the most pressing ODBC problems before we release.

regards, tom lane



Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-02-27 Thread Hiroshi Inoue
Tom Lane wrote:
 
 Emmanuel Charpentier [EMAIL PROTECTED] writes:
  Yep ! As of beta4, the ODBC driver is still seriously broken (the
  original libpsqlodbc.so.0.26 doesn't even connect. A version patched by
  Nick Gorham allows some connectivity (you can query the DB), but still
  has some serious breakage (i. e. no "obvious" ways to see views from
  StarOffice or MS-Access)).
 

I think I've fixed this bug at least for MS-Access.
You could get the latest win32 driver from
  ftp://ftp.greatbridge.org/pub/pgadmin/stable/psqlodbc.zip .
Please try it.

However I'm not sure about unixODBC.

Regards,
Hiroshi Inoue


Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-02-27 Thread Thomas Lockhart

 I have a copy of OpenOffice for LinuxPPC but have not figured out how to
 tell it to connect to Postgres.  If someone can slip me a clue on how to
 configure it and do simple database stuff with it, I'll try to clean up
 the most pressing ODBC problems before we release.

I've got a clue for ApplixWare, if you happen to have that package
(US$90).

- Thomas



Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-02-27 Thread Oliver Elphick

Thomas Lockhart wrote:
   I have a copy of OpenOffice for LinuxPPC but have not figured out how to
   tell it to connect to Postgres.  If someone can slip me a clue on how to
   configure it and do simple database stuff with it, I'll try to clean up
   the most pressing ODBC problems before we release.
  
  I've got a clue for ApplixWare, if you happen to have that package
  (US$90).
 
Please post it, Thomas.

I got nowhere following their instructions.

-- 
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight  http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
 
 "These things have I written unto you that believe on 
  the name of the Son of God; that ye may know that ye 
  have eternal life, and that ye may believe on the name
  of the Son of God."I John 5:13 





Re: [ODBC] Re: [HACKERS] Release in 2 weeks ...

2001-02-27 Thread Thomas Lockhart

   I've got a clue for ApplixWare, if you happen to have that package
   (US$90).
 Please post it, Thomas.
 I got nowhere following their instructions.

Uh, who's instructions? We have a writeup on Applix and ODBC in the
docs. Have you found those, or are those falling short of helpful?

   - Thomas



[HACKERS] Release in 2 weeks ...

2001-02-26 Thread The Hermit Hacker


Morning all ...

Are there any major outstandings that ppl have on their plates,
that should prevent a release?  I'd like to put out an RC1 by Friday this
week, with a full release schedualed for March 15th ... this would give
Thomas his two weeks for the docs freeze ...

Basically, RC1 would say to ppl that we're ready to release, there
will be no more core changes that will require an initdb ... feel
comfortable using this version in production, with the only major changes
between now and release being docs related ...

Does this work?  Or is there something earth-shattering that still
has to be done?

Marc G. Fournier   ICQ#7615664   IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED]   secondary: scrappy@{freebsd|postgresql}.org




AW: [HACKERS] Release in 2 weeks ...

2001-02-26 Thread Zeugswetter Andreas SB


   Are there any major outstandings that ppl have on their plates,
 that should prevent a release?

Imho startup after a failing WAL recovery is a 'must do' before release,
as Tom pointed out. Remember that you can currently run into this situation
with as easy a mistake as running out of diskspace.

Also a reasonable default for commit_delay and commit_siblings should be 
found before release.

Andreas