Re: [HACKERS] 7.4 status

2003-10-03 Thread Alvaro Herrera
While reviewing someone else's translation of pg_dump I noted that the
phrase ACL list is used in a couple of places.  However ACL stands for
Access Control List, so the term ACL list seems redundant.

Maybe it should be replaced with plain ACL?

-- 
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
I think my standards have lowered enough that now I think 'good design'
is when the page doesn't irritate the living f*ck out of me. (JWZ)

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


Re: [HACKERS] 7.4 status

2003-10-03 Thread Peter Eisentraut
Alvaro Herrera writes:

 While reviewing someone else's translation of pg_dump I noted that the
 phrase ACL list is used in a couple of places.  However ACL stands for
 Access Control List, so the term ACL list seems redundant.

These kinds of redundancies are pretty common for the sake of clarity and
the flow of the language.  Even major so-called Usage Panels accept
them.

The thing being parsed here is an array of datums of type aclitem, so
the term ACL list is rather unclear anyway.  But I hesitate to change it
now because we wanted to call a string freeze.

-- 
Peter Eisentraut   [EMAIL PROTECTED]


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


Re: [HACKERS] 7.4 status

2003-10-02 Thread Peter Eisentraut
Alvaro Herrera writes:

 The only things left that I can see are

 #: commands/tablecmds.c:4093
 msgid tables \%s\ already has a TOAST table
 tables - table

Fixed.

 #: commands/user.c:651 commands/user.c:1357
 msgid sysid %d is already assigned
 sysid - user ID?  Not sure, maybe it can be a group ID.

Changed to user ID and group ID.  Sounds better to me too.

-- 
Peter Eisentraut   [EMAIL PROTECTED]


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


Re: [HACKERS] 7.4 status

2003-10-02 Thread Peter Eisentraut
Patrick Welche writes:

 Does this count a string change? :)

Yes, but it's also a documentation bug fix.

Anyway, you got it in before the freeze. :)

-- 
Peter Eisentraut   [EMAIL PROTECTED]


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


Re: [HACKERS] 7.4 status

2003-10-01 Thread Patrick Welche
On Mon, Sep 29, 2003 at 11:50:23PM +0200, Peter Eisentraut wrote:
 Tom Lane writes:
 
  At the very least we need to set a strings freeze soon, so the
  translators can catch up.  Peter, are you getting close to done with the
  message revisions you've been making?
 
 Yes, I think we're ready for a string freeze.  Alvaro, do you have
 anything you still want to submit in that area?

Does this count a string change? :)

Patrick
? psql
Index: help.c
===
RCS file: /projects/cvsroot/pgsql-server/src/bin/psql/help.c,v
retrieving revision 1.80
diff -u -r1.80 help.c
--- help.c  14 Sep 2003 22:37:13 -  1.80
+++ help.c  1 Oct 2003 19:58:15 -
@@ -234,8 +234,8 @@
ON(pset.popt.topt.format == PRINT_HTML));
fprintf(output, _(  \\pset NAME [VALUE]\n
   set table output option\n
-  (NAME := 
{format|border|expanded|fieldsep|null|recordsep|\n
-  tuples_only|title|tableattr|pager})\n));
+  (NAME := 
{format|border|expanded|fieldsep|footer|null|\n
+  
recordsep|tuples_only|title|tableattr|pager})\n));
fprintf(output, _(  \\t show only rows (currently %s)\n),
ON(pset.popt.topt.tuples_only));
fprintf(output, _(  \\T [STRING]set HTML table tag attributes, or unset 
if none\n));

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


Re: [HACKERS] 7.4 status

2003-09-30 Thread Hannu Krosing
Bruce Momjian kirjutas T, 30.09.2003 kell 02:16:
 Tom Lane wrote:
  
   !  Faster regular expression code
  
  We could tout more functionality too, since the new regex package
  has a lot of advanced stuff that wasn't there before.
 
 Added more powerful
 

This wording covers nicely possible incompatibilities too ;)

--
Hannu

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

   http://archives.postgresql.org


Re: [HACKERS] 7.4 status

2003-09-29 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes:
 Perhaps it is time to start looking at a final release date for 7.4?

At the very least we need to set a strings freeze soon, so the
translators can catch up.  Peter, are you getting close to done with the
message revisions you've been making?

regards, tom lane

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


Re: [HACKERS] 7.4 status

2003-09-29 Thread Marc G. Fournier

Should we maybe get a Beta4 out now that everything is caught up code
wise?  Is anyone still sitting on something (other then the translations
stuff) that should be in v7.4?

On Mon, 29 Sep 2003, Tom Lane wrote:

 Bruce Momjian [EMAIL PROTECTED] writes:
  Perhaps it is time to start looking at a final release date for 7.4?

 At the very least we need to set a strings freeze soon, so the
 translators can catch up.  Peter, are you getting close to done with the
 message revisions you've been making?

   regards, tom lane

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


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

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


