I want to concatenate 2 fields : tpmov char(4) | dsmov char(10) ---------------+---------------- AB | SOMETHING If I do: SELECT tpmov...

Luiz K. Matsumura

07-23-2004 01:56 PM
Tom Lane

I am starting to build an internet directory. What type of system generated unique ID would you suggest? ---------------------------(end of...

sql@aniota.com

07-23-2004 12:48 PM
John Brookes

First of all, my apologies for posting it to 3 lists: I'm not sure if this is an admin question, or I only have this question because I'm a novice,...

Si Chen

07-22-2004 04:45 PM
Tom Lane

"Richard Watt" <warren_tf_mcarthur (AT) hotmail (DOT) com> writes: Double check that the postmaster is really listening to 5321 and not some other...

Tom Lane

07-22-2004 02:13 PM
Tom Lane

I have upgraded my dual processor AMD64 server running FreeBSD 5.2.1 to PostgreSQL 7.4.3 and decided to being making use of pg_autovacuum in order to...

Martin Foster

07-19-2004 08:12 PM
Martin Foster

VIRUS ALERT Notre anti-virus a trouvé W32/Bagle-AI virus dans un email vous etant adresse par: ?@68-72-6-238.ded.ameritech.net Le message a été...

virusalert@pyrenet.fr

07-19-2004 04:44 PM
virusalert@pyrenet.fr

I wrote the following: CREATE OR REPLACE FUNCTION escritorio.seq_valor_actual( text) RETURNS integer AS ' DECLARE secuencia ALIAS FOR...

Marcos Medina

07-19-2004 12:23 AM
Tom Lane

When trying to find duplicates on an table how I need to know how index the table to optimize performance. Should there be an index for each...

Loftis, Charles E

07-19-2004 12:05 AM
Tom Lane

Mark Dexter

07-18-2004 06:39 PM
Scott Marlowe

On Fri, 2004-07-16 at 22:04, Steve Tucknott wrote: Should be: ALIAS FOR $1 -- Oliver Elphick olly (AT)...

Oliver Elphick

07-18-2004 06:13 PM
Oliver Elphick

Ignore my previous messages - I have found the answers.... The FUNCTION not running was caused by my ALIAS settings - I had the aliases defined as...

Steve Tucknott

07-18-2004 07:00 AM
Steve Tucknott

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I?m a spanish user from a short time and I?ve a problem each time I tried to insert a record with...

Alexis Serafin

07-18-2004 06:49 AM
Markus Bertheau

POSTGRESQL 7.2.4 (RedHat 8 RPM Install) Due to an earlier problem with FUNCTIONs in postgre, I thought I'd use pgaccess to see if that gave me...

Steve Tucknott

07-18-2004 04:23 AM
Steve Tucknott

Hello, I recently set up a small Mandrake 10 box that I want to use as a DB server.... I tried to log in to postgres through ssh and trough webmin...

Yves

07-16-2004 09:51 AM
Yves

Yes, I was thinking about a threaded client that would be able to fetch from several portals (quasi) simultaneously and repeatedly (but with other...

Marcus Andree S. Magalhaes

07-16-2004 07:57 AM
M. Bastin

On Saturday 03 July 2004 6:37 am, Vitaly Belman wrote: This is expected. It has to do with MVCC, not commit. PostgreSQL creates a duplicate record...

Steve Crawford

07-15-2004 05:07 PM
M. Bastin

Hi, I'm a bit under temporal pressure and I don't have much experience with data base design (only did some stuff with DBase a couple of years...

Felix E. Klee

07-15-2004 03:34 PM
Felix E. Klee

resend after joining list ...

Frank Voellmann

07-14-2004 04:06 PM
Bruce Momjian

Hello, I have a multilingual portal running on PostgreSQL 7.4.2. My clients come from spain,portugal, latin america and germany (mainly). The main...

Ullrich Ralf

07-14-2004 03:36 PM
Lynna Landstreet

Hello. I am a beginner with pgsql and struggeling with the documentation. Why can't I pass OLD from my rule to the function so the function knows on...

R.Welz

07-14-2004 10:29 AM
Tom Lane

Hello, Has anyone installed postgis successfully on red hat 9? Red hat comes with a version of postgresql (7.3.2) already installed, and when I do...

Marie-Lise VAUTIER

07-14-2004 06:20 AM
Devrim GUNDUZ

On Sun, Jan 18, 2004 at 00:02:42 +1300, Ankur Arora <"Ankur Arora"@clear.net.nz> wrote: Its possible to do something like this with subqueries as...

Bruno Wolff III

07-13-2004 02:58 PM
Bruno Wolff III

Good day, I hope you guys can help me, I went through the archives and spend some time Googling, and I think my biggest problem is not really...

Werner vd Merwe

07-13-2004 02:23 PM
Frank Bax

On Tue, Jul 13, 2004 at 12:02:38 +0300, Costin Manda <costin (AT) interpoint (DOT) ro> wrote: Please keep responses posted to the list while...

Costin Manda

07-13-2004 07:43 AM
Bruno Wolff III

Hi Postgres people! yes, I googled a lot for an answer to this question and found out that it was asked several times, but I could not find a...

Ralf Hasemann

07-12-2004 07:50 PM
Stephan Szabo

I'm writing some perl to sendmail maillog reporting. Since the logs are too big to some of the things I want to do, I'm just stuffing it to a pgsql...

Andy Harrison

07-12-2004 02:02 PM
Andy Harrison

Hello, Is there any way to set up overloaded functions whose parameters are composite types (i.e., row types) within a table inheritance hierarchy,...

David.Ventimiglia@wellsfargo.com

07-12-2004 12:11 PM
David.Ventimiglia@wellsfargo.com

Hi there, Does anyone else here host their sites with pgHoster.com? More to the point, does anyone know what's happened to them? We switched our...

Lynna Landstreet

07-11-2004 11:30 AM
MK

MS Access 2003 ODBC 7.03.02.09 snapshot or 7.03.02 released version 7.4.3 (cygwin) My application needs updatable views to use as record sources for...

David P. Lurie

07-10-2004 08:40 AM
David P. Lurie

Hi suppose we have the following query: select ....from ...where...and x *=3; "x" is an integer array,here we want to check whether "x" contains 3...

gavaneh

07-10-2004 12:29 AM
Tom Lane

---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Pradeepkumar, Pyatalo

07-10-2004 12:14 AM
Tom Lane

I'm running Debian unstable, and I keep getting a message from a cron job that wants to do.maintenance about no password...

ghaverla@freenet.edmonton.ab.ca

07-09-2004 08:59 PM
Tom Lane

Hi all! Something weird seems to be happening when I try to restore a db, pg_dumped on PC 1, on a second PC. PG vers. 7.2 is running on both PCs...

Ennio-Sr

07-09-2004 05:18 PM
Ennio-Sr

on 7/9/04 1:32 PM, Eduardo Vázquez Rodríguez at evazquez (AT) insys-corp (DOT) com.mx wrote: Wow, a question *I* can actually answer!...

Lynna Landstreet

07-09-2004 01:54 PM
Lynna Landstreet

Hi, Can anyone explain what may be the reason to the drastic difference in the execution speed of the same SQL statement, executed from the command...

Dmitry Karasik

07-09-2004 09:31 AM
Stephan Szabo

Hi all, I have written a sample procedure where i pass 2 arguments. Based on the arguments i need to select few fields from a table. After selecting...

Pradeepkumar, Pyatalo

07-07-2004 06:13 AM
Pradeepkumar, Pyatalo

Hi All Has anybody had experience with both JDBC and ODBC? Could you make some comments about the usability and performance of both. I'm trying to...

Chris Leahy

07-07-2004 02:15 AM
Mel Jamero

Hello. Can I use the procedural language plpgsql inside a RULE or do I have to CREATE FUNCTION for this? Thanks for helping me in my first steps...

R.Welz

07-04-2004 08:43 AM
R.Welz

Hello all, why this does not work ? ----------------------------------------- create table original(num...

Roberto Rezende de Assis

07-04-2004 06:10 AM
Markus Bertheau

Hello. What do I have to do to install plpgsql ? I tried as root: /usr/local/pgsql/bin/createlang plpgsql test to enable plpgsql in database test,...

R.Welz

07-03-2004 01:05 PM
R.Welz

This actually sounds more like an issue with your html coding. If you are executing select statements against postgres, a row of data is returned,...

mike g

07-02-2004 12:16 PM
Aarni Ruuhimäki

I'm not sure if this is a good list to discuss this to make sure it are good ideas, but here I go. This is something that has kept bugging me with...

M. Bastin

07-01-2004 01:47 PM
M. Bastin

Hi All I completed a regression test on a new install. There are a lot of errors. After examining the diffs file I think it is OK, but I would like...

Chris Leahy

07-01-2004 10:35 AM
Tom Lane

For Postgres: 1. Is there an ODBC example to identify/process records locks in Postgres? 2. Is there an example using ODBC to set the statement...

Robert Antonio

06-29-2004 01:41 PM
Robert Antonio

By mistake I took away superuser rights from my postgresql Admin. Any idea how to get it back? There is no other superuser in the...

Reinhard Hnat

06-29-2004 10:07 AM
Tom Lane

Hello: I am using postgres 7.35 on a Linux 9.0 PC. I am trying to create a technical intranet using the postgresql database for the information....

Larry J. Gross

06-28-2004 03:24 PM
Scott Marlowe

Hi Lynna, I have my site with them, and so far, I am pleased. (I am with them for 1 year now). If you have technical issues, you must use their...

Dani Oderbolz

06-28-2004 07:49 AM
Dani Oderbolz

Hi I have a problem with initdb ! When i run initdb it stops at line 6 at the following messages $ ipc-daemon2 & $ initdb -D...

Hondjack Dehainsala

06-27-2004 06:54 AM
Hondjack Dehainsala

Hi, We recently switch over from Solaris to Linux and we've been experiencing a couple database corruptions problems. We're using the 2.6 kernel...

Michael Guerin

06-24-2004 04:10 PM
A Palmblad

We are using postgres as the back-end to our webapp which is built with Jakarta Tomcat, Struts, and Hibernate. Most of our database-related activity...

Frank Kurzawa

06-23-2004 06:28 PM
Frank Kurzawa