Re: [HACKERS] [7.0.2] cannot create an index ...

2000-10-09 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: >> Hmm. That suggests a clobbered index (as in, first page zeroed out). > I've rebuilt the whole data structure, as I fear it is a residual of the > crash we had last week, but, if it means anytyhing, we had done a 'drop > database/create database'

Re: [HACKERS] [7.0.2] cannot create an index ...

2000-10-09 Thread Marc G. Fournier
On Tue, 10 Oct 2000, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > TRAP: Failed Assertion("!(metaopaque->btpo_flags & (1 << 3)):", File: "nbtpage.c > > ", Line: 181) > > Hmm. That suggests a clobbered index (as in, first page zeroed out). > The Assert report doesn't tell

Re: [HACKERS] [7.0.2] cannot create an index ...

2000-10-09 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > TRAP: Failed Assertion("!(metaopaque->btpo_flags & (1 << 3)):", File: "nbtpage.c > ", Line: 181) Hmm. That suggests a clobbered index (as in, first page zeroed out). The Assert report doesn't tell us which index. Possibly a backtrace of the coref

[HACKERS] [7.0.2] cannot create an index ...

2000-10-09 Thread Marc G. Fournier
altho I'm still investigating, does anyone have an idea why the following 'CREATE TABLE' will cause this erro: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'playlist_info_pkey ' for table 'playlist_info' FindExec: found "/pgsql/bin/postgres" using argv[0] TRAP: Failed Assertion("