[HACKERS] Problem: Referential Integrity Constraints lost

2002-11-07 Thread Achilleus Mantzios
. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end

Re: [HACKERS] [SQL] Problem: Referential Integrity Constraints lost: Correction

2002-11-07 Thread Achilleus Mantzios
I was wrong about parent side triggers only having disappeared. Triggers of both sides are missing. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax

Re: [HACKERS] [SQL] Problem: Referential Integrity Constraints lost

2002-11-07 Thread Achilleus Mantzios
. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] [SQL] Problem: Referential Integrity Constraints lost

2002-11-07 Thread Achilleus Mantzios
On Wed, 6 Nov 2002, Stephan Szabo wrote: On Wed, 6 Nov 2002, Achilleus Mantzios wrote: Hi i think a hit a major problem on 7.2.1. I run 3 systems with postgresql 7.2.1. Its a redhat 7.1 for development, a redhat 7.3 for production and a FreeBSD 4.6.1RC2 for testing. After long

Re: [HACKERS] [SQL] Problem: Referential Integrity Constraints lost

2002-11-07 Thread Achilleus Mantzios
On Thu, 7 Nov 2002, Achilleus Mantzios wrote: On Wed, 6 Nov 2002, Stephan Szabo wrote: On Wed, 6 Nov 2002, Achilleus Mantzios wrote: Hi i think a hit a major problem on 7.2.1. I run 3 systems with postgresql 7.2.1. Its a redhat 7.1 for development, a redhat 7.3 for production

Re: [HACKERS] [GENERAL] [SQL] Problem: Referential Integrity Constraints lost

2002-11-08 Thread Achilleus Mantzios
On Thu, 7 Nov 2002, Tom Lane wrote: Achilleus Mantzios [EMAIL PROTECTED] writes: After recreating the missing triggers should i upgrade to 7.2.3?? Make that before. I frankly suspect pilot error here. Triggers do not simply disappear. If you did have crash-induced corruption leading

[HACKERS] FreeBSD, Linux: select, select count(*) performance

2002-11-27 Thread Achilleus Mantzios
no syscall info). The same results come out for every count(*) i try. Is it just the reporting from explain analyze?? Has any hacker some light to shed?? Thanx. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4