On Sun, 10 Oct 2004 19:12:51 +0400, Eugeny Balakhonov <c0ff75 (AT) mail (DOT) ru> wrote: I think you could create a daemon/cron job which would get...

Eugeny Balakhonov

10-16-2004 06:44 PM
Gaetano Mendola

In Microsoft SQL Server, I can write an UPDATE query as follows: update orders set RequiredDate = (case when c.City IN ('Seattle','Portland') then...

Mark Dexter

10-16-2004 11:11 AM
Mark Dexter

Hello, I am trying to create audit tables for all of the tables in my database. The function, table and trigger create statements are...

Scott Cain

10-16-2004 01:57 AM
William Yu

I'm in the process of adding more historic information to one of my databases. I've liked the theoretical treatment of the concept in "Temporal Data...

Eric D. Nielsen

10-16-2004 12:13 AM
Michael Glaesemann

Hi All, Earlier this year there was a discussion between Tom and Ezra regarding extending 'set session authorization' to facilitate changing the...

Greg Wickham

10-15-2004 06:14 PM
Greg Wickham

I read "Chapter 23. Monitoring Database Activity" to monitor postgresql, but on Solaris it doesn't work. I tried "/usr/ucb/ps", but it doesn't work...

Leonardo Francalanci

10-15-2004 02:50 PM
Andrew Sullivan

I have a situtation where a particular table includes a timestamp column and a id column. The query I am working with right now filters based...

Thomas Yagel

10-15-2004 01:57 PM
Tom Lane

Hi, given a table with some data, e.g. some monthly measures. Some of the measures are missing though. id m1 m2 m3 m4 m5 .... ...

Alexander Pucher

10-15-2004 12:21 PM
Marco Colombo

Hi, I am getting ready to release a new version of my postgresql browser and regrettably no longer have access to any version 7 of postgresql. I...

Jerry LeVan

10-15-2004 12:10 PM
Jerry LeVan

I am in the process of converting an existing database to PostGreSQL and wrote a generic script to update all of the sequences as they default at...

Sim Zacks

10-15-2004 11:40 AM
Michael Fuhr

ljb <ljb220 (AT) mindspring (DOT) com> writes: Yeah, looks like Neil applied that about two weeks ago. regards, tom...

David Rysdam

10-15-2004 11:09 AM
Tom Lane

I have a database in sql_ascii that I need to convert to Unicode. I tried using pg_dump -Fc .. but it fails on certain characters. like this one...

Jason Tesser

10-15-2004 10:48 AM
Alvaro Herrera

One's marked VOLATILE, the other is marked IMMUTABLE. This affects whether it's considered a constant, the planner estimates and hence whether it...

Martijn van Oosterhout

10-15-2004 10:46 AM
Tom Lane

Hi, When I execute a function, I would like psql to show me only RAISE NOTICE messages but not all function calls.... Indeed, I currently get some...

Patrick Fiche

10-15-2004 10:43 AM
David Rysdam

Hello all, I am trying to get a total number of rows returned form a query. SELECT count(this) from table group by this Currently it is returning...

Dev

10-15-2004 08:47 AM
Dev

Dear postgres community, I would like to know what are the significant changes and new features introduced in Postgres 8.0 which warranted the major...

Artem Litvinovich

10-15-2004 07:26 AM
David Garamond

Hello, If I have a rule like this: CREATE OR REPLACE RULE sometable_update AS ON UPDATE TO table2 DO UPDATE cache SET updated_dt=NULL WHERE...

Net Virtual Mailing Lists

10-15-2004 05:57 AM
Oleg Bartunov

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. I'm trying to determine the best way of saying 'The current time in UTC with no time zone...

Stuart Bishop

10-15-2004 05:43 AM
Martijn van Oosterhout

Hello. I'm writing SQL functions that take an action code and determine the rows visible by accessing application-maintained privilege...

Mike Mascari

10-15-2004 01:02 AM
Tom Lane

Hi, I'd like to store who changed records on some tables. I'd prefer not to store the username but rather his/her ID. Will I allways have to...

Andreas

10-14-2004 10:24 PM
Andreas

Hi, folks.... There is a file located at /usr/local/pgsql/data/base/26920/ named 35987 that is roughly 750mb. Is there any way to find out...

Michael Holden

10-14-2004 05:20 PM
Alvaro Herrera

First, apologies in advance for this somewhat OT post ... I'm looking for a source of information on using the psycopg interface to postgresql. A...

Scott Frankel

10-14-2004 04:52 PM
Lee Harr

Postgres returns me 't' or 'f' from boolean field How to change that it returns me 'true' or 'false' replace(its, 'f', 'false') AS its doesn't...

Bambero

10-14-2004 04:43 PM
Bambero

Is there a way to do "dirty" reads on postgres? If there is an insert of a million records or so, is there a way to select from those records before...

Josh Close

10-14-2004 04:38 PM
Bruce Momjian

Hmm, very good points. Thank you. I was hoping for a get/easy solution, but those never pan out :) Your suggestion is also much more flexible --...

