Re: [HACKERS] CVS ODBC does not compile

2001-09-07 Thread Bruce Momjian
> > -Original Message- > > From: Bruce Momjian > > > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > The current CVS tree does not compile ODBC. All sorts of > > failure due to > > > > const and undefined variables. > > > > > > I just got a ton of errors in odbc too, trying to build

Re: [HACKERS] CVS ODBC does not compile

2001-09-07 Thread Bruce Momjian
> > Don't bother. Some are const prototype, non-const definition, but > > others are undefined variable and possible variable used but not > > initialized. I think we have to wait for Hiroshi. > > OK I removed the errors on cygwin port and will commit > the fix soon. However I couldn't check it

Re: [HACKERS] PL/pgSQL bug?

2001-09-07 Thread Hiroshi Inoue
> -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > > I am not sure if there is a TODO item here, but if there is, please let > me know. Thanks. There seems to be no consensus on this item currently. IMHO both the command counters and the snapshots in a function shoul

Re: [HACKERS] CVS ODBC does not compile

2001-09-07 Thread Hiroshi Inoue
> -Original Message- > From: Bruce Momjian > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > The current CVS tree does not compile ODBC. All sorts of > failure due to > > > const and undefined variables. > > > > I just got a ton of errors in odbc too, trying to build it with HP's cc.

Re: [HACKERS] CURRENT CVS: MULTIBYTE: CANT CONNECT....

2001-09-07 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [010907 21:06]: > I finally got all the way through a compile set: > > CC=cc CXX=CC ./configure --prefix=/usr/local/pgsql --enable-syslog \ > --with-CXX --with-perl --enable-multibyte --enable-cassert \ > --with-includes=/usr/local/include --with-

[HACKERS] CURRENT CVS: MULTIBYTE: CANT CONNECT....

2001-09-07 Thread Larry Rosenman
I finally got all the way through a compile set: CC=cc CXX=CC ./configure --prefix=/usr/local/pgsql --enable-syslog \ --with-CXX --with-perl --enable-multibyte --enable-cassert \ --with-includes=/usr/local/include --with-libs=/usr/local/lib \ --enable-debug \ --wi

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Tatsuo Ishii
> > > I am looking at how to get it compiling right away. > > > > Hmm.. my world is comiled by 'gcc' and I'm still must learning that > > here are some cathedrals and not bazaars only :-) Sorry. > > > > OK, please erase all these debug macros (encdebug). I used it for binary > > search check

Re: [HACKERS] CVS access

2001-09-07 Thread D'Arcy J.M. Cain
Thus spake Marc G. Fournier > with the new passowwrd, your problem should be resolved too ... is it not? What new password? Certainly the one I have on the mail machine doesn't work. -- D'Arcy J.M. Cain| Democracy is three wolves http://www.druid.net/darcy/| and a sheep v

Re: [HACKERS] A fixed user id for the postgres user?

2001-09-07 Thread Peter Eisentraut
Tom Lane writes: > I've been thinking a little bit about how one might recover from Really > Stupid Mistakes, like deleting one's only superuser pg_shadow entry. > What I'm thinking is that if we hard-wired usesysid = 1 for the > superuser, it'd be possible to arrange for standalone backends to

Re: [HACKERS] Escaping strings for inclusion into SQL queries

2001-09-07 Thread Bruce Momjian
Patch applied. Thanks. > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Patch removed at the request of the author. Author will resubmit. > > I've attached the fixed version of the patch below. After the > discussion on pgsql-hackers (especially the frightening memory dump in > <[EMAIL PRO

Re: [HACKERS] Changelog and 7.1.3 release

2001-09-07 Thread Tom Lane
> Can we come to some kind of decision on this before going beta? >> The point of these changelogs was to show the changes between beta and rc >> versions, because those were not necessarily recorded in the HISTORY file. >> However, putting these in the tarball is questionable (if you already >>

Re: [HACKERS] Changelog and 7.1.3 release

2001-09-07 Thread Bruce Momjian
> I'd suggest that the future procedure ought to be to pull a changelog > from CVS but put it beside the tarball on the FTP server, not inside > the tarball (and certainly not back into CVS --- that's redundant). When we commit the log files to CVS, don't we have to run cvs log again and commit a

Re: [HACKERS] Escaping strings for inclusion into SQL queries

2001-09-07 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Patch removed at the request of the author. Author will resubmit. > > I

