Re: [GENERAL] postgres 6.5.1

Hi jeff

I have two paths with the directory /data

[root(at)servidor data]# pwd
/usr/src/redhat/BUILD/postgresql-6.5.1/src/data
[root(at)servidor data]# ls
CVS koi-alt.tab koi-koi.tab koi-win.tab
charset.conf koi-iso.tab koi-mac.tab

and

[root(at)servidor data]# cd
/usr/src/redhat/BUILD/postgresql-6.5.1/src/test/regress/data
[root(at)servidor data]# ls
CVS dept.data onek.data streets.data
agg.data desc.data person.data stud_emp.data
constrf.data emp.data real_city.data student.data
constro.data hash.data rect.data tenk.data

The table's name is not in any of the directories above, the other tables
I have in my database aren't here either.

I have the next path where postgres keeps its files:

[root(at)servidor data]# cd /var/lib/pgsql/base/
[root(at)servidor base]# ls
db_redife db_redife_bd redife_1 redife_4
db_redife_1 imp redife_2 template1
db_redife_2 redife redife_3 utilidades

[root(at)servidor base]# cd redife
[root(at)servidor redife]# ls -l lista_nominal
-rw------- 1 postgres postgres 66977792 Feb 24 05:21 lista_nominal

the name of my DB is redife
the file lista_nominal is here
is very large and I can't read it
and my trouble remains.
thanks for your help...

On Wed, 23 Feb 2000, Jeff MacDonald wrote:

> try finding that table inthe data directory
> i think it's /var/lib/data in redhat, (something like that)
>
> if the file doesn't exist, touch it. and try
> to drop the table again
>
> jeff
>
> A
> On Wed, 23 Feb 2000, Adrian Perez Camarena wrote:
>
> >
> > I have a problem with my D.B.
> > I'm using linux 5.2 and postgres 6.5.1
> > When i try to delete a table with 300,000 rows, the first time, postgres
> > show me the next message:
> >
> > heap delete: (am) invalid tid
> >
> > If i try to delete it again , the message is the follow:
> >
> > ExecutePlan: (junk) 'ctid' is NULL!
> >
> > and there is a third message:
> >
> > Cannot open segment 1 of relation lista_nominal
> >
> > where lista_nominal is the table that has the problem.
> >
> > I don't understand the messages, i hope someone can help me
> >
> >
> > Adrian Perez Camarena
> > IFE
> >
> >
> > ************
> >
>
> Jeff MacDonald
> jeff(at)pgsql(dot)com
>
>