[BUGS] index(fct(primary key)) kills INSERTs

2000-11-09 Thread Frank Miles
Your name : Frank Miles Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : Linux

Re: [BUGS] index(fct(primary key)) kills INSERTs

2000-11-10 Thread Frank Miles
On Fri, 10 Nov 2000, Tom Lane wrote: > Frank Miles <[EMAIL PROTECTED]> writes: > > If an index is created based on a function of the primary key, > > you cannot insert new entries into the database. > > I think the critical point here is that your "function o

Re: [BUGS] index(fct(primary key)) kills INSERTs

2000-11-10 Thread Frank Miles
On Fri, 10 Nov 2000, Tom Lane wrote: > Frank Miles <[EMAIL PROTECTED]> writes: > >> which surprises me not at all, because at the point where this function > >> is invoked, the new record with tt_id 3 hasn't been entered into the > >> table yet. >