Martijn, days ago, although for some reason it was never received by the mailing list. ---- Marco,

Dann Corbit

11-02-2004 04:48 AM
Marco Colombo

Hi, I have a problem I dont really know how to solve except for writing a function. I have a table with prices; SecCode| Price |...

Alex P

11-02-2004 04:32 AM
Richard Huxton

Hi, when creating a query with a subselect SELECT name, (SELECT max(pop) FROM cities WHERE cities.state = states.name) AS max_pop FROM...

Alex P

11-02-2004 04:27 AM
Richard Huxton

Hi! I want to parse a query (SFW) and create new queries: one for each table referenced, if that possible. I've written a function for this in the...

Katsaros Kwn/nos

11-02-2004 04:05 AM
Katsaros Kwn/nos

Is there something to interface postgreSQL with QMail to store mails in pgsql instead of using mbox or maildir? Or maybe it's not a good idea to do...

Eric

11-02-2004 01:57 AM
Tino Wildenhain

Hi everyone, When importing a bunch of data (> 85000 rows) I get an error I can't explain. The table into which I'm importing has a unique clause...

Joolz

11-02-2004 01:33 AM
Joolz

I have a table that is usually really small (currently 316 rows) but goes through spasams of updates in a small time window. Therefore I have a...

Joseph Shraibman

11-01-2004 10:44 PM
Tom Lane

Is there any way to determine the last time statistics were analyzed on a given table? -- Jim C. Nasby, Database Consultant decibel...

Jim C. Nasby

11-01-2004 03:00 PM
Jim C. Nasby

I couldn't agree more!.. I've been watching the list every day just to see what is going to be said next.... Good stuff! - Greg

Net Virtual Mailing Lists

11-01-2004 02:07 PM
Net Virtual Mailing Lists

On 1 Nov 2004 at 20:45, Glen Eustace wrote: It's more likely that the functions are defined in the template1 database and so get copied to every...

Gary Doades

11-01-2004 02:00 PM
Glen Eustace

The Postgres manual says: The AT TIME ZONE construct allows conversions of time stamps to different time zones. I'd guess most people would think...

David Garamond

11-01-2004 11:47 AM
Tom Lane

hi, what do u do if the DB become big and u have to spread it into two or more computers. Links and Docs are ok too ? For example what if u do if u...

raptor

11-01-2004 10:49 AM
Richard Huxton

Hi. i would like to log every single query coming in to the database into a table. i would like the log to include the entire query and...

stig erikson

11-01-2004 09:59 AM
Michael Fuhr

Sorry, hit Sent too early... David Garamond wrote: Compare with: # select timestamptz '2004-11-01 12:00:00-05' = timestamptz '2004-11-01...

David Garamond

11-01-2004 08:02 AM
David Garamond

Did you know what is the maximum character length for a name of : a database or schema ? a table or a view ? a column ? a constraint ? an index...

Fred BROUARD - SQLpro

11-01-2004 05:05 AM
Ian Barwick

Hallo List! I just found this old posting on google. Now my question is how can I read an integer value from the PGresult using the binary format?...

Bastian Voigt

11-01-2004 02:16 AM
David Helgason

I export data from a table that contains a varchar field that stores whole names in it. Some of the names include the apostrophe...

GreyGeek

11-01-2004 01:43 AM
Oliver Elphick

Hi everyone From time to time i get the following error: could not fork new process for connection: Resource temporarily unavailable im using...

Ben-Nes Michael

11-01-2004 12:48 AM
Ben-Nes Michael

Hi! Can I use postgresql on windows without cygwin?

Michael Shtelma

10-31-2004 11:52 PM
Bruce Momjian

Hello, i'm etablishing a naming convention for a new project under postgresql. For tables, sequences, views, that's ok! I used good naming...

Bruno Lavoie

10-31-2004 05:08 PM
Bruno Lavoie

Hi all, Question: is there any way to use environment variables (or something similar) in my saved SQL code, and have them expanded at runtime? I...

Andy Gimblett

10-31-2004 05:02 PM
Joe Conway

Hi, In 7.4.6 there is only plpgsql under pl where as 7.4.5 includes it in the main distribution can anyone tell from where plperl for 7.4.6 can...

Rajesh Kumar Mallah

10-31-2004 03:26 PM
mallah@trade-india.com

Hello I know it is possible to time isolated queries through the settting of the \timing option in psql. This makes PgSQL report the time it took...

nd02tsk@student.hig.se

10-31-2004 02:52 PM
Ken Tozier

"Ed L." <pgsql (AT) bluepolka (DOT) net> writes: I don't think so. Since sequences are inherently not transactional, it seems wrong to fire a...

Tom Lane

10-31-2004 11:10 AM
Ed L.