Re: [HACKERS] 7.4 status

2003-09-29 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes:
 Should we maybe get a Beta4 out now that everything is caught up code
 wise?  Is anyone still sitting on something (other then the translations
 stuff) that should be in v7.4?

We still have several open items in Bruce's list, but maybe we can
resolve them soon.  Tentatively set a beta for Wed the 1st, maybe?

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


Re: [HACKERS] 7.4 status

2003-09-29 Thread Neil Conway
On Mon, 2003-09-29 at 14:57, Bruce Momjian wrote: 
 I have emptied the patch queue, and have updated the HISTORY file for
 7.4.  I am looking for any improvements to that file.  (I have to move
 it to SGML soon.)

A patch that improves HISTORY is attached. I added a few bullet items to
the highlights of this release section that are IMHO important,
removed the mention of hash indexes (IMHO, they are still inappropriate
for production use, just less so), fixed some spelling mistakes, and
clarified a few entries.

Please apply.

-Neil

Index: HISTORY
===
RCS file: /var/lib/cvs/pgsql-server/HISTORY,v
retrieving revision 1.216
diff -c -r1.216 HISTORY
*** HISTORY	29 Sep 2003 18:06:48 -	1.216
--- HISTORY	29 Sep 2003 20:26:57 -
***
*** 15,52 
 Major changes in this release:
 
 IPv6
!  Full support for IPv6 connections and IPv6 data types.
  
 SSL
!  Major SSL improvements in performance and security.
  
 Index Growth Prevention
   Allow free space map to efficiently reused empty index pages,
!  and other free space improvements.
  
 New Client/Server Communication Protocol
!   New protocol improves connection speed/reliability, and adds 
!   error codes, status information, a binary protocol, error
!   reporting verbosity, and cleaner startup packets.
  
 Performance
!   IN/NOT IN subqueries now perform as efficiently as joins
!   Improved GROUP BY procesing by using hack buckets
!   Hash indexes now have better concurrency/reliability/performance
!   New multi-key hash join capability
!   ANSI joins are now fully optimized
!   Faster regular expression code

!Cursors
!   Allow cursors to exist outside transactions
  
 Threads
!   libpq and ecpg are now fully thread-safe with --enable-thread-safety
  
 Contrib
!   New version of full text indexing (tsearch2)
!   New autovacuum tool
!   Array handling has been improved and moved into the main server
  
   _
 
--- 15,57 
 Major changes in this release:
 
 IPv6
!  Full support for IPv6 connections and IPv6 address data types
  
 SSL
!  Major improvements in SSL performance and security
  
 Index Growth Prevention
   Allow free space map to efficiently reused empty index pages,
!  and other free space management improvements.
! 
!Standards Compliance
!  Implement information schema
!  Support for read-only transactions
!  Make cursors comply more closely with the SQL standard
  
 New Client/Server Communication Protocol
!  New protocol improves connection speed/reliability, and adds 
!  error codes, status information, a binary protocol, error
!  reporting verbosity, and cleaner startup packets.
  
 Performance
!  IN/NOT IN subqueries now perform as efficiently as joins
!  Improved GROUP BY processing by using hash buckets
!  New multi-key hash join capability
!  ANSI joins are now fully optimized
!  Faster regular expression code
!  Function-inlining for simple SQL functions

!Holdable Cursors
!  Allow cursors to exist outside transactions
  
 Threads
!  libpq and ecpg are now fully thread-safe with --enable-thread-safety
  
 Contrib
!  New version of full text indexing (tsearch2)
!  New autovacuum tool
!  Array handling has been improved and moved into the main server
  
   _
 
***
*** 58,75 
 Observe the following incompatibilities:
   * The server-side autocommit setting was removed an reimplemented
 in client applications and languages.
!  * Error message wording has changed dramtically in this release,
 and error codes have been added.
   * ANSI joins may behave differently because they are now fully optimized
   * A number of server variables have been renamed for clarity
   * MOVE/FETCH 0 now does nothing; return value of MOVE/FETCH 1/0
 varies based on the current offset in the cursor
!  * COPY now can process carriage-return/line-feed and carraige-return
 terminated files.  Literal carriage-returns and line-feeds are no
 longer accepted as data values;  use \r and \n instead.
!  * Auto-trim spaces when converting from CHAR() to VARCHAR()/TEXT
   * FLOAT(p) now measures 'p' in bits, not digits
   * Date values now must match the ordering specified by DateStyle
  
   _
 
--- 63,83 
 Observe the following incompatibilities:
   * The 

Re: [HACKERS] 7.4 status

2003-09-29 Thread Bruce Momjian

Patch applied.  Thanks.

---


