public inbox for [email protected]help / color / mirror / Atom feed
8.0 beta status 16+ messages / 5 participants [nested] [flat]
* 8.0 beta status @ 2004-08-05 23:58 Tom Lane <[email protected]> 0 siblings, 3 replies; 16+ messages in thread From: Tom Lane @ 2004-08-05 23:58 UTC (permalink / raw) To: [email protected] AFAIK there are no major patches still outstanding, with the exception of the Windows-symlinks patch that arrived today from Andreas. Bruce and I both think that's worth getting in, if no one has any objections, but otherwise we essentially have 8.0beta1 code. The documentation, however, desperately needs work still; and Marc would like to get some of the postgresql.org domains shifted over to the newly-installed venus server before we go beta. So the plan right now is for a couple days' push on documentation, wrap beta1 on Sunday, announce it Monday. If anyone has time to work on docs over the next two days, please show up on pgsql-docs and let us know what you want to work on. (And of course it's still open season for bug-fix patches.) regards, tom lane ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-06 00:25 David Fetter <[email protected]> parent: Tom Lane <[email protected]> 2 siblings, 1 reply; 16+ messages in thread From: David Fetter @ 2004-08-06 00:25 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] On Thu, Aug 05, 2004 at 07:58:14PM -0400, Tom Lane wrote: > AFAIK there are no major patches still outstanding, with the > exception of the Windows-symlinks patch that arrived today from > Andreas. Bruce and I both think that's worth getting in, if no one > has any objections, but otherwise we essentially have 8.0beta1 code. > > The documentation, however, desperately needs work still; and Marc > would like to get some of the postgresql.org domains shifted over to > the newly-installed venus server before we go beta. Which docs are in the most desparate need of help? Cheers, D -- David Fetter [email protected] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-06 00:28 Gavin Sherry <[email protected]> parent: Tom Lane <[email protected]> 2 siblings, 0 replies; 16+ messages in thread From: Gavin Sherry @ 2004-08-06 00:28 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] I've fixed dbsize here and will send it off once I get a second to test it with multiple tablespaces. I haven't looked at oid2name. Bruce put together some ideas a few months back on what we want from oid2name now (somewhere around here: http://archives.postgresql.org/pgsql-patches/2004-06/msg00263.php). Were there any other suggestions? Gavin On Thu, 5 Aug 2004, Tom Lane wrote: > AFAIK there are no major patches still outstanding, with the exception > of the Windows-symlinks patch that arrived today from Andreas. Bruce > and I both think that's worth getting in, if no one has any objections, > but otherwise we essentially have 8.0beta1 code. > > The documentation, however, desperately needs work still; and Marc would > like to get some of the postgresql.org domains shifted over to the > newly-installed venus server before we go beta. So the plan right now > is for a couple days' push on documentation, wrap beta1 on Sunday, > announce it Monday. > > If anyone has time to work on docs over the next two days, please show > up on pgsql-docs and let us know what you want to work on. (And of > course it's still open season for bug-fix patches.) > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [email protected]) > > > !DSPAM:4112cc7c190631668695780! > > ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: [HACKERS] 8.0 beta status @ 2004-08-06 00:35 Tom Lane <[email protected]> parent: David Fetter <[email protected]> 0 siblings, 0 replies; 16+ messages in thread From: Tom Lane @ 2004-08-06 00:35 UTC (permalink / raw) To: David Fetter <[email protected]>; +Cc: pgsql-docs David Fetter <[email protected]> writes: > On Thu, Aug 05, 2004 at 07:58:14PM -0400, Tom Lane wrote: >> The documentation, however, desperately needs work still; and Marc >> would like to get some of the postgresql.org domains shifted over to >> the newly-installed venus server before we go beta. > Which docs are in the most desparate need of help? The problem is really that we've done only cursory documentation additions for the features added in 8.0. For instance, there are reference pages for SAVEPOINT/ROLLBACK TO/RELEASE but there are still many places that incorrectly say that we don't have nested transactions; much less places that give examples involving using nested transactions to solve real problems. What I was thinking of doing was just trying to read large sections of the docs and annotate places that are out of date and need work. If there are any particular areas you are familiar with, you might want to claim responsibility for those. regards, tom lane ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-06 01:11 Christopher Kings-Lynne <[email protected]> parent: Tom Lane <[email protected]> 2 siblings, 1 reply; 16+ messages in thread From: Christopher Kings-Lynne @ 2004-08-06 01:11 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] > If anyone has time to work on docs over the next two days, please show > up on pgsql-docs and let us know what you want to work on. (And of > course it's still open season for bug-fix patches.) Tom, I haven't had a comment on the 'restoring LOB comments' patch, nor on the two tablespace failures that Gavin and I brought up (Or the original schema tablespace problem you found when you committed). They could probably be post-beta perhaps though... Chris ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-06 01:16 Tom Lane <[email protected]> parent: Christopher Kings-Lynne <[email protected]> 0 siblings, 1 reply; 16+ messages in thread From: Tom Lane @ 2004-08-06 01:16 UTC (permalink / raw) To: Christopher Kings-Lynne <[email protected]>; +Cc: [email protected] Christopher Kings-Lynne <[email protected]> writes: > Tom, I haven't had a comment on the 'restoring LOB comments' patch, nor > on the two tablespace failures that Gavin and I brought up (Or the > original schema tablespace problem you found when you committed). They > could probably be post-beta perhaps though... Yeah, those are all bug fixes and okay for post-beta I think. But which two tablespace failures are you thinking of exactly? The last couple weeks have been a bit of a blur for me... regards, tom lane ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-06 04:53 Christopher Kings-Lynne <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 2 replies; 16+ messages in thread From: Christopher Kings-Lynne @ 2004-08-06 04:53 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] > Yeah, those are all bug fixes and okay for post-beta I think. But which > two tablespace failures are you thinking of exactly? The last couple > weeks have been a bit of a blur for me... http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... Sorry about crappy long urls :/ Chris ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-07 03:54 Tom Lane <[email protected]> parent: Christopher Kings-Lynne <[email protected]> 1 sibling, 2 replies; 16+ messages in thread From: Tom Lane @ 2004-08-07 03:54 UTC (permalink / raw) To: Christopher Kings-Lynne <[email protected]>; +Cc: [email protected] Christopher Kings-Lynne <[email protected]> writes: >> Yeah, those are all bug fixes and okay for post-beta I think. But which >> two tablespace failures are you thinking of exactly? The last couple >> weeks have been a bit of a blur for me... > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... Okay, this is a the-error-message-could-be-better gripe. Fair enough, but it's not top of my priority list ... > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... I think the problem here is that we don't have a syntax for saying "my tablespace is the same as my database's default tablespace" or "my tablespace is the same as my schema's default tablespace", when there is an intermediate object (schema or table) that isn't using that tablespace. (Note that "TABLESPACE pg_default" does definitely not mean either of these.) This is fixable with some special syntax but is it worth the trouble? regards, tom lane ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-13 04:03 Bruce Momjian <[email protected]> parent: Tom Lane <[email protected]> 1 sibling, 2 replies; 16+ messages in thread From: Bruce Momjian @ 2004-08-13 04:03 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: Christopher Kings-Lynne <[email protected]>; [email protected] Where are we on this? --------------------------------------------------------------------------- Tom Lane wrote: > Christopher Kings-Lynne <[email protected]> writes: > >> Yeah, those are all bug fixes and okay for post-beta I think. But which > >> two tablespace failures are you thinking of exactly? The last couple > >> weeks have been a bit of a blur for me... > > > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... > > Okay, this is a the-error-message-could-be-better gripe. Fair enough, > but it's not top of my priority list ... > > > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... > > I think the problem here is that we don't have a syntax for saying > "my tablespace is the same as my database's default tablespace" or "my > tablespace is the same as my schema's default tablespace", when there is > an intermediate object (schema or table) that isn't using that > tablespace. (Note that "TABLESPACE pg_default" does definitely not mean > either of these.) > > This is fixable with some special syntax but is it worth the trouble? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [email protected] > -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-13 04:14 Christopher Kings-Lynne <[email protected]> parent: Bruce Momjian <[email protected]> 1 sibling, 0 replies; 16+ messages in thread From: Christopher Kings-Lynne @ 2004-08-13 04:14 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Tom Lane <[email protected]>; [email protected] The other tablespace problem is if you drop a tablespace that schema in another db uses, it's broken still I think. Chris Bruce Momjian wrote: > Where are we on this? > > --------------------------------------------------------------------------- > > Tom Lane wrote: > >>Christopher Kings-Lynne <[email protected]> writes: >> >>>>Yeah, those are all bug fixes and okay for post-beta I think. But which >>>>two tablespace failures are you thinking of exactly? The last couple >>>>weeks have been a bit of a blur for me... >> >>>http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... >> >>Okay, this is a the-error-message-could-be-better gripe. Fair enough, >>but it's not top of my priority list ... >> >> >>>http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... >> >>I think the problem here is that we don't have a syntax for saying >>"my tablespace is the same as my database's default tablespace" or "my >>tablespace is the same as my schema's default tablespace", when there is >>an intermediate object (schema or table) that isn't using that >>tablespace. (Note that "TABLESPACE pg_default" does definitely not mean >>either of these.) >> >>This is fixable with some special syntax but is it worth the trouble? >> >> regards, tom lane >> >>---------------------------(end of broadcast)--------------------------- >>TIP 1: subscribe and unsubscribe commands go to [email protected] >> > > ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-13 04:25 Gavin Sherry <[email protected]> parent: Bruce Momjian <[email protected]> 1 sibling, 0 replies; 16+ messages in thread From: Gavin Sherry @ 2004-08-13 04:25 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Tom Lane <[email protected]>; Christopher Kings-Lynne <[email protected]>; [email protected] On Fri, 13 Aug 2004, Bruce Momjian wrote: > > Where are we on this? > > --------------------------------------------------------------------------- > > Tom Lane wrote: > > Christopher Kings-Lynne <[email protected]> writes: > > >> Yeah, those are all bug fixes and okay for post-beta I think. But which > > >> two tablespace failures are you thinking of exactly? The last couple > > >> weeks have been a bit of a blur for me... > > > > > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... > > > > Okay, this is a the-error-message-could-be-better gripe. Fair enough, > > but it's not top of my priority list ... I submitted a patch for the above with the subject: [PATCHES] CREATE DATABASE with tablespace fix Gavin ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-15 03:17 Bruce Momjian <[email protected]> parent: Christopher Kings-Lynne <[email protected]> 1 sibling, 2 replies; 16+ messages in thread From: Bruce Momjian @ 2004-08-15 03:17 UTC (permalink / raw) To: Christopher Kings-Lynne <[email protected]>; +Cc: Tom Lane <[email protected]>; [email protected] Christopher Kings-Lynne wrote: > > Yeah, those are all bug fixes and okay for post-beta I think. But which > > two tablespace failures are you thinking of exactly? The last couple > > weeks have been a bit of a blur for me... > > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... I am confused. You had: template1=# create tablespace blah location '/home/swm/tbl/tspc1/'; CREATE TABLESPACE template1=# create table foo (i int) tablespace blah; CREATE TABLE template1=# create database foo tablespace blah; ERROR: could not initialize database directory DETAIL: Directory "/home/swm/tbl/data/pg_tblspc/17227/17230" already exists. but with CVS head I see: $ psql -a test </tmp/x create tablespace blah location '/bjm/tmp'; CREATE TABLESPACE create table foo (i int) tablespace blah; CREATE TABLE create database foo tablespace blah; CREATE DATABASE However, I don't see any CVS commit that fixed this? What am I missing? -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-15 03:37 Bruce Momjian <[email protected]> parent: Tom Lane <[email protected]> 1 sibling, 0 replies; 16+ messages in thread From: Bruce Momjian @ 2004-08-15 03:37 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: Christopher Kings-Lynne <[email protected]>; [email protected] Tom Lane wrote: > > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... > > I think the problem here is that we don't have a syntax for saying > "my tablespace is the same as my database's default tablespace" or "my > tablespace is the same as my schema's default tablespace", when there is > an intermediate object (schema or table) that isn't using that > tablespace. (Note that "TABLESPACE pg_default" does definitely not mean > either of these.) > > This is fixable with some special syntax but is it worth the trouble? Seems we have to come up with some solution or dump/reload will not put things back in the same place for certain unusual configurations. Added to open items: * fix ambiguity for objects using default tablespaces -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-15 03:46 Tom Lane <[email protected]> parent: Bruce Momjian <[email protected]> 1 sibling, 1 reply; 16+ messages in thread From: Tom Lane @ 2004-08-15 03:46 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Christopher Kings-Lynne <[email protected]>; [email protected] Bruce Momjian <[email protected]> writes: > However, I don't see any CVS commit that fixed this? What am I missing? The failure case is where the template database has a conflicting table. You didn't show us where you created that table, but it evidently was not in template1. regards, tom lane ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-15 05:02 Gavin Sherry <[email protected]> parent: Bruce Momjian <[email protected]> 1 sibling, 0 replies; 16+ messages in thread From: Gavin Sherry @ 2004-08-15 05:02 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Christopher Kings-Lynne <[email protected]>; Tom Lane <[email protected]>; [email protected] On Sat, 14 Aug 2004, Bruce Momjian wrote: > Christopher Kings-Lynne wrote: > > > Yeah, those are all bug fixes and okay for post-beta I think. But which > > > two tablespace failures are you thinking of exactly? The last couple > > > weeks have been a bit of a blur for me... > > > > http://groups.google.com.au/groups?q=tablespaces+group:comp.databases.postgresql.hackers&hl=en&a... > > I am confused. You had: > > template1=# create tablespace blah location '/home/swm/tbl/tspc1/'; > CREATE TABLESPACE > template1=# create table foo (i int) tablespace blah; > CREATE TABLE > template1=# create database foo tablespace blah; > ERROR: could not initialize database directory > DETAIL: Directory "/home/swm/tbl/data/pg_tblspc/17227/17230" already > exists. > > but with CVS head I see: > > $ psql -a test </tmp/x > create tablespace blah location '/bjm/tmp'; > CREATE TABLESPACE > create table foo (i int) tablespace blah; > CREATE TABLE > create database foo tablespace blah; > CREATE DATABASE You need to create a condition where by the new database would have to merge a table into its default database. If you did the above in the template1 database, you would get the same effect. I sent a (partial) fix for this, which included some documentation improvements. However, I posed a question. *digs* [PATCHES] CREATE DATABASE with tablespace fix was the subject. Gavin ^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: 8.0 beta status @ 2004-08-15 13:48 Bruce Momjian <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 0 replies; 16+ messages in thread From: Bruce Momjian @ 2004-08-15 13:48 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: Christopher Kings-Lynne <[email protected]>; [email protected] Tom Lane wrote: > Bruce Momjian <[email protected]> writes: > > However, I don't see any CVS commit that fixed this? What am I missing? > > The failure case is where the template database has a conflicting > table. You didn't show us where you created that table, but it > evidently was not in template1. OK, reproduced by using template1: create tablespace blah location '/bjm/tmp'; CREATE TABLESPACE create table foo (i int) tablespace blah; CREATE TABLE create database foo tablespace blah; ERROR: could not initialize database directory DETAIL: Directory "/u/pgsql/data/pg_tblspc/17229/17232" already exists. Gavin has posted a patch for this so I will put it in the patch queue. -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ^ permalink raw reply [nested|flat] 16+ messages in thread
end of thread, other threads:[~2004-08-15 13:48 UTC | newest] Thread overview: 16+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-08-05 23:58 8.0 beta status Tom Lane <[email protected]> 2004-08-06 00:25 ` David Fetter <[email protected]> 2004-08-06 00:35 ` Tom Lane <[email protected]> 2004-08-06 00:28 ` Gavin Sherry <[email protected]> 2004-08-06 01:11 ` Christopher Kings-Lynne <[email protected]> 2004-08-06 01:16 ` Tom Lane <[email protected]> 2004-08-06 04:53 ` Christopher Kings-Lynne <[email protected]> 2004-08-07 03:54 ` Tom Lane <[email protected]> 2004-08-13 04:03 ` Bruce Momjian <[email protected]> 2004-08-13 04:14 ` Christopher Kings-Lynne <[email protected]> 2004-08-13 04:25 ` Gavin Sherry <[email protected]> 2004-08-15 03:37 ` Bruce Momjian <[email protected]> 2004-08-15 03:17 ` Bruce Momjian <[email protected]> 2004-08-15 03:46 ` Tom Lane <[email protected]> 2004-08-15 13:48 ` Bruce Momjian <[email protected]> 2004-08-15 05:02 ` Gavin Sherry <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox