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.
>
> > This makes sense if the index is updated bef
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.
> This makes sense if the index is updated before the new record is completely
> added. (showin
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 of the primary
> key" is actually doin
Dear Whomever,
I recently tried to export a database and import it onto another system
using pg_dump to produce the textfile dump and \i from the postgres
command prompt to pull the file into the new empty database.
I discovered that I recieved errors when re-importing because the return
chara
