PostgreSQL Database Forum

This is postgres 7.4 on a linux box ... I have driven myself to distraction trying to what ought to be easy. I have a table with house number, street direction, street name and street suffix as 4 columns. I want to paste them together as one text string for use by another application. SELECT s_house,s_post_dir,s_street,s_suffix FROM...

Hello everyone: I am attempting to upgrade from 7.2 to 7.4 Postgresql. I have successfully installed 7.4 and am attempting to use the pgdump from 7.2 for 7.4. I'm having only one slight error that I would like some help with. I create both the pgsql and pltcl languages. I get two messages that I don't understand. The first is a...

Hi all, I have to develop an embedded database with PostgreSQL. I have a Linux Distribuction that works only in single user mode as root. The postmaster daemon starts only if I 'm not root user. Do you have a solution for this problem ?? Thanks.

Recently there has been some discussion about attaching a timezone to a timestamp and some other discussion about including a 'day' part in the interval type. These two features impact each other, since if you add a 'day' to a timestamp the result can depend on what timezone the timestamp is supposed to be in. It probably makes more sense to...

Hi, i would like to check for a given query (insert, update, delete) if there is a key or constraint violation which prevents the query from being executed. Is such a feature implemented in the perl or java drivers? If so, could anyone point to a list of available return codes? Thanks

Hi all, What are the characters used for pattern matching with PostgreSQL 7.3. I know it is using % and _ . Any other characters ?. rgds Atnony Paul ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

I am trying to install PostgreSQL on OS X 10.3, using the package from Entropy.ch. The installation instructions there, as well as anywhere else I have seen them on the net, say to create a user (using the System Preferences pane) with a shortname "postgres". The problem is, this user already exists in my netinfo database/domain, and so I...

Hi. As most of you know, comp.databases.postgresql.general is a wonderful resource. What you may not know is that it has not gone through a process that would enable it to be listed on hundreds of usenet servers worldwide by default. Normally groups that are under the comp.* hierarchy go through a something called RFD and CFV. ...

We currently are running a data intensive web service on a Mac using 4D. The developers of our site are looking at converting this web service to PostgreSQL. We will have a backup of our three production servers at our location. The developers are recommending that I purchase a 2GHz Dual Processor G5 with between 2GB and 4 GB RAM. They say...

I would like to be able to truncate all of the tables in a schema without worrying about FK constraints. I tried issuing a "SET CONSTRAINTS ALL DEFERRED" before truncating, but I still get constraint errors. Is there a way todo something like: 1) disable all constraints 2) truncate all tables 3) re-enable all constraints ? In the slony...

What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0? Is it still considered an important maintenance task? If so, how frequently is it needed? Ed ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Hi, Anybody know/have functions or package to create text file from postgres function? I want to execute a function to take some fields from a table and save it in a text file (or xml format). I need function like: createfile(filename); appendtofile(filename,text);

Hi! I have to select a random row from a table where primary key isn't continuous (some rows have been deleted). Postgres just seems to do something strange with my method. -- -- Use the order by desc limit 1 -trick to get maximum value -- CREATE OR REPLACE FUNCTION max_uid() RETURNS int4 AS

Hello all, I have a few somewhat simple questions.... Does the postmaster vacuum it's internal (pg_*) tables? if not what is the best way to vacuum them without having to vacuum the entire db? and how often is this recommended to be done? Thanks,

People, I will visit Seoul, Korea to attend "3rd Northeast Asia OSS Promotion Forum" from Dec 1st to Dec 5th. I would like to meet with someone from Korean PostgreSQL community. Please let me know if you are interested in. -- Tatsuo Ishii ---------------------------(end of broadcast)---------------------------

I am running a web-based accounting package (SQL-Ledger) that supports multiple languages on PostgreSQL. When a database encoding is set to Unicode, multilingual operation is possible. However, when a user's input language is set to say English, and the user enters data such as "79", the data that is sent back to PostgreSQL for storage is...

While dealing with filesystem bloat issues, I found a large file named 43710738, recently updated and sitting in one of my database directories, $ ls -lh ../../../data/base/11259315/43710738 -rw------- 1 dba dba 1016M Nov 3 17:05 ../../../data/base/11259315/43710738 .... with no corresponding entry that I can find in...

Hi, Is there a way to translate information in pg_xlog files to a more readable format? Basically we have someone accidentally emptied a text column containing quite a large amount of text, and unfortunately have no backups. I know the pg_xlog is for WAL, and probably is not the proper way to restore a lost data. but I find some of the...

Is there a function that will give me the number of months, as an integer, in Pg 7.4.x? I found the date_trunc function but that will return text and I didn't see anything else? I have this, but didn't want to duplicate the work if it wasn't necessary: (date_part('Year', CURRENT_DATE) -date_part('Year', SOMEDATE)) * 12...

Is there a function that will give me the number of months, as an integer, in Pg 7.4.x? I found the date_trunc function but that will return text and I didn't see anything else? I have this, but didn't want to duplicate the work if it wasn't necessary: (date_part('Year', CURRENT_DATE) -date_part('Year', SOMEDATE)) * 12...

Hi, Is there a way to translate information in pg_xlog files to a more readable format? Basically we have someone accidentally emptied a text column containing quite a large amount of text, and unfortunately have no backups. I know the pg_xlog is for WAL, and probably is not the proper way to restore a lost data. but I find some of the...

I'm looking for a function that returns a md5 encryption for postgreSQL 7.3.4 I've found that this function exists on version 7.4, but I have had problems installing it on my Windows XP with Cygwin, so I need to found it for version 7.3 Anyone can help me? Sorry about my english, i'm spanish Víctor Robador Capel

Hello: I'm trying to use kylix3 and postgresql 7.4.1. My distro was Debian Woody, kernel 2.20. I make the link /usr/local/pgsql/lib/libpq.so pointing to libpq.so.2.2 and connection with my database get fine. But now, using Debian Sarge Testing, kernel 2.4.27 (I tried also with kernel 2.6.8-1) that link don't make things work anymore, I...

We currently are running a data intensive web service on a Mac using 4D. The developers of our site are looking at converting this web service to PostgreSQL. We will have a backup of our three production servers at our location. The developers are recommending that I purchase a 2GHz Dual Processor G5 with between 2GB and 4 GB RAM. They say...

I'm looking for a function that returns a md5 encryption for postgreSQL 7.3.4 I've found that this function exists on version 7.4, but I have had problems installing it on my Windows XP with Cygwin, so I need to found it for version 7.3 Anyone can help me? Sorry about my english, i'm spanish Víctor Robador Capel