PostgreSQL Database Forum

Hi, I migrated one table from oracle to postgresql. I used a PgadminII. But the table allocated, in Oracle, 152MB and in Postgresql , after migration, the space was 568MB. Anybody help me? Tkank you! Jlopes

Hi, I am runing linux red hat 7.3 (standart install) on dual athlon box , 1 GB ram and pg 7.3.4. If I try to access with pgAdmin one from my tables (i contains ~ 1 M records) the linux box crashes. In my pg log I can find: ERROR: Invalid page header in block 5604 of a_acc

hi. pls help me in installing postgres 7.3.0 rpm for suse linux 8.0. reg sharath ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your

hi. pls help me in installing postgres 7.3.0 rpm for suse linux 8.0. reg sharath ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your

Is there a way to replicate one-off(a copy of duplicate) of an existing Postgres database. regards, caroline __________________________________ Do you Yahoo!?

Is there a way to replicate one-off(a copy of duplicate) of an existing Postgres database. regards, caroline __________________________________ Do you Yahoo!?

I am doing asynchronous sql calls using the postgres C library. After doing two PQsendQuery() calls, I get the "another command is already in progress" error. The two calls I am doing are an update, and then an insert, in that order. I am doing this for speed, since my program can't afford to wait for the answer from the first to complete...

I am doing asynchronous sql calls using the postgres C library. After doing two PQsendQuery() calls, I get the "another command is already in progress" error. The two calls I am doing are an update, and then an insert, in that order. I am doing this for speed, since my program can't afford to wait for the answer from the first to complete...

We are pleased to announce the new release 2.2.0 of the DBManager Professional. It is a major bug fix bringing stability and performance to the application. Also it adds support to SQLite databases and Xbase Tables which you can manage using the same way you do for MySQL and PostgreSQL. In next version support for Interbase/Firebird will be...

We are pleased to announce the new release 2.2.0 of the DBManager Professional. It is a major bug fix bringing stability and performance to the application. Also it adds support to SQLite databases and Xbase Tables which you can manage using the same way you do for MySQL and PostgreSQL. In next version support for Interbase/Firebird will be...

Is there a way to make Postgresql case-INSENSITIVE? Thanks

Howdy: Can someone tell what the difference (and why you would use it) is between the following: select distinct on (col_1, col_2), col_1, col_2, col_3

We have a Struts app running on Tomcat and PostgreSQL, and we are thinking of changing from Tomcat to Weblogic. Are there any reasons not to do this with regarding to the database access and connection pooling? Regards, BTJ

We have a Struts app running on Tomcat and PostgreSQL, and we are thinking of changing from Tomcat to Weblogic. Are there any reasons not to do this with regarding to the database access and connection pooling? Regards, BTJ

I don't know if jdbc/java code requires this, but when I use two gui admin tools I found, and I insert a row into the table using their row editor feature, both require me to enter a number for the Serial type. I thought this type was used to auto-increment an id field and that I would not need to enter anything into it? Basically we need the...

Hi: Can anyone provide a rough guesstimate on how much memory does fully conigured, with all the services turned on pgSql database require? I'm trying to make an estimate on how much memory would be required in Flash and RAM to run pgSql database. Thanks.

hello, I'm facing an odd problem. I have a query: SELECT "Kürzel", "Autor(en)", "Titel" FROM "tblTitelangaben" WHERE "Titel"||"Kürzel"||"Monographie-Kürzel"||"Autor(en)" ILIKE '%er%'; this works like a charm.

I don't know if jdbc/java code requires this, but when I use two gui admin tools I found, and I insert a row into the table using their row editor feature, both require me to enter a number for the Serial type. I thought this type was used to auto-increment an id field and that I would not need to enter anything into it? Basically we need the...

Hi, I know SQL, but I would like to know what is constraint database & MLPQ/PReSTO? What is the relation of constraint database with MLPQ/PReSTO. Thanks Kanchan

I am wondering if it's possible to retrieve the current value of a serial type field without using the name of the corresponding sequence? I know that currval function takes the sequence name as a parameter, but I would like to use the name of the serial field instead. Is this possible? Thanks. Oleg *************************************

Hi, I know SQL, but I would like to know what is constraint database & MLPQ/PReSTO? What is the relation of constraint database with MLPQ/PReSTO. Thanks Kanchan

Hi: I'm very new to PostGreSql database and actually looking to evaluate for one of our project needs. Below please find some questions. I'm hoping if I can get some insight into these questions. Thanks. Ish...

Help! Postmaster is segfaulting i think. I am running RH_AS_3beta, postgresql 7.3.4 compiled from postgresql-7.3. 4-1PGDG.src.rpm on ia64 arch. Tsearch2 compiled from tsearch-v2-stable.tar.gz I have no idea how to fix it, all help gratefully received! Potentially useful output below:

ok, i'm confused. i have two systems. one is redhat 7.1 (a server in colo, reasonably current), the other is 8.0 (my laptop). the server in colo is running postgresql 7.3.2 along with redhat's updated versions of apache and php for 7.1 (the php version is 4.1.2) on this server, php can access postgres without difficulty. my laptop is...

Hi, at NC State University, my students and I are working on a project called "self-organizing databases," please see description below. I would like to use an open-source database system for implementation and would really appreciate your opinion on whether PostgreSQL is suitable for the project. In general, I am very impressed by the...