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

2005-01-25 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/200

Re: [BUGS] Privilege escalation via LOAD

2005-01-25 Thread Tom Lane
"David Litchfield" <[EMAIL PROTECTED]> writes: > _init() is the equivalent of DllMain on Linux/etc; in fact the other > database server I was looking at is vulnerable to this exact problem. If > postgresql accepts CLOB/BLOB input from a client to a table and then can > dump to disk you might be

Re: [BUGS] BUG #1440: ecpg seg faults

2005-01-25 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Tue, Jan 25, 2005 at 01:52:33PM +0100, Michael Meskes wrote: >> Thanks for the report and the analysis. I just committed a fixe. It >> should work correctly now. > Where all did you commit the fix? Just HEAD? Shouldn't it also > be committed to REL8

Re: [BUGS] Wierd rule problem

2005-01-25 Thread Hendrik Müller
Tom Lane schrieb: Bear in mind that the DELETEs issued by the ON DELETE CASCADE trigger will be rewritten by this same rule. There has been debate in the past whether this behavior is a feature or a bug, but it's unlikely to change soon. Why postgres does not show this trigger for a better understa

Re: [BUGS] BUG #1440: ecpg seg faults

2005-01-25 Thread Michael Fuhr
On Tue, Jan 25, 2005 at 01:52:33PM +0100, Michael Meskes wrote: > Thanks for the report and the analysis. I just committed a fixe. It > should work correctly now. Where all did you commit the fix? Just HEAD? Shouldn't it also be committed to REL8_0_STABLE, etc., as well? -- Michael Fuhr http

[BUGS] Also submitted via web site bug report

2005-01-25 Thread Cameron, Thomas
Howdy - New to the list, not a PostgreSQL user typically, so don't know if this has already been addressed. I tried to build RPMs from the source rpm supplied from the PostgreSQL web site. The spec file supplied by postgresql-7.4.6-2PGDG.src.rpm is broken. When I tried to run: rpmbuild -ba

Re: [BUGS] Wierd rule problem

2005-01-25 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: > CREATE RULE handle_delete_on_kid AS ON DELETE TO kid WHERE > (NOT old.onlythis) DO INSTEAD DELETE FROM parent > WHERE (parent.id = old.parid); Bear in mind that the DELETEs issued by the ON DELETE CASCADE trigger will be rewritten by this same

Re: [BUGS] BUG #1428: SHGetSpecialFolderPath not found in SHELL32.dll

2005-01-25 Thread Hendrik Müller
Magnus Hagander schrieb: This is a known issue on NT4 with the release. I have just submitted a patch that will fix this. If you need it urgently, you can get new binaries from http://www.hagander.net/pgsql/nt4bin.zip. But *BEWARE*. These binaries carry *incorrect version numbers*. If you install t

Re: [BUGS] BUG #1429: stats tests fails

2005-01-25 Thread Hendrik Müller
Tom Lane schrieb: That means the statistics collector subprocess didn't start. Check the postmaster log to find out why not. (In my experience the most common reason why not is that your DNS configuration is broken to the point that it won't resolve the name "localhost".) Thank you for your help.

[BUGS] Wierd rule problem

2005-01-25 Thread Achilleus Mantzios
Consider that foodb=# \d parent Table "public.parent" Column | Type | Modifiers +-+ id | integer | not null default nextval('public.parent_id_seq'::text) name | text

Re: [BUGS] BUG #1432: type "cube" does not exist

2005-01-25 Thread Sam Hahn
Sorry... I thought I had checked "cube"... Michael Fuhr wrote: On Sat, Jan 22, 2005 at 02:25:27AM +, Sam Hahn wrote: A database command error occured whilst executing "E:\Program Files\PostgreSQL\8.0\share\contrib\earthdistance.sql": ERROR: type "cube" does not exist

[BUGS] BUG #1439: unable to create more than 21 database connections

2005-01-25 Thread Martin Drinck
The following bug has been logged online: Bug reference: 1439 Logged by: Martin Drinck Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: Win XP Description:unable to create more than 21 database connections Details: Im trying to connect 50

Re: [BUGS] BUG #1440: ecpg seg faults

2005-01-25 Thread Michael Meskes
On Mon, Jan 24, 2005 at 03:24:13PM -0500, Tom Lane wrote: > Edmund Bacon <[EMAIL PROTECTED]> writes: > > njamd says: > > NJAMD/free: Double free of address 0x41454ff4 > > > #4 0x40021e87 in free () from /usr/lib/libnjamd.so > > OK, here's where I defer to Michael Meskes to actually fix it ;-) T