PostgreSQL Database Forum

There doesn't seem to be any way to embed the name of the fields in a text file for either MySQL or Postgres. So, for example, if I had a tab delimited table of all my MP3's on a Win32 partition as well as all the MP3's on my laptop and I wanted to access them from a php/postgres application from either windblowsXP on one partition or Linux...

Dear sirs I have a crazy problem here. Nobody seems to known why. I am not a database expert nor do known much about Postgres. I am just a system administrator trying to move a database from one system to another. O the old system (slackware linux) the postgres was downloaded an compiled from source.

Hi everybody. Is there any way to alter the order the columns appear in a table (apart from using views)? I tried changing attnum from pg_attribute... but I could only mess the server up! Successive INSERT command crashed it until I restored the previous order... :-\ If the answer was "You have to create a new table and dump everything...

In trying to trim some data while selecting and loading from 2 tables into 1 I get the following: SELECT TRIM(TRAILING ' ' FROM s.strk_sym_cmplt), TRIM(TRAILING ' ' FROM s.stk_sym), s.c_p, o.dta_date, o.dta_date_num, o.dta_date_dys, o.strk_sym, o.strk_yr, s.strk_num, s.exp_sym, s.exp_mo, s.exp_mo_num, s.exp_yr, s.exp_yr_num, s.exp_date,...

hi I have a table: id | integer | not null default nextval('public.menu_2_id_seq'::text) parent_id | integer | description | text | not null how am I able to move some element with id = x before or after element with id = y ?

I have variable length strings in records in a flat ascii file I need to "trim" before or during load of the file to a table using psql embedded in C. What is the best way to accomplish this? Is there perhaps a variable type I should use other than varchar, that will accomplish this for me? Thanks for your help! Lynn Tilby

Hi, I get the following exception periodically. does anybody what is the reason for it to throw this exception? I really appriciate if anyone can help me on this. thanks, Chinthaka at org.postgresql.PG_Stream.flush(PG_Stream.java:356) at org.postgresql.core.QueryExecutor.sendQuery(QueryExecutor.java:159) at...

Hello. I have a problem with ecpg precompiler. In a code like: **** main() { .... some calls to EXEC SQL

Hello, I don't know if this is *entirely* a postgresql question or if it's my screwup with the database design. First, a little introduction to the problem: I maintain a database of open proxies (they're used for tagging and/or rejecting email) and I use postgres as it's backend. The list itself is contained in three tables: tHost...

Michael Meskes, Noèl Köthe, and myself orgnized a PostgreSQL booth at the LinuxWorld Expo in Frankfurt. It was a nice show, we had a good crowd, and interesting contacts. I put up some pictures of the event: http://developer.postgresql.org/~petere/lwe2003-pictures (The pictures tend to show the PG booth only when it was rather empty, but...

Hi, I am using DBD::Pg in some of my scripts. I want to customize the error login based on the error received. While I am happy with the Errstr message I want to take specific actions depending on Errstr or Err. Is there a list of all available error number (err) with associated error message (errstr) that is produced by postgres? Is...

Hi, is it possible to add a column to a table at a specific place ? Reading the man pages i could not figure that out. Thanks. Alex ---------------------------(end of broadcast)---------------------------

Hello, First of all I want to say that I really like this tsearch2 - it's a really great addition to Postgres!.. I am having one minor issue with it and I just can't quite figure out the best way to solve it... Basically I had a user enter the following string "Executive Assistant/Network Manager"... I am unable to find this data by...

Folks, I have a question or two regarding PHP and Postgres on the issue of speed: 1. Is the semicolon at the end of SQL superflous when sent to Postgres? Should it make much of a difference if I removed it? 2. A lot of SQL issued have white space characters (newlines, tabs and spaces) present - does this have any impact on how quick...

Hi, I have two db servers primary/backup for which I would like to synchronize a few tables. Basically I need to check every 30 - 60 minutes if on the primary table an update has beend one and add the changes to the backup server. The problem is that some of these tables have foreign keys so I cannot just simply drop and re-create them....

Hi, I am using DBD::Pg in some of my scripts. I want to customize the error login based on the error received. While I am happy with the Errstr message I want to take specific actions depending on Errstr or Err. Is there a list of all available error number (err) with associated error message (errstr) that is produced by postgres? Is...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi everybody, I have tables like create table xx ( id int4,

Hi all, WE currently use PG for the local database on our POS workstations in shops. Data is then extracted and sent back to head office. Also product updates etc are regularly sent to the shops. I have noticed over time that the shop PG databases get slower and slower. If I do a pg_dump, recreate the database and then restore the data - all...

Folks, Stefano is our project's Italian translator. But he's feeling a little overwhelmed lately. I'd desperately like to find someone to share the responsibility of English-->Italian translation with him. Please e-mail me ASAP; even if you can only help out on a one-time basis, this week, it would be appreciated. --

I have a development server where I, well, do my development. Occasionally, I will create a new schema within an existing database that I would like to use on my production machine. I know that doing a pg_dump -s <database> > somefile.sql will dump the entire schema of the database, but is there a way to export only schema X from the...

Hey, I was wondering if it is possible to send email from within PL/pgsql. I'd like to do this to avoid code duplication in multiple frontends. Can this be done somehow? Or do I have to write a C function for this purpose? If so, how does one go about that? Thanks, --

Does anyone know a good commercial application that does multi-master replication for postgres? Thanks ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Here's maybe a silly question, but I haven't seen it asked or answered so.. For those settings in the .conf file that say "this doesn't take effect until the database is restarted".. does that mean that "pg_ctl reload" also does not reload them? I imagine the statement is specific, and means what it says, but I'm curious anyway.. s'all...

I am working at a company that has been using MS SQL Server, and we are going to be switching over to postgresql next week. (Getting off of Windows will be a relief!) I am very familiar with SQL Server's "Enterprise Manager", which is their GUI for accessing the db. I have been acquainting myself with pgAdmin. There are a number of things...

hi I have a table: id | integer | not null default nextval('public.menu_2_id_seq'::text) parent_id | integer | description | text | not null how am I able to move some element with id = x before or after element with id = y ?