Re: [GENERAL] [SQL] Flight numbers data

O Josh Rovero έγραψε στις Mar 29, 2006 : > We built an operational flight tracking and weather system that uses > Postgresql, > http://www.sonalysts.com/wXstation > > One data feed (FAA ASDI) uses both aircraft registration > numbers (tail numbers) and airline-assigned flight numbers. Typicall

Re: [GENERAL] [SQL] Flight numbers data

O Scott Marlowe έγραψε στις Mar 29, 2006 : > On Wed, 2006-03-29 at 02:17, Achilleus Mantzios wrote: > > Hi, i am in the process of writing an application about > > tickets, flights, etc, and i am thinking of getting the primitive > > data ready at the begining and doing it the right way, > > (e.g.

Re: [GENERAL] EXPLAIN SELECT .. does not return

David Link <[EMAIL PROTECTED]> writes: > The following large EXPLAIN SELECT Statement fails to return, but > continues to take up processing time until it is killed. > [ 52-way join... ] Am I right in guessing that all the sales_xxx tables are the same size and have similar statistics? I think t

Re: [GENERAL] Implementation Suggestions

Ian Harding wrote: I'm wondering if I could get some suggestions as to how implement this quickly and simply? I was thinking a web interface using PHP would be the fastest way of going about it. If you used Ruby on Rails, you'd be finished by now. It slices, it dices, it makes julienn

Re: [GENERAL] checking data type

raj wrote: is there a function that could check for a variable's data type? like i want to check all the columns of a table and if i found a column with an integer data type i set it to a default 1 and i'll set a constant to a column of type text. You could start psql with -E: psql -d dbname

Re: [GENERAL] weird GROUP BY error

Sergey E. Koposov wrote: Hi All! I experienced the strange error when running a simple query. 1) I have the following tables : wsdb=# \d slit_data Table "public.slit_data" Column | Type | Modifiers +--+--- chip | smallint | tile | sma

Re: [GENERAL] Is this possible.

On Thu, 30 Mar 2006 10:45:20 +1100, "Harvey, Allan AC" <[EMAIL PROTECTED]> wrote: > Hi all, > > Can sombody please help me realise a function, the intent as described by... > > -- Function to create the table for a new point > > CREATE OR REPLACE FUNCTION make_table( varchar ) RETURNS VARCHAR A

[GENERAL] Is this possible.

Hi all, Can sombody please help me realise a function, the intent as described by... -- Function to create the table for a new point CREATE OR REPLACE FUNCTION make_table( varchar ) RETURNS VARCHAR AS ' CREATE TABLE $1( parameter varchar(8) NOT NULL, value float NOT NULL,

[GENERAL] weird GROUP BY error

Hi All! I experienced the strange error when running a simple query. 1) I have the following tables : wsdb=# \d slit_data Table "public.slit_data" Column | Type | Modifiers +--+--- chip | smallint | tile | smallint | slit |

Re: [GENERAL] PostgreSQL client api

On Wed, 2006-03-29 at 16:48, Antimon wrote: > Yes i tried and realized apache child processes.. > Then i looked for another pooling solution, the project pgpool i found. > No windows binaries, it might run on cygwin. > After all, i think postgreSQL is not meant to run on windows production > for ~2

Re: [GENERAL] PostgreSQL client api

Yes i tried and realized apache child processes.. Then i looked for another pooling solution, the project pgpool i found. No windows binaries, it might run on cygwin. After all, i think postgreSQL is not meant to run on windows production for ~2 more major releases or something. It performs great o

[GENERAL] EXPLAIN SELECT .. does not return

Hi, The following large EXPLAIN SELECT Statement fails to return, but continues to take up processing time until it is killed. I've straightened up the postgresql.conf, as per Tom Lane's suggestions since last time I wrote about this. See: http://archives.postgresql.org/pgsql-general/2005-12

Re: [GENERAL] PostgreSQL client api

