[GENERAL] ERROR: cache lookup for userid 26 failed

2001-06-18 Thread Vilson farias
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

[GENERAL] Still getting problems with -cache lookup for userid 26 failed-

2001-06-19 Thread Vilson farias
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

[GENERAL] Re: Still getting problems with -cache lookup for userid 26 failed- (PART 2)

2001-06-19 Thread Vilson farias
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

[GENERAL] slow line insert

2001-07-16 Thread Vilson farias
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

[GENERAL] Lost indexes

2003-07-18 Thread Vilson farias
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

[GENERAL] Simulating sequences

2003-08-18 Thread Vilson farias
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

Re: [GENERAL] timeofday() and CAST

2003-08-21 Thread Vilson farias
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

[GENERAL] Help needed : temp tables.

2000-10-09 Thread Vilson farias
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

[GENERAL] Delete temp tables

2000-10-24 Thread Vilson farias
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

Re: [GENERAL] Delete temp tables

2000-10-25 Thread Vilson farias
: 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

[GENERAL] CPU killer

2000-10-27 Thread Vilson farias
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

[GENERAL] Sequencial scan over primary keys

2000-11-10 Thread Vilson farias
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

[GENERAL] Sequencial scan over primary keys 2

2000-11-10 Thread Vilson farias
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

No Luck -> Re: [GENERAL] Sequencial scan over primary keys

2000-11-10 Thread Vilson farias
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

[GENERAL] postgresql-server-7.0.3-2.i386.rpm error

2000-12-12 Thread Vilson farias
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

[GENERAL] Why my vacuum fails?

2001-03-15 Thread Vilson farias
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

Re: [GENERAL] Why my vacuum fails?

2001-03-16 Thread Vilson farias
- 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

[GENERAL] Cant connect if -B 1024 was set to postmaster

2001-03-19 Thread Vilson farias
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

Re: [GENERAL] Cant connect if -B 1024 was set to postmaster

2001-03-19 Thread Vilson farias
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:

[GENERAL] indexes not working very well

2001-03-23 Thread Vilson farias
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=#

Re: [GENERAL] VARCHAR and TEXT

2001-03-29 Thread Vilson farias
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

Re: [GENERAL] enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM

2001-03-30 Thread Vilson farias
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

Re: [GENERAL] very slow execution of stored procedures

2001-04-20 Thread Vilson farias
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