PostgreSQL Database Forum

Has anyone successfully built 7.3.4, 7.4.3, or 8.0.0beta1 on IA64 with HP-UX 11i v2 (11.23)? I'm not having any success, running into 'make' failures. Googling old posts suggests this might be due to missing test-and-set code for ia64? I saw a disputed/repudiated ViSolve patch, but nothing else. Is this still broken? Here's my attempt on...

I need to get a server to run Postgres, Sun's AS8 and nothing else. I am favouring Linux and am aiming for a cheap server (around £900 / $1600). Does anyone have recommendations for a) Hardware and b) Distro. I am inclined to use Gentoo, but that's only because I'm used to it. John

Hi I'm trying to install postgreSQL V8 béta3 on AIX5.2 and the horlogy regression test fails: $ more /postgres_util/postgresql-8.0.0beta3/src/test/regress/regression.diffs *** ./expected/horology.out Sat Jul 10 23:57:20 2004 --- ./results/horology.out Tue Sep 28 15:51:33 2004 *************** *** 1775,1784 ****

What is the best "module" to use for mssql to set up a linked server with postgresql? -Josh ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

To all, Running into an out of memory error on our data warehouse server. This occurs only with our data from the 'September' section of a large fact table. The exact same query running over data from August or any prior month for that matter works fine which is why this is so weird. Note that June 2004 through today is stored in the same...

The postgres engine saves the function bodies, at least, without removing the carriage returns. Could it be changed to report the LINE within the function body that has the problem, based on the carriage return? I don't have an editor that counts characters within a document, but even if I did, Postgres doesn't consistently use that to say...

Hi Guys! Someone already read this the documentation below? http://www.janus-software.com/fyracle.pdf They are saying that PostgreSQL is so robust as Firebird according to triggers ( I think that they are talking about their "universal triggers"), SQL functionality and transactions. wow! Someone have something to say about this?

AIX pg version 7.4 Select * from document2 core dump. Did a few more experiments with select * from document2 limit... I limit to 500000 it works, 600000 it exits but says "calloc: There is not

I'm looking for a data modeler that can look at an existing database schema and generate an ERD. A PDF of it would be nice. I'm using OS X, but a Linux or Windows tool would be acceptable too. I don't need any other features than that right now. Just want to generate something that new developers can look at to more easily become familiar...

Hi, I was wondering if the .net connector for pgsql works fine on Visual C# on PocketPC 2002/2003 too. Any comments on past experiences is truly appreciated. Thanks, Fed

I had a bunch of tables that had v_ prepended to their names. I've renamed all of the tables so that they don't have that prefix anymore so that v_address is now addresses. The name of this table's sequence is still v_addresses_address_id_seq. This is fine except for the fact that I'm using JBoss and it assumes that the table's sequence is...

This is a tip for the record in case it helps somebody else in the future. I have an import script that relies on a stored procedure that runs as a trigger on inserts into a temporary table. The script looks like this: -- create table -- ... -- define procedure and trigger

Dear list, i want to limit the execution time of an SQL-query. That means, that the query should be stoped if it takes longer that e.g. 10 seconds. How can I do so? Hagen ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

I'm a little confused about why I am getting this. I was reading a message from Tom earlier that said it was because postgresql could not bind to localhost, but the statistics collector is running and localhost does resolve to 127.0.0.1. There is no dns server, only an /etc/hosts file. Is it possible that it's still resolving fine, but...

Hello! I'm using ltree data type for about 1 or 2 years now. I wan't to here how you people using this type and how your data is structured. For example: I use it for our directory service where I have some categories and entries (classifieds). Right now I have 2 tables. One for categories with ltree column and table for storing...

Hello, What is the recommended way of killing an indididual client connection to Postgresql, in case there is a deadlock? Thanks Philippe ---------------------------(end of broadcast)---------------------------

please CC me as I am on digest ------------------------------- I have three tables, simplified for, well, simplicity :-) CREATE TABLE Usrs ( usr_id serial primary NOT NULL, name text NOT NULL, login text NOT NULL,

Hi, I'm looking for details, or tools about porting a full Ms Sql Server 2000 database to Postgres on Linux. Is this possible? We have the whole nine yards, stored procedures, triggers, and all. Is there a way to automate this process?

Hello, I'm building a small web app (written in JSP) and using PostgreSQL 8.0 Beta 2 as the backend running on Windows XP (installed with pgInstaller). Ocassionally, I get this SQLException message in my web page: "SMgrRelation hashtable corrupted"

I'm calling one stored procedure with a prepared statement on the server with 6 arrays of around 1200 elements each as parameters. The parameters are around 220K in total. This is taking a surprising amount of time. Thus I put a lot of logging into the application and in the stored procedure that's getting called. It seems that almost all...

Hi, Is it possible to define "linked servers" like in MS-SQL? Or - is any work going on to implement such feature? So that using 2 postgresql DB's where one is in dmz and one in production - the last one has defined the one in dmz as a "linked server" and sql's sent to the internal DB can do joins between tables in internal DB and DB in...

Hi people, I was wondering is inheritance a sql -99 standard and is it available in oracle or not. i kow that postgresql supports inhertiance but wanted to know in case my boss wants to migrate from postgresql to oracle than in that case it would not be a pain designing the whole architecture again thanks for your time jay

Just installed and started Pg8.0 beta 2 When I tried to connect via psql, I received an error message: $ psql -Upostgres template1 psql: relocation error: psql: undefined symbol: PQsetErrorVerbosity Can someone give me a clue what to do next? Thank you -Patrick

I'm digging throught the data types and am trying to understand how to utilize the interval data type. I'm thinking I can use these values to add to another date field... Can someone give a simplified example of how I might use this? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our...

Hi, I would like to be able to figure out if a table has been updated in this connection from within a C trigger. I have already tried to the use a query with currval on the autoincremented primary key but that exits the trigger with table.currval is not yet defined in this session