PostgreSQL Database Forum

hello everybody, i have only a short question can someone tell me which filename extenion postgresql database has? thank you very much!

I am running postgresql at version 8.1 on a windows xp desktop machine. I then loaded 40 million rows into a table of 6 varchar fields ( The sum total length of a row is on average about 100 characters ) If create a single btree index on one of the shortest fields ( about 6 chars long ) it takes approximately 15 minutes On the other...

Hello friends; I need to give somebody the permission to access somewhere in the system. That permission can be through the group or user, but I has found problems with using of inherits. What is the good solution to this situation? It would be better to remove all FK and PK, and use other ways? how can I do it? CREATE TABLE identify( ...

I need convert .DBF to Postgres, and use DBF2PG.EXE. It works fine, but the problem is: The source is DBF (LATIN1) and target is PG UNICODE, and the options "-F charset_from" and "-T charset_to" do not work properly. I need DBF2PG.EXE with iconv enabled in the compile. I use PostgreSQL 8.0.6 - WinXP. Thanks and Regards. Roberto Longo

Hi All. I want to extract and Load data from PostgreSQL using Libpq C API. Please let me know which approach will be good to load large number of rows into PostgreSQL(Insert or COPY FROM) and, which approach will be good to extract large number of rows from PostgreSQL (COPY TO or SELECT). I want to handle all the data types supported in the...

Hi all I saw these meesage from my log file could not load library "/usr/lib/postgresql/utf8_and_iso8859_1.so": /usr/lib/postgresql/utf8_and_iso8859_1.so: undefined symbol: pg_utf8_islegal So what does this mean ? Any help

Hi, I can't retrieve the full results from the table.Every time I retrieve without setting limitation,I only got 1000 records even the results are more than that. pls guide me how to get all of the results. Thanks and Regards. vivian.

Hi Every Body, Can i instal postgres sql database in windows 2000 server.Hw i can instal.Pls help to me. With Regards Siva

Hi, Can anyone please tell me about What is ODBC Query timeout error? And How to resolve this issue. Thanks.

Hi there, I’m running Postgres on SuSe Linux and some times the database uses so much disk space that we got disk full problems. Is there a way in postgres to specify how much disk space to use? For instance, I’d like it to use no more than 50G. And if there is such parameter, what is the effect? Will postgres simply stop writing to the disk?...

Hi, Are there any web development libraries for postgresql that support a C++ CGI interface? What I'm dreaming of is a library that defines classes that provide a rich GUI via HTML for buttons, tables, forms, etc. An example would be a "TABLE" class that allows, in addition to the standard row and column data, information-rich flyover text....

Hi, I'm new to SQL, and I'm hoping to get some help in selecting a value based on a hierachy. What I'm trying to achieve is get the campus phone number, and if this is not available, then go down the hierarchy: if campus phone is null then get business_phone if business_phone is null then get permanent_phone columns in the table are...

boolean retval = false; StringBuffer sql = new StringBuffer(); ResultSet rst = null; conn.setAutoCommit(false); sql.append("select assign_customers() "); Statement st = conn.createStatement(); retval = st.execute(sql.toString()); When I execute assign_customers through pgadmin , it works. But within javacode I do not get any...

We had pg_clog files for ages and were not cleared. We performed a vacuum on template1 and most of the files were cleared. Now we are getting DETAIL: could not open file "/y/pgdata/pg_clog/08F0": No such file or directory 2006-10-02 06:46:36 ERROR: could not access status of transaction 2399531383 There are no hardware errors or bad...

i have tables in postgresql. i need to create these tables in oracle. for this i'm trying to write a php function. i got column names of the tables by using internal tables of postgres.But how can i get field width of these columns ??? thanks in advance ann.

is there an ESQL for postgres? thanks Tom

Hi Is there any limitation in query result in postgresql? When I run the query , I only can see maximum 1000 records(rows). Actually the results should be more than 1000. I appreciate the reply. Thanks and Regards. vivian

Hi Database Gurus, Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are about to begin development for a data intensive web based application and are faced with the choice of database software. We (at least currently) are focusing on free software. Some basic research has...

Hi i have a severe performance problem with one of my views which has 6 to 8 joins .. any help will be appreciated.. the view is: CREATE OR REPLACE VIEW thsn.trade_view AS SELECT tra.tra_id, tra.per_id, tra.fir_id, tra.tra_dcn, tra.tra_startdate::date AS tra_startdate, tra.tra_enddate::date AS tra_enddate, tra.tra_highprice,...

Hi I'm having a table with data as follows ID Start_time End_time Days 1. 06:00:00 10:00:00 { 1 } 2. 01:00:00 05:00:00 { 2 } 3. 22:00:00 04:00:00 {1,2}

ups...sorry(( not correct topic i'm too drunk... I'm st01en zasrancheg... fcuk ,, sorry arain P.S. st01en - lox

Hello 'http://my.opera.com/car-insurance-online-quote/blog' (http://my.opera.com/car-insurance-online-quote/blog/)/ Bye -- martinaixuy ------------------------------------------------------------------------

Dear All, I am using postgres sql 8.1 version.That version have a replication conecept. Hw to use the replication concept in postgres sql.I need to replicate one database server to another one server database.Pls help to me With Kindly Regards Siva

Can anybody tell me what I'm doing wrong with my syntax with the following statement? Immediately following is the error. The bugger of this is that this statement works on MySQL, MS SQL, ORACLE, DB2, H2, and even hsqldb. Any suggestions would be appreciated.... select distinct 'default' as data_source, nhb_group_member.is_active,...

hello can anyone tell me how to create a table with 3 columns as UNIQUE KEY PraDz