CREATE RULE "new_rule2" AS ON DELETE TO "public"."klients_view" DO INSTEAD ( DELETE FROM klients WHERE (klients.klient_id =...

Stanislaw Tristan

10-31-2004 10:41 AM
Michael Fuhr

Hello, Yes, you can do that, programmatically: Here is some DAO code for your Access project: Dim strTblName As String Dim strConn As String Dim...

Philippe Lang

10-31-2004 04:06 AM
Philippe Lang

I did not notice in the Install instructions that a dump restore needed to be done... This is what I got when I upgrade the v8b3 to the...

Jerry LeVan

10-31-2004 03:10 AM
Claudio Duffini

Somehow I missed the ltree array stuff - this solves fairly nicely at least the second part of my problem, but I'm still not sure how to optimize the...

Net Virtual Mailing Lists

10-31-2004 12:29 AM
Oleg Bartunov

On Sat, 30 Oct 2004 15:17:16 -0700, Shane Wegner <shane-keyword-pgsql.a1e0d9 (AT) cm (DOT) nu> wrote: select lastname,count(*) as c from names group...

Ian Barwick

10-30-2004 07:12 PM
Tom Lane

On Tue, 26 Oct 2004 08:03:26 +0200, tom.zschockelt (AT) flender (DOT) com <tom.zschockelt (AT) flender (DOT) com> wrote: Providing details of the...

Ian Barwick

10-30-2004 06:24 PM
Ian Barwick

Hello Why is it that PostgreSQL chooses to have features like replication, fulltext indexing and GIS maintained by others outside of the...

nd02tsk@student.hig.se

10-30-2004 04:15 PM
Jan Wieck

Yes, this looks like a known issue that is fixed in current CVS, but not in any of the released betas. (By the way, there is a beta-4 out there to...

Magnus Hagander

10-30-2004 04:11 PM
Magnus Hagander

What does this mean? WARNING: Rel pg_class: TID 17/13: InsertTransactionInProgress 106004881 - can't shrink...

Ed L.

10-30-2004 02:06 PM
Tom Lane

Hello, I've got one 7.4 installation and a brand new 8.0 beta4 running on the same machine. Both installations are configured to use the same...

Vinko Vrsalovic

10-30-2004 10:48 AM
Vinko Vrsalovic

Dear All, I have a simple join query SELECT c1 FROM t1 INNER JOIN t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3; Which gives the expected result but I...

C G

10-30-2004 02:09 AM
Russell Smith

I'm sure this has been answered before, but the search seems to be down again. How can I convert the results of a subselect into an array?...

Jim C. Nasby

10-30-2004 12:40 AM
Michael Fuhr

Hi, I'm trying to write a recordset-returning function that returns a values from a base table, and one column from a joined table, where the joined...

Eric E

10-29-2004 07:43 PM
Paul Tillotson

I'm designing a system where I'll be making frequent updates to rows, but some columns will change far less frequently than others. All columns...

Ben

10-29-2004 07:03 PM
Ben

Try a cast, or just use UNION ALL On Fri, Oct 29, 2004 at 04:44:37PM +0200, Karsten Hilbert wrote: -- Martijn van Oosterhout <kleptog (AT) svana...

Martijn van Oosterhout

10-29-2004 06:27 PM
Tom Lane

ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 Running 7.4.5, I frequently get this error, and ONLY on this particular character...

Cott Lang

10-29-2004 04:56 PM
Ian Pilcher

I need advice on archiving data from our production database. Each night I would like to save and remove a day's data from two weeks ago, from all...

Sally Ruggero

10-29-2004 04:21 PM
Joshua D. Drake

I was just wondering why the btrim syntax that takes only a single argument is not documented in 9.4 in the documentation (I checked both 7.4 and 8.0...

Thomas F.O'Connell

10-29-2004 02:21 PM
Thomas F.O'Connell

=?UTF-8?B?U8OtZGFyIExD?= <slopez_pg (AT) ceroriesgo (DOT) co.cr> writes: Most people use the standard Unix "cron" utility for this. regards, tom...

Tom Lane

10-29-2004 02:14 PM
Alvaro Herrera

Hmm, I'm using another SMTP server now that actually informs me when it is unable to deliver. Apparently it bounces intermittently with...

Marco Colombo

10-29-2004 11:53 AM
Thomas Hallgren

Hi All, I'm unsure if this is the correct mailinglist for my question. I have a problem with CREATE DATABASE, but as the docs state that officially...

M.A. Oude Kotte

10-29-2004 11:26 AM
Tom Lane

I've sent an e-mail to Guiseppe Tanzilli about this, but maybe someone here has seen this. I'm pretty sure it's not PostGreSQL, but it...

Joel

10-29-2004 07:47 AM
Joel

Thanks to some help here on the list, I've been able to get addresses sorting pretty well, but now I have a issue with same addresses on different...

Robert Fitzpatrick

10-29-2004 07:22 AM
Greg Sabino Mullane

Thanks for the response on this, especially the tip regarding xmin. I've been spending much of the night and morning comptemplating this issue. I am...

Terry Lee Tucker

10-29-2004 06:41 AM
Karsten Hilbert

On Thu, 28 Oct 2004, Thomas Hallgren wrote: Let's take a look at the bigger picture. We need to serve many clients, that is many sessions, that is...

nd02tsk@student.hig.se

10-29-2004 06:38 AM
Marco Colombo

Hello, i installed the new Beta. And first everything seams to work fine. But sometimes I get this error Message: (FATAL: terminating connection...

Stefan Sturm

10-29-2004 03:19 AM
Stefan Sturm