On Wed, 2006-03-29 at 15:58, Scott Marlowe wrote: > On Wed, 2006-03-29 at 15:22, Antimon wrote: > > Just tried, yes, pconnect boosts multi user performance. > > But causes this: > > http://img526.imageshack.us/img526/6302/pgsql7th.jpg > > :) > > > > Need to modify max persistent connection setting

Re: [GENERAL] PostgreSQL client api

On Wed, 2006-03-29 at 15:22, Antimon wrote: > Just tried, yes, pconnect boosts multi user performance. > But causes this: > http://img526.imageshack.us/img526/6302/pgsql7th.jpg > :) > > Need to modify max persistent connection settings. I don't thin that doesn't do what you think it does. max pe

Re: [GENERAL] Implementation Suggestions

Thanks for all the suggestions I now have a lot better idea of my options. It is nice to fire off a question at a mailing list and get so many positive helpful answers, gives me a warm and fuzzy glow. Thank you all -- Rory Hart Lifestyle Management Consultant Professional Lifestyle Managemen

Re: [GENERAL] PostgreSQL client api

Just tried, yes, pconnect boosts multi user performance. But causes this: http://img526.imageshack.us/img526/6302/pgsql7th.jpg :) Need to modify max persistent connection settings. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] More AIX 5.3 fun - out of memory ?

On Wed, 29 Mar 2006 11:22:11 -0500 Seneca Cunningham <[EMAIL PROTECTED]> wrote: > > Are "0x800" and "0x400" typos in this message, or did you really > request less than 256MB? Those numbers are the number of bytes > requested for the heap and memory is set aside in 256MB segments. No,

Re: [GENERAL] Implementation Suggestions

Bernhard Weisshuhn wrote: Kenneth Downs wrote: I have been meaning to investigate it because it is the only system I've heard of that makes the same claim that I do, which is to have eliminated entire categories of labor through automation. Have you looked at http://catalyst.perl.org/ late

Re: [GENERAL] postgresql.conf listen_addresses causing connection problems

> By "8.1" do you really mean "8.1.0"? If so, you might try updating to > the latest subrelease (currently 8.1.3). This problem doesn't offhand > seem to match any of the bug fixes I see in the CVS logs, but there have > been a number of Windows-specific fixes and maybe one of them explains > it.

Re: [GENERAL] postgresql.conf listen_addresses causing connection problems

> Just a thought, did you restart the server after making the changes? > From the Postgres docs- > "...This parameter can only be set at server start." Sure did, each and every time. On 3/29/06, Adrian Klaver <[EMAIL PROTECTED]> wrote: > On Wednesday 29 March 2006 02:59 am, David Bernal wrote: >

Re: [GENERAL] postgresql.conf listen_addresses causing connection problems

> Try * (wildcard) and see what happens. It should either work or not > work, not work 'sometimes' so I think there must be something else > involved. If pg_hba.conf is set up right, and listen address is * > then you have the network to look at. I actually also did try '*', and it actually did

Re: [GENERAL] [SQL] Flight numbers data

We built an operational flight tracking and weather system that uses Postgresql, http://www.sonalysts.com/wXstation One data feed (FAA ASDI) uses both aircraft registration numbers (tail numbers) and airline-assigned flight numbers. Typically if you have the latter, you won't get the former.

Re: [GENERAL] ODed on overloads

On Wed, Mar 29, 2006 at 12:19:03PM -0800, Joshua D. Drake wrote: > > > MY application sends XML requests to a perl script, which has to > > parse them and turn them into queries which get sent off, then the > > results are put back into XML, and sent back to the client. > > This doesn't answer yo

Re: [GENERAL] PostgreSQL's XML support comparison against other

If you have just a column containing a chunk of xml, and want to transform it into individual columns, such that each element/attribute is its own column, it should be pretty easy. Here's a simple perl example: Table "public.testxml1" Column | Type |

Re: [GENERAL] PostgreSQL client api

Antimon wrote: Just noticed, On windows, these results are produced. But on linux, postgresql performs great. So postgre has a bad windows integration than mysql. Well since it supports win32 for a long time, it makes sense. I did some "multi client" tests and postgre could not even catch mysql s

