Re: Cannot create unique index
От | Henrik Steffen |
---|---|
Тема | Re: Cannot create unique index |
Дата | |
Msg-id | 03ee01c33fd6$6812ce40$9800a8c0@henrik обсуждение исходный текст |
Ответ на | Re: Cannot create unique index ("Henrik Steffen" <steffen@city-map.de>) |
Список | pgsql-general |
Hello, before the reindexing starts, the webserver is always shut down. as there are no database-users except the web-users, there should not be a possibility of inserting a non-unique value just between DROP INDEX and CREATE INDEX.... allthough, sometimes an apache child process may take a few seconds to exit... I will put a delay between webserver-stop and reindexing, maybe this helps... the other possibility is segfaults or other hardware problems. We have often had this kind of problem with earlier postgres versions before (this has been discussed on the list several times). but since 7.3.3 we have never had it again. On none of our servers. -- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am Steinkamp 7 - D-21684 Stade - Germany -------------------------------------------------------- http://www.topconcepts.com Tel. +49 4141 991230 mail: steffen@topconcepts.com Fax. +49 4141 991233 -------------------------------------------------------- 24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc) -------------------------------------------------------- Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de System-Partner gesucht: http://www.franchise.city-map.de -------------------------------------------------------- Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563 -------------------------------------------------------- ----- Original Message ----- From: "Martijn van Oosterhout" <kleptog@svana.org> To: "scott.marlowe" <scott.marlowe@ihs.com> Cc: "Henrik Steffen" <steffen@city-map.de>; "Andrew Gould" <andrewgould@yahoo.com>; "pgsql" <pgsql-general@postgresql.org> Sent: Tuesday, July 01, 2003 3:04 PM Subject: Re: [GENERAL] Cannot create unique index
В списке pgsql-general по дате отправления: