Greetings,
Does anyone know what is this error?
ERROR: cache lookup for userid 26 failed
Some system tables are inacessible in my database but I can access others. I tried to
check pg_tables, but it's blocked :
persona=> select * from pg_tables;
ERROR: cache lookup for userid 26 failed
per
How do you mean, Tom?
> "Vilson farias" <[EMAIL PROTECTED]> writes:
> > Does anyone know what is this error?
> > ERROR: cache lookup for userid 26 failed
>
> Evidently pg_shadow has no entry with usesysid 26. Add it back...
>
> regards, tom lan
ve another
postgre installed here and in that machine (working very well) pg_pwd is empty.
Regards.
> How do you mean, Tom?
>
> > "Vilson farias" <[EMAIL PROTECTED]> writes:
> > > Does anyone know what is this error?
> > > ERROR: cache lookup for userid
Greetings,
I have a table with only three tuples. I've been using it as primary key container
for tables, like the Sequence from postgresql. I'm not using sequences because my
application was originally created for MSSQL 6.5.
My problem is very specific, I have a stored procedure for p
Greetings,
I've been fighting against a very strange behaviour found in PostgreSQL
7.1.2 on a RedHat 6.2. I have a very simple table called site_site and I
lost it's indexes everytime I run a vaccum. Do you know why this happens? Is
there a way to get around or fix this kind of problem?I put a f
Greetings,
I'm getting a big performance problem and I would like to ask you what
would be the reason, but first I need to explain how it happens.
Let's suppose I can't use sequences (it seams impossible but my boss
doesn't like specific database features like this one).
For sequence simul
AC%sT 1988 Sep 12
-5:00 - ACT 1993 Sep 28
-5:00 Brazil AC%sT 1994 Sep 22
-5:00 - ACT
#
# Acre (AC)
Zone America/Rio_Branco -4:31:12 - LMT 1914
-5:00 Brazil AC%sT 1988 Sep 12
-5:00 - ACT
Best Regards
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "V
I'm having problems with temporary tables in postgre.
I've been using Postgre 7.02 in a red hat 6.2 and I'm accessing using Delphi
5 + Winzeos Postgre Components. I've been using for some mounths and now I
checked that there are lots of temp tables in my system. These tables where
created by my a
Hi people!
I'm writing a script to erase non-droped temp tables. When I tried to delete
from pg_tables, the following problem raises:
**check out, there are data:
relatorio=# SELECT COUNT(*) FROM pg_tables WHERE tablename like 'pg_temp.%';
count
---
101
(1 row)
**There are data, reall
: In short: if you want to delete a table there is one and only one
: safe method to do it: DROP TABLE. The key difference between a temp
: table and a regular table is that the DROP will be done for you
: automatically when you disconnect.
Now why?
relatorio=# DROP TABLE "pg_temp.1823.17";
ERR
Greetings,
I've been using Postgres in a Pentium 75Mhz, Linux RedHat 6.2, 32Mb.
Every big query I execute uses too much cpu (more than 90%).
I start postgres with these params: su -l postgres -c
'/usr/bin/postmaster -B 2048 -i -D "/home/postgres/data"' &.
What should I do for avoid
Hello,
I need help in case below. My table tipo_categoria has a primary key,
called cod_categoria When I use this key as parameter for my sql script, the
result of execution is a sequencial scan, but this is a PRIMARY KEY, it does
has an index. How can it be explained?
sitest=# CREATE TAB
Just another question : Does foreign has a automatic created index, like
primary keys?
- Original Message -
From: Vilson farias <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: SIMONE Carla MOSENA <[EMAIL PROTECTED]>
Sent: Sexta-feira, 10 de Novembro de 2000 10:16
arias
Dígitro Tecnologia - Brasil
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
To: Vilson farias <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; SIMONE Carla MOSENA
<[EMAIL PROTECTED]>
Sent: Sexta-feira, 10 de Novembro de 2000 13:11
Subject: Re
Hello!
I've been trying to install 7.0.3, but I'm always getting the same error,
even if I try to install in another computer. What can I do?
[root@localhost /tmp]# rpm -i postgresql-7.0.3-2.i386.rpm
[root@localhost /tmp]# rpm -i postgresql-devel-7.0.3-2.i386.rpm
[root@localhost /tmp]# rpm -i po
Greetings,
I'm trying to do a vacuum and it's not working very well. Could you
please tell me what can I do?
The main problems appears to be related with "Cannot insert a duplicate
key into unique index pg_attribute_relid_attnum_index" message. How can I
fix it?
Thanks a lot.
[postgres@d
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
To: Vilson farias <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; SIMONE Carla MOSENA
<[EMAIL PROTECTED]>
Sent: Quinta-feira, 15 de Março de 2001 18:08
Subject: Re: [GENERAL] Why my vacuum fails?
: "Vil
Greetings,
There are a very weird problem here.
I changed my /etc/rc.d/init.d/postgresql. The postmaster line now is :
su -l postgres -c "/usr/bin/pg_ctl -o '-B 1024' -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
That mean now are 8Mb (1024 buffers of 8Kb) availab
Great! Now it's ok. Thanks.
- Original Message -
From: Poul L. Christiansen <[EMAIL PROTECTED]>
To: Vilson farias <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; SIMONE Carla MOSENA
<[EMAIL PROTECTED]>
Sent: Segunda-feira, 19 de Março de 2001 11:23
Subject: Re:
Greetings,
I have a little problem here and need some help. I created a table where
indexes are not working very well here. Please take a look at the code below
(it's easier).
Two databases with same problem : 7.0.2 and 7.0.3 both on linux redhat
6.2.
Am I doing something wrong?
bxs=#
I gave up from using ODBC... to much problems with blobs and other stuff...
and really very low speed under Delphi. Try Zeos Database Components for
Postgre(http://www.marms.com/zeos). I've been using for 6 mounths and its
great. Blobs greater than 8Kb still are a big problem, but you will see thi
My RPM install didn't set pl/pgsql too... I needed to write this code :
Execute psql template1
After this, type these 2 lines :
CREATE FUNCTION plpgsql_call_handler () RETURNS opaque AS
'/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
CREATE PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_ha
acao is null;
END IF;
Now execution time is <1s. Ok, but I really would like to know what's
happening to the older version.
Best Regards,
José Vilson de Mello de Farias
Dígitro Tecnologia Ltda. - Brazil
----- Original Message -
From: Richard Huxton <[EMAIL PROTECTED]>
To: Vilson f
23 matches
Mail list logo