PostgreSQL Database Forum

Hi All I am trying to run the Postgres 8.0 intaller on my XP embedded (XPe) build. I get to the point where it runs initdb.exe but it ends up failing and does not install. I believe i am possible missing a system file or service but i don't know. To me it seems like the postgres installer comes with its own system files. below is a link to...

hi, I'm looking for an open-source tool that will allow me to extract data as XML. thanks for any tips. j

Another newbie to Postgresql. I need to know where I may find info on setting up two servers on the same machine. I am wanting to examine postgresql 8.1.1 and am currently running 8.0.1. Thanks...... J.D. Leach

Hello, I am attempting to compile postgresql from source with python enable. I have compiled & installed python on my machine according to the instruction, installation seems fine My Platform ==> # uname -a FreeBSD econ.com 4.9-STABLE FreeBSD 4.9-STABLE #0: Wed Nov 12 17:41:01 PST 2003

Hi. I'm new with PostgreSQL, but this thing doesn't allow me to sleep: I wonder if it is possible to execute SQL query which: 1. checks out if table exists, and if it is: 2. deletes it All of it at SQL query level, preferrably in one transaction. Something like (MSSQL):

I am using Postgres 7.4.6 i have 3 tables i want to join 3 tables and return a list of route_id to which a specified user_id does NOT belong. Table "public.vts_users" Column | Type | Modifiers ------------+------------------------+--------------------------------------...

In a WHERE clause, I want to to compare strings ignoring the spaces inside them. Is therd a function to do that? I do not find it in the documentation. SELECT ... WHERE (ignore_spaces(table.phone_number) ~* igore_spaces(?)); would be fine but ignore_space() does not exist! Maybe there is a solution based on regular epxression, but I do...

I have added a field to one of my PostgreSQL tables in the "Timestamp" datatype, but when I add a row to that table I don't get the date and time inserted into that column? Do I need to put a default value into the column too?

Hi, I have a PG database "foodsvc" and I want to make a copy of it with a new name "newfoodsvc". So that I can play with the "newfoodsve" without any damage to the "foodsvc". How can I do that? Thank you. GL

Hi, I need to execute some queries that do not return any value for example "DELETE * FROM foo". This queries take a lot of time and I can't put them together in a single query. If I use the non-blocking function PQsendQuery() I have to wait until the execution of the first query terminates before executing another query right? In my case...

I'm emulating ROLAP in Postgres, populating a sorta-cube from a table with 200 million rows in it. Many aggregates over around 20 fields. Two questions : 1. Currently, it takes 1000 seconds to build a cube from scratch. What, other then trivial, tricks can be done to speed up the monstrous SELECT 2. Adding a text field to the source table...

Makes me glad I chose PostgreSQL to develop my goodies on.... http://developers.slashdot.org/developers/05/10/07/2021211.shtml?tid=221 -- Available for Hire! http://amduus.com/Resumes/

I have Visio for Visual Studio.NET Enterprise Architect 2003 and I am designing a PostgresSQL database using it. Is it possible to generate and manage a PostgresSQL database using Visio?

I have to update a PostgreSQL linked server through MSSQL2K. I first configured the connection with ODBC as follows and I can do queries with no problem: EXEC sp_droplinkedsrvlogin @rmtsrvname = 'PostgreSQL', @locallogin = NULL GO EXEC sp_DropServer 'PostgreSQL' GO

How can I execute a query which prompt the user for input? Something like SELECT FROM Table WHERE Name= In Oracle PL/SQL, you use & before variable names to have the SQL*Plus ask for input. In Postgres PLpg/SQL, I read that the EXECUTE statement should let you do something like this, but I tried

Hi, all, I am looking for the 1991 and 1992 Black Box Catalogs. I am will to pay $$ for them. If you have one, please email me. Thank you. Tom

Please take a look at this project and place your bid to do the job. http://www.jobquote.com/c/current_project.aspx?pid=1100

Hi all, Looking for a affordable PostgreSQL database design tool? www.polderij.nl/happyfish Download your free trial copy now!

Please ook at this project and place your bid to do the job. http://www.jobquote.com/c/current_project.aspx?pid=1100

Hi, I have a database that was created with the encoding set to SQL_ASCII. A lot of data comes with accented characters. When reading this data with PHP, and using utf-8 as my broweser output charset, any accented characters are displayed as weird symbols. If I use the PHP function utf8_encode() around the data, it all looks fine again. ...

Hi, Would someone please help me with this question. I have the PDF file but I would like to read HTML. On http://www.postgresql.org/docs/manuals/ I read: "Manuals in HTML format as well as their DocBook SGML sources can also be downloaded from the FTP area."

Sorry for the seemingly novice posting, but I could find a solution for this on the web so far... I've been developing a database using postgresql (and loving it) and have started running into problems with attempting to update records using the ODBC connection. The tables that contain geometric fields are causing the problems. Whenever I...

Friends, We have created a good web site for various resources related to the process of knowledge discovery in data. The site is in its early stages right now, however we expect it to mature over next few months. Please visit us at http://www.eruditionhome.com/datamining Hopefully, this site will serve as a good resource for you....

I am working with an application whose performance is limited by the write activity (inserts, updates and deletes) on three specific tables. The database is RAM resident so read performance is not limited by the disk speeds. We are using Postgres 8 and I am wondering about the best way to set up tablespaces. We have 3 disk arrays. Would it...

Hi, I am hitting an issue when using SCROLL CURSORS. -->My Setup: PostgreSQL 8.0.3 on Windows XP Pro SP2 -->My Test Function: CREATE OR REPLACE FUNCTION TestFunction () RETURNS varchar(50) AS $$ DECLARE CursorProductGroups SCROLL CURSOR FOR SELECT * FROM TEST_TABLE;