Re: [BUGS] Missing tables in postgresql 7.2.4

ies'? regards Michael -- -- Dipl.-Inform. Michael Beckstette Office: M3-129 AG-PI / Technische Fakultaet EMail:[EMAIL PROTECTED] Universitaet Bielefeld Fon: +49-521-106-

Re: [BUGS] Missing tables in postgresql 7.2.4

t for weekly VACUUM ;) Michael -- ------ Dipl.-Inform. Michael Beckstette Office: M3-129 AG-PI / Technische Fakultaet EMail:[EMAIL PROTECTED] Universitaet Bielefeld Fon: +49-521-106-2914 Postfach 100131Fax: +49-521-10

Re: [BUGS] Missing tables in postgresql 7.2.4

happens with the 8 tables that are still accessable, but not listed in pg_tables, after a VACUUM? Will they be removed completely or 'reinserted' into pg_tables? Does anyone has an advise how to proceed in this situation? Regards Michael On May 11, 6:11pm, Michael Beckstette wrote: >

Re: [BUGS] Missing tables in postgresql 7.2.4

he whole DB(s) fix our problem? Michael On May 11, 11:51am, Tom Lane wrote: > Subject: Re: [BUGS] Missing tables in postgresql 7.2.4 > "Michael Beckstette" <[EMAIL PROTECTED]> writes: > > we recently discovered on our production database an a little bit bizarre > > pro

[BUGS] Missing tables in postgresql 7.2.4

at this is probably not enough information for a precise analysis. May be someone can give me a hint how to further investigate this issue. regards Michael -- -- Dipl.-Inform. Michael Beckstette Office: M3-129 AG-PI /

[BUGS] Problems with select chaining using INTERSECT

. So mybe there is a problem with the data type TEXT and INTERSECT ? Any idea ? --- Dipl.-Inform. Michael BeckstetteOffice: M3-129 AG-PI / Technische FakultaetEMail:[EMAIL PROTECTED] Universitaet

Re: [BUGS] length limitation in '=' operator when comparing TEXT fields ?

assed through LIPQ's PQexec function ? My system: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 Regards Michael Beckstette ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister comm

[BUGS] length limitation in '=' operator when comparing TEXT fields ?

EXT Thanx in advance Michael ------- Dipl.-Inform. Michael BeckstetteOffice: M3-129 AG-PI / Technische FakultaetEMail:[EMAIL PROTECTED] Universitaet Bielefeld Fon: +49-521-106-2914 Postfach 100131

Re: [BUGS] postmaster crash

Hi Tom, thanx for your quick response. Yes the DB is on a NFS mounted volume, but i have checked my logs: There are no nfs error messages. As i said these error occures only from time to time (3 times in the last 6 month...I guess).And the only thing i recognized (except the same errormessage (xl

[BUGS] postmaster crash

BUG: redo starts at (13, 2751936936) DEBUG: ReadRecord: record with zero len at (13, 2751970312) DEBUG: redo done at (13, 2751970248) DEBUG: database system is in production state Thanks for an almost :) excellent product. Regards Michael Beckstette ---(end of broadcast)

[BUGS] Postmaster crash

server processes... There is enough disk space left, i have checked this. My system configuration: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 running on a Sun Enterprise Server 400 Thanx in advance Michael Beckstette ---(end of