PostgreSQL Database Forum

Hello, I have changed DB from MySQL to PostgreSQL. When I have run my application on PostgreSQL it was disaster - it was much slower than MySQL... I have tried to change PG configuration file etc.. no luck. After many long days of thinking what is wrong I have made several tests with "EXPLAIN" statement, and to my amusement there was many...

Hi, I have posted this question yesterday. It doesn't seem to show up for some reason. Here is the problem: mm=# delete from signon where user_id='210'; ERROR: get_typdefault: failed to lookup type 0 What is the cause and how to solve it? Thanks,

Hi, Here is the case: mm=# delete from signon where user_id='210'; ERROR: get_typdefault: failed to lookup type 0 What is wrong here? A bug or something else. Thanks for your information.

hello, i am a newbie to the pgsql world, so pls bear with a possibly stupid question. i want to test out pgsql but i only have a shared hosting account. is it possible to install pgsql without root access, only for my account? my webhost uses redhat i think. thanks! ..ep

I use PostgreSQL as a default database in our solution and with the 7.2 version I was able to tar up the area pointed to by the --prefix build argument and untar to an arbitrary path as part of my product installation and I could initdb the database no problem and get a running database setup completely. With the 7.4 released version I get...

I have problems to connect my postgres db in Openoffice 1.1 via jdbc. I can open the tables and run queries. But when try to create or alter tables OpenOffice crashes. My Settings ClassPath /usr/share/pgsql/pg73b1jdbc2.jar:/usr/share/pgsql/pg73b1jdbc3.jar JDBC Driver Class org.postgresql.Driver

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, I have a database with encoding UNICODE, when I run lower() on a column with non ascii code the code for "sharp s" gets garbled. This happens with postgres 7.3. under Linux (Debian woody and SuSE 7.2). I have made sure that LC_CTYPE=C for the server:

Hi all Will autovacuum both VACUUM and ANALYZE all databases, so that I can delete my script which runs daily: "vacuumdb -a -z"? br socketd (a Postgresql newbie) ps: Please cc to me as I am not on this list

It would appear that MySQL is making great strides into the commercial and even the enterprise arena. I am not seeing the same news coverage being said about Postgresql. I believe Postgresql has been a much better rdbms than MySQL for a long time, so then why has not Postgresql grabbed the commercial and enterprise arena before MySQL did? ...

Just curious - are there any PostgreSQL certifications, or plans for them? I ask because I just became aware of two for mysql: http://vue.com/mysql/ http://www.mysql.com/certification/ __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now

I've two questions, they may or may not be related - 1. I copied the entire data directory from postgreSQL 7.3.2 (AIX4.3) to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem setup. I didn't do an dump/reload process since the copy process is faster. Is it OK to take this shortcut in postgreSQL? any side-effects? 2. The...

Hello! When I try to run ./configure --with-java, it complains that ant doesn't work. However ant is installed, as is the latest Java SDK 1.4.2 from sun, PATH and JAVA_HOME are set correctly; helles:/ # /usr/java/apache-ant-1.5.4/bin/ant -version Apache Ant version 1.5.4 compiled on August 12 2003 It complains about some unsupported...

Hi guys, I have a simple table: teste=# \d forn Table "public.forn" Column | Type | Modifiers ---------+---------+------------------------------------------------------ id | integer | not null default nextval('public.forn_id_seq'::text)

Hello, I've run across a pretty serious problem with pg_autovacuum. pg_autovacuum looses track of any table that's ever been truncated (possibly other situations too). When i truncate a table it gets a new relfilenode in pg_class. This is a problem because pg_autovacuum assumes pg_class.relfilenode will join to pg_stats_all_tables.relid....

Hi, Help me pls a little with locals in postgres 7.3.4 why "order by" and "like" doesnt work in 7.3.4 properly? - im working with ALT server local settings. in 7.2.xx all this things worked well . Thank u . and have a nice day!

Hopefully not fuel to the RPM discussion but I've downloaded the PGDG SRPM this AM made some changes to what packages/portions would build and am now getting the following error. gcc: cannot specify -o with -c or -S and multiple compilations Somewhere near line 719 in the spec file. The changes I've made pertained to not building tk,...

Hi, thanks for the new great version! Only one small problem, how can I disable autocommit in Postgres 7.4 in libpgtcl and psql? I found something about .psqlrc but how is the syntax and how can I set it for libpgtcl? BTW, SET AUTOCOMMIT TO ON still gives no error, only SET AUTOCOMMIT TO OFF

Hi. Where is the SQL text of view stored in the database? I mean the text like "SELECT the_field FROM the_table". I can found the function's text in "pg_proc.prosrc", but can't find the same for a view. Yury Shvetsov.

I am trying to authenticate POstgres using Pam. How do I do this. I tried using webmin on RH9 and telling it to use Pam for authentication but it doesn't seem to work. Jason Tesser Web/Multimedia Programmer Northland Ministries Inc. (715)324-6900 x3050 ---------------------------(end of broadcast)---------------------------

Is there an updated version of Lamar Owen's linux startup script available? It initializes the database on first invocation after initdb has been done manually (even after changing all 7.3's to 7.4's in the script), then gives an error on subsequent startups. __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it...

Hello (Sorry about reposting, but I'm still not arriving to any good solution for this one) I need to output a timestamp attribute formatted to fixed-width, no spaces nor separators, something like test=> select to_char(timestamp '2003-10-24 15:30:59.999', 'YYYYMMDDHH24MISS');

Is there a way to declare an array in plpgsql so that it's empty (not NULL)? The following causes arr to end up being NULL: arr varchar; -- do stuff with arr.. arr = array_append(arr, '',''); And this causes an unwanted element at the front:

Before I go deep into this - does anyone have the quick fix for this ? Some facts - the 7.3.4 version of plperl.c has the same errors in the 7.4 tree. The 7.4 version of plperl.c (with some error handling API calls commented out) compiles fine in the 7.3.4 tree. (Same machine - same install of perl !) Points to using some alternate perl...

Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either a MySql shop or a Postgresql shop. It's my opinion that we should be using PG, because of the full ACID support, and the license involved. A...

Who's the maintainer? I think I've found another problem with it, but I'd like a second opinion... Stephen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQA/wXQb4hFS2REFUecRAvJSAJ43ZuNysbUbv+FIBdp1hyt1XBLs+QCfR21E pljwSFjsb3wPykjlj0WHEGc=