Neil Conway wrote:
 On Mon, 2003-09-29 at 14:57, Bruce Momjian wrote: 
  I have emptied the patch queue, and have updated the HISTORY file for
  7.4.  I am looking for any improvements to that file.  (I have to move
  it to SGML soon.)
 
 A patch that improves HISTORY is attached. I added a few bullet items to
 the highlights of this release section that are IMHO important,
 removed the mention of hash indexes (IMHO, they are still inappropriate
 for production use, just less so), fixed some spelling mistakes, and
 clarified a few entries.
 
 Please apply.
 
 -Neil
 

[ Attachment, skipping... ]

-- 
  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: [HACKERS] 7.4 status

2003-09-29 Thread Peter Eisentraut
Tom Lane writes:

 At the very least we need to set a strings freeze soon, so the
 translators can catch up.  Peter, are you getting close to done with the
 message revisions you've been making?

Yes, I think we're ready for a string freeze.  Alvaro, do you have
anything you still want to submit in that area?

-- 
Peter Eisentraut   [EMAIL PROTECTED]


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

   http://archives.postgresql.org


Re: [HACKERS] 7.4 status

2003-09-29 Thread Alvaro Herrera
On Mon, Sep 29, 2003 at 11:50:23PM +0200, Peter Eisentraut wrote:
 Tom Lane writes:
 
  At the very least we need to set a strings freeze soon, so the
  translators can catch up.  Peter, are you getting close to done with the
  message revisions you've been making?
 
 Yes, I think we're ready for a string freeze.  Alvaro, do you have
 anything you still want to submit in that area?

The only things left that I can see are

#: commands/tablecmds.c:4093
msgid tables \%s\ already has a TOAST table
tables - table

#: commands/user.c:651 commands/user.c:1357
msgid sysid %d is already assigned
sysid - user ID?  Not sure, maybe it can be a group ID.

-- 
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
I think my standards have lowered enough that now I think 'good design'
is when the page doesn't irritate the living f*ck out of me. (JWZ)

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


Re: [HACKERS] 7.4 status

2003-09-29 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes:
  SSL
 !  Major improvements in SSL performance and security

Did we actually add any security to the SSL code?  Performance and
reliability, maybe, but I didn't think we'd done anything to the
security algorithms per se.  Did I miss something?

  Index Growth Prevention
Allow free space map to efficiently reused empty index pages,
 !  and other free space management improvements.

reused - reuse

 !  ANSI joins are now fully optimized

better optimized maybe; I wouldn't say we're done with that issue yet.
(In particular, I want to look into reordering outer joins sometime.)

 !  Faster regular expression code

We could tout more functionality too, since the new regex package
has a lot of advanced stuff that wasn't there before.

* The server-side autocommit setting was removed an reimplemented
  in client applications and languages.

an - and

 !  * Error message wording has changed dramatically in this release,
  and error codes have been added.

Substantially might be a better term anyway?

* ANSI joins may behave differently because they are now fully optimized

See above

* Date values now must match the ordering specified by DateStyle

... except that -MM-DD (with 3 or more digits for year) is always
accepted.

regards, tom lane

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


Re: [HACKERS] 7.4 status

2003-09-29 Thread Bruce Momjian
Tom Lane wrote:
 Neil Conway [EMAIL PROTECTED] writes:
   SSL
  !  Major improvements in SSL performance and security
 
 Did we actually add any security to the SSL code?  Performance and
 reliability, maybe, but I didn't think we'd done anything to the
 security algorithms per se.  Did I miss something?

I changed the wording to reliability.  We did so some security by
changing the rate of key negotiation, but it isn't substantial.

   Index Growth Prevention
 Allow free space map to efficiently reused empty index pages,
  !  and other free space management improvements.
 
 reused - reuse

Done.

 
  !  ANSI joins are now fully optimized
 
 better optimized maybe; I wouldn't say we're done with that issue yet.
 (In particular, I want to look into reordering outer joins sometime.)

Yep.

 
  !  Faster regular expression code
 
 We could tout more functionality too, since the new regex package
 has a lot of advanced stuff that wasn't there before.

Added more powerful

 
 * The server-side autocommit setting was removed an reimplemented
   in client applications and languages.
 
 an - and

Done.

 
  !  * Error message wording has changed dramatically in this release,
   and error codes have been added.
 
 Substantially might be a better term anyway?

Yep.

 
 * ANSI joins may behave differently because they are now fully optimized
 
 See above

Changed to better optimized

 
 * Date values now must match the ordering specified by DateStyle
 
 ... except that -MM-DD (with 3 or more digits for year) is always
 accepted.

Changed to:

 * Ambiguous date values now must match the ordering specified by DateStyle

Committed to CVS.

-- 
  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 6: Have you searched our list archives?

   http://archives.postgresql.org