[COMMITTERS] pgsql-server/src/include/catalog Tag: REL7_4_S ...

2003-11-11 Thread Tom Lane
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/11 17:23:26

Modified files:
src/include/catalog: Tag: REL7_4_STABLE pg_amop.h 

Log message:
Fix thinko in reltime and tinterval operator classes that I added a
couple months ago: the >= and > operators were swapped.  Not worth
forcing an initdb for this, but we should get it right in the release.
Will be patched separately in HEAD.


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/src/backend/postmaster Tag: REL7_ ...

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/11 17:37:35

Modified files:
src/backend/postmaster: Tag: REL7_4_STABLE postmaster.c 

Log message:
Default ioctlsocket_ret to 1 in case Cygwin needs it for 7.4 --- already
in HEAD.


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql-server/src/port copydir.c dirmod.c getho ...

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/11 19:52:45

Modified files:
src/port   : copydir.c dirmod.c gethostname.c getrusage.c 
 isinf.c path.c random.c sprompt.c srandom.c 
 strcasecmp.c strdup.c strtol.c 

Log message:
Update /port C header descriptions.


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/src/backend/utils/init findbe.c

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/11 20:04:10

Modified files:
src/backend/utils/init: findbe.c 

Log message:
Cleanup for recent .exe Win32 fix.


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/doc TODO

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/11 20:25:35

Modified files:
doc: TODO 

Log message:
Update:

> * Add free-behind capability for large sequential scans (fadvise)


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server/contrib/start-scripts PostgreSQL. ...

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/11 23:27:27

Modified files:
contrib/start-scripts: PostgreSQL.darwin 

Log message:
Typo fix in comment from David Wheeler


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[COMMITTERS] pgsql-server/contrib/start-scripts Tag: REL7_4 ...

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/11 23:28:45

Modified files:
contrib/start-scripts: Tag: REL7_4_STABLE PostgreSQL.darwin 

Log message:
Typo fix in comment from David Wheeler


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [COMMITTERS] pgsql-server/doc TODO

2003-11-11 Thread Neil Conway
[EMAIL PROTECTED] (Bruce Momjian) writes:
>   > * Add free-behind capability for large sequential scans
>   > * (fadvise)

This isn't really what posix_fadvise() is intended for, I believe (or
rather, I can't figure out a way for us to be able to use it in that
manner). Check the posix_fadvise() discussion on -hackers for more
details.

-Neil


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

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


Re: [COMMITTERS] pgsql-server/doc TODO

2003-11-11 Thread Bruce Momjian
Neil Conway wrote:
> [EMAIL PROTECTED] (Bruce Momjian) writes:
> > > * Add free-behind capability for large sequential scans
> > > * (fadvise)
> 
> This isn't really what posix_fadvise() is intended for, I believe (or
> rather, I can't figure out a way for us to be able to use it in that
> manner). Check the posix_fadvise() discussion on -hackers for more
> details.

Yes, I guess it should be "Better inform kernel on which pages to
cache".  Is that right?

-- 
  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


[COMMITTERS] pgsql-server/doc/src/sgml/ref create_table.sgml

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/12 00:08:08

Modified files:
doc/src/sgml/ref: create_table.sgml 

Log message:
Here's a patch that adds some text mentioning that
RESTRICT is not deferrable to the create table reference
page.

Stephan Szabo


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql-server/doc/src/sgml/ref Tag: REL7_4_STAB ...

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/12 00:08:14

Modified files:
doc/src/sgml/ref: Tag: REL7_4_STABLE create_table.sgml 

Log message:
Here's a patch that adds some text mentioning that
RESTRICT is not deferrable to the create table reference
page.

Stephan Szabo


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


[COMMITTERS] pgsql-server/doc TODO

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/12 00:10:43

Modified files:
doc: TODO 

Log message:
Add:

> * Ignore temporary tables from other session when processing inheritance


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql-server/doc Tag: REL7_4_STABLE FAQ_MSWIN

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/12 00:14:34

Modified files:
doc: Tag: REL7_4_STABLE FAQ_MSWIN 

Log message:
Here's some improvements.  I just ended up referring people to Jason's
website for install as service, because it's a quite a long and complex
process.

Christopher Kings-Lynne


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


[COMMITTERS] pgsql-server/doc FAQ_MSWIN

2003-11-11 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/11/12 00:14:30

Modified files:
doc: FAQ_MSWIN 

Log message:
Here's some improvements.  I just ended up referring people to Jason's
website for install as service, because it's a quite a long and complex
process.

Christopher Kings-Lynne


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

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


Re: [COMMITTERS] pgsql-server/src/backend/postmaster postmaster.c

2003-11-11 Thread Bruce Momjian

I have added this to my personal TODO list.  Thanks.

---

Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > We define the variable only on Win32/BeOS.  Any ideas on how to do this
> > better?
> 
> int
> set_non_blocking(some_type socket)
> {
> int ret;
> 
> #ifdef SOME_UNIX_PLATFORM
> ret  = ...;
> #else
> 
> #ifdef SOME_WINDOWS_PLATFORM
> ret = ...;
> #else
> ret = ...;
> #endif
> 
> return ret;
> }
> 
> This function shouldn't be in the critical path for anything, so ISTM
> that we can hide this platform-specific ugliness inside a function
> without any harm.
> 
> -Neil
> 

-- 
  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 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly