Re: [PATCHES] Unix timestamp - timestamp, per Tom Lane :)

2003-12-17 Thread Bruce Momjian

Applied by Peter.

---

David Fetter wrote:
 Folks,
 
 'nother one.  Thanks very much, Tom! :)
 
 Cheers,
 D
 -- 
 David Fetter [EMAIL PROTECTED] http://fetter.org/
 phone: +1 510 893 6100cell: +1 415 235 3778

[ Attachment, skipping... ]

 
 ---(end of broadcast)---
 TIP 5: Have you checked our extensive FAQ?
 
http://www.postgresql.org/docs/faqs/FAQ.html

-- 
  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)---
TIP 8: explain analyze is your friend


Re: [PATCHES] fork/exec patch

2003-12-17 Thread Bruce Momjian
Claudio Natoli wrote:
 
 [Thought I replied to this already]
 
  I am now thinking we have to remove pgsql/data/pgsql_tmp
  unconditionally:
  [snip]
  The reason is that if they stop a postmaster that is 
  fork/exec, install
  a non-exec postmaster, and restart, we should still clear out that
  directory.  I guess what i am saying is that I don't want to tie the
  directory format to the exec() case of the binary.
 
 Could do. On the other hand, it is a directory for a small number (usually
 zero) of tmp files.
 
 More pertitently, is *anyone* even going to use fork/exec? Whilst there is
 no reason (yet) why someone couldn't, other than for development, why would
 anyone want to? I've only really been seeing it as a stepping stone to
 pushing the Win32 port out...

Agreed.  Forget my idea.

-- 
  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)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [PATCHES] fork/exec patch

2003-12-17 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.

---


Claudio Natoli wrote:
 
 Resubmission, incorporating Neil Conway's comments and some minor
 corrections.
 
  -Original Message-
  From: Bruce Momjian [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, 17 December 2003 11:12 AM
  To: Claudio Natoli
  Cc: '[EMAIL PROTECTED]'
  Subject: Re: [PATCHES] fork/exec patch
  
  
  
  Patch withdrawn.  Author will resubmit new version.
  
  --
  -
  
  Claudio Natoli wrote:
   
   This patch is the next step towards (re)allowing fork/exec.
   
   Bruce, I've cleaned up the parts we discussed, and, pending 
  objections from
   anyone else, it is ready for application to HEAD.
   
   Cheers,
   Claudio
   
   --- 
   Certain disclaimers and policies apply to all email sent 
  from Memetrics.
   For the full text of these disclaimers and policies see 
   a
   
  href=http://www.memetrics.com/emailpolicy.html;http://www.me
  metrics.com/em
   ailpolicy.html/a
 
   
  
  [ Attachment, skipping... ]
  
   
   ---(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 backup.|  Newtown Square, 
  Pennsylvania 19073
  
 
 --- 
 Certain disclaimers and policies apply to all email sent from Memetrics.
 For the full text of these disclaimers and policies see 
 a
 href=http://www.memetrics.com/emailpolicy.html;http://www.memetrics.com/em
 ailpolicy.html/a
   
 

[ 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 life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [PATCHES] Double Backslash example patch

2003-12-17 Thread Bruce Momjian

I have applied your additional example in the place Peter suggested. 
Patch attached.

---

David Fetter wrote:
 Kind people,
 
 Please find enclosed a patch exemplifying typical use of the ARE
 Class-Shorthand EscapesĀ®.  I believe it will help intrepid regex
 users. :)
 
 Cheers,
 D
 -- 
 David Fetter [EMAIL PROTECTED] http://fetter.org/
 phone: +1 510 893 6100cell: +1 415 235 3778

[ Attachment, skipping... ]

 
 ---(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 backup.|  Newtown Square, Pennsylvania 19073
Index: doc/src/sgml/func.sgml
===
RCS file: /cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.182
diff -c -c -r1.182 func.sgml
*** doc/src/sgml/func.sgml  16 Dec 2003 15:27:58 -  1.182
--- doc/src/sgml/func.sgml  18 Dec 2003 03:53:59 -
***
*** 3134,3140 
 note
  para
   Keep in mind that an escape's leading literal\/ will need to be
!  doubled when entering the pattern as an SQL string constant.
  /para
 /note
  
--- 3134,3143 
 note
  para
   Keep in mind that an escape's leading literal\/ will need to be
!  doubled when entering the pattern as an SQL string constant.  For example:
! programlisting
! '123' ~ '^\\d{3}' lineannotationtrue/lineannotation
! /programlisting
  /para
 /note
  

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings