Re: [PATCHES] LIKE subtable (second attempt)

2003-06-23 Thread Bruce Momjian
. --- Rod Taylor wrote: -- Start of PGP signed section. On Thu, 2003-06-12 at 07:47, Bruce Momjian wrote: Rod, this patch now fails initdb. Can you send over a newer version? Seems my sql_features.txt update was wrong. Patch attached. I had a regression failure, but reran make check 10

Re: [PATCHES] [HACKERS] MARKED_FOR_UPDATE XMAX_COMMITTED == XMAX_INVALID ?

2003-06-23 Thread Bruce Momjian
to the mailing list cleanly -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] ecpg compile (compatlib)

2003-06-23 Thread Bruce Momjian
)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] Adddepend

2003-06-23 Thread Bruce Momjian
://www.rbt.ca/rbtpub.asc [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] System Catalog Foreign Keys (linked)

2003-06-23 Thread Bruce Momjian
, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania

Re: [PATCHES] pg_hba.conf.sample

2003-06-23 Thread Bruce Momjian
patch to pg_hba.conf.sample that explains the use of CIDR addresses. I'm still working on a patch to the regular docs. cheers andrew [ Attachment, skipping... ] ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce

Re: [PATCHES] ecpg compile (compatlib)

2003-06-24 Thread Bruce Momjian
OK, ecpg patch applied. Thanks for the testing. --- Jason Tishler wrote: Bruce, On Tue, Jun 24, 2003 at 09:33:56AM -0400, Bruce Momjian wrote: My last question is do we have this covered in every other case except

Re: [PATCHES] perform.sgml update

