[HACKERS] Weird new time zone

2004-07-08 Thread Christopher Kings-Lynne
How come I default to Antartica in CVS? test=# show time zone; TimeZone -- Antarctica/Casey (1 row) test=# Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister Y

Re: [HACKERS] Bug: psql misquotes constraints

2004-07-08 Thread Christopher Kings-Lynne
As a result of the constraint output functions being shared between pg_dump and psql, some of the output is mis-quoted in the display area for columns including quotes. Notice it's correct in the table Column list, but the constraint has the escaped versions. It's misquoted because psql DOES NOT sh

[HACKERS] try this patch!

2004-07-08 Thread t-ishii
docs? --- Trend GateLock [EMAIL PROTECTED] (主機:higp7.gatelock.com.tw) ** 中毒檔案 friend_incest.pif 已刪除。 Trend GateLock [EMAIL PROTECTED] (主機:higp7.gatelock.com.tw) ** 在檔案 friend_incest.pif 中發現病毒 WORM_NETSKY.C。 無法清除病毒,中毒檔案

Re: [HACKERS] Nested Transactions, Abort All

2004-07-08 Thread Simon Riggs
ISTM - my summary would be 1. We seem to agree we should support SAVEPOINTs 2. We seem to agree that BEGIN/COMMIT should stay unchanged... > With savepoints, it looks pretty strange: > > BEGIN; > SAVEPOINT x1; > INSERT INTO ...; > SAVEPOINT x2; > INSERT INTO ...; >

Re: [HACKERS] Want to Contribute

2004-07-08 Thread Dann Corbit
Title: Message   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of robert kernellSent: Thursday, July 08, 2004 4:23 PMTo: [EMAIL PROTECTED]Subject: [HACKERS] Want to Contribute Hi. I want to begin helping develop postgresql.   I have

[HACKERS] Want to Contribute

2004-07-08 Thread robert kernell
Hi. I want to begin helping develop postgresql.   I have an up-to-date computer, a dell dimension 4600, built with lots of extras. I have an MS in CS, and have worked with postgres in industry.   Can someone tell me what software I need? I guess I need a compiler. What compiler do I need? What else

Re: [HACKERS] Nested Transactions, Abort All

2004-07-08 Thread Bruce Momjian
Alvaro Herrera wrote: > On Thu, Jul 08, 2004 at 10:40:36AM -0700, Josh Berkus wrote: > > > This means that we CANNOT maintain compatibility with other databases without > > supporting SAVEPOINT syntax, which we are not yet ready to do. As a result, > > I would propose the following syntax: > >

Re: [HACKERS] [subxacts] Aborting a function

2004-07-08 Thread Rod Taylor
> Some sort of modification will be needed to the error processing > mechanism, but this is beyond me at this point ... I don't have any > idea how could this be. So.. If you cannot rollback a subtransaction within a plpgsql function (all function types or just that one?) then there is no point i

[HACKERS] User Quota Implementation

2004-07-08 Thread Jonah H. Harris
All, Out of necessity, I've implemented user quotas in 7.4.3. What would the process be for having this reviewed and combined? I have a patch for 7.4.3 ready, but wanted to know if you suggest that I patch the latest cvs instead. Below if some information on the implementation. =

Re: [HACKERS] [subxacts] Aborting a function

2004-07-08 Thread Alvaro Herrera
On Thu, Jul 08, 2004 at 04:52:04PM -0400, Rod Taylor wrote: > > create function crashme2() returns int strict language plpgsql as ' > > begin > >subbegin; > > select foo; -- aborts the transaction > > -- did not close the subxact > > end;'; > > I'm not s

Re: [HACKERS] [subxacts] Aborting a function

2004-07-08 Thread Rod Taylor
> create function crashme2() returns int strict language plpgsql as ' > begin >subbegin; > select foo; -- aborts the transaction > -- did not close the subxact > end;'; I'm not sure I follow. Are you saying that the following code or something similar wi

Re: [HACKERS] Initdb error

2004-07-08 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Magnus Hagander > Sent: 06 July 2004 21:46 > Cc: [EMAIL PROTECTED] > Subject: [HACKERS] Initdb error > > Hi! > > I'm getting this error whenever I try to change the superuser of my > database t

