Re: [GENERAL] index with LIKE

exes now. Would changing the lc_collate setting to 'C' solve this issue as well? Thanks again, -- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am Steinkamp 7 - D-21684 Stade - Germany

Re: [GENERAL] index with LIKE

ing issue. > > > ---(end of > broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > [EMAIL PROTECTED]) -- Mit freundlichem Gruß Henrik Steff

Re: [GENERAL] index with LIKE

-- -- Seq Scan on basiseintrag (cost=1.00..100024064.96 rows=1 width=264) (actual time=1028.468..1092.537 rows=1 loops=1) Filter: ((kundennummer ~~ '0101%'::text) AND (firma ~~ &#

Re: [GENERAL] newbie question... how do I get table structure?

try something like this: select attname from pg_class, pg_attribute where relname='your_tablename' and attrelid=relfilenode; -- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am Steinkamp 7 - D-21684 Stade

Re: [GENERAL] Still trouble reindexing

shouldn't it be necessary to prevent postgres from inserting a 536870936 bytes long value in to a 8192 byte column? I am not sure if this (again) is a hardware issue... -- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am St

[GENERAL] Still trouble reindexing

what that could mean? -- 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: [EMAIL PROTECTED]

Re: [GENERAL] Cannot create unique index

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

Re: [GENERAL] Cannot create unique index

yes, there were duplicates -- 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: [EMAIL

Re: [GENERAL] Cannot create unique index

yes, of course, I allready did this. What I was aiming at, was, that postgres should normally not insert a duplicate value into a unique index, should it? Isn't this a bug? -- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am Steinkamp 7 - D-

[GENERAL] Cannot create unique index

and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. Haven't had this for quite a while now (using 7.3.3) Any idea? In my opinion this should not be possible... -- Mit freundlichem Gruß Henrik St