Mester József wrote: Install /contrib/dbase. -- Bruce Momjian | http://candle.pha.pa.us pgman (AT) candle (DOT) pha.pa.us ...

Bruce Momjian

08-11-2004 01:24 PM
Bruce Momjian

We have a need to create temporary tables (within functions); the documentation states that temporary tables last as long as the pg session. What,...

Taber, Mark

08-11-2004 12:59 PM
Bruce Momjian

First, thanks for all your responses. The programmers have yet another question. We will be connecting to a single pg db from our...

Taber, Mark

08-11-2004 12:56 PM
Scott Marlowe

Eduardo Vázquez Rodríguez wrote: to a text file, to html, or to an excel spreadsheet? In pgAdminII it's a dropdown box at the bottom of the SQL...

Ron St-Pierre

08-11-2004 06:43 AM
Oliver Elphick

Hello everybody I have to work with postgresql, but I don't know which stable version using: the technical definition environnement is : -...

MP TORRE

08-11-2004 05:19 AM
Scott Marlowe

On Sun, 2004-08-08 at 23:35, Benjamin wrote: In addition to my previous post, or wait until 8.0 and use pitr to...

Benjamin

08-11-2004 02:50 AM
Benjamin

Once again, ;-) The script is finally done i hope ... i can create my function.... no problem but when i'm calling it up with a SELECT zufall();...

Marcel Boscher

08-11-2004 12:11 AM
Mike G

Hello all, I wish to know if there is some function soundex on PostgreSQL ? I'm need to make search based on this, and by now what I've made...

Roberto Rezende de Assis

08-10-2004 10:45 AM
Tom Lane

Hey there, ERROR: function round(double precision, integer, integer) does not exist Any suggestions Purpose is to generate a 4 digit errorcode 1st...

Marcel Boscher

08-10-2004 09:12 AM
Oliver Elphick

On Mon, 2004-08-09 at 20:00, Eduardo Vázquez Rodríguez wrote: $ psql -d mydb mydb=# \o /path/to/file mydb=# select ...; mydb=# \o In that case...

Oliver Elphick

08-09-2004 04:09 PM
Oliver Elphick

Steve Tucknott <steve (AT) retsol (DOT) co.uk> writes: In the form I showed, yes. Only if you're prepared to specify the actual record type in the...

Steve Tucknott

08-09-2004 11:15 AM
Steve Tucknott

Hello, Ill assume I have the correct mailing list since my question regards the tip located in the 7.4 user docs on arrays. It says that searching...

A Gilmore

08-09-2004 10:34 AM
Sean Davis

Hey guys, i got a question that bothers me quite a while, been looking everywhere but found no answer My idea is to automate this procedure for...

Marcel Boscher

08-09-2004 05:11 AM
Marcel Boscher

hi all, i'm new to pgsql, although i've developed several databases using access and vb / access. anyway, i want to ditch that approach and go open...

Skeets

08-06-2004 10:02 PM
mike g

I can't seem to create a trigger and function correctly to get it done.... I am trying to create the backend to a web-based checklist that will...

Christian Emery

08-06-2004 05:04 PM
Christian Emery

Gastón Simone wrote: Using the tablespace feature in the future 8.0 version or right now with help of symlink. However a suggest you to put in the...

Gaetano Mendola

08-06-2004 02:34 PM
Scott Marlowe

Environment: PostgreSQL 7.2.2 on FreeBSD 4.6 with PHP 5.0.0; Apache 1.3.26 Application: Moodle 1.3.3 Error message: : class does not have a...

Worth Bishop

08-06-2004 12:02 PM
Worth Bishop

Benjamin wrote: Not that I know of, but why would you want to anyway? Check out the docs...

Ron St-Pierre

08-06-2004 11:32 AM
Ron St-Pierre

Does PostgreSQL not support insert into mytable (row1, row2) values ('a', '1'), ('b', '2'), ('c', '3'), ('d', '4') ? If not, does anyone know why...

Si Chen

08-06-2004 10:27 AM
Tony Reina

Hi, I am trying to install Postgresql 7.4.3 on RedHat Linux 9. After I finished ./configure, I typed 'gmake', then it began to check. It shows...

Max Chu

08-06-2004 12:57 AM
Tom Lane

