[BUGS] BUG #1501: in additional to previous "DEAD of child"

2005-02-22 Thread nagash
The following bug has been logged online: Bug reference: 1501 Logged by: nagash Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.2 Operating system: gentoo Description:in additional to previous "DEAD of child" Details: pg kill all it's childs also tested on

[BUGS] BUG #1502: hash_seq_search might return removed entry

2005-02-22 Thread Thomas
The following bug has been logged online: Bug reference: 1502 Logged by: Thomas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: N/A Description:hash_seq_search might return removed entry Details: The hash_seq_search keeps track of what e

Re: [BUGS] BUG #1497: Default permissions allow any user to create objects in any database

2005-02-22 Thread Tom Lane
"Barry Brown" <[EMAIL PROTECTED]> writes: > I should not be able to do this. Not everyone would agree with you. But if you want to work that way, revoke public CREATE privileges on the public schema, and revoke public CREATE privileges on the database so people can't create new schemas.

[BUGS] BUG #1500: child dead

2005-02-22 Thread nagash
The following bug has been logged online: Bug reference: 1500 Logged by: nagash Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: RedHat Description:child dead Details: site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'MonDD'); se

[BUGS] BUG #1499: Unable to install

2005-02-22 Thread Luke Lincoln
The following bug has been logged online: Bug reference: 1499 Logged by: Luke Lincoln Email address: [EMAIL PROTECTED] PostgreSQL version: None Yet! Operating system: Windows 2000 Description:Unable to install Details: Error message (using Either msi file) "Please

[BUGS] BUG #1503: pg_restore cannot restore a backup

2005-02-22 Thread Yavuz
The following bug has been logged online: Bug reference: 1503 Logged by: Yavuz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: windows 2000 sp4 Description:pg_restore cannot restore a backup Details: firstly i try a backup on Fedore Linu

[BUGS] BUG #1504: Wrong user is used for sequences through rules

2005-02-22 Thread Nicolas Rachinsky
The following bug has been logged online: Bug reference: 1504 Logged by: Nicolas Rachinsky Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: FreeBSD 4.10 Description:Wrong user is used for sequences through rules Details: As the user (nico

[BUGS] BUG #1494: psql \df to_char

2005-02-22 Thread Ludwig Lim
The following bug has been logged online: Bug reference: 1494 Logged by: Ludwig Lim Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux Description:psql \df to_char Details: Hi: I notice that when I type \df to_char in psql prompt t

Re: [BUGS] BUG #1490: contrib .sql.in sed command bogus

2005-02-22 Thread alexis
Hi Tom, Indeed, with the correct version the $libdir will work in the .sql file. Very good. 8-) Alexis On Mon, 21 Feb 2005, Tom Lane wrote: > "Alexis Wilke" <[EMAIL PROTECTED]> writes: > > Inside pgxs.mk I had to change the $$libdir into $(libdir ) to get the > > proper path in the final .sql

[BUGS] BUG #1498: Default permissions allow any user to create objects in any database (revised)

2005-02-22 Thread Barry Brown
The following bug has been logged online: Bug reference: 1498 Logged by: Barry Brown Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: RHEL 3.0 (kernel 2.4.21-27.0.2.ELsmp) Description:Default permissions allow any user to create objects in

[BUGS] BUG #1496: Problem with instalation

2005-02-22 Thread Sergius
The following bug has been logged online: Bug reference: 1496 Logged by: Sergius Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Win NT Description:Problem with instalation Details: With I make the instalation using the windows NT?? -

Re: [BUGS] BUG #1491: Getting an "undefined symbol" when loading

2005-02-22 Thread alexis
Tom, Ha! If I'd known of the select version(); I would have fixed the problem sooner! It all works when you run the right version... 8-) You may want to specify that select command in the doc in regard to modules so people can test their backend version before to bug you guys. Thank you for th

Re: [BUGS] problem installing postgresql-8.0.1 on Windows 2K

2005-02-22 Thread Juu
Magnus, > You need to look a bit earlier in the logfile to determine where the > error is - the log you have here is only from the MSI rollback. > > How far into the installation do you get befoer it fails? I get to the point where it would start copying the files (it shows the progressbar for

[BUGS] BUG #1497: Default permissions allow any user to create objects in any database

2005-02-22 Thread Barry Brown
The following bug has been logged online: Bug reference: 1497 Logged by: Barry Brown Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: RHEL 3.0 Description:Default permissions allow any user to create objects in any database Details: The d

Re: [BUGS] BUG #1487: Index problem

2005-02-22 Thread Tom M. Yeh
Yes, it really depends on Locale. If I created a database with Locale = C, the problem won't happen (at least so far). BTW, I forgot to mention I tested with some Chinese and Japanese characters. However, it raises another issue why a wrong Locale would damage index? It shall only affect records w

[BUGS] BUG #1493: image storeg

2005-02-22 Thread naresh soni
The following bug has been logged online: Bug reference: 1493 Logged by: naresh soni Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.1 Operating system: window 2000 professional Description:image storeg Details: how to store the images in the posgreSQL Man