Re: [HACKERS] confusing log messages on pg_ctl -w start

2004-11-12 Thread Bruce Momjian
Andrew Dunstan wrote: > > When I run pg_ctl -w start I often see this on the log, which is less > than clear, if not downright confusing: > > > LOG: database system is ready > FATAL: the database system is starting up > > Any ideas on how to improve this? Yes, that FATAL message certainly

Re: [HACKERS] code question: storing INTO relation

2004-11-12 Thread Alvaro Herrera
On Fri, Nov 12, 2004 at 03:49:44PM -0800, Kevin Brown wrote: > Bruce Momjian wrote: > > > > Added to TODO: > > > > * Eliminate WAL logging for CREATE INDEX/REINDEX/CREATE TABLE AS > > when not doing WAL archiving > > But that means that these operations can't be performed in a > transa

Re: [HACKERS] code question: storing INTO relation

2004-11-12 Thread Kevin Brown
Bruce Momjian wrote: > > Added to TODO: > > * Eliminate WAL logging for CREATE INDEX/REINDEX/CREATE TABLE AS > when not doing WAL archiving But that means that these operations can't be performed in a transaction unless WAL archiving is on, right? (If I misunderstand and thus am w

Re: [HACKERS] code question: storing INTO relation

2004-11-12 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Greg Stark wrote: > >> I think that's already done for CREATE INDEX/REINDEX. > > > I don't think so. Can someone confirm? > > Greg is correct --- at least for btree build, which is the only index > type we have WAL-ified at all :-(

Re: [HACKERS] code question: storing INTO relation

2004-11-12 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Greg Stark wrote: >> I think that's already done for CREATE INDEX/REINDEX. > I don't think so. Can someone confirm? Greg is correct --- at least for btree build, which is the only index type we have WAL-ified at all :-( regards

Re: [HACKERS] code question: storing INTO relation

2004-11-12 Thread Bruce Momjian
Greg Stark wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Added to TODO: > > > > * Eliminate WAL logging for CREATE INDEX/REINDEX/CREATE TABLE AS > > when not doing WAL archiving > > I think that's already done for CREATE INDEX/REINDEX. The reason I mentioned > them was to

Re: [HACKERS] 8.0 press release

2004-11-12 Thread Oleg Bartunov
On Fri, 12 Nov 2004, Josh Berkus wrote: Oleg, I'm worried about support of local postgresql community and offical press release, which will be copied/mirrored many times on many servers, is a good chance for doin that. Ok, I don't follow your question then.Can you be more explicit? I cite mysel

Re: [HACKERS] 8.0 press release

2004-11-12 Thread Josh Berkus
Oleg, > I'm worried about > support of local postgresql community and offical press release, > which will be copied/mirrored many times on many servers, is a good > chance for doin that. Ok, I don't follow your question then.Can you be more explicit? -- --Josh Josh Berkus Aglio Database So

Re: [HACKERS] 8.0 press release

2004-11-12 Thread Josh Berkus
Oleg, > I'm not sure it's a translator's deal ! It's sort of conceptual document > and best place is -advocacy,-hackers lists. I already contacted with N Ah, well, in terms of the content, we've been going over it on the -Advocacy list. Will forward you my e-mail from translators. -- __Aglio

Re: [HACKERS] 8.0 press release

2004-11-12 Thread Oleg Bartunov
On Fri, 12 Nov 2004, Marc G. Fournier wrote: Please join [EMAIL PROTECTED] where this has been being reviewed, critisized and discussed for the past month or so :( just joined :) On Fri, 12 Nov 2004, Oleg Bartunov wrote: Josh, what is a status of press release http://cvs.pgfoundry.org/cgi-bin/cvs

Re: [HACKERS] 8.0 press release

2004-11-12 Thread Oleg Bartunov
On Fri, 12 Nov 2004, Josh Berkus wrote: Oleg, what is a status of press release http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/press/pr/releases/8.0/en/releas e and it's translations ? Does it somehow confirmed ? Oh! We've been discussing this on the translators mailing list. I thought you were s

Re: [HACKERS] 8.0 press release

2004-11-12 Thread Marc G. Fournier
Please join [EMAIL PROTECTED] where this has been being reviewed, critisized and discussed for the past month or so :( On Fri, 12 Nov 2004, Oleg Bartunov wrote: Josh, what is a status of press release http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/press/pr/releases/8.0/en/release and it's translati

Re: [HACKERS] 8.0 press release

2004-11-12 Thread Josh Berkus
Oleg, > what is a status of press release > http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/press/pr/releases/8.0/en/releas >e and it's translations ? Does it somehow confirmed ? Oh! We've been discussing this on the translators mailing list. I thought you were subscribed. There's another Russ

[HACKERS] 8.0 press release

2004-11-12 Thread Oleg Bartunov
Josh, what is a status of press release http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/press/pr/releases/8.0/en/release and it's translations ? Does it somehow confirmed ? What do you mean under "To find out more about PostgreSQL or to download it, please visit: In " in press release and p

Re: [HACKERS] MAX/MIN optimization via rewrite (plus query

2004-11-12 Thread Jim C. Nasby
On Thu, Nov 11, 2004 at 11:59:06AM -0600, Bruno Wolff III wrote: > On Thu, Nov 11, 2004 at 09:29:14 +, > Simon Riggs <[EMAIL PROTECTED]> wrote: > > On Wed, 2004-11-10 at 22:48, Mark Kirkwood wrote: > > > Planning for future note: I would like whatever mechanism that is added > > > for this M

Re: [HACKERS] MAX/MIN optimization via rewrite (plus query rewrites generally)

2004-11-12 Thread Jim C. Nasby
On Thu, Nov 11, 2004 at 08:00:01AM -0600, Bruno Wolff III wrote: > On Thu, Nov 11, 2004 at 17:52:19 +1100, > John Hansen <[EMAIL PROTECTED]> wrote: > > Why not just change the function all together to 'select $1 from $2 > > order by $1 desc limit 1;' > > > > Is there ANY situation where max(col)

Re: [HACKERS] code question: storing INTO relation

2004-11-12 Thread Greg Stark
Bruce Momjian <[EMAIL PROTECTED]> writes: > Added to TODO: > > * Eliminate WAL logging for CREATE INDEX/REINDEX/CREATE TABLE AS > when not doing WAL archiving I think that's already done for CREATE INDEX/REINDEX. The reason I mentioned them was to provide precedent that CREATE TAB

Re: [HACKERS] Database reverse engineering

2004-11-12 Thread Andreas Pflug
Oleg I.Ivanov wrote: Excuse me for a possible offtopic, but can anybody help me to understand why Sybase Power Designer 10.1 does not understand serials and inheritance when reverse engineer Postgres database from script. Serial is no datatype, but an int4 with a default. I don't know if the def

Re: [HACKERS] code question: storing INTO relation

2004-11-12 Thread Bruce Momjian
Added to TODO: * Eliminate WAL logging for CREATE INDEX/REINDEX/CREATE TABLE AS when not doing WAL archiving --- Greg Stark wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > > I agree, hence why this s

Re: [HACKERS] Open Items

2004-11-12 Thread Bruce Momjian
Zeugswetter Andreas DAZ SD wrote: > I think in addition the system global name "sharemem.1" should be made more > pg specific, like "PostgreSQL.1". I have not done this since a new compile > would not detect a running old beta. But now would be the time (or never). Change made and attached. I a

[HACKERS] Database reverse engineering

2004-11-12 Thread Oleg I.Ivanov
Excuse me for a possible offtopic, but can anybody help me to understand why Sybase Power Designer 10.1 does not understand serials and inheritance when reverse engineer Postgres database from script. Is it possible to teach PowerDesigner to reverse engineer correctly ? Or can anybody re

Re: [HACKERS] multiline CSV fields

2004-11-12 Thread Patrick B Kelly
On Nov 12, 2004, at 12:20 AM, Tom Lane wrote: Patrick B Kelly <[EMAIL PROTECTED]> writes: I may not be explaining myself well or I may fundamentally misunderstand how copy works. Well, you're definitely ignoring the character-set-conversion issue. I was not trying to ignore the character set and en

Re: [HACKERS] multiline CSV fields

2004-11-12 Thread Andrew Dunstan
This example should fail on data line 2 or 3 on any platform, regardless of the platform's line-end convention, although I haven't tested on Windows. cheers andrew [EMAIL PROTECTED] inst]$ bin/psql -e -f csverr.sql ; od -c /tmp/csverrtest.csv create table csverrtest (a int, b text, c int); CRE