Re: [BUGS] BUG #1414: DOC - pl/Perl hash tags missing

2005-01-22 Thread Bruce Momjian
Mike Blackwell wrote: > > The following bug has been logged online: > > Bug reference: 1414 > Logged by: Mike Blackwell > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.0 > Operating system: N/A > Description:DOC - pl/Perl hash tags missing > Details: >

Re: [BUGS] BUG #1426: pg_restore SIGSEGV on 7.2.2 dump

2005-01-22 Thread Tom Lane
"Alan Pevec" <[EMAIL PROTECTED]> writes: > Running pg_restore dump-produced-on-pg722.dump > fails with Segmentation fault: Fixed. Thanks for the report. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is

Re: [BUGS] 8.0.0 pg_restore -L doesn't restore ACLs

2005-01-22 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > PostgreSQL 8.0.0 > Running "pg_restore -l" to create a list file and then restoring > using "pg_restore -L" fails to restore ACLs. See the "Privileges > where [sic] not restored" thread in pgsql-admin: > http://archives.postgresql.org/pgsql-admin/2005-01/

Re: [BUGS] 8.0 doesn't dump index tablespace correctly.

2005-01-22 Thread Tom Lane
TANIDA Yutaka <[EMAIL PROTECTED]> writes: > pg_dump on 8.0 can't dump index's tablespace information if both table > and its index 's tablespaces are different. Good catch. Patch applied, thanks! regards, tom lane ---(end of broadcast)

Re: [BUGS] BUG #1414: DOC - pl/Perl hash tags missing

2005-01-22 Thread Tom Lane
Bruce Momjian writes: > Mike Blackwell wrote: >> In the pl/Perl section of the 8.0.0 manual, as viewed on the postgresql.org >> web site, all perl code hash tags seem to be missing. i.e. > I have fixed this. We now just need someone to rebuild the docs for > 8.0. The developers page will show

Re: [BUGS] BUG #1414: DOC - pl/Perl hash tags missing

2005-01-22 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Mike Blackwell wrote: > >> In the pl/Perl section of the 8.0.0 manual, as viewed on the postgresql.org > >> web site, all perl code hash tags seem to be missing. i.e. > > > I have fixed this. We now just need someone to rebuild the docs for > > 8.0.

Re: [BUGS] BUG #1409: A good and a bad news: Crazy SQL JOIN?

2005-01-22 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > It looks like it thinks that the output is already sorted by b.col2 which > would appear to be untrue if rows are being extended from a so I think > this is a bug optimizing the query. Yup. Looks like this bug has been there since day one (ever since we

Re: [BUGS] 8.0.0 pg_restore -L doesn't restore ACLs

2005-01-22 Thread Michael Fuhr
On Sat, Jan 22, 2005 at 07:19:28PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > PostgreSQL 8.0.0 > > Running "pg_restore -l" to create a list file and then restoring > > using "pg_restore -L" fails to restore ACLs. See the "Privileges > > where [sic] not restored" thread i