Re: [GENERAL] ODed on overloads

MY application sends XML requests to a perl script, which has to parse them and turn them into queries which get sent off, then the results are put back into XML, and sent back to the client. This doesn't answer your question... but why not just use plPerl? Joshua D. Drake -- =

Re: [GENERAL] PostgreSQL client api

Just noticed, On windows, these results are produced. But on linux, postgresql performs great. So postgre has a bad windows integration than mysql. Well since it supports win32 for a long time, it makes sense. I did some "multi client" tests and postgre could not even catch mysql so i decided to go

[GENERAL] ODed on overloads

I just wanted to get a sanity check on using overloading in PL/pgSQL. MY application sends XML requests to a perl script, which has to parse them and turn them into queries which get sent off, then the results are put back into XML, and sent back to the client. The XML language is pretty simple,

Re: [GENERAL] [SQL] Flight numbers data

On Wed, 2006-03-29 at 10:50 -0600, Scott Marlowe wrote: > > Has anyone from the postgresql camp ever solved such a problem? > > Where I work, we're building a middle level system (look up the website > that goes with my domain). And if we weren't in the airline reservation > industry, we couldn'

Re: [GENERAL] Create an index with a sort condition

On Wed, 2006-03-29 at 03:14 -0800, sylsau wrote: > I use PostgreSQL 8.1 and I would like create and index on a table's > field with a sort condition on this field. > For example, I have a table named books and I want create an index on > the fields title and id_book with an order by id_book descen

Re: [GENERAL] Implementation Suggestions

Ian Harding wrote: ... works fine, but you have to do it "The Rails Way" and expect no help from the "Community" because they are a fanboi cheerleader squad, not interested in silly stuff like referential integrity, functions, triggers, etc. All that nonsense belongs in the application! You e

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

On 3/29/06, Ted Byers <[EMAIL PROTECTED]> wrote: > May I ask a question about this? > > I will be working on an older database in which the original developer > stored XML documents as a single variable length text field. To process it, > it has to be retrieved in full and parsed. But the structu

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

May I ask a question about this? I will be working on an older database in which the original developer stored XML documents as a single variable length text field. To process it, it has to be retrieved in full and parsed. But the structure of it is simple in that it has an element for each

Re: [GENERAL] PostgreSQL client api

On Wed, 2006-03-29 at 12:19, Antimon wrote: > Hi, > I'm sorry about being understood like i was trying to compare pgsql > with mysql. I was trying stuff, did this and saw that huge difference > (even it is not bad alone, but comparing to mysql), and thought that > might be some library issue causin

Re: [GENERAL] Foreign key / performance question

On Wed, 2006-03-29 at 11:35, Nico Callewaert wrote: > Hi !, > > Is it wise to define foreign keys for referential entegrity ? > Example : I have a customer table with 40 fields. Out of that 40 > fields, 10 fields contain information linked to other tables. So, is > defining foreign keys for th

Re: [GENERAL] Foreign key / performance question

On Wed, 29 Mar 2006, Nico Callewaert wrote: > Is it wise to define foreign keys for referential entegrity ? > Example : I have a customer table with 40 fields. Out of that 40 > fields, 10 fields contain information linked to other tables. So, is > defining foreign keys for these 10 fiel

Re: [GENERAL] PostgreSQL client api

Hi, I'm sorry about being understood like i was trying to compare pgsql with mysql. I was trying stuff, did this and saw that huge difference (even it is not bad alone, but comparing to mysql), and thought that might be some library issue causing slow reads from server. I don't need any rdbms to be

Re: [GENERAL] Flight numbers data

On Mar 29, 2006, at 11:50 AM, Scott Marlowe wrote: There's much in the reservation industry that is basically a computer implementation of a 3x5 note card system. And none of those systems were originally built to talk to each other, so it's often impossible We at one time built a nice pre-d

Re: [GENERAL] Foreign key / performance question

