It's Postgresql 7.2.1, installed with stable version of Debian Woody, at the time.On 8/21/06, Jim Nasby <[EMAIL PROTECTED]
> wrote:On Aug 15, 2006, at 8:50 AM, Luiz Henrique wrote:> my problem was problably corrupted index files. I recreated the
> index and it's ok now.
postgresql/bin/postgres -D /var/lib/postgres/data -O -P db
reindex database db;
/etc/init.d/postgresql start
Thanks!On 8/4/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
On Fri, 4 Aug 2006, Luiz Henrique wrote:> Hi, could you tell me how postgresql look for a referenced key? It looks in> t
Hi, could you tell me how postgresql look for a referenced key? It looks in table index? Maybe only the index is corrupted?Thanks!On 8/2/06, Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Wed, 2 Aug 2006, Luiz Henrique wrote:> Hi,>> I'm running Postgresql 7.3 in Debian Woody O
Hi,I'm running Postgresql 7.3 in Debian Woody OS.After some time working properly, insert's statements related this error:referential integrity violation - key referenced from xxx not found in yyy
This error would be normal, if the key really doesn't exist, but the key exist.The insert's wo
