PostgreSQL Database Forum

I just experienced the same problem with 8.0.0beta2. http://archives.postgresql.org/pgsql-bugs/2004-08/msg00086.php -- Georgi Chorbadzhiyski http://georgi.unixsol.org/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your

Hi all! After a very long struggle I finally succeded in transferring my old *.dbf file and the relating *.dbt (alias memo fields) to a pg table. For the time being I put the memo field in a separate table having two fields only (i.e.: n_memo integer, memo text) which can be related to the main table in a view.

Hello, I have experienced problems with postgres hanging when two inserts reference the same foreign key. It appears that the second insert is waiting for the first insert to release a lock. Here is an example of how to recreate the problem. Please ignore the lack of sequences, since that is irrelevent to the problem. I have tested this...

postgres 7.4.2 on a RedHat Enterprise Server using libpq on SCO Open Server Seems that if a command takes too long I get ERROR:Canceling query due to user request. I have ulimit=unlimited postgresql.conf has statement_timeout = 0 Any ideas on what could be causing this?

Hi, My webserver work in PHP4, safemode and it's running for years. I use Debian, kernel 2.6 since yesterday. I install psotgreSQL and PHPPGADMIN from apt-get (in .deb package) like always on Debian... I configure pg_hba.conf with

Today I tried to move a database and got this error, which I gather is very rare (also undocumented): postgres: FATAL: incorrect checksum in control file I moved the database from a 32-bit arch to a 64-bit arch. All I did was shutdown a 7.4.1 database, shutdown the machine, swap the storage onto the 64-bit machine running 7.4.5, and...

Hi all, I want to have the time zone string (like 'BRT') displayed after a date-time. The date column is of the type timestamp with time zone. But the time zone is not displayed. It works for a timestamp without time zone column: # select to_char(timestamp '2001-02-16 20:38:40' at time zone 'BRT', 'HH24:MI DD/MM/YYYY TZ'); to_char

I have a long but straightforward query (on some very large tables) that always ends in 'Memory exhausted in AllocSetAlloc(108)'. Even stranger are some messages that appear in the logfile, such as the following (edited for length, repetitions, etc): TopMemoryContext: 32792 total in 4 blocks; 9712 free (2 chunks); 23080 used...

Hello, How do I clear out dropped column names that appear in pg_attribute.attname automatically? Thanks, Pete

What would be performance of pgSQL text search vs MySQL vs Lucene (flat file) for a 2 terabyte db? thanks for any comments. ..V -- Please post on Rich Internet Applications User Interface (RiA/SoA) <http://www.portalvu.com> ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet,...

Dear Postgresql experts, According to the documentation for MOVE, it returns the number of rows that it has moved over. It seems to me that this is true for MOVE FORWARD n, but not for MOVE RELATIVE n or MOVE ABSOLUTE n when it always returns 1: db=> declare c scroll cursor for select * from p; DECLARE CURSOR db=> move absolute -1 in c;

Hi everyone. Im having a problem with heritage. The situation is the following: I have two tables, tbl_everyone and tbl_employees. tbl_employees inherits from tbl_everyone. In tbl_everyone, i store some information about everyone who is related with the place where i work: Name, ID (PK), Birth Date, Adress... Then, in tbl_employees i have...

Hi, I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the following error when I try and run a SQL query on a script: Error - /usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php -- Line: 33 PostgreSQL said: ERROR: parser: unterminated quoted string at or near "'Black Tea\015\012Fresh range of leaf tea...

I have a problem with postgresql runnung on smp kernel. setup: master: ------- - Pentium 4 (hyperthreading) - 2 GB Memory - os: fedora core 1 - kernel: 2.4.22-1.2188.nptlsmp

Hello. I am trying to port an old java application from MS SQL Server to PostgreSQL running on Mac OS X. I have access to the java source code and can make modifications. I have tried with PostgreSQL version 7.4.2 and 8.0.0beta2, but get the same error. I am using pgdev.305.jdbc3.jar for 8.0.0beta2. The PostgreSQL installation are standard,...

What is the performance or other benefits of text search on pgSQL vs mySQL on large dbs? thanks for any comments, ..V -- Please post on Rich Internet Applications User Interface (RiA/SoA) <http://www.portalvu.com>

As per subject, i'm considering migrating a database (still in development) from MaxDB to postgresql. The main reason for this is that the stored procedures (functions) in MaxDB are unreliable and hard to debug, and that the JDBC driver is still experimental. I thought I'd post here to find out how well functions and JDBC are supported in...

I took the white space between characters out of my script 'create.txt4' and ran it on database 'test'. There were errors: 26 27 -- Create Orders Table 28 29 CREATE TABLE Orders 30 ( 31 Order_num int NOT NULL, 32 Order_date datetime NOT NULL,

For those of you interested in benchmark studies and other DB vendor's marketing hype. http://www.sybase.com/content/1031301/IA64_Benchmark_wp.pdf Unfortunately it doesn't compare Sybase to any other DB. I was interested in the way this point however: "For testing purposes, we increased the number of ASE engines – which typically...

I have a view like this: CREATE or replace VIEW program_member_this_year AS SELECT DISTINCT person.person_id FROM unit.person, unit.visit WHERE unit.person.person_id = unit.visit.person_id AND visit.program_id = this_program() AND

Im getting this error when trying to start postgres: FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied im running under an unprivileged user, and have set up pgsql in a different place on my hard drive then the normal one. The user does not have rights to /tmp, how can i set this up so the tmp file are...

I see that a newly created database in 8.0.0beta2 now has tables sql_sizing, sql_sizing_profiles, sql_packages, sql_features, sql_implementation_info, and sql_languages as part of the information schema. Given these are system tables, why are these tables not prefixed with 'pg_', as in 'pg_sql_sizing', etc? Ed

Dear Group. I want to read vrml file and store the same in the postgresql.So please send me some links or solution to achieve this. Ashok --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage!

I have the following insert to populate a new table: insert into pending_tnmt_sec select tseceventid, tsecsecno, nextval('sec_seq'), tsecrtddt from tnmtsec order by tsecrtddt,tseceventid,tsecsecno; I need to access this data in a particular order which may change over

Hi, Any suggestion to Rapid Application Dev with postgreSQL ? I have a small app to make. I would prefer open-source solution if possible. I also would like to developp on my linux box but the result will be used on a windows 2000 and XP machine. But If I have no choice, I will developp on winXP.