On Mar 29, 2006, at 12:35 PM, Nico Callewaert wrote: Because from what I understand, for every foreign key, there is an index defined. So, all these indexes has to be maintained. Is that killing performance ? What's the best practise : defining foreign keys or not ? If your applicatio

Re: [GENERAL] Implementation Suggestions

On Mar 29, 2006, at 12:33 PM, Steve Atkins wrote: For the original poster - a web interface might well be the simplest to put together, but if a client turns out to be a better solution I'd strongly suggest looking at Qt. It has nice SQL support and it's very quick to turn around a simple

Re: [GENERAL] Implementation Suggestions

On Mar 29, 2006, at 11:03 AM, Kenneth Downs wrote: I am fascinated by your post. I have never heard a bad thing said about RoR. Most of what you read about RoR is written from a very superficial view of what it promises, as tainted by the simplistic uses of mysql people are familiar wit

Re: [GENERAL] Comparing 7.4 with 8.0

On Wed, 2006-03-29 at 11:58, Reimer wrote: > Hello, > > We would like to have only one PostgreSQL version at our clients, > currently some are using 7.4.6 and others 8.0.6. The first thing is > to migrate those 7.4.6 clients to 8.0.6. > > But before, I´ve to convince them that such migration

[GENERAL] Comparing 7.4 with 8.0

Hello,   We would like to have only one PostgreSQL version at our clients, currently some are  using 7.4.6 and others 8.0.6. The first thing is to migrate those 7.4.6 clients to 8.0.6.   But before, I´ve to convince them that such migration will be worth for them. My idea is to write a docum

[GENERAL] Foreign key / performance question

Hi !,   Is it wise to define foreign keys for referential entegrity ? Example : I have a customer table with 40 fields.  Out of that 40 fields, 10 fields contain information linked to other tables.   So, is defining foreign keys for these 10 fields a good idea ?  Because from what I understand,

Re: [GENERAL] Implementation Suggestions

On Mar 29, 2006, at 8:03 AM, Kenneth Downs wrote: Ian Harding wrote: I am fascinated by your post. I have never heard a bad thing said about RoR. I have been meaning to investigate it because it is the only system I've heard of that makes the same claim that I do, which is to have eli

Re: [GENERAL] PostgreSQL client api

On Wed, 2006-03-29 at 02:45, Antimon wrote: > I know this is not even a test but i thought it might be a client > library issue, not server itself. > Well it is not, i tried it on .net with npgsql which is a .net client > library (Not using libpq). Results are same. Connect time does not have > muc

Re: [GENERAL] Implementation Suggestions

Kenneth Downs wrote: I have been meaning to investigate it because it is the only system I've heard of that makes the same claim that I do, which is to have eliminated entire categories of labor through automation. Have you looked at http://catalyst.perl.org/ lately? IMHO it's "Rails done rig

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

On Mar 29, 2006, at 2:57 AM, Ivan Zolotukhin wrote: On 3/29/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: Ivan Zolotukhin wrote: BTW, are there any plans for its improvement? What are the first steps for the people who want to contribute to PostgreSQL in this field? The first step would b

Re: [GENERAL] Postgresql string parsing

[EMAIL PROTECTED] wrote: Hi Folks, I'm looking for the fatest way to parse string in a postgresql function and insert each parsed chunk in a table. Something like that: You might be able to use the |string_to_array function which |splits a string into array elements using the provided delim

Re: [GENERAL] Connecting

Thanks Tony I found it. Can you give me a hint as to how to open the file?? Bob - Original Message - From: "Tony Caduto" <[EMAIL PROTECTED]> To: "Bob Pawley" <[EMAIL PROTECTED]>; Sent: Wednesday, March 29, 2006 8:12 AM Subject: Re: [GENERAL] Connecting Bob Pawley wrote: Do I someh

[GENERAL] Postgresql string parsing

