[BUGS] bug report: pg_dump does not use CASCADE in DROP

2003-08-28 Thread Preston Landers
POSTGRESQL BUG REPORT TEMPLATE Your name : Preston Landers Your email address : [EMAIL PROTEC

Re: [BUGS] Suggestion on documentation

2003-08-28 Thread Peter Eisentraut
Wenguang Wang writes: > When I install postgresql on Windows 2000 Server or Advanced Server with > cygwin, I have to use the console and cannot connect from the terminal > client. If I connect from the terminal client, postgresql hangs for all > operations. This problem costed me lots of time. Wou

[BUGS] Suggestion on documentation

2003-08-28 Thread Wenguang Wang
When I install postgresql on Windows 2000 Server or Advanced Server with cygwin, I have to use the console and cannot connect from the terminal client. If I connect from the terminal client, postgresql hangs for all operations. This problem costed me lots of time. Would you please add this note

Re: [BUGS] Install postgresql 7.3 on Solaris 2.6 sparc

2003-08-28 Thread Wiseguy
On the wall of the virtual bathroom stall, [EMAIL PROTECTED] ("Keow Yeong Huat Joseph") scratches: > This is a multi-part message in MIME format. > > --_=_NextPart_001_01C36C7F.BD71285F > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > >

Re: [BUGS] [PERFORM] pgsql inserts problem

2003-08-28 Thread Richard Huxton
On Wednesday 27 August 2003 13:50, Tarhon-Onu Victor wrote: > > shared_buffers = 520 > max_locks_per_transaction = 128 > wal_buffers = 8 > max_fsm_relations = 3 > max_fsm_pages = 482000 > sort_mem = 131072 > vacuum_mem = 131072 > effective_cache_size = 1 > random_page_cost = 2 Slightly off

[BUGS] "Returned due to virus; was:" Re: Re: My details

2003-08-28 Thread pgsql-bugs
See the attached file for details INFECTION ALERT The WebShield Appliance, at Binghamton University, discovered a virus in this file.You may or may not have sent this file. We do not check each email for correct addressing, we only return to the address on the FROM: line. The file was not cleaned

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-28 Thread mike
Hi, On Tue, 26 Aug 2003, Stephan Szabo wrote: ... > But does it change the amount of time the query actually takes to run? > seqscans are not always slower nor are they necessarily the actual problem > here. The problem seems to be choosing a group aggregate + sort which is > taking alot of time,

Re: [BUGS] Install postgresql 7.3 on Solaris 2.6 sparc

2003-08-28 Thread Keow Yeong Huat Joseph
Hi,   I encountered error when trying to configure the source on Solaris as shown below, error message as shown below, : checking for fseeko... (cached) yes checking test program... failed configure: error: *** Could not execute a simple test program. This may be a probl

Re: [BUGS] [PERFORM] pgsql inserts problem

2003-08-28 Thread Christopher Kings-Lynne
> > The problems is that only ~15% of the lines are inserted into > > the database. The same script modified to insert the same data in a > > similar table created in a MySQL database inserts 100%. > > Did you check the error status for the records that weren't entered? > > My first guess is that y

Re: [BUGS] [PERFORM] pgsql inserts problem

2003-08-28 Thread Bruno Wolff III
On Wed, Aug 27, 2003 at 15:50:32 +0300, Tarhon-Onu Victor <[EMAIL PROTECTED]> wrote: > > The problems is that only ~15% of the lines are inserted into > the database. The same script modified to insert the same data in a > similar table created in a MySQL database inserts 100%. Did you

Re: [BUGS] psql does not pick up hostname without -h even though they ae the same

2003-08-28 Thread Tom Lane
John Griffiths <[EMAIL PROTECTED]> writes: > When running psql locally using the tcp connect with tcpip_socket = true and > hostname_lookup = true in postgresql.conf, psql does not find localhost unless > the -h option is specified. I think you've got something weird in your PGHOST environment var

Re: [BUGS] Renaming table doesn't rename primary key index or serial

2003-08-28 Thread Bruce Momjian
Yes, this is a known problem, and our TODO list mentions them. We haven't had time to fix them yet. --- Jonathan Gardner wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > PostgreSQL 7.3.2 (Redhat 9) > > When cr

[BUGS] pgsql inserts problem

2003-08-28 Thread Tarhon-Onu Victor
Hi, I have a (big) problem with postgresql when making lots of inserts per second. I have a tool that is generating an output of ~2500 lines per seconds. I write a script in PERL that opens a pipe to that tool, reads every line and inserts data. I tryed both commited an

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-28 Thread Stephan Szabo
On Wed, 27 Aug 2003, mike wrote: > Hi, > On Tue, 26 Aug 2003, Stephan Szabo wrote: > ... > > But does it change the amount of time the query actually takes to run? > > seqscans are not always slower nor are they necessarily the actual problem > > here. The problem seems to be choosing a group agg

[BUGS] psql does not pick up hostname without -h even though they ae thesame

2003-08-28 Thread John Griffiths
When running psql locally using the tcp connect with tcpip_socket = true and hostname_lookup = true in postgresql.conf, psql does not find localhost unless the -h option is specified. 427 bash$ psql psql: FATAL: No pg_hba.conf entry for host localhost, user jrg4598, database jrg4598 428 bash$ psql