If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports@postgresql.org.

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs@postgresql.org.

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches@postgresql.org instead.  Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	GURUDAS SALGAONKAR
Your email address	:	gurudas@phil.com.sg


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	:	Intel Pentium MMX

  Operating System (example: Linux 2.0.26 ELF) 	:	Red Hat Linux 5.2
							Linux 2.0.36

  PostgreSQL version (example: PostgreSQL-6.3.2)  :   PostgreSQL-6.3.2

  Compiler used (example:  gcc 2.7.2)		:	gcc (v2.7)


Please enter a FULL description of your problem:
------------------------------------------------

	I am having a table having about 34 fields . And the total no of records in this table were about 1500 . I wanted generate a report for which i was repeatedly  making a join with another table of 9 fields and 3 records to  select just the count of records that satisfy  a condition. So I tried to select only selected fields from the larger table into a new table using the following query  :

	select finish_date,total_no_copies,amount,cust_type into table flash_jobs from jobcover where finish_date between '01/10/1999' and '28/10/1999' 

	Before Ending the transaction I was dropping the temporary table that was created 

	This query was executed properly and it gave proper result as expected.  I even made joins on other tables to get the required result. I could run the program several times later.

	Some time later due to  some error in my c code the program crashed . This program error was not a big one and was corrected. Then when I tried to run the program the above querry could not create the table and the PQerrorMessage given was "cannot create flash_jobs". Now i went to  'psql temp' (where "temp" is our database name) and tried to drop this table the error then given to me was  "Relation flash_jobs does not exist " .  Now I tried to change the table name created in the above query, it worked fine but once the program crashed again before dropping the table created gave me the same error.

	Getting bored with this I tried to use "Views" for the same query and now also I had to give another name for the table to be created. The query worked fine without giving any PQerrorMessage. Now when I tried to execute a query on the table that was created the PQerrorMessage said that "The Query was send to the Backend ,But the connection was closed" (the second part is not the same but almost the same thing like [I THINK !! :-)]) . Now I did 'psql temp' again so that I could drop the view created but could not delete , It gave an error as       "" RewriteGetRuleEventRel: rule "_RETfxlash_job" not found "" 

	Now I have almost bored with this problem, but I want to complete it

						PLEASE HELP!!!



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------





If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------