All, I'm trying to create a regular expression that plays nice with UNICODE strings. I'd like to allow any alphabetic or digit character (as defined...

David Norris

08-05-2004 12:49 PM
David Norris

I have a problem that I can't understand. I am using macosx, pg 7.4.3. I had a server running and working. I tried to bring the server down with...

Sean Davis

08-05-2004 10:17 AM
Tom Lane

I've upgraded postgresl from 7.1 to 7.3 and am having an issue with the following: 7.1 would truncate column names greater than 31 characters to...

Frank Voellmann

08-05-2004 04:53 AM
Oliver Fromme

I am migrating from mysql to postgresql. I have many auto_increment columns, all requiring code during loading to explicitly save the last insert id...

Sean Davis

08-04-2004 02:42 AM
Sean Davis

On Wed, 2004-08-04 at 17:16, michael (AT) floog (DOT) net wrote: Precisely that. Either all the data goes in or none of it does. Clean up your...

Martin Foster

08-03-2004 02:38 PM
Kenneth Marshall

The result of the function test() should be a list of integer coming from a column "ech_id" from a recursive...

Masse Jacques

08-03-2004 12:13 PM
Joe Conway

PostGreSql 7.4.3 I noticed that there was a change in the way that 7.4 handled trailing spaces in CHAR/VARCHARS, so upgraded from 7.2.4, I still...

Steve Tucknott

08-03-2004 11:04 AM
michael@floog.net

How are people doing automated comparisons of schemas in different databases? E.g. we have a dev database, a beta database, and a production...

Frank Kurzawa

08-03-2004 07:47 AM
Gaetano Mendola

---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql...

Pradeepkumar, Pyatalo

08-02-2004 11:31 PM
mike g

Hi all, I have 2 tables - table1 and table2. Both the tables are related to each other. I have written triggers so that if a tuple is inserted into...

Pradeepkumar, Pyatalo

08-02-2004 12:17 PM
Scott Marlowe

Hi all: In Dezign 3 I have created an sql schema and saved it locally. Dezign3 does not export it to an sql db. Is there a command that will access...

sql@aniota.com

08-02-2004 10:09 AM
sql@aniota.com

Thank you ! that did it. - Joel On Aug 1, 2004, at 11:15, Peter Eisentraut wrote: ---------------------------(end of...

Joel Rodrigues

08-02-2004 05:04 AM
Joel Rodrigues

Hi all, In want to write a function PP_ReadPoints() for my project. I have 2...

Pradeepkumar, Pyatalo

08-02-2004 03:23 AM
Pradeepkumar, Pyatalo

PostGreSQL 7.2.4 Can anyone tell me where trailing spaces are significant in CHAR, VARCHAR and TEXT fields? We pass a VARCHAR variable into a 3rd...

Steve Tucknott

07-31-2004 09:11 AM
Frank Bax

On Thu, 2004-07-22 at 11:16, Hari Bhanujan wrote: Post your code... ---------------------------(end of broadcast)--------------------------- TIP...

Scott Marlowe

07-30-2004 01:45 PM
Jeffrey Melloy

Hi most esteemed novices and experts. It is an honor to post here! I imported a MySQL dump into PostgreSQL (7.4.3) and was wondering what a good...

Austin Swinney

07-29-2004 06:01 PM
Tom Lane

PLEASE HELP. I've read and read and read and have tried all of the example calls. I need to call a pl/pgsql function that returns a custom type. Just...

Betsy Barker

07-29-2004 02:32 PM
Betsy Barker

Jean-Guillaume LALANNE wrote: It's possible (I've done it in the past), but I would not recommend it. If you don't need network connectivity (i.e....

Oliver Fromme

07-29-2004 12:45 PM
Oliver Fromme

Hallo, I've a quick question about a problem I have moving a database from V7.3 to V7.4. I have an old database in version 7.3, unfortunately on my...

Tobias Graf

07-29-2004 10:51 AM
Tom Lane

Hi , I have attached the function that I am trying to run. But I am getting the following error - select * from...

Pradeepkumar, Pyatalo

07-29-2004 07:23 AM
Pradeepkumar, Pyatalo

On Wed, 2004-07-28 at 17:38, Eduardo Vázquez RodrÃ*guez wrote: Do you need speed or precision? For max speed, use an int4 and drop the non-integer...

Scott Marlowe

07-29-2004 03:28 AM
Scott Marlowe

Hi everybody, at the moemnt I am writing a little app that uses the libpq client library. The function PQfnumber returns the column number...

Ralf Hasemann

07-28-2004 08:34 PM
Tom Lane

I have a 6-digit integer number for a patient identifier which I intend to use as a primary key (PK) for a table. It also will be a foreign key in...

Rafael Charnovscki

07-27-2004 09:33 AM
Rafael Charnovscki

hello, i was wondering how to specify hexadecimal constants in SQL in a way that postgresql understands. something like: select 0xFFFF; -- this...

Chris

07-27-2004 03:29 AM
Chris

Hi, I have written a function to update values in a table. The table structure is as follows: CREATE TABLE PointAttributes(AttributeId BIGINT NOT...

Pradeepkumar, Pyatalo

07-27-2004 12:49 AM
Stephan Szabo

I'm interested in upgrading to 7.4.x, and in preparation to moving my db's to the new version, I am looking to do a 'pg_dumpall'. In 7.3.3 - I've...

Martin J. Brown, Jr.

07-27-2004 12:27 AM
Martin J. Brown, Jr.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Tue, 20 Jul 2004, Mike Friedel wrote: Aglio Database Solutions provides high-quality...

Devrim GUNDUZ

07-26-2004 12:29 PM
Marc G. Fournier

Bob Jarman wrote: I'm using PyGreSQL: http://www.druid.net/pygresql/ You simply "import pgdb" and get a Python DB-API 2.0- compliant interface. ...

Oliver Fromme

07-26-2004 05:52 AM
Oliver Fromme

Hi, We have to develop an application for one of our clients. We are considering using PostgreSQL as the database. However, reliablity and...

Amitabh Kumar

07-26-2004 05:16 AM
Oliver Fromme

Hi, I'm building a function that utilizes a temporary table and I am doing a SELECT INTO variable from the table. I've read several posts about the...

Betsy Barker

07-23-2004 11:36 PM
mike g