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] libpq.dll (Win32) for rel. 7.3.2 missing some exports

2003-06-23 Thread Bruce Momjian
*** 3 errors in Compile *** I updated with WinCVS to get the clean copy. Karl -- 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] 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] ipv6 patch #3

2003-06-24 Thread Bruce Momjian
(addr) = 4 ... Order by and other bits should all work. Regression tests pass, at least on my NetBSD machine. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts

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

Re: [PATCHES] ipv6 patch #3

2003-06-25 Thread Bruce Momjian
OK, done. --- Michael Graff wrote: Ok, I think the ,bits part was in error. Go ahead and remove the %d and the ,bits part. --Michael Bruce Momjian [EMAIL PROTECTED] writes: Index: src/backend/utils/adt

[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] [NOVICE] connectby(... pos_of_sibling)

2003-07-19 Thread Bruce Momjian
int, pos int) ORDER BY t.pos; -- test connectby with int based hierarchy CREATE TABLE connectby_int(keyid int, parent_keyid int); -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

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

2003-07-19 Thread Bruce Momjian
Tom Lane wrote: This reminds me, someone (Barry?) was griping that SHOW DATESTYLE doesn't produce a value that SET DATESTYLE will take. Did we agree that it was OK to change the output to look like ISO, US etc? Is this a TODO? -- Bruce Momjian| http

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

2003-07-19 Thread Bruce Momjian
an index scan if your joining column's datatypes do not match -- 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] src/bin/psql/input.c

2003-07-19 Thread Bruce Momjian
constants. -- 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-1001 + If your life is a hard

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] ruleutils with pretty-print option

2003-07-19 Thread Bruce Momjian
Sorry I am getting to this patch late. I know you posted a newer version, but this one has a better description. I am uncertain if we are over-engineering the interface by having three ways to control the output. Is that valuable? If it is, fine, but if it isn't, the extra code just adds to

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] fix for plpgsql polymorphism

2003-07-20 Thread Bruce Momjian
); ---(end of broadcast)--- TIP 4: Don't 'kill -9' 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

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

2003-07-20 Thread Bruce Momjian
. Content-Description: [ 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 PROTECTED

Re: [PATCHES] [BUGS] pg_tables view definition incorrect??

2003-07-21 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] createlang/droplang fix

2003-07-21 Thread Bruce Momjian
, but were not implemented) Hope this helps, Christoph Dalitz [ Attachment, skipping... ] [ Attachment, skipping... ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts

Re: [PATCHES] [GENERAL] [BUGS] pg_tables view definition incorrect??

2003-07-21 Thread Bruce Momjian
? regards, tom lane ---(end of broadcast)--- 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

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: [PATCHES] [HACKERS] clock_timestamp() and transcation_timestamp() patch

2003-07-23 Thread Bruce Momjian
Explorer: http://explorer.msn.com/lccn/ [ 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 PROTECTED

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] Datetime patch

2003-07-29 Thread Bruce Momjian
/AHNDvJuQZxSWSsgRApuiAKDB5CcBTxwQBnOdRkzPpLCOKHMmNgCeLJ// Nz5sB+KyQUWv+MEVLXztBJw= =kXb4 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend [ Decrypting message... End of raw data. ] -- Bruce Momjian| http

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

Re: [PATCHES] fix compile warning in pg_id

2003-08-10 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

[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] [HACKERS] Are we losing momentum?

2003-08-16 Thread Bruce Momjian
an appropriate 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

Re: [PATCHES] Added comments to postgresql.conf file

2003-08-16 Thread Bruce Momjian
://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] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

2003-08-16 Thread Bruce Momjian
. Err.. and attached. -sc -- Sean Chittenden [ Attachment, skipping... ] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us

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] misc doc fixes

2003-08-16 Thread Bruce Momjian
of the client apps (3) Adds a link to the libpq docs in the vacuumdb ref page. -Neil [ Attachment, skipping... ] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian

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] Minor verbosity increase for analyze

2003-08-26 Thread Bruce Momjian
; } ---(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 life is a hard drive, | 13 Roberts Road

Re: [PATCHES] Minor verbosity increase for analyze

2003-08-26 Thread Bruce Momjian
an appropriate 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

Re: [PATCHES] add (minimal) UPDATE regression test

2003-08-26 Thread Bruce Momjian
/regress/expected/update.out) -Neil [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http

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

2003-08-26 Thread Bruce Momjian
, and it shall be opened unto you... (MAT 7:7) ANT17-RIPE ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED

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

  1   2   3   4   5   6   7   8   9   10   >