[BUGS] Bug #783: WINDOWS 2000: invalid primary checkpoint record

2002-09-26 Thread pgsql-bugs
Le Quang Anh Ngoc ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description WINDOWS 2000: invalid primary checkpoint record Long Description Hello, I'm using Windows 2000, PostgreSQL 7.2.1-win32. While System was be running, the power w

Re: [BUGS] Bug #782: clog files disappear after 'vacuum;'

2002-09-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > We are having a problem with our pg_clog files disappearing after a > vacuum command is run. VACUUM is supposed to remove no-longer-needed pg_clog files; space reclamation is what it's all about, after all. Your problem is more correctly thought of as "there shouldn't

[BUGS] Bug #782: clog files disappear after 'vacuum;'

2002-09-26 Thread pgsql-bugs
Steven Wilton ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description clog files disappear after 'vacuum;' Long Description We are having a problem with our pg_clog files disappearing after a vacuum command is run. We have a database

[BUGS] Bug #781: Broken Indices in 7.3 Beta

2002-09-26 Thread pgsql-bugs
Christoph Nelles ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Broken Indices in 7.3 Beta Long Description Hello everybody! I am currently using 7.3 Beta (my data is not so important ;)) and it breaks frequently one index d

[BUGS] FW: 7.3b1 : DROP DOMAIN CASCADE CAN LEAVE A TABLE WITH NO COLUMNS

2002-09-26 Thread Tim Knowles
Hello, I have found it is possible for a user with create table permission to crash the 7.3b1 backend. The crash occurs because it is possible to have a table with no columns after a DROP DOMAIN CASCADE. Create a table with one column (with that columns type specified as a domain) then issue t

Re: [BUGS] Bug #780: Timestamp shifted by one minute

2002-09-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > Timestamp shifted by one minute [ in locally-built PG ] Do you have CFLAGS set in your environment, and if so how? This sounds quite a bit like the known problems with -ffast-math, though I have not heard this exact complaint before. If you built with -ffast-math the

[BUGS] Bug #780: Timestamp shifted by one minute

2002-09-26 Thread pgsql-bugs
Rob Abbot ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Timestamp shifted by one minute Long Description The output of the code below is: 25/09/02 23:59:00 *NOT* 26/09/02 00:00:00 which is timeshifted backward by 1 minute