Re: [HACKERS] Log rotation?

2001-09-07 Thread Giles Lean
Hi Peter, > I've been playing with a little program I wrote whose sole purpose is to > write its stdin to a file and close and reopen that file when it receives > a signal. I figured this could work well when integrated transparently > into pg_ctl. > > So, is log rotation a concern? Is this a

Re: [HACKERS] Changelog and 7.1.3 release

2001-09-07 Thread Bruce Momjian
Can we come to some kind of decision on this before going beta? > Bruce Momjian writes: > > > Can I ask why we are mentioning the changelog for the release and not > > the list from the HISTORY file? Any why are we putting the changelog in > > the tarball anyway? Seems that could easily go o

Re: [HACKERS] ODBC TODO list is way out of date

2001-09-07 Thread Bruce Momjian
> There is a TODO list at src/interfaces/odbc/TODO.txt which was last > updated in 1998. > > Do any of the things in this list remain to be done? > If not, perhaps the file should be removed. File removed. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED]

Re: [HACKERS] Re: Escaping strings for inclusion into SQL queries

2001-09-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Has this been resolved? Peter applied his patch, but I am planning to also change addlit to not require null termination, because I believe we'll get bit again if we don't. regards, tom lane ---(end of b

Re: [HACKERS] PATCH proposed with new features for CREATE TABLE

2001-09-07 Thread Bruce Momjian
To get this applied, we will need to hear from people who want this functionality. Sorry. > Hi people!.I developed a work for an university course, which I wish to share with >you. > > I extended the foreign key clause in the create table in order to permit insertions >and updates on a ref

Re: [HACKERS] Re: Escaping strings for inclusion into SQL queries

2001-09-07 Thread Bruce Momjian
Has this been resolved? > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Tom Lane writes: > >> I don't follow. xddouble can only expand to two quote marks, so how > >> does it matter which one we use as the result? > > > addlit() expects the first argument to be null-terminated and implicit

Re: [HACKERS] encoding: ODBC, createdb

2001-09-07 Thread Bruce Momjian
Was this completed? > > I found some other things: > > - why database encoding for new DB check 'createdb' script and not > CREATE DATABASE statement? (means client only encodings, like BIG5)? > > Bug? > > > - ODBC -- here is some multibyte stuff too. Why ODBC code don't use > pg_wch

Re: [HACKERS] backend hba.c prob

2001-09-07 Thread Bruce Momjian
> On Fri, 7 Sep 2001, Bruce Momjian wrote: > > > > gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations >-I../../../src/include -c -o hba.o hba.c > > > hba.c: In function `ident_unix': > > > hba.c:923: sizeof applied to an incomplete type > > > hba.c:960: dereferencing pointer to

Re: [HACKERS] backend hba.c prob

2001-09-07 Thread Bruce Momjian
> On Fri, Sep 07, 2001 at 10:14:27AM -0400, Tom Lane wrote: > > Patrick Welche <[EMAIL PROTECTED]> writes: > > > hba.c: In function `ident_unix': > > > hba.c:923: sizeof applied to an incomplete type > > > > > Now, the problem is sizeof(Cred), typedef struct cmsgcred Cred, and I don't > > > have

Re: [HACKERS] Why "ERROR: dtoi4: integer out of range" on pg_dump

2001-09-07 Thread Tom Lane
Martin Weinberg <[EMAIL PROTECTED]> writes: > Thanks, Tom! This was the problem. Here is my patch to pg_dump.c > that appears to fix the problem. Turns out that the oid needed to > be coerced in two places. I've already committed fixes (I found one or two more places that were missing the same

Re: [HACKERS] Makefile.PL for Pg.so

2001-09-07 Thread Bruce Momjian
Yes, thanks. Cleaning out my mailbox, as usualy before a beta. > I think peter_e dealt with this > > LER > > * Bruce Momjian <[EMAIL PROTECTED]> [010907 13:25]: > > > > Can someone comment on this? > > > > > > > I made the following patch, and it works for MY platform. > > > > > > P

Re: [HACKERS] autoconf on server

2001-09-07 Thread Bruce Momjian
> Bruce Momjian writes: > > > Marc, can we get the proper autoconf on postgresql.org so I can run > > autoconf. I have autoconf here but am getting errors running it: > > > > #$ autoconf > > configure.in:139: /usr/contrib/bin/gm4: Non-numeric argument to built-in > > `divert' > > configure.in:14

Re: [PATCHES] [HACKERS] Makefile.PL for Pg.so

2001-09-07 Thread Peter Eisentraut
Bruce Momjian writes: > Can someone comment on this? It's done. > > > > I made the following patch, and it works for MY platform. > > > > Peter, > > Can we do something similar for the distribution to set the > > RUNPATH for Pg.so? > > > > > > Index: Makefile.PL > >

Re: [HACKERS] autoconf on server

2001-09-07 Thread Peter Eisentraut
Bruce Momjian writes: > Marc, can we get the proper autoconf on postgresql.org so I can run > autoconf. I have autoconf here but am getting errors running it: > > #$ autoconf > configure.in:139: /usr/contrib/bin/gm4: Non-numeric argument to built-in > `divert' > configure.in:146: /usr/contrib/bi

Re: [HACKERS] CVS access

2001-09-07 Thread Marc G. Fournier
with the new passowwrd, your problem should be resolved too ... is it not? On Fri, 7 Sep 2001, D'Arcy J.M. Cain wrote: > Thus spake Marc G. Fournier > > okay, is this still a problem, and is this with the new password that I > > issued/email'd about a couple of weeks back? > > Are you also addr

Re: [HACKERS] Makefile.PL for Pg.so

2001-09-07 Thread Larry Rosenman
I think peter_e dealt with this LER * Bruce Momjian <[EMAIL PROTECTED]> [010907 13:25]: > > Can someone comment on this? > > > > I made the following patch, and it works for MY platform. > > > > Peter, > > Can we do something similar for the distribution to set the > > RUNPATH for Pg

Re: [HACKERS] Makefile.PL for Pg.so

2001-09-07 Thread Bruce Momjian
Can someone comment on this? > I made the following patch, and it works for MY platform. > > Peter, > Can we do something similar for the distribution to set the > RUNPATH for Pg.so? > > > Index: Makefile.PL > === > RCS fil

[HACKERS] autoconf on server

2001-09-07 Thread Bruce Momjian
Marc, can we get the proper autoconf on postgresql.org so I can run autoconf. I have autoconf here but am getting errors running it: #$ autoconf configure.in:139: /usr/contrib/bin/gm4: Non-numeric argument to built-in `divert' configure.in:146: /usr/contrib/bin/gm4: Non-numeric argument to built

Re: [HACKERS] Why "ERROR: dtoi4: integer out of range" on pg_dump

2001-09-07 Thread Martin Weinberg
Thanks, Tom! This was the problem. Here is my patch to pg_dump.c that appears to fix the problem. Turns out that the oid needed to be coerced in two places. --- --- pg_dump.c Thu Sep 6 21:18:21 2001 +++ pg_dump.c.ori

Re: [HACKERS] [BUGS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing no failure here with enable-multibyte and enable-locale. > > Can you update cvs, do a make clean, and try again. > > pg_encoding builds okay here. > > I think Marc said something about having recently changed the anon-CVS > server to be

Re: [HACKERS] CVS ODBC does not compile

2001-09-07 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > The current CVS tree does not compile ODBC. All sorts of failure due to > > const and undefined variables. > > I just got a ton of errors in odbc too, trying to build it with HP's cc. > I have not tried to build ODBC at all lately, so I'm not sure

Re: [HACKERS] CVS ODBC does not compile

2001-09-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > The current CVS tree does not compile ODBC. All sorts of failure due to > const and undefined variables. I just got a ton of errors in odbc too, trying to build it with HP's cc. I have not tried to build ODBC at all lately, so I'm not sure how new the

Re: [HACKERS] [BUGS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing no failure here with enable-multibyte and enable-locale. > > Can you update cvs, do a make clean, and try again. > > pg_encoding builds okay here. > > I think Marc said something about having recently changed the anon-CVS > server to be

Re: [HACKERS] [BUGS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I am seeing no failure here with enable-multibyte and enable-locale. > Can you update cvs, do a make clean, and try again. pg_encoding builds okay here. I think Marc said something about having recently changed the anon-CVS server to be a mirror of the

Re: [HACKERS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Larry Rosenman
Still Fails here LER * Bruce Momjian <[EMAIL PROTECTED]> [010907 11:27]: > > I am seeing no failure here with enable-multibyte and enable-locale. > Can you update cvs, do a make clean, and try again. > > > * Marc G. Fournier <[EMAIL PROTECTED]> [010907 10:06]: > > > CVSROOT: /home/project

Re: [HACKERS] backend hba.c prob

2001-09-07 Thread Patrick Welche
On Fri, Sep 07, 2001 at 10:14:27AM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > hba.c: In function `ident_unix': > > hba.c:923: sizeof applied to an incomplete type > > > Now, the problem is sizeof(Cred), typedef struct cmsgcred Cred, and I don't > > have a cmsgcred any

Re: [HACKERS] PL/pgSQL bug?

2001-09-07 Thread Bruce Momjian
I am not sure if there is a TODO item here, but if there is, please let me know. Thanks. > > -Original Message- > > From: Tom Lane > > > > I believe the reason for this is that in Read Committed mode, > > each separate query from the client computes a new snapshot (see > > SetQuerySna

Re: [HACKERS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Bruce Momjian
I am seeing no failure here with enable-multibyte and enable-locale. Can you update cvs, do a make clean, and try again. > * Marc G. Fournier <[EMAIL PROTECTED]> [010907 10:06]: > > CVSROOT:/home/projects/pgsql/cvsroot > > Module name:pgsql > > Changes by: [EMAIL PROTECTED] 01/09/07

[HACKERS] CVS ODBC does not compile

2001-09-07 Thread Bruce Momjian
The current CVS tree does not compile ODBC. All sorts of failure due to const and undefined variables. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ

Re: [HACKERS] backend hba.c prob

2001-09-07 Thread bpalmer
On Fri, 7 Sep 2001, Bruce Momjian wrote: > > gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations >-I../../../src/include -c -o hba.o hba.c > > hba.c: In function `ident_unix': > > hba.c:923: sizeof applied to an incomplete type > > hba.c:960: dereferencing pointer to incomplete

Re: [HACKERS] CVS access

2001-09-07 Thread D'Arcy J.M. Cain
Thus spake Marc G. Fournier > okay, is this still a problem, and is this with the new password that I > issued/email'd about a couple of weeks back? Are you also addressing my problem connecting? -- D'Arcy J.M. Cain| Democracy is three wolves http://www.druid.net/darcy/| a

Re: [HACKERS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Larry Rosenman
* Marc G. Fournier <[EMAIL PROTECTED]> [010907 10:06]: > CVSROOT: /home/projects/pgsql/cvsroot > Module name: pgsql > Changes by: [EMAIL PROTECTED] 01/09/07 11:01:45 > > Modified files: > src/backend/utils/mb: encnames.c > > Log message: > Remove variable length macros used

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Bruce Momjian
> On Fri, Sep 07, 2001 at 10:39:19AM -0400, Bruce Momjian wrote: > > > Karel Zak <[EMAIL PROTECTED]> writes: > > > >> But here is the tail of the output: > > > >> UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled > > > >> UX:acomp: ERROR: "encnames.c", line 36: syntax erro

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Peter Eisentraut
Karel Zak writes: > > But here is the tail of the output: > > UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled > > UX:acomp: ERROR: "encnames.c", line 36: syntax error in macro parameters > ^ > Here is: > > /* #define DEBUG_ENCODING */ > #i

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Bruce Momjian
> > I am looking at how to get it compiling right away. > > Hmm.. my world is comiled by 'gcc' and I'm still must learning that > here are some cathedrals and not bazaars only :-) Sorry. > > OK, please erase all these debug macros (encdebug). I used it for binary > search check only. It's no

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Karel Zak
On Fri, Sep 07, 2001 at 10:39:19AM -0400, Bruce Momjian wrote: > > Karel Zak <[EMAIL PROTECTED]> writes: > > >> But here is the tail of the output: > > >> UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled > > >> UX:acomp: ERROR: "encnames.c", line 36: syntax error in macro

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Tom Lane
Karel Zak <[EMAIL PROTECTED]> writes: >> But here is the tail of the output: >> UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled >> UX:acomp: ERROR: "encnames.c", line 36: syntax error in macro parameters > ^ > #define encdebug(_format, _a..

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Thomas Lockhart
> I'll keep trying to clean up loose ends, but I wonder if we should put > it off a few days more. There's still a long list of unreviewed patches > and undone todo items... *sigh* I'd like a few more days also. I've got "timestamp with time zone" work to do, and unexpectedly may not have the t

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Bruce Momjian
> Karel Zak <[EMAIL PROTECTED]> writes: > >> But here is the tail of the output: > >> UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled > >> UX:acomp: ERROR: "encnames.c", line 36: syntax error in macro parameters > > ^ > > > #define encdebug

Re: [HACKERS] backend hba.c prob

2001-09-07 Thread Bruce Momjian
> gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations >-I../../../src/include -c -o hba.o hba.c > hba.c: In function `ident_unix': > hba.c:923: sizeof applied to an incomplete type > hba.c:960: dereferencing pointer to incomplete type > hba.c:965: dereferencing pointer to incompl

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Larry Rosenman
* Karel Zak <[EMAIL PROTECTED]> [010907 09:00]: > On Fri, Sep 07, 2001 at 07:31:50AM -0500, Larry Rosenman wrote: > > * Bruce Momjian <[EMAIL PROTECTED]> [010906 23:45]: > > > > > > > > > Oh, I see. Can you send an detailed email to hackers to Tatsuo can get > > > it fixed? If we have to back

Re: [HACKERS] byteain bug(?)

2001-09-07 Thread Bruce Momjian
> > > > > It checks for a '\' followed by three digits, but does not attempt > to > > > > > enforce that the three digits actually produce a valid octal number. > > > Anyone > > > > > object to me fixing this? > > > > > > > > > > > Based on the thread this morning on patches, I was thinking we sho

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Bruce Momjian
> I check current CVS and encoding names patch was commit incorrect! > > Well, again: > > * following files are renamed (see mb/Unicode > -- is needful do: > > cvs remove src/utils/mb/Unicode/KOI8_to_utf8.map > cvs addsrc/utils/mb/Unicode/koi8r_to_utf8.map > > cvs remove src/u

Re: [HACKERS] backend hba.c prob

2001-09-07 Thread Tom Lane
Patrick Welche <[EMAIL PROTECTED]> writes: > hba.c: In function `ident_unix': > hba.c:923: sizeof applied to an incomplete type > Now, the problem is sizeof(Cred), typedef struct cmsgcred Cred, and I don't > have a cmsgcred anywhere! That's new code and we expected some portability issues with i

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Karel Zak
On Fri, Sep 07, 2001 at 07:31:50AM -0500, Larry Rosenman wrote: > * Bruce Momjian <[EMAIL PROTECTED]> [010906 23:45]: > > > > > > Oh, I see. Can you send an detailed email to hackers to Tatsuo can get > > it fixed? If we have to back it out, we will. > > > > Monday is not written in stone. I

Re: [HACKERS] Log rotation?

2001-09-07 Thread Peter Eisentraut
Christopher Kings-Lynne writes: > Yeah, I use FreeBSD's wonderful newsyslog utility, and I do my logging like > this: > > su -l pgsql -c '[ -d ${PGDATA} ] && exec /usr/local/bin/pg_ctl > start -s -w -o "-i" -l /var/log/pgsql.log' > > And my /etc/newsyslog.conf entry: > > /var/log/pgsql.log p

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > Is the schedule still to go beta Monday? > > Well, I dunno about you, but I've had a few distractions to deal with > over the past couple days ;-) > > I'll keep trying to clean up loose ends, but I wonder if we should put > it off a few days more.

Re: [HACKERS] [Pgreplication-general] GreatBridge ceases operations

2001-09-07 Thread Jan Wieck
Mark Pritchard wrote: > Hi Darren, > > I'd be interested in finding out what your usage stats are, and any > requirements for hosting the replication content. > > As qualification, we maintain an infrastructure at GlobalCentre (a child > company of http://www.exodus.com/ ) This hosting facility al

[HACKERS] backend hba.c prob

2001-09-07 Thread Patrick Welche
gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include -c -o hba.o hba.c hba.c: In function `ident_unix': hba.c:923: sizeof applied to an incomplete type hba.c:960: dereferencing pointer to incomplete type hba.c:965: dereferencing pointer to incomplete type gm

Re: [HACKERS] Beta Monday?

2001-09-07 Thread Larry Rosenman
* Bruce Momjian <[EMAIL PROTECTED]> [010906 23:45]: > > > Oh, I see. Can you send an detailed email to hackers to Tatsuo can get > it fixed? If we have to back it out, we will. > > Monday is not written in stone. If people want it later, we can do > that. Having it compile is a beta require