Re: [BUGS] Bug #899: pg_dumpall produce erroneous files if the databbase

2003-03-14 Thread Laurent FAILLIE
Hi Tom, First of all, I appologies for my english : it's not my native language so, it's not so easy for me :-( > > ... yes but it is not the probleme : as no user is > > attached w/ procedural languages (it's clearly > > commented in the source code of pg_dump), it > should > > generate ACL of

Re: [BUGS] Bug #899: pg_dumpall produce erroneous files if the databbase

2003-03-14 Thread Tom Lane
=?iso-8859-1?q?Laurent=20FAILLIE?= <[EMAIL PROTECTED]> writes: > ... yes but it is not the probleme : as no user is > attached w/ procedural languages (it's clearly > commented in the source code of pg_dump), it should > generate ACL of then in a scope of a normal user, and > not as super user. Aga

Re: [BUGS] Bug #899: pg_dumpall produce erroneous files if the databbase

2003-03-14 Thread Laurent FAILLIE
--- Bruce Momjian <[EMAIL PROTECTED]> a écrit : > Hello Bruce, > Well, we do dump/load procedural languages before > function, as you can > see in your output. The plpgsql has TOC #247 while > the create language > has TOC #252. Please have a look in another message I made in this mailling li

Re: [BUGS] pg_dumpall segfault

2003-03-14 Thread Tom Lane
Nick Eskelinen <[EMAIL PROTECTED]> writes: > Ahh... as a matter of fact I do. Adding someone to this empty group > corrects the problem. Thought so. I've committed a fix if you need it: *** src/bin/pg_dump/pg_dumpall.c.orig Thu Mar 6 16:45:52 2003 --- src/bin/pg_dump/pg_dumpall.cFri M

Re: [BUGS] pg_dumpall segfault

2003-03-14 Thread Tom Lane
Nick Eskelinen <[EMAIL PROTECTED]> writes: > pg_dumpall segfaults when trying to dump group information. Hmm, you have any empty (member-less) groups? Looks like this loop needs a test at the top not the bottom ... regards, tom lane ---(end of bro

[BUGS] pg_dumpall segfault

2003-03-14 Thread Nick Eskelinen
POSTGRESQL BUG REPORT TEMPLATE Your name : Nick Eskelinen Your email address : [EMAIL PR

Re: [BUGS] Bug #899: pg_dumpall produce erroneous files if the databbase

2003-03-14 Thread Bruce Momjian
Well, we do dump/load procedural languages before function, as you can see in your output. The plpgsql has TOC #247 while the create language has TOC #252. As for loading the languages, did you load this dump as super-user? ---

Re: [BUGS] Bug #909: Website docs broken

2003-03-14 Thread Robert Treat
I believe this to be fixed. If you see any further problems please report them. Robert Treat On Fri, 2003-03-14 at 11:26, [EMAIL PROTECTED] wrote: > Daniel Quaroni ([EMAIL PROTECTED]) reports a bug with a severity of 1 > The lower the number the more severe it is. > > Short Description > Websit

[BUGS] Bug #909: Website docs broken

2003-03-14 Thread pgsql-bugs
Daniel Quaroni ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Website docs broken Long Description I couldn't find a place to report bugs about the website, so I apologize for sending it to this address if it's not the correct

Re: [BUGS] now() and date_trunc() apparently corrupting data

2003-03-14 Thread Oliver Elphick
On Thu, 2003-03-13 at 23:06, Tom Lane wrote: > Oliver Elphick <[EMAIL PROTECTED]> writes: > > This is with -configure -enable-integer-datetime in 7.3.2, i386 Linux > > platform. Is anyone else seeing this? If so, does it happen without > > --enable-integer-datetime? > > > junk=# select