Eric D Nielsen

10-14-2004 01:20 PM
Michael Fuhr

I'm connected to a database and I want to verify that a username and password for some user is correct. I know I can verify a users existence by...

Thomas Hallgren

10-14-2004 01:19 PM
Steven Klassen

I have a large amount of data that I copy in and out of Sybase very often. Now I also want to copy this data in and out of postgres. I have an...

David Rysdam

10-14-2004 11:47 AM
Michael Fuhr

I wrote a function to sum arrays. It works, but I had to cast the data pointer to int64 (because my arrays are 'int8'): int64* ptr1 =...

Leonardo Francalanci

10-14-2004 09:33 AM
Leonardo Francalanci

Hi Guys! Anyone already made a importation from CTREE files ( files .dtc) to PostgreSQL ? I know that there is a "contrib" tool to import files...

Rodrigo Carvalhaes

10-14-2004 09:21 AM
Rodrigo Carvalhaes

Is there any way to remove a password, specifically from the postgres user? I installed the 8.0 Windows version via the installer, and it forces you...

Neil Berkman

10-14-2004 06:48 AM
Tom Lane

Hi Gaetano: This procedure to recover data from a corrupted table should be documented somewhere... If it is, I could not find it! Now I wonder if...

ruben20@superguai.com

10-14-2004 05:09 AM
Gaetano Mendola

Hi all, We, Software Research Associates, Inc., have started "PostgreSQL CE" (PostgreSQL Certificated Engineer), on Oct 1st. PostgreSQL CE is...

Tatsuo Ishii

10-13-2004 11:51 PM
Bruce Momjian

Hello I am going to do a comparison betweem PgSQL and MySQL replication system. I hear there are some replication projects available for PgSQL. ...

nd02tsk@student.hig.se

10-13-2004 10:11 PM
Christopher Browne

Dear All, Within a transaction, now() and current_timestamp are constant and give the time that the transaction started. This is normally what you...

Phil Endecott

10-13-2004 06:56 PM
Phil Endecott

On Saturday, our database machine locked up hard on us due to some faulty hardware. Since then, we have been getting messages like this: ERROR: ...

Steve Wolfe

10-13-2004 05:46 PM
Tom Lane

Hi I'm trying to create a select statement that will return all rows that are older than 30 milleseconds. Is either of these correct? select...

phil campaigne

10-13-2004 04:33 PM
phil campaigne

Hi, Im looking for instructions on installing the postgresql ODBC driver on mac osx and windows. Is there any reference for that. Any help...

Alexander Cohen

10-13-2004 01:06 PM
Robby Russell

In reference to the pg_clog errors I'm having, I am still looking for tips or help. Here's the info again: "ERROR: could not access status of...

Steve Wolfe

10-13-2004 01:01 PM
Steve Wolfe

I found on http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html that it is not poosible to use start or end a...

Michael Kleiser

10-13-2004 12:04 PM
Tino Wildenhain

Hi, I'm trying to come up with a relatively simple multi-master replication solution. This is for multiple databases that need to be discreet,...

Ted Shab

10-13-2004 11:56 AM
Ted Shab

Hi: I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting this error after executing a query: Warning: pg_exec() query failed:...

ruben20@superguai.com

10-13-2004 11:34 AM
Tom Lane

Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat Enterprise server, version 3.0). We find ourselves in an awkward position: we...

Michael Hannon

10-13-2004 09:56 AM
John

The following query updated all the rows in the AssembliesBatch table, not just where batchID=5. There are 2 rows in the AssembliesBatch table with...

Sim Zacks

10-13-2004 09:41 AM
Ian Harding

I try to detect potential memory management bugs of my program with valgrind. (PostgreSQL is at version 8.0 beta2. Operating System is Red Hat...

xiaoling he

10-13-2004 09:37 AM
Gaetano Mendola

Hello everyone, I would like to know if anyone has found or developed any monitoring software for Postgres. I would like to be able to gather...

Bob Powell

10-13-2004 09:28 AM
Frank Kurzawa

Hi I want to test PostgreSQL v8 native windows taht allows to create a table or column with 128 characters !! Where can i get it ? Thanks U for help...

DEHAINSALA Hondjack

10-13-2004 07:48 AM
DEHAINSALA Hondjack

hello everybody, i ve got two big tables with the same structure. i would like to add the second one to the first one directly without generating a...

fx gamoy

10-13-2004 07:45 AM
DEHAINSALA Hondjack

Hi, how come, if you create a user with no permissions at all, having been granted nothing, he can still log into any database, list available...

Henriksen, Jonas F

10-13-2004 05:37 AM
Richard Huxton

Hello. For a project we are planning cost management. Each "user" should pay for the cost he/she generates on the postgresql server. The idea is that...

stig erikson

10-13-2004 03:59 AM
stig erikson

hi, could anyone tell me how to open stat log in postgres? and how to monitor its concurrent connection number as well as the current sql(s)...

postgres2008

10-13-2004 03:55 AM
Neil Conway