PostgreSQL Database Forum

Dear All, I have installed the contrib xml package and have it working, but I would like some advice on the best way to use it. In particular, how should I alter xml files? For instance, if I have: <name>None</name> and I wanted to update 'None' to 'John', what's the best way of doing this? Can xml contrib package do this for me, if so...

Hello list, I have 7.3.4 on RH 8, server hardware is a dual processor Intel Xeon 2.4 Ghz, 2G RAM, 27Gb HD available on postgres partition. Table cost2est2003 with 99350 recs is described as: code char(4) -- index tcos numeric(12,4) mes char(6) -- index

Greetings, I'm trying to write a pl/perl function that will return multiple rows. I've looked all over the web and only found vague references as to how to do this (some said it was possible, and some said it wasn't but it was for older versions of Postgres). Basically I would *love* to be able to do something like this: SELECT some_id

Hi, I have two tables , A and B where table B has a foreign key constraint to table A. I want to delete all records in table A that are older than a certain date that are not referenced by table B. When I use a DELETE FROM the entire transaction fails as soon as a referential integrity violation is detected.

We have just packaged up our second Release Candidate for v7.4, with the hopes of producing a full release next week. A full ChangeLog is available at: ftp://ftp.postgresql.org/pub/sources/v7.4/ChangeLog.RC1.to.RC2 But, one of the highlights is that support for tcl8.0.x has been re-introduced.

Hi, I just went through the install notes on erserver1.2 and saw a mention in there that every table for replication requires a integer based column. It also states that a new column is added for every table that is replicated. The tables I intend to replicate already have such a column. Can the server be configured to use these instead so...

Hello! We working currently with the Oracle and we would like to know if postgresql has some similar components as the concept of instance, buffer database cache, Redo log buffer, datafiles, background process, etc. How postgre works? It works in memory? There is some figure that ilustrates your architecture? regards, Carla Mello e...

Hello, I'm quite new with PostgreSQL, so this question might be quite dumb, but is there any structure storing information about the transactions which are locked in a moment? I mean, is there, for example, an array with the IDs of the transactions which are locked in the same object? If so, what is its name? Thanks in advance! ...

Hello list, Is there a way to create indexes using functions like these: substring(prod_no,8,4) to_char(fkardex,'YYYYMM') substr(facnum,1,2) Help says is not possible but I would like to know if someone know an undocumented/tricky way to get that done.

Hi , Looks like ADD UNIQUE( some_fuc( some_feild) ) is not supported with add constraint. the only way is to add the constriant is using UNIQUE INDEX . Is it a bug or intended behaviour? Regds Mallah.

Hmmm... am i doing anything really silly? tradein_clients=# CREATE INDEX profile_master2 on profile_master (lower( btrim(email) ) ); ERROR: parser: parse error at or near "(" at character 61 tradein_clients=# Regds mallah.

How cvan i install the postgresql ODBC Driver for Windows if i have only a DLL ? Thanx in Advance

I have create user PIPPO: CREATE USER PIPPO; I have create a table: create table aa (id int4); Change owner of table to user PIPPO. alter table aa owner pippo; I drop user PIPPO. Who is the owner of the table?

After doing some googling through the lists and such, I wasn't able to arrive at a solution for a problem I've run into recently. I've seen mention of similar symptoms, but my case seems different. After recently upgrading to 7.3.4 from 7.3.1, I started having problems with using subselects in INSERTs. I'm seeing things like this...

Greetings, I'm trying to build 7.3.4 and I've come across two problems, one during the configure and the other afterward. Problem 1) Trying to build with openssl support gives this: ../configure --with-openssl --enable-odbc --with-perl --enable-multibyte

I have indexed two columns in a table. Can somebody explain to me why the first query below uses an Index Scan while the second uses a Seq Scan? Many TIA! Mark planb=# \d abcs Table "public.abcs"

I am trying to set up a project in Visual C++ to use libpq.dll from Postgres. Are there instructions on how and where to build the libpq.dll and then insert libpq.dll and libpq-fe.h into a project. Thanks, I am trying to get a quick start back into coding after not doing it for a while. I am using a Windows XP Professional OS for the...

On my windows/cygwin/PG 7.3.1 box, results are sorted with lowercase appearing after uppercase. On my redhat/PG 7.3.3 boxes results are sorted without regard to case. Is there some locale (or other) setting that controls this? If so, which locales do which? Or is this due to something else entirely - such as the OS's?

Hi I prepare to write a master thesis about PostgreSQL. I need some technical information about solution (concrite information about algorithms, why the postgresql "masters" used exactly this algorithms). Most information avaliable (s2k-ftp.cs.berkeley.edu:8000/postgre/papers, http://developer.postgresql.org/docs/postgres/biblio.html)...

Hello, Imagine we have the following kind of table, with two values (a and b), and a varchar (f) representing an expression. ---------------------------------- CREATE TABLE public.test ( id serial NOT NULL, a int4, b int4,

I maintain an internet site. The host is linux based and uses postgres on the server. I wish to install a smallish database (of names and addresses +) on the host, and allow it to be accessed over the internet (by a restricted number of people). I have the database working locally on a MS Access database, but would expect to transfer it to a...

Hi, We need to implement following logic efficiently. SELECT * from some_table where .... IF rows_matched = 1 THEN use the single row that matched.

Hi , my current database in 7.3.4 is SQL_ASCII are there any benifits of coverting it to UNICODE encoding in 7.4 ? If so what is the process. Regds Mallah.

Hello; If I add the line: ------------------- su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l /usr/local/pgsql/data/logfile' postgres ------------------- to /etc/rc.d/rd.local. Is there a way this could work when I don't boot as root, but as a common user?