Re: [COMMITTERS] pgsql-server/src/template bsdi freebsd netbsd ...

2003-10-09 Thread Bruce Momjian
Neil Conway wrote:
> On Thu, 2003-10-09 at 00:34, Bruce Momjian wrote:
> > Re-add -pipe compile flags for bsd's.
> 
> Is there a particular reason this flag is used for these platforms?
> 
> (For one thing, -pipe certainly works with GCC on Linux.)

I only put back what was already there --- not sure why others don't use
it.  You want it enabled on Linux?

-- 
  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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server/contrib/pg_dumplo utils.c

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 10:38:05

Modified files:
contrib/pg_dumplo: utils.c 

Log message:
Someone report  me small  bug in contrib/pg_dumplo  today. It's problem
with a little dirty snprintf() usage which I used some years ago:

snprintf(path, BUFSIZ, "%s/lo_dump.index", path);

Karel Zak


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

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


Re: [COMMITTERS] pgsql-server/src/template bsdi freebsd netbsd ...

2003-10-09 Thread Neil Conway
On Thu, 2003-10-09 at 09:35, Bruce Momjian wrote:
> I only put back what was already there --- not sure why others don't use
> it.  You want it enabled on Linux?

Well, why do we have it enabled at all? If it's to speed compilation, we
may as well enable it on other platforms where -pipe works, of which
Linux is one.

-Neil



---(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/src/template aix cygwin freebsd h ...

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

Modified files:
src/template   : aix cygwin freebsd hpux osf solaris univel 
 unixware 

Log message:
Make template CFLAGS handling consistent.


---(end of broadcast)---
TIP 8: explain analyze is your friend


[COMMITTERS] pgsql-server/src/template linux

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

Modified files:
src/template   : linux 

Log message:
Add -pipe compile for Linux.


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


[COMMITTERS] pgsql-server/src/template linux

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

Modified files:
src/template   : linux 

Log message:
Remove -pipe on Linux, per reports from Peter.


---(end of broadcast)---
TIP 8: explain analyze is your friend


[COMMITTERS] pgsql-server/ oc/FAQ_Solaris rc/template/bsdi

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

Modified files:
doc: FAQ_Solaris 
src/template   : bsdi 

Log message:
Update Solaris FAQ to mention -fast.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server/doc/src/sgml maintenance.sgml run ...

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 16:05:10

Modified files:
doc/src/sgml   : maintenance.sgml runtime.sgml 

Log message:
Add mention of logrotate for syslog, from Robert Treat


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server/src/backend/catalog sql_features.txt

2003-10-09 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 16:11:03

Modified files:
src/backend/catalog: sql_features.txt 

Log message:
Some updates


---(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/src/backend/parser scan.l

2003-10-09 Thread Peter Eisentraut - PostgreSQL
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 16:13:24

Modified files:
src/backend/parser: scan.l 

Log message:
Make sure that -- comments extend to the end of the line.  This fixes the
misscanning of this construct:

SELECT ''hello world''
-- SELECT ''goodbye world''
::text;


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


[COMMITTERS] pgsql-server/doc/src/sgml datatype.sgml

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 16:13:48

Modified files:
doc/src/sgml   : datatype.sgml 

Log message:
About section 8.5.1.5. ("Special Values"):

I suggest adding LOCALTIMESTAMP and LOCALTIME to the first paragraph.
Maybe it should be phrased as:

The following SQL-compatible functions can be used to obtain
current datetime-related values: CURRENT_DATE, CURRENT_TIME,
CURRENT_TIMESTAMP, LOCALTIME and LOCALTIMESTAMP.
(See Section 9.8.4.)

Troels Arvin


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

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


[COMMITTERS] pgsql-server/doc TODO

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 16:36:27

Modified files:
doc: TODO 

Log message:
Add:

> * Have VACUUM FULL use REINDEX rather than index vacuum


---(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/src/template aix bsdi freebsd net ...

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 19:55:46

Modified files:
src/template   : aix bsdi freebsd netbsd openbsd 

Log message:
Remove -pipe from compiles.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server/doc TODO

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

Modified files:
doc: TODO 

Log message:
Add:

>   o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]


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


[COMMITTERS] pgsql-server/src/bin/pg_id pg_id.c

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 22:34:51

Modified files:
src/bin/pg_id  : pg_id.c 

Log message:
Allow pg_id to compile on Win32.

Andrew Dunstan


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server/doc TODO

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 22:52:15

Modified files:
doc: TODO 

Log message:
Add TODO.detail for count(*):

>   to allow fast COUNT(*) queries with no WHERE clause(?) [count]


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


[COMMITTERS] pgsql-server/doc/TODO.detail count

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 22:53:06

Added files:
doc/TODO.detail: count 

Log message:
Add count(*) TODO detail.


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/doc/src/sgml perform.sgml runtime ...

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 23:08:42

Modified files:
doc/src/sgml   : perform.sgml runtime.sgml 

Log message:
> That's a fairly useless place to put it, though, since someone would
> only think to look at sort_mem if they already had a clue.  It should
> be mentioned under bulk data load (in performance tips chapter)

Attached is a doc patch that does this. The way I've worded it may not
be the best, though.

Neil Conway


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server/doc TODO

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

Modified files:
doc: TODO 

Log message:
Add:

> * Prevent libpq's PQfnumber() from lowercasing the column name
572d572
< * Vadim is Vadim B. Mikheev <[EMAIL PROTECTED]> of Sector Data


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

   http://archives.postgresql.org


[COMMITTERS] pgsql-server/doc FAQ_russian src/FAQ/FAQ_russi ...

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/09 23:52:12

Modified files:
doc: FAQ_russian 
doc/src/FAQ: FAQ_russian.html 

Log message:
Update Russian FAQ.

Viktor Vislobokov


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[COMMITTERS] pgsql-server/src/port Tag: WIN32_DEV dirmod.c

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/10 00:28:24

Modified files:
src/port   : Tag: WIN32_DEV dirmod.c 

Log message:
Change Win32 rename/unlink timeout to 3 seconds.


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


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

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/10 00:27:59

Modified files:
src/port   : dirmod.c 

Log message:
Change Win32 rename/unlink timeout to 3 seconds.


---(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/src/test/regress expected/copy2.o ...

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/10 00:46:52

Modified files:
src/test/regress/expected: copy2.out 
src/test/regress/sql: copy2.sql 

Log message:
Add NULL regression tests.

Manfred Koizar


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

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


[COMMITTERS] pgsql-server/src/include/storage s_lock.h

2003-10-09 Thread Bruce Momjian
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED]   03/10/10 00:58:57

Modified files:
src/include/storage: s_lock.h 

Log message:
Rename __arm__/__arm__ to __arm__/__arm, found by Neil Conway


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