[HACKERS] PyGreSQL and Distutils

2001-02-02 Thread Bernard Frankpitt
Hi All, The setup.py file in PyGreSQL does not work with newer distutils (at least not for the distutils in Python 2.0). The new versions of distutils require you to use an instance of a new Python class called Extension to configure the compiled extensions. I have attached a modification of th

Re: [HACKERS] TODO list: Allow Java server-side programming

2001-02-02 Thread Alex Pilosov
On Fri, 2 Feb 2001, tomasz konefal wrote: > could someone please clarify what "Allow Java > server-side programming" actually means? what are the > limitations of using java and jdbc with pgsql? It means to embed Java interpreter inside postgres, and allow writing stored procedures and trigge

[HACKERS] TODO list: Allow Java server-side programming

2001-02-02 Thread tomasz konefal
greetings, group! :) i have a question about the TODO list and could not find an answer in any of the list archives. i am very new to SQL and even newer to pgsql, so my ideas of how things work is still a bit fuzzy. i am currently working on a small e-commerce type website which is hopefully

[HACKERS] best windows ODBC driver for HEAD CVS version?

2001-02-02 Thread Fred Yankowski
What PostgreSQL ODBC driver should I use on Windows NT with the latest version of PostgreSQL from CVS? I had been using psqlodbc.dll version 6.50. by Insight Distribution System, as made available on ftp.postgresql.org in the 'latest' folder. That worked OK with version 7.0.3 of PostgreSQL,

[HACKERS] RE: Index grows huge, possible leakage?

2001-02-02 Thread Mikheev, Vadim
> After several weeks our idicies grow very large (in one case to > 4-5 gigabytes) After droppping and recreating the indecies they > shrink back to something more reasonable (500megs same case). > > We are currently using Vadim's vacuum patches for VLAZY and MMNB, > against 7.0.3. We are using

Re: [HACKERS] 7.1 beta 3 CHANGES FOR QNX

2001-02-02 Thread Bruce Momjian
I have applied the following patch for QNX. I had to do the ECHO test in pgc.l because pgc.c is generated from pgc.l. Can you test this to see it fixes the problem? in [ Charset ISO-8859-1 unsupported, converting... ] > I have compiled 7.1 b3 in QNX but to let postgresql works I changed someth

[HACKERS] Patch to add cursor support to PL/pgSQL

2001-02-02 Thread Ian Lance Taylor
I wrote a patch to add cursor support to PL/pgSQL. I sent it to pgsql-patches earlier, and Bruce said he would consider it after the 7.1 release. I would be interested in getting feedback on it, so for now I have put the patch up on the web: http://www.airs.com/ian/pgsql-cursor.html If you

Re: [HACKERS] configure problem with krb4 and ssl when compiling 7.1beta4

2001-02-02 Thread Bruce Momjian
I have updated the CVS copy of python to show the proper version. We had 3.1, but the 3.1 tarball called it 2.5 in README. > On Fri, Feb 02, 2001 at 12:03:14PM +, Jun Kuwamura wrote: > > Furthermore, the newest version of PyGreSQL is 3.1 instead of 2.5. > > Is this on the TODO-7.1 list? >

[HACKERS] Re: Format of the Money field

2001-02-02 Thread Mitch Vincent
hhs=> select version(); version --- PostgreSQL 6.4.2 on i386-unknown-freebsd3.1, compiled by gcc 2.7.2. | currentsalary| money| 4 | hhs=> select currentsalary from applicants; $77,000

Re: [HACKERS] Format of the Money field

2001-02-02 Thread The Hermit Hacker
On Fri, 2 Feb 2001, Peter T Mount wrote: > When did the MONEY type change it's output format? > > While working on the JDBC test suite, Money broke. It seems to output: > $10.99 > ($10.99) for negative values > > While since ages past, the PGMoney class interprets it as a number (no > currency sy

Re: [HACKERS] configure problem with krb4 and ssl when compiling 7.1beta4

2001-02-02 Thread Nathan Myers
On Fri, Feb 02, 2001 at 12:03:14PM +, Jun Kuwamura wrote: > Furthermore, the newest version of PyGreSQL is 3.1 instead of 2.5. Is this on the TODO-7.1 list? Nathan Myers [EMAIL PROTECTED]

[HACKERS] 7.1 beta 3 CHANGES FOR QNX

2001-02-02 Thread Maurizio
I have compiled 7.1 b3 in QNX but to let postgresql works I changed something.   In src/backend/port/qnx4/sem.c #define SEMMAX  (PROC_NSEMS_PER_SET)         --OLD#define SEMMAX  (PROC_NSEMS_PER_SET + 1)       --NEW   in src/include/storage

[HACKERS] configure problem with krb4 and ssl when compiling 7.1beta4

2001-02-02 Thread Jun Kuwamura
Hi, I encounterd some problems when compiling 7.1beta4 with options --with-krb4 and (--with-openssl --with-python). Actual command line of configuration is the followings. -- ./configure --enable-multibyte --with-tcl \ --with-tclconfig=/usr/local/lib --with-tkconfig=/usr/local/lib \ --wi

[HACKERS] Format of the Money field

2001-02-02 Thread Peter T Mount
When did the MONEY type change it's output format? While working on the JDBC test suite, Money broke. It seems to output: $10.99 ($10.99) for negative values While since ages past, the PGMoney class interprets it as a number (no currency symbol). Peter -- Peter Mount [EMAIL PROTECTED] Postgr