Re: [HACKERS] Nested Transactions, Abort All

2004-07-08 Thread Barry Lind
Alvaro, > My proposal would be: > > 1. Begin main transaction: BEGIN { TRANSACTION | WORK } > 2. Commit main (all) transaction: COMMIT { TRANSACTION | WORK } > 3. Rollback main (all) transaction: ROLLBACK { TRANSACTION } > > 4. Begin inner transaction: BEGIN NESTED { TRANSACTION | WORK } > 5. Commi

[HACKERS] [subxacts] Aborting a function

2004-07-08 Thread Alvaro Herrera
[Note: my ISP is having problems with email, so probably a duplicate of this will be published as soon as their SMTP starts working again] There's a point that hasn't been raised in discussion of subtransactions here and it's what to do when a function aborts. If I have a plpgsql function that g

Re: [HACKERS] plperl status

2004-07-08 Thread David Fetter
On Thu, Jul 08, 2004 at 03:28:12PM -0400, Andrew Dunstan wrote: > > I will be away from the 9th to the 16th or 17th of July, and will > have no net access during that time. I'm hoping that in the meantime > other interested people will pick up the remaining tasks (docs, I've got some preliminary

Re: [HACKERS] Nested Transactions, Abort All

2004-07-08 Thread Alvaro Herrera
On Thu, Jul 08, 2004 at 10:40:36AM -0700, Josh Berkus wrote: > This means that we CANNOT maintain compatibility with other databases without > supporting SAVEPOINT syntax, which we are not yet ready to do. As a result, > I would propose the following syntax: > > Begin main transaction: BEGI

[HACKERS] plperl status

2004-07-08 Thread Andrew Dunstan
I will be away from the 9th to the 16th or 17th of July, and will have no net access during that time. I'm hoping that in the meantime other interested people will pick up the remaining tasks (docs, test suite, fix for 'select foo() when foo returns a composite, other bugs). I will try to get the

Re: [HACKERS] working on support triggers on columns

2004-07-08 Thread Alvaro Herrera
On Thu, Jul 01, 2004 at 07:38:19PM -0400, Mark Wu wrote: > I have spent the past four months on this and I have finished the YYpaser, > Catalog, trigger creation and some other support functions, I am working on > trigger execution right now. I expect the project will be completed by the > end of

Re: [HACKERS] PITR Redo Create Database fails

2004-07-08 Thread Alvaro Herrera
On Thu, Jul 08, 2004 at 06:33:56PM +0100, Simon Riggs wrote: > On Thu, 2004-07-08 at 16:19, Alvaro Herrera wrote: > > On Thu, Jul 08, 2004 at 02:58:01PM +0100, Simon Riggs wrote: > > > > The correct solution would be to emit a XLog record for CREATE > > DATABASE ... > > I'd prefer a formal approa

Re: [HACKERS] Nested Transactions, Abort All

2004-07-08 Thread Josh Berkus
Alvaro, Hackers: I've been giving this some thought. Here's what I came up with: We should NOT use the savepoint syntax. Alvaro's Nested Transactions are not savepoints, they don't meet the spec, and they don't behave the same. Using standard syntax for a non-standard feature will, in my o

Re: [HACKERS] PITR Redo Create Database fails

2004-07-08 Thread Simon Riggs
On Thu, 2004-07-08 at 16:19, Alvaro Herrera wrote: > On Thu, Jul 08, 2004 at 02:58:01PM +0100, Simon Riggs wrote: > > > I've discovered that CREATE DATABASE doesn't redo correctly in an > > archive recovery test. > > > > This isn't a bug --in the current code--, because when crash recovery > > oc

[HACKERS] Update pg_tables, pg_indexes views to show tablespace name?

2004-07-08 Thread Klaus Naumann
Hi, while playing around with the tablespace stuff I noticed that one can't see the tablespace a table is in when querying the pg_tables view. I think the tablespace a table is in is a valuable information and should be shown there. This also applies to any ohter related view (like pg_indexes et

Re: [HACKERS] Quick question regarding tablespaces

2004-07-08 Thread Mike Rylander
On Thursday 01 July 2004 08:54 pm, Gavin Sherry wrote: > On Thu, 1 Jul 2004, Mike Rylander wrote: > > On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote: > > > Hi Mike, > > > > > > In this release, unfortunately not. > > > > That't too bad, but it's not that urgent I suppose. > > > > > I had som

