PostgreSQL Database Forum

Howdy: Running PostgreSQL 7.2 and Oracle 9.2.0.1 on RedHat Linux 7.2. I'm trying to use the Ora2pg.pl script that I found on the PostgreSQL site. I'm hoping someone could point out what's wrong with this.

Having a requirement to change null into a certain value in a query I created a couple versions of an ifnull function as follows: create or replace function "ifnull" (text, text) returns text as ' begin if $1 is null then return $2; else return $1;

I'm implementing paging through search results using cursors. Is there a better way to know total number of rows under a cursor than running a separate COUNT(*) query? I think PostgreSQL is bound to know this number after the first FETCH, isn't it? On a side note, why queries using LIMIT are SO terribly slow, compared to cursors and...

A bit of query plan strangeness. Suppose you have an inheritance tree such that the columns 'ID' and 'field' appear in the top level table, call that table XXX. tables YYY and ZZZ both inherit XXX. Now suppose there exists some query that returns a set of IDs that match some criteria (that query may involve various tests/joins/etc on other...

We are looking for information regarding any capabilities of PostgreSQL in regards to scalability. Ideally we want to be able to scale in both directions. What sort of solutions are out there for either or both directions of scalability? Specifically, open-source solutions would be most in need, but commercial applications are fine as well. ...

If I try to delete a record from my table which is giving following error Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in /xxx/database.inc on line 73 What might be the problem. Regards, Sreedhar Bhaskararaju

I have a table in my database which can grow very quickly. Is there some way to partition the table so that when it reaches a certain size the information in it is copied to a temporary table and the original table is free again. Or is this possible at all. If not is there any sort of perfomance update I can add to speed up the queries on...

Hi, I have had a site working for the last 2 years and have had no problems until at the weekend I replace my database server with a newer one. The database migration went like a dream and I had the whole db changed over in 1 hour. Since the upgrade I have been getting the following error message sporadically.

I had no idea that my address was being broadcast to the world via comp.databases.postgresql.general I have no problem with having messages sent to the list go to the group. I do have a problem with my address out there in the free and clear. Shouldn't the initial subscription notice let new sub- scribers know that their address will be...

I have a class that I designed that contains some objects in its fields, that are derived from the TList class. I want to use the TList Sort procedure to sort the items that are in the derived class. The derived class has an extra field that specifies how to sort the items. The problem I have is in the implementation of the Sort method in...

Is it right for postgres to accept a foreign key constraint when the type of the field is not the same as that of the foreign key? For example: # Create table a (id int primary key); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'a_pkey' for table 'a' CREATE TABLE # Create table b (id2 text references a(id));

Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake

I'm working psql v7.2.2 to postmaster v7.2.2 and want to use the \lo_import function. The psql manual says that the syntax is \lo_import '<filename>' 'comment' This loads the blob OK and returns the loid but the comment gets lost and doesn't appear when I run \lo_list Any ideas?

Does anybody know how to detect a NULL in a geometric box type? When I execute the following sql statement (coords is a box type) autotest=# select coords from dlg_control limit 1 autotest-# \g coords -------- (1 row)

hi, i'm new in this community. But i have a question about DSN. Is there possible to use DSN-Less in order to connect to Postgresql RDBMS (under redhat machine) ? i didnt find any information about DSN-Less in http://gborg.postgresql.org/project/gborg/projdisplay.php Thanks _____________________________________________________________...

hi, i'm new in this copmmunity. i usualy use ms sql 2000 to develope Database in every project. But since Microsoft make an office in my city, there is big difficulties to get a copy of ms sql 2000 cd in my city (illegally hehehe). i think postgresql more powerfull than ms sql 2000, but i didnt get any information about DSN less according to...

hi, i'm new in this copmmunity. i usualy use ms sql 2000 to develope Database in every project. But since Microsoft make an office in my city, there is big difficulties to get a copy of ms sql 2000 cd in my city (illegally hehehe). i think postgresql more powerfull than ms sql 2000, but i didnt get any information about DSN less according to...

Hi all, Maybe it's a question or report to bug section, but i'm not sure :-) I have a database in UTF-8 encoding filled with text in czech laguage. Everything looks correctly ... by hand translation from UTF8 2 latin2 and back is correct. But When i make any LIKE or ILIKE comparsion it sometimes fails. It's realy weird because for example...

I am trying to use Redhat Linux 9, J2sdk 1.4.2 and Postgresql 7.3.2 to do my setting. But, I cannot access the database to set/get data through the java program. Please help give me some suggestions. Here is what my setting and problems: http://hk.geocities.com/daisy_nhy/java_postgresql2.html Thanks

Hi all, Maybe it's a question or report to bug section, but i'm not sure :-) I have a database in UTF-8 encoding filled with text in czech laguage. Everything looks correctly ... by hand translation from UTF8 2 latin2 and back is correct. But When i make any LIKE or ILIKE comparsion it sometimes fails. It's realy weird because for example...

Hi list I have any problems with Postgres 7.0 and a DataBase. When I do a select to the database it works well, but when I try to insert or to update it remains hooked and I couldn't work with it. Problems started 2 days ago after I done a vacuum in one table (only). Since this day I have several processes such as: /usr/bin/postgres...

unsubscribe ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly

postgres 7.3.2 I store unicode-data in postgresql. The data is retrieved via webinterfaces, processed with perl and then stored in postgresql (and viceversa). All is going nice with one problem. If performing a "select * order by field"-query the result is not what I expected. German umlauts (ie: Ö) are stored as doublechars ("Ö" is...

Does anyone know if I can connect to a PostgreSQL database with Toad? Thanks, Ron