============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Nikolay Mijaylov
Your email address : nmmm@nsi.bg
Category : unknown
Severity : serious
Summary: bad transaction support
System Configuration
--------------------
Operating System : Linux ELF 2.XX
PostgreSQL version : 6.4.2
Compiler used : gcc ???
Hardware:
---------
Pentium 64 RAM
Versions of other tools:
------------------------
gmake ??? Fles ???
--------------------------------------------------------------------------
Problem Description:
--------------------
when u make a transaction that make a table (object?) and
transaction break, a small file is created in the data directory.
after this u cannot create this table (object?) until
do not delete this file.
--------------------------------------------------------------------------
Test Case:
----------
send a SQL:
--------
begin work;
create table tab ( ppp char(50) );
insert into tab values ('hello','this is err and tr. will abort');
commit work;
-------------
after this try to do same - it;ll be abort on create
after this go to '/usr/pgsql/data/my_database'
------------
$ls tab
------------
result:
tab (0 bytes)
thats all :)))
I love PostGre :)
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------