2003-06-24 Thread Bruce Momjian
)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html [ Decrypting message... End of raw data. ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard

Re: [PATCHES] Runtime.SGML diff ... please expedite!

2003-06-24 Thread Bruce Momjian
section, PGP failed! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

[PATCHES] ecpg warning

2003-07-01 Thread Bruce Momjian
Michael, I am seeing this ecpg warning: informix.c:290: warning: `nres' might be used uninitialized in this function Can we initialize it to NULL to suppress the warning? Also, I fixed a typo where you had ;; instead of ; as a statement terminator. -- Bruce Momjian

Re: [PATCHES] Patch for listing runtime option details through server

2003-07-02 Thread Bruce Momjian
... ] [ Attachment, skipping... ] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your

Re: [PATCHES] [COMMITTERS] pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

2003-07-02 Thread Bruce Momjian
and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] [COMMITTERS] pgsql-server/ oc/src/sgml/runtime.sgml rc/back

2003-07-02 Thread Bruce Momjian
Yes, very minor and easy to fix. --- Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I have modifed this patch because MACHINE is defined in the BSD/OS system include files. I changed them to MACHINE_OUTPUT

[PATCHES] fix for new SUSET GUC variables

2003-07-09 Thread Bruce Momjian
the proper context for the postgres -d flag, and the bottom handles the new USERLIMIT context. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] [NOVICE] connectby(... pos_of_sibling)

2003-07-17 Thread Bruce Momjian
' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 diff -rc postgresql-7.3.3/contrib

[PATCHES] postgresql.conf formatting cleanup

2003-07-18 Thread Bruce Momjian
I have applied the following patch to improve the formating of postgresql.conf.sample. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [PATCHES] Adding Rendezvous support to postmaster

2003-07-18 Thread Bruce Momjian
because we don't do that with other options that aren't enabled by default, like SSL and Kerberos. --- Chris Campbell wrote: On Wednesday, Jun 11, 2003, at 10:43 US/Eastern, Bruce Momjian wrote: Bruce Momjian wrote: Tom

Re: [PATCHES] [NOVICE] connectby(... pos_of_sibling)

2003-07-18 Thread Bruce Momjian
? --- Joe Conway wrote: Bruce Momjian wrote: Joe, would you comment on this change to tablefunc connectby? I actually tied up a few loose ends on this and submitted it to PATCHES on 6/26/2003. See: http://archives.postgresql.org/pgsql-patches/2003-06

Re: [PATCHES] timetravel.c

2003-07-19 Thread Bruce Momjian
? Sorry for my english Zoltan ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [PATCHES] [HACKERS] allowed user/db variables

2003-07-20 Thread Bruce Momjian
Oh, I see now. My new 'make check' script doesn't install a new version in my standard path but just in the regression database. I see what you see now. --- Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom

Re: [PATCHES] timestamp date_trunc('quarter',...)

2003-07-20 Thread Bruce Momjian
; case DTK_YEAR: ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED

Re: [PATCHES] patch for Oracle initcap compatibility

2003-07-21 Thread Bruce Momjian
*ptr = tolower((unsigned char) *ptr); ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359

Re: [PATCHES] psql patches for win32

2003-07-21 Thread Bruce Momjian
Christoph Dalitz PS: How was your talk at LinuxTag? Was there strong interest in PostgreSQL? [ Attachment, skipping... ] [ Attachment, skipping... ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your

Re: [PATCHES] nitpick consistency patch for pg_dump.c

2003-07-21 Thread Bruce Momjian
); /* * DROP must be fully qualified in case same name appears in ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce

Re: [PATCHES] Adding Rendezvous support to postmaster

2003-07-21 Thread Bruce Momjian
: On Monday, Jul 21, 2003, at 21:17 US/Eastern, Bruce Momjian wrote: Again, why does the current code pass NULL as the first param --- that was from your orignal patch. The original patch passed the service_name variable (which you've now renamed rendezvous_name) as the first parameter. I'm

Re: [PATCHES] ruleutils with pretty-print option

2003-07-21 Thread Bruce Momjian
, (); --- appendStringInfoChar(buf, '('); -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square

Re: [PATCHES] timetravel.c

2003-07-22 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Böjthe Zoltán wrote: Bruce Momjian ?rta

Re: [PATCHES] ruleutils with pretty-print option

2003-07-22 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Andreas Pflug wrote: Bruce Momjian

Re: [PATCHES] ruleutils with pretty-print option

2003-07-22 Thread Bruce Momjian
Andreas Pflug wrote: Bruce Momjian wrote: Andreas, looks good, but I need a diff -c, context diff. Hi Bruce, I intentionally only attached only non-context diffs because the patch is about 50 % size of the original file. Now, here's the same as context diff. I understand. I

Re: [PATCHES] Adding Rendezvous support to postmaster

2003-07-22 Thread Bruce Momjian
) -- that should be if (rendezvous_name != NULL) since that variable's been renamed. Change that, and I'm happy. Thanks! - Chris On Monday, Jul 21, 2003, at 23:50 US/Eastern, Bruce Momjian wrote: OK, new patch attached, with the adjustment you suggested. We do probably have a few days

Re: [HACKERS] [PATCHES] PATCH: Memory leaks on start-up

2003-07-23 Thread Bruce Momjian
: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square

Re: [PATCHES] UPDATED Patch for adding DATACUBE operator

2003-07-24 Thread Bruce Momjian
PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [PATCHES] Datetime patch

2003-07-25 Thread Bruce Momjian
to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly [ Decrypting message... End of raw data. ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13

Re: [PATCHES] UPDATED Patch for adding DATACUBE operator

2003-07-25 Thread Bruce Momjian
On Fri, 25 Jul 2003, Bruce Momjian wrote: This looks good, but it is going to require more work, and we have run out of time for 7.4. This has been saved for the 7.5 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 Sorry

Re: [PATCHES] PG Patch (fwd) [openserver patch followup #2]

2003-07-25 Thread Bruce Momjian
to be sure you catch all the shared library file creations. Also, once we hard code it, you can't move the library around later if you wish. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

Re: [PATCHES] Datetime patch

2003-07-25 Thread Bruce Momjian
below. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: datetime.c

Re: [PATCHES] Datetime patch

2003-07-25 Thread Bruce Momjian
will modify the years to have the leading '19' so the regression tests will pass. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] src/bin/psql/input.c

2003-07-25 Thread Bruce Momjian
! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast

Re: [PATCHES] pg_dump fix

2003-07-25 Thread Bruce Momjian
other places as I went along (indenting) -- Rod Taylor [EMAIL PROTECTED] PGP Key: http://www.rbt.ca/rbtpub.asc [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359

Re: [PATCHES] Datetime patch

2003-07-25 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: INSERT INTO TIMESTAMP_TBL VALUES ('97/02/10 17:32:01 UTC'); + ERROR: Bad timestamp external representation '97/02/10 17:32:01 UTC' Again, this one should fail. It should? I think you're gonna have a lot of unhappy users

Re: [PATCHES] Minor pager corrections in print.c and help.c (psql)

2003-07-25 Thread Bruce Momjian
analyze is your friend [ Decrypting message... End of raw data. ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown

Re: [PATCHES] sslmode patch

2003-07-26 Thread Bruce Momjian
? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] Revised sslmode patch

2003-07-26 Thread Bruce Momjian
patch. Thanks, Jon Content-Description: [ Attachment, skipping... ] Content-Description: [ Attachment, skipping... ] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http

Re: [PATCHES] timestamp date_trunc('quarter',...)

2003-07-26 Thread Bruce Momjian
and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] fix linux startup script

2003-07-26 Thread Bruce Momjian
$DAEMON status -D '$PGDATA' ;; Regards, Slawomir Sudnik -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown

Re: [PATCHES] fix for plpgsql polymorphism

2003-07-26 Thread Bruce Momjian
, + var-refname); + } } ReleaseSysCache(typeTup); ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http

Re: [PATCHES] An additional foreign key test for regression

2003-07-26 Thread Bruce Momjian
)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] patch for Oracle initcap compatibility

2003-07-26 Thread Bruce Momjian
analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] psql patches for win32

2003-07-26 Thread Bruce Momjian
... ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [PATCHES] nitpick consistency patch for pg_dump.c

2003-07-26 Thread Bruce Momjian
)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

Re: [PATCHES] nitpick consistency patch for pg_dump.c

2003-07-26 Thread Bruce Momjian
of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [PATCHES] [NOVICE] connectby(... pos_of_sibling)

2003-07-26 Thread Bruce Momjian
, with orderby + SELECT * FROM connectby('connectby_text', 'keyid', 'parent_keyid', 'pos', 'row2', 0) AS t(keyid text, parent_keyid text, level int, pos int) ORDER BY t.pos; -- test connectby with int based hierarchy CREATE TABLE connectby_int(keyid int, parent_keyid int); -- Bruce

Re: [PATCHES] timetravel.c

2003-07-26 Thread Bruce Momjian
Patch applied. Thanks. --- Böjthe Zoltán wrote: Bruce Momjian ?rta: Great. Please send over the file as an attachment and I will see that it is added, or even better, use diff -c against the 7.3.2 version and your

Re: [HACKERS] [PATCHES] PATCH: Memory leaks on start-up

2003-07-26 Thread Bruce Momjian
of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-27 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: ! where reltype not in ('v','c') and Surely you meant relkind. Also, there is no 'c' relkind; perhaps you meant 's'? I think v,s,t are all relkinds to exclude here. Yes, sorry

Re: [PATCHES] ruleutils with pretty-print option

2003-07-27 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Are these illustrating a problem with the function definition, or is it happening because it is the first time we are calling the same function with one and more than one parameter? The function definition is broken. While it could

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-27 Thread Bruce Momjian
OK, change made and applied. --- Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I think v,s,t are all relkinds to exclude here. Is 't' for toast tables? If so, we should allow 't', no? I

Re: [PATCHES] ruleutils with pretty-print option

2003-07-27 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom, how do I pass PG_FUNCTION_ARGS to another function, while adding a new parameter? I wouldn't. Do the PG_GETARGS in the wrapper, and have the called function take a normal C parameter list. So I need to wrappers for each

Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

2003-07-30 Thread Bruce Momjian
feature. -sc -- Sean Chittenden [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

2003-07-30 Thread Bruce Momjian
subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road

Re: [PATCHES] updateable cursors

2003-07-30 Thread Bruce Momjian
-- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [PATCHES] ruleutils with pretty-print option

2003-07-30 Thread Bruce Momjian
editorializing. In particular, I don't believe the original did the right thing with (a - (b - c)). regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian

Re: [PATCHES] ruleutils with pretty-print option

2003-07-30 Thread Bruce Momjian
Patch applied, modified by Tom and myself. --- Andreas Pflug wrote: Bruce Momjian wrote: Andreas, looks good, but I need a diff -c, context diff. Hi Bruce, I intentionally only attached only non-context diffs

Re: [PATCHES] ruleutils with pretty-print option

2003-07-31 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I didn't like the functions ending in _ext. I renamed them to _pp for pretty print. Patch attached and applied. Seems to be shy a catversion bump; since you have just made an incompatible change in the internal-function-names array

Re: [PATCHES] ruleutils with pretty-print option

2003-07-31 Thread Bruce Momjian
command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown

Re: [PATCHES] updateable cursors

2003-07-31 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: This has been saved for the 7.5 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 Saved for? It's not gonna be acceptable in its current form for 7.5, either. I saved the patch plus your comments about it, so we can

Re: [PATCHES] fix compile warning in pg_id

2003-08-08 Thread Bruce Momjian
by removing the variable. -Neil [ Attachment, skipping... ] ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [PATCHES] UPDATED UnixWare Threads Patch.

2003-08-08 Thread Bruce Momjian
PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 [ Attachment, skipping... ] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [PATCHES] psql \d should use pg_get_viewdef (oid, true)

2003-08-09 Thread Bruce Momjian
-- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast

[PATCHES] threading NEED_REENTRANT_FUNC_NAMES patch

2003-08-16 Thread Bruce Momjian
Here is the threading patch I mentioned on hackers. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square

Re: [PATCHES] contrib/binarycopy

2003-08-16 Thread Bruce Momjian
\ cube\ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [PATCHES] COPY BINARY documentation

2003-08-16 Thread Bruce Momjian
---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] fix CLOSE ref page

2003-08-16 Thread Bruce Momjian
this (suggestions on better wording are welcome). -Neil [ Attachment, skipping... ] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [PATCHES] psql's HISTSIZE from .psqlrc do not want to be set

2003-08-16 Thread Bruce Momjian
: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square

Re: [PATCHES] libpq-win32 patches

2003-09-01 Thread Bruce Momjian
31 Aug 2003 23:22:31 - @@ -60,4 +60,9 @@ #include windows.h #endif +#include port/win32.h + +/* getpwuid doesn't exist under win32 */ +#define getpwuid(uid) NULL + #endif /* pg_config_h_win32__ */ * CVS exited normally with code 1 * -- Bruce Momjian

Re: [PATCHES] [HACKERS] [BUGS] 7.4 beta 1: SET log_statement=false

2003-09-03 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Yes, I have been thinking of that. The big question is whether a non-super user can control the reset value? He could (via PGOPTIONS) ... but since he can only increase it, there is nothing to fear. I have followed your suggestion

Re: [PATCHES] Warning for missing createlang

2003-09-04 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I have written a patch to issue an hint if someone tries to create a function in a language that isn't loaded into the database: ERROR: language plpgsql does not exist HINT: Perhaps you need to use 'createlang' to load

Re: [PATCHES] libpq with ssl under win32

2003-09-04 Thread Bruce Momjian
should be located. For NT/W2K and up, the natural way would be using GetUserProfileDirectory, but this would exclude Win9x. Can't we check the OS version via the compiler? Maybe not portabily between the various compilers supported. -- Bruce Momjian| http

Re: [PATCHES] libpq-win32 patches

2003-09-04 Thread Bruce Momjian
/win32.h + +/* getpwuid doesn't exist under win32 */ +#define getpwuid(uid) NULL + #endif /* pg_config_h_win32__ */ * CVS exited normally with code 1 * -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [PATCHES] postgresql-7.4b1 Native-Windows patch

2003-09-04 Thread Bruce Momjian
it into consideration as an information though it thinks whether it is during the progress. Regards, Hiroshi Saito [ Attachment, skipping... ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

Re: [PATCHES] doc patch - linux memory handling

2003-09-04 Thread Bruce Momjian
to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] IPV4 addresses on IPV6 machines in pg_hba.conf

2003-09-05 Thread Bruce Momjian
try to clean it up more, be my guest ... Would you like me to conditionally add the IPv6 line to pg_hba.conf from initdb now? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13

[PATCHES] MinGW patch

2003-09-06 Thread Bruce Momjian
to the screen (no prompt, no errors display), but the same binary runs fine in CMD.EXE. We can look at that later. I will update the WIN32 branch to match current CVS so all the Win32 fixes will be in that branch. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [PATCHES] MinGW patch

2003-09-07 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: In mbprint.c: + #ifndef PGSCRIPTS + #include settings.h + #endif Why is this needed, considering that the rest of the code was not changed to make use of any setting? The print modules in psql should not make use of psql-specific

Re: [PATCHES] WIN32_CONSOLE usage

2003-09-07 Thread Bruce Momjian
WIN32_CONSOLE When set with \set WIN32_console, the function OemToChar() Bruce Momjian writes: Is this a valid feature? Should I document it? Maybe it's a valid feature, but the implementation is not valid. Other applications also make use of the print routines (e.g., createlang

Re: [PATCHES] MinGW patch

2003-09-07 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: As Tom mentioned, it doesn't find things like sys/socket.h, which we have added to src/include/port/win32/. This was done to elimintate #ifdef of the include files that are Win32-specific. OK, then you can reference the top source

Re: [PATCHES] Minor lmgr code cleanup

2003-09-07 Thread Bruce Momjian
] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [PATCHES] Minor lmgr code cleanup

2003-09-08 Thread Bruce Momjian
Manfred, can I get a description for this patch? Thanks. --- Manfred Koizar wrote: On Mon, 8 Sep 2003 00:51:45 -0400 (EDT), Bruce Momjian [EMAIL PROTECTED] wrote: This has been saved for the 7.5 release: http

Re: [PATCHES] ISO 8601 Time Intervals of the format with time-unit

2003-09-08 Thread Bruce Momjian
); } else if (*cp == '\0') === ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian

Re: [PATCHES] ISO 8601 Time Intervals of the format with time-unit

2003-09-08 Thread Bruce Momjian
completely undocumented. If we're going to support the real ISO spec, I'd suggest ripping out any not-quite-there variant. (Especially so noting that your code seems a lot cleaner than the ptype stuff.) Agreed. Let me put your code in the queue for 7.5. -- Bruce Momjian

Re: [PATCHES] ISO 8601 Time Intervals of the format with time-unit

2003-09-08 Thread Bruce Momjian
: mailinglist etiquite question... for discussion, should I more this to hackers, or continue it here. Your choice, but you get a larger audience on hackers. I usually keep things on patches when I have lots of code to post, and other times move to hackers. -- Bruce Momjian

Re: [PATCHES] Minor lmgr code cleanup

2003-09-09 Thread Bruce Momjian
This has been saved for the 7.5 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 --- Manfred Koizar wrote: On Mon, 8 Sep 2003 13:02:11 -0400 (EDT), Bruce Momjian [EMAIL PROTECTED] wrote: Manfred, can I

Re: [PATCHES] [HACKERS] Index creation takes for ever

2003-09-07 Thread Bruce Momjian
Manfred Koizar wrote: On Sun, 7 Sep 2003 11:43:42 -0400 (EDT), Bruce Momjian [EMAIL PROTECTED] wrote: I assume this completes this TODO: * Order duplicate index entries by tid for faster heap lookups I don't think so, because the patch does nothing to keep the sort order once

Re: [PATCHES] Tiny doc improvement

2003-09-10 Thread Bruce Momjian
that pg_type_is_visible is used for domains as well. Chris Content-Description: [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce

Re: [PATCHES] [HACKERS] psql \h alter scrolls of screen

2003-09-11 Thread Bruce Momjian
Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: On Thu, 2003-09-04 at 21:14, Bruce Momjian wrote: Should we be using the pager for \h output? in 7.3.4 we do, let me check 7.4...seems to work, though I am on beta1 on this box. Hmm. I do not see the pager used for \h in either

Re: [PATCHES] fix doc typo

2003-09-11 Thread Bruce Momjian
)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] timetravel.c

2003-09-11 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Böjthe Zoltán wrote: Bruce Momjian ?rta

Re: [PATCHES] timetravel.c

2003-09-11 Thread Bruce Momjian
I had to modify your patch sligthly to fit more recent code changes --- updated version attached and applied. --- Böjthe Zoltán wrote: Bruce Momjian ?rta: Patch applied. Thanks

Re: [PATCHES] minor documentation improvements

2003-09-11 Thread Bruce Momjian
can get through to the mailing list cleanly -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania

[PATCHES] Reorganization of spinlock defines

2003-09-11 Thread Bruce Momjian
and test for HAS_TEST_AND_SET until configure completes. I plan to apply this to 7.4. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

  1   2   3   4   5   6   7   8   9   10   >