Hi Folks, I'm looking for the fatest way to parse string in a postgresql function and insert each parsed chunk in a table. Something like that: CREATE FUNCTION parse_and_insert(text) RETURNS integer AS ' DECLARE my_string ALIAS FOR $1; -- empty string, do nothing IF my_stri

Re: [GENERAL] [SQL] Flight numbers data

On Wed, 2006-03-29 at 02:17, Achilleus Mantzios wrote: > Hi, i am in the process of writing an application about > tickets, flights, etc, and i am thinking of getting the primitive > data ready at the begining and doing it the right way, > (e.g. the user will just select a flight number and doesnt

Re: [GENERAL] Implementation Suggestions

On 3/29/06, Ian Harding <[EMAIL PROTECTED]> wrote: Seriously, it's not too bad if you don't mind it's plentifulshortcomings.  I was getting carpal tunnel syndrome from typing pages so I switched to RoR for a hobby app.  Itworks fine, but you have to do it "The Rails Way" and expect no help from the

Re: [GENERAL] More AIX 5.3 fun - out of memory ?

Gavin Hamill wrote: Seneca Cunningham wrote: You're using a 32-bit build with the default memory model, it would seem. You're limited to less than 256MB for the heap in that model. Try stopping the postmaster and starting it back up with the environment variable LDR_CNTRL set to "MAXDATA=0x8

Re: [GENERAL] invalid page header

Jo De Haes wrote: OK. The saga continues, everything is a little bit more clear, but at the same time a lot more confusing. Today i wanted to reproduce the problem again. And guess what? A vacuum of the database went thru without any problems. I dump the block i was having problems with y

[GENERAL] Getting more information about errorcodes such as when these error1 happen

Good morning, In my plpgsql functions I use "exception when..." to catch possible exceptions of my data. I found postgresql error code track functions are very helpful. In my functions, I will not catch all error codes, but only the ones applying to my data operation . I found errorcodes in

Re: [GENERAL] Connecting

Bob Pawley wrote: Do I somehow have the wrong driver for my version of Postgresql or is there something in Postgresql that I need to switch on??? Bob Pawley Hi Bob, Make sure you have the listen_addresses setting in postgresql.conf set to * listen_addresses = '*'# what IP ad

Re: [GENERAL] Implementation Suggestions

Ian Harding wrote: I am fascinated by your post.  I have never heard a bad thing said about RoR. I have been meaning to investigate it because it is the only system I've heard of that makes the same claim that I do, which is to have eliminated entire categories of labor through automation. E

Re: [GENERAL] Guidelines for upgrading from pgsql7.4.xxx server to

On Tue, 2006-03-28 at 20:53, Luki Rustianto wrote: > Hi All, > > All of our application now runs on postgresql7.4.xxx servers, I never > tried it on version 8.xxx > > I wonder if there are any guidelines / step by step / special > considerations whether it applies to database structure or the > a

[GENERAL] PostgreSQL x Sybase

Hi,   Does anyone know of any recent comparisons of postgres vs Sybase?   Thanks in advance!   Reimer

Re: [GENERAL] invalid page header

Ok, So we reran everything and got the same error message again, now i'm able to reproduce it. 2006-03-28 12:05:18.638 CESTERROR: XX001: invalid page header in block 39248 of relation "dunn_main" 2006-03-28 12:05:18.638 CESTLOCATION: ReadBuffer, bufmgr.c:257 2006-03-28 12:05:18.638 CESTSTAT

Re: [GENERAL] invalid page header

OK. The saga continues, everything is a little bit more clear, but at the same time a lot more confusing. Today i wanted to reproduce the problem again. And guess what? A vacuum of the database went thru without any problems. I dump the block i was having problems with yesterday. It doesn'

[GENERAL] Create an index with a sort condition

Hello, I use PostgreSQL 8.1 and I would like create and index on a table's field with a sort condition on this field. For example, I have a table named books and I want create an index on the fields title and id_book with an order by id_book descendant. I know how to create the index without this

Re: [GENERAL] Implementation Suggestions

> >> I'm wondering if I could get some suggestions as to how implement > >> this quickly and simply? I was thinking a web interface using PHP > >> would be the fastest way of going about it. > > If you used Ruby on Rails, you'd be finished by now. It slices, it dices, it makes julienne fries. Se

[GENERAL] checking data type

is there a function that could check for a variable's data type? like i want to check all the columns of a table and if i found a column with an integer data type i set it to a default 1 and i'll set a constant to a column of type text. ---(end of broadcast)-

[GENERAL] using types for encrypting fields

Hi, I have the need to encrypt some columns in some tables. With Postgres 7.4, using a tablespace on an encrypted partition is not an option, right? Thus, my idea is: - put the encryption/decryption key in a temporary table - create types for each type of data which must be encrypted (enc_numeri

Re: [GENERAL] Advantages of PostgreSQL over MySQL 5.0

To go slightly OT, I have the current displeasure of becomming acquainted with Sybase which has ideas about being flexible with standards (and sanity) much like MySQL. The first of the two intentional "helpful" features I have come across so far is that inserting (or updating) char/varchar columns

Re: [GENERAL] postgresql.conf listen_addresses causing connection problems

On Wednesday 29 March 2006 02:59 am, David Bernal wrote: > > Any ideas? I'm fairly baffled, but then I'm a newbie. > Just a thought, did you restart the server after making the changes? From the Postgres docs- "...This parameter can only be set at server start." -- Adrian Klaver [EMAIL PROTE

Re: [GENERAL] postgresql.conf listen_addresses causing connection problems

"David Bernal" <[EMAIL PROTECTED]> writes: > I recently have been attempting to get my install of postgresql 8.1 > (running Win XP as OS) to listen on both 127.0.0.1 and my IP address, > 192.168.0.100 (inside my network, obviously.) As such, I tried first > setting listen_addresses = '192.168.0.100

Re: [GENERAL] postgresql.conf listen_addresses causing connection problems

On 3/29/06, David Bernal <[EMAIL PROTECTED]> wrote: > I recently have been attempting to get my install of postgresql 8.1 > (running Win XP as OS) to listen on both 127.0.0.1 and my IP address, > 192.168.0.100 (inside my network, obviously.) As such, I tried first > setting listen_addresses = '192.

Re: [GENERAL] Connecting

On Wed, Mar 29, 2006 at 06:08:44AM -0800, Bob Pawley wrote: > I have been attempting to connect to a database (Postgresql 8.0, running on > XP. > > I have two different applications that see and apparently connect to > the Postgresql ODBC driver (version - psqlodbc-08_00_0101) but I > receive an

Re: [GENERAL] PostgreSQL client api

On 28 Mar 2006 17:01:45 -0800, Antimon <[EMAIL PROTECTED]> wrote: > Nearly 3 times slower even w/o any table queries. But i could not > reproduce this by writing stored procs on both which selects 0-1 in > a loop to a variable. results were almost same. > (I tried pg_ and mysqli_ functions too,

[GENERAL] Connecting

I have been attempting to connect to a database (Postgresql 8.0, running on XP.   I have two different applications that see and apparently connect to the Postgresql ODBC driver (version - psqlodbc-08_00_0101) but I receive an error message when attempting to connect.   Do I somehow have the

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

On 3/29/06, Ivan Zolotukhin <[EMAIL PROTECTED]> wrote: > On 3/29/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > Ivan Zolotukhin wrote: > > > BTW, are there any plans for its improvement? What are the first > > > steps for the people who want to contribute to PostgreSQL in this > > > field? > >

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

On 3/29/06, Martijn van Oosterhout wrote: On Wed, Mar 29, 2006 at 02:57:44PM +0400, Ivan Zolotukhin wrote:> So let's make such analysis here within PostgreSQL community! There> were a lot of talks about XML support in Postgres, but they did not> lead to any steady work in this d

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

On Wed, Mar 29, 2006 at 02:57:44PM +0400, Ivan Zolotukhin wrote: > So let's make such analysis here within PostgreSQL community! There > were a lot of talks about XML support in Postgres, but they did not > lead to any steady work in this direction. IMHO, it's time to start it > now, no? Quite, le

Re: [GENERAL] table owner of cloned databases

Scott Marlowe wrote: > On Mon, 2006-03-27 at 11:04, Stefan Fink wrote: > >>Hi all, >> >>I would like to create a database based upon a template which also >>contains some tables. After invoking >> >>psql -T -U -O test >> >>the new database 'test' belongs to but all tables are still >>belongi

[GENERAL] postgresql.conf listen_addresses causing connection problems

I recently have been attempting to get my install of postgresql 8.1 (running Win XP as OS) to listen on both 127.0.0.1 and my IP address, 192.168.0.100 (inside my network, obviously.) As such, I tried first setting listen_addresses = '192.168.0.100, localhost' With it like that, when I try to conn

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

On 3/29/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Ivan Zolotukhin wrote: > > BTW, are there any plans for its improvement? What are the first > > steps for the people who want to contribute to PostgreSQL in this > > field? > > The first step would be making a detailed analysis of what "XML

Re: [GENERAL] Guidelines for upgrading from pgsql7.4.xxx server to pgsql8.xxx server

As others have pointed out, OID dependant tables may need special attention. We recently upgraded from 7.4 to 8.1.x and found some issues with encoding -- 8.1 defaulted to a different encoding and we had some data that was invalid; we manually fixed the old data before retrying the export. Make

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

Ivan Zolotukhin wrote: > BTW, are there any plans for its improvement? What are the first > steps for the people who want to contribute to PostgreSQL in this > field? The first step would be making a detailed analysis of what "XML support" is supposed to mean. (You alluded to one use case, but b

Re: [GENERAL] best practice in upgrading db structure

> Could somebody explain me, or point me to a resource where I can find > out what is the recommended practice when a live db needs to be replaced > with a new version of it that has a slightly different structure? Our development infrastructure includes a development data base cluster, with one

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

Hello, On 3/28/06, Merlin Moncure <[EMAIL PROTECTED]> wrote: > > Does anybody know good comparison/review article of XML support in > > major RDMBSes? I know that PostgreSQL's XML capabilities are quite > > weak, but how far is it from other products? > > Could you please desribe a specific exampl

Re: [GENERAL] best practice in upgrading db structure

Hello, > Could somebody explain me, or point me to a resource where I can find > out what is the recommended practice when a live db needs to be replaced > with a new version of it that has a slightly different structure? > > What do you usually do in a situation like this? That's a big problem f

Re: [GENERAL] about un-discrible

On 3/29/06, 查海平 <[EMAIL PROTECTED]> wrote: > hi, >Could anyone tell me how to un-discrible this mails list? how to do? Check the mail headers: List-Unsubscribe: -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast

[GENERAL] about un-discrible

hi, Could anyone tell me how to un-discrible this mails list? how to do? thx! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL client api

I know this is not even a test but i thought it might be a client library issue, not server itself. Well it is not, i tried it on .net with npgsql which is a .net client library (Not using libpq). Results are same. Connect time does not have much effect by the way. ---(end

Re: [GENERAL] More AIX 5.3 fun - out of memory ?

Seneca Cunningham wrote: You're using a 32-bit build with the default memory model, it would seem. You're limited to less than 256MB for the heap in that model. Try stopping the postmaster and starting it back up with the environment variable LDR_CNTRL set to "MAXDATA=0x8000". This expa

[GENERAL] Flight numbers data

Hi, i am in the process of writing an application about tickets, flights, etc, and i am thinking of getting the primitive data ready at the begining and doing it the right way, (e.g. the user will just select a flight number and doesnt have to enter the airports, airport coordinates, countries, ai

[GENERAL] updategram in pg

Is there a way to store update/insert logic in the data instead of writing db or application procedures to do that? I am looking for something along the lines of MS updategrams like this: Thanks for the help. Balázs ---(end of broadcast)--