Re: [GENERAL] 'like' refuses to use an index???

2003-12-30 Thread Dima Tkach
Keith C. Perry wrote: Ahhh, so it is!! So let me ask you this. In order to build an index that would be able to handle something like "lastname like '%erry'", would you need that full text search patch in contrib (tsearch?) or could you do it with an index on a function? I suppose, if this is

[GENERAL] postmaster and logrotate

2003-12-22 Thread Dima Tkach
Hi, everybody! I was wonderring if there is a way to make logrotate work with postgres logs? More precisely, the question is - is there any way to tell a running postmaster process to reopen its log file? I tried kill -HUP ... but that doesn't seem to do anything... Is there just no way to do w

Re: [GENERAL] CREATE TABLE with REFERENCE

2003-07-29 Thread Dima Tkach
Do you know of a better way to handle multitable references? Sure. SET CONSTRAINTS DEFERRED; BEGIN; insert this insert that END; That only handles single table references. For example, I have a database with a "notes" table. This table is used to store annotations on ANY record