[HACKERS] Bug: psql misquotes constraints

2004-07-08 Thread Rod Taylor
As a result of the constraint output functions being shared between pg_dump and psql, some of the output is mis-quoted in the display area for columns including quotes. Notice it's correct in the table Column list, but the constraint has the escaped versions. Thoughts? rt=# create table c ("""ver

[HACKERS] creating a complex aggregate function

2004-07-08 Thread Najib Abi Fadel
Hi i have an ordered table of dates let's say:   1/1/2004 8/1/2004 15/1/2004 29/1/2004 5/2/2004 12/2/2004   I am searching for a way to have the minimum date and maximum date for dates seperated by one week whitout gaps between them in a string. which will give the following output: 1/1/20

Re: [HACKERS] Postgres Crashes

2004-07-08 Thread Prem Gopalan
After reproducing these crashes and running tests long enough, we found that these Postgres Crashes happen on linux 2.4.18 and not on linux 2.4.25. In all likelihood, this is a kernel (or driver) issue. Could you kindly ensure this gets on my mail thread with subject "Postgres Crashes". Thanks P

Re: [HACKERS] Quick question regarding tablespaces

2004-07-08 Thread Mike Rylander
On Thursday 01 July 2004 09:26 pm, Scott Marlowe wrote: > On Thu, 2004-07-01 at 18:54, Gavin Sherry wrote: > > On Thu, 1 Jul 2004, Mike Rylander wrote: > > > On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote: > > > > Hi Mike, > > > > > > > > In this release, unfortunately not. > > > > > > That'

Re: [HACKERS] Quick question regarding tablespaces

2004-07-08 Thread Mike Rylander
On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote: > Hi Mike, > > In this release, unfortunately not. That't too bad, but it's not that urgent I suppose. > > I had some idea early on of putting rand_page_cost in pg_tablespace and > having the planner have access to it for costing. I didn't ac

[HACKERS] working on support triggers on columns

2004-07-08 Thread Mark Wu
I'm currently working on a master student research project “support triggers on columns” that is supervised by a professor from my university (Ottawa U).  I have contacted Neil Conway whose name is with this item on the TODO list. It happened that he actually lives very close to me(Queen's

Re: [HACKERS] PITR Redo Create Database fails

2004-07-08 Thread Alvaro Herrera
On Thu, Jul 08, 2004 at 02:58:01PM +0100, Simon Riggs wrote: > I've discovered that CREATE DATABASE doesn't redo correctly in an > archive recovery test. > > This isn't a bug --in the current code--, because when crash recovery > occurs, the database directories are already there, so this only do

[HACKERS] PITR Redo Create Database fails

2004-07-08 Thread Simon Riggs
I've discovered that CREATE DATABASE doesn't redo correctly in an archive recovery test. This isn't a bug --in the current code--, because when crash recovery occurs, the database directories are already there, so this only doesn't work when using the PITR patches. During archive recovery, nothin

[HACKERS] SAN, clustering, MPI, Backplane Re: Postgresql on SAN

2004-07-08 Thread Andrew Piskorski
On Wed, Jul 07, 2004 at 12:39:34PM +0200, Yannick Lecaillez wrote: > Thanks a lot for all people which answer. > > I have this "clustering on SAN" problem today and i think it could be > less harder to implement this today than it was for Oracle in 1993 You want to do clustering for failover/reli

Re: [HACKERS] Point in Time Recovery

2004-07-08 Thread Simon Riggs
On Thu, 2004-07-08 at 07:57, [EMAIL PROTECTED] wrote: > On Thu, 8 Jul 2004, Simon Riggs wrote: > > > We don't need to mention timelines in the docs, nor do we need to alter > > pg_controldata to display it...just a comment in the code to explain why > > we add a large number to the LogId after eac

[HACKERS] windows encodings

2004-07-08 Thread Karel Zak
Hi, in Czech database conference we talk about windows PostgreSQL port and windows encodings now. The current code expect use win1250 as FE encoding only. That's right for non-windows systems, but native windows knows work with this encoding. The encodings separation (FE|BE) is