public inbox for [email protected]help / color / mirror / Atom feed
List schema contents 21+ messages / 8 participants [nested] [flat]
* List schema contents @ 2006-06-09 19:33 Jim C. Nasby <[email protected]> 0 siblings, 3 replies; 21+ messages in thread From: Jim C. Nasby @ 2006-06-09 19:33 UTC (permalink / raw) To: [email protected] Currently, the only way to get a listing of tables in a schema via psql is to modify your search_path, which is both non-intuitive and a PITA. You can do \d schemaname., but that's the equivalent of set search_path = schemaname \d * I'd like to propose that the behavior of \d schemaname. be changed to match set search_path = schemaname \d That avoids issues with table name conflicts that could arise if the trailing . wasn't required. And the old behavior is still available as \d schemaname.* One problem I see is that this will break the ability to search for tablename. via regex. Since that's easy to do via tablename?, I don't think it's a big deal, unless someone has better ideas on how to indicate we want to list something for a specific schema. -- Jim C. Nasby, Sr. Engineering Consultant [email protected] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: List schema contents @ 2006-06-09 19:47 Martijn van Oosterhout <[email protected]> parent: Jim C. Nasby <[email protected]> 2 siblings, 0 replies; 21+ messages in thread From: Martijn van Oosterhout @ 2006-06-09 19:47 UTC (permalink / raw) To: Jim C. Nasby <[email protected]>; +Cc: [email protected] On Fri, Jun 09, 2006 at 02:33:57PM -0500, Jim C. Nasby wrote: > Currently, the only way to get a listing of tables in a schema via psql > is to modify your search_path, which is both non-intuitive and a PITA. > You can do \d schemaname., but that's the equivalent of Isn't this \dt schemaname.*? The only irritating thing is that is only displays table, not other objects... Have a nice day, -- Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate. Attachments: [application/pgp-signature] signature.asc (189B, 2-signature.asc) download ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: List schema contents @ 2006-06-09 19:52 Neil Conway <[email protected]> parent: Jim C. Nasby <[email protected]> 2 siblings, 1 reply; 21+ messages in thread From: Neil Conway @ 2006-06-09 19:52 UTC (permalink / raw) To: Jim C. Nasby <[email protected]>; +Cc: [email protected] On Fri, 2006-06-09 at 14:33 -0500, Jim C. Nasby wrote: > Currently, the only way to get a listing of tables in a schema via psql > is to modify your search_path, which is both non-intuitive and a PITA. I've griped about psql's limited support for schemas in the past: http://archives.postgresql.org/pgsql-hackers/2004-10/msg00989.php http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php I never actually got around to making any behavioral changes, but I agree there is certainly room for improvement. (The fact that archives.p.o can't properly link between threads that cross month boundaries is pretty annoying...) -Neil ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: List schema contents @ 2006-06-09 20:20 Tom Lane <[email protected]> parent: Jim C. Nasby <[email protected]> 2 siblings, 1 reply; 21+ messages in thread From: Tom Lane @ 2006-06-09 20:20 UTC (permalink / raw) To: Jim C. Nasby <[email protected]>; +Cc: [email protected] "Jim C. Nasby" <[email protected]> writes: > I'd like to propose that the behavior of \d schemaname. be changed to > match > set search_path = schemaname > \d I'm not sure what your reasoning is here, but AFAICS this would move the behavior away from what you say you want. What exactly have you got in mind, and why? In particular, why do you think that "\d schemaname." doesn't already produce exactly what you asked for, namely a list of the tables in that schema? The above would *not* produce such a list (counterexample: temp tables). > One problem I see is that this will break the ability to search for > tablename. via regex. You are aware of the double-quoting option in \d search patterns, no? regards, tom lane ^ permalink raw reply [nested|flat] 21+ messages in thread
* archive threads across months (was Re: [HACKERS] List schema contents) @ 2006-06-09 20:22 Tom Lane <[email protected]> parent: Neil Conway <[email protected]> 0 siblings, 2 replies; 21+ messages in thread From: Tom Lane @ 2006-06-09 20:22 UTC (permalink / raw) To: Neil Conway <[email protected]>; +Cc: pgsql-www Neil Conway <[email protected]> writes: > (The fact that archives.p.o can't properly link between threads that > cross month boundaries is pretty annoying...) Indeed, I was just annoyed by that (again) a few minutes ago. Anyone on -www have an idea how to fix it? regards, tom lane ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: List schema contents @ 2006-06-09 20:27 Jim C. Nasby <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: Jim C. Nasby @ 2006-06-09 20:27 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] On Fri, Jun 09, 2006 at 04:20:16PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[email protected]> writes: > > I'd like to propose that the behavior of \d schemaname. be changed to > > match > > > set search_path = schemaname > > \d > > I'm not sure what your reasoning is here, but AFAICS this would move the > behavior away from what you say you want. What exactly have you got > in mind, and why? In particular, why do you think that "\d schemaname." > doesn't already produce exactly what you asked for, namely a list of the > tables in that schema? The above would *not* produce such a list > (counterexample: temp tables). What I'm looking for is what "\d" provides you, only limited to a specific schema. "\d information_schema." (for example) doesn't provide that; it provides the details for every table/view in information_schema. Changing the search path does what I want, but is a pain: decibel=# set search_path=information_schema; SET decibel=# \d List of relations Schema | Name | Type | Owner --------------------+---------------------------------+-------+----------- information_schema | applicable_roles | view | postgres8 information_schema | check_constraints | view | postgres8 information_schema | column_domain_usage | view | postgres8 ... information_schema | usage_privileges | view | postgres8 information_schema | view_column_usage | view | postgres8 information_schema | view_table_usage | view | postgres8 information_schema | views | view | postgres8 (40 rows) decibel=# > > One problem I see is that this will break the ability to search for > > tablename. via regex. > > You are aware of the double-quoting option in \d search patterns, no? No, but I'm not really sure how that would help... -- Jim C. Nasby, Sr. Engineering Consultant [email protected] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] List @ 2006-06-09 20:33 Bruce Momjian <[email protected]> parent: Tom Lane <[email protected]> 1 sibling, 1 reply; 21+ messages in thread From: Bruce Momjian @ 2006-06-09 20:33 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: Neil Conway <[email protected]>; pgsql-www Tom Lane wrote: > Neil Conway <[email protected]> writes: > > (The fact that archives.p.o can't properly link between threads that > > cross month boundaries is pretty annoying...) > > Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > on -www have an idea how to fix it? I am also having problems that the date sorting often has a few entries at the end of out of order. I think that needs to be fixed too. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: List schema contents @ 2006-06-09 20:55 Tom Lane <[email protected]> parent: Jim C. Nasby <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: Tom Lane @ 2006-06-09 20:55 UTC (permalink / raw) To: Jim C. Nasby <[email protected]>; +Cc: [email protected] "Jim C. Nasby" <[email protected]> writes: > What I'm looking for is what "\d" provides you, only limited to a > specific schema. "\d information_schema." (for example) doesn't provide > that; it provides the details for every table/view in > information_schema. What you're looking for is \dt, or perhaps \dtsv or one of those forms. I'd be the first to agree that the behavior of \d isn't particularly orthogonal, but it's not the pattern language that's the problem, it's the command itself. regards, tom lane ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: List schema contents @ 2006-06-09 21:00 Jim C. Nasby <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: Jim C. Nasby @ 2006-06-09 21:00 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] On Fri, Jun 09, 2006 at 04:55:07PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[email protected]> writes: > > What I'm looking for is what "\d" provides you, only limited to a > > specific schema. "\d information_schema." (for example) doesn't provide > > that; it provides the details for every table/view in > > information_schema. > > What you're looking for is \dt, or perhaps \dtsv or one of those forms. \dtsv produces exactly what I'd want/expect. > I'd be the first to agree that the behavior of \d isn't particularly > orthogonal, but it's not the pattern language that's the problem, it's > the command itself. Perhaps \d without an argument should just do whatever \dtsv does? -- Jim C. Nasby, Sr. Engineering Consultant [email protected] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: List schema contents @ 2006-06-09 21:08 Tom Lane <[email protected]> parent: Jim C. Nasby <[email protected]> 0 siblings, 0 replies; 21+ messages in thread From: Tom Lane @ 2006-06-09 21:08 UTC (permalink / raw) To: Jim C. Nasby <[email protected]>; +Cc: [email protected] "Jim C. Nasby" <[email protected]> writes: > On Fri, Jun 09, 2006 at 04:55:07PM -0400, Tom Lane wrote: >> I'd be the first to agree that the behavior of \d isn't particularly >> orthogonal, but it's not the pattern language that's the problem, it's >> the command itself. > Perhaps \d without an argument should just do whatever \dtsv does? That's exactly what it does ... without an argument. The non-orthogonality is that adding an argument changes the printout style, instead of just determining which objects are displayed. See the psql man page: Note: If \d is used without a pattern argument, it is equivalent to \dtvs which will show a list of all tables, views, and sequences. This is purely a convenience measure. regards, tom lane ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-10 05:20 Marc G. Fournier <[email protected]> parent: Tom Lane <[email protected]> 1 sibling, 1 reply; 21+ messages in thread From: Marc G. Fournier @ 2006-06-10 05:20 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: Neil Conway <[email protected]>; pgsql-www On Fri, 9 Jun 2006, Tom Lane wrote: > Neil Conway <[email protected]> writes: >> (The fact that archives.p.o can't properly link between threads that >> cross month boundaries is pretty annoying...) > > Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > on -www have an idea how to fix it? Someone that knows mhonarc better then I might know of a way, but, I don't believe cross-month linking is actually possible ... majordomo stores archives by month in mbox format ... mhonarc processes each month and deposits it into a directory YYYY-MM ... without merging all of the mbox files into one huge archive file, and eliminating the YYYY-MM subdirectories, I don't believe that you could do this ... But, as I said, someone with more knowledge about mhonarc may know a way of doing this ... ? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [email protected] MSN . [email protected] Yahoo . yscrappy Skype: hub.org ICQ . 7615664 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-10 05:20 Marc G. Fournier <[email protected]> parent: Bruce Momjian <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: Marc G. Fournier @ 2006-06-10 05:20 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www On Fri, 9 Jun 2006, Bruce Momjian wrote: > Tom Lane wrote: >> Neil Conway <[email protected]> writes: >>> (The fact that archives.p.o can't properly link between threads that >>> cross month boundaries is pretty annoying...) >> >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone >> on -www have an idea how to fix it? > > I am also having problems that the date sorting often has a few entries > at the end of out of order. I think that needs to be fixed too. please provide a sample of what you are talking about ... :) ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [email protected] MSN . [email protected] Yahoo . yscrappy Skype: hub.org ICQ . 7615664 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-10 12:48 Bruce Momjian <[email protected]> parent: Marc G. Fournier <[email protected]> 0 siblings, 2 replies; 21+ messages in thread From: Bruce Momjian @ 2006-06-10 12:48 UTC (permalink / raw) To: Marc G. Fournier <[email protected]>; +Cc: Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www Marc G. Fournier wrote: > On Fri, 9 Jun 2006, Bruce Momjian wrote: > > > Tom Lane wrote: > >> Neil Conway <[email protected]> writes: > >>> (The fact that archives.p.o can't properly link between threads that > >>> cross month boundaries is pretty annoying...) > >> > >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > >> on -www have an idea how to fix it? > > > > I am also having problems that the date sorting often has a few entries > > at the end of out of order. I think that needs to be fixed too. > > please provide a sample of what you are talking about ... :) Sure, search for "misnomer" and sorty by date. Look at the last page. You will see 2005 entries that should have appeared earlier. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-10 13:52 Marc G. Fournier <[email protected]> parent: Bruce Momjian <[email protected]> 1 sibling, 0 replies; 21+ messages in thread From: Marc G. Fournier @ 2006-06-10 13:52 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www On Sat, 10 Jun 2006, Bruce Momjian wrote: > Marc G. Fournier wrote: >> On Fri, 9 Jun 2006, Bruce Momjian wrote: >> >>> Tom Lane wrote: >>>> Neil Conway <[email protected]> writes: >>>>> (The fact that archives.p.o can't properly link between threads that >>>>> cross month boundaries is pretty annoying...) >>>> >>>> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone >>>> on -www have an idea how to fix it? >>> >>> I am also having problems that the date sorting often has a few entries >>> at the end of out of order. I think that needs to be fixed too. >> >> please provide a sample of what you are talking about ... :) > > Sure, search for "misnomer" and sorty by date. Look at the last page. > You will see 2005 entries that should have appeared earlier. Wait, you are talking Search results, not ordering in the archives themselves ... can't help you with that one, sorry ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [email protected] MSN . [email protected] Yahoo . yscrappy Skype: hub.org ICQ . 7615664 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-10 17:57 Jim Nasby <[email protected]> parent: Marc G. Fournier <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: Jim Nasby @ 2006-06-10 17:57 UTC (permalink / raw) To: Marc G. Fournier <[email protected]>; +Cc: Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www On Jun 10, 2006, at 12:20 AM, Marc G. Fournier wrote: > On Fri, 9 Jun 2006, Tom Lane wrote: > >> Neil Conway <[email protected]> writes: >>> (The fact that archives.p.o can't properly link between threads that >>> cross month boundaries is pretty annoying...) >> >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone >> on -www have an idea how to fix it? > > Someone that knows mhonarc better then I might know of a way, but, > I don't believe cross-month linking is actually possible ... > > majordomo stores archives by month in mbox format ... mhonarc > processes each month and deposits it into a directory YYYY-MM ... > without merging all of the mbox files into one huge archive file, > and eliminating the YYYY-MM subdirectories, I don't believe that > you could do this ... > > But, as I said, someone with more knowledge about mhonarc may know > a way of doing this ... ? Are we wed to mhonarc? Is there another archiving tool we could use? -- Jim C. Nasby, Sr. Engineering Consultant [email protected] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-10 18:09 Marc G. Fournier <[email protected]> parent: Jim Nasby <[email protected]> 0 siblings, 0 replies; 21+ messages in thread From: Marc G. Fournier @ 2006-06-10 18:09 UTC (permalink / raw) To: Jim Nasby <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www On Sat, 10 Jun 2006, Jim Nasby wrote: > On Jun 10, 2006, at 12:20 AM, Marc G. Fournier wrote: >> On Fri, 9 Jun 2006, Tom Lane wrote: >> >>> Neil Conway <[email protected]> writes: >>>> (The fact that archives.p.o can't properly link between threads that >>>> cross month boundaries is pretty annoying...) >>> >>> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone >>> on -www have an idea how to fix it? >> >> Someone that knows mhonarc better then I might know of a way, but, I don't >> believe cross-month linking is actually possible ... >> >> majordomo stores archives by month in mbox format ... mhonarc processes >> each month and deposits it into a directory YYYY-MM ... without merging all >> of the mbox files into one huge archive file, and eliminating the YYYY-MM >> subdirectories, I don't believe that you could do this ... >> >> But, as I said, someone with more knowledge about mhonarc may know a way of >> doing this ... ? > > Are we wed to mhonarc? Is there another archiving tool we could use? I'll never say we're *wed* to anything ... do you know of another archiving tool? I think the first question is are there any other ones that offer the functionality that Tom is asking for ... ? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [email protected] MSN . [email protected] Yahoo . yscrappy Skype: hub.org ICQ . 7615664 ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-15 01:27 John Hansen <[email protected]> parent: Bruce Momjian <[email protected]> 1 sibling, 1 reply; 21+ messages in thread From: John Hansen @ 2006-06-15 01:27 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www On Sat, 2006-06-10 at 08:48 -0400, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Fri, 9 Jun 2006, Bruce Momjian wrote: > > > > > Tom Lane wrote: > > >> Neil Conway <[email protected]> writes: > > >>> (The fact that archives.p.o can't properly link between threads that > > >>> cross month boundaries is pretty annoying...) > > >> > > >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > > >> on -www have an idea how to fix it? > > > > > > I am also having problems that the date sorting often has a few entries > > > at the end of out of order. I think that needs to be fixed too. > > > > please provide a sample of what you are talking about ... :) > > Sure, search for "misnomer" and sorty by date. Look at the last page. > You will see 2005 entries that should have appeared earlier. > Thats due to a bug in the search engine, not the archives themselves. ... John ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-15 01:34 Bruce Momjian <[email protected]> parent: John Hansen <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: Bruce Momjian @ 2006-06-15 01:34 UTC (permalink / raw) To: John Hansen <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www John Hansen wrote: > On Sat, 2006-06-10 at 08:48 -0400, Bruce Momjian wrote: > > Marc G. Fournier wrote: > > > On Fri, 9 Jun 2006, Bruce Momjian wrote: > > > > > > > Tom Lane wrote: > > > >> Neil Conway <[email protected]> writes: > > > >>> (The fact that archives.p.o can't properly link between threads that > > > >>> cross month boundaries is pretty annoying...) > > > >> > > > >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > > > >> on -www have an idea how to fix it? > > > > > > > > I am also having problems that the date sorting often has a few entries > > > > at the end of out of order. I think that needs to be fixed too. > > > > > > please provide a sample of what you are talking about ... :) > > > > Sure, search for "misnomer" and sorty by date. Look at the last page. > > You will see 2005 entries that should have appeared earlier. > > > > Thats due to a bug in the search engine, not the archives themselves. OK, how does it get fixed? -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-15 01:47 John Hansen <[email protected]> parent: Bruce Momjian <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: John Hansen @ 2006-06-15 01:47 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www On Wed, 2006-06-14 at 21:34 -0400, Bruce Momjian wrote: > John Hansen wrote: > > On Sat, 2006-06-10 at 08:48 -0400, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > > > > On Fri, 9 Jun 2006, Bruce Momjian wrote: > > > > > > > > > Tom Lane wrote: > > > > >> Neil Conway <[email protected]> writes: > > > > >>> (The fact that archives.p.o can't properly link between threads that > > > > >>> cross month boundaries is pretty annoying...) > > > > >> > > > > >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > > > > >> on -www have an idea how to fix it? > > > > > > > > > > I am also having problems that the date sorting often has a few entries > > > > > at the end of out of order. I think that needs to be fixed too. > > > > > > > > please provide a sample of what you are talking about ... :) > > > > > > Sure, search for "misnomer" and sorty by date. Look at the last page. > > > You will see 2005 entries that should have appeared earlier. > > > > > > > Thats due to a bug in the search engine, not the archives themselves. > > OK, how does it get fixed? Someone needs to fix the ASPseek source... > ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-15 02:01 Bruce Momjian <[email protected]> parent: John Hansen <[email protected]> 0 siblings, 1 reply; 21+ messages in thread From: Bruce Momjian @ 2006-06-15 02:01 UTC (permalink / raw) To: John Hansen <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www John Hansen wrote: > On Wed, 2006-06-14 at 21:34 -0400, Bruce Momjian wrote: > > John Hansen wrote: > > > On Sat, 2006-06-10 at 08:48 -0400, Bruce Momjian wrote: > > > > Marc G. Fournier wrote: > > > > > On Fri, 9 Jun 2006, Bruce Momjian wrote: > > > > > > > > > > > Tom Lane wrote: > > > > > >> Neil Conway <[email protected]> writes: > > > > > >>> (The fact that archives.p.o can't properly link between threads that > > > > > >>> cross month boundaries is pretty annoying...) > > > > > >> > > > > > >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > > > > > >> on -www have an idea how to fix it? > > > > > > > > > > > > I am also having problems that the date sorting often has a few entries > > > > > > at the end of out of order. I think that needs to be fixed too. > > > > > > > > > > please provide a sample of what you are talking about ... :) > > > > > > > > Sure, search for "misnomer" and sorty by date. Look at the last page. > > > > You will see 2005 entries that should have appeared earlier. > > > > > > > > > > Thats due to a bug in the search engine, not the archives themselves. > > > > OK, how does it get fixed? > > Someone needs to fix the ASPseek source... Have we submitted a bug report to them? -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ^ permalink raw reply [nested|flat] 21+ messages in thread
* Re: archive threads across months (was Re: [HACKERS] @ 2006-06-15 02:04 John Hansen <[email protected]> parent: Bruce Momjian <[email protected]> 0 siblings, 0 replies; 21+ messages in thread From: John Hansen @ 2006-06-15 02:04 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Tom Lane <[email protected]>; Neil Conway <[email protected]>; pgsql-www On Wed, 2006-06-14 at 22:01 -0400, Bruce Momjian wrote: > John Hansen wrote: > > On Wed, 2006-06-14 at 21:34 -0400, Bruce Momjian wrote: > > > John Hansen wrote: > > > > On Sat, 2006-06-10 at 08:48 -0400, Bruce Momjian wrote: > > > > > Marc G. Fournier wrote: > > > > > > On Fri, 9 Jun 2006, Bruce Momjian wrote: > > > > > > > > > > > > > Tom Lane wrote: > > > > > > >> Neil Conway <[email protected]> writes: > > > > > > >>> (The fact that archives.p.o can't properly link between threads that > > > > > > >>> cross month boundaries is pretty annoying...) > > > > > > >> > > > > > > >> Indeed, I was just annoyed by that (again) a few minutes ago. Anyone > > > > > > >> on -www have an idea how to fix it? > > > > > > > > > > > > > > I am also having problems that the date sorting often has a few entries > > > > > > > at the end of out of order. I think that needs to be fixed too. > > > > > > > > > > > > please provide a sample of what you are talking about ... :) > > > > > > > > > > Sure, search for "misnomer" and sorty by date. Look at the last page. > > > > > You will see 2005 entries that should have appeared earlier. > > > > > > > > > > > > > Thats due to a bug in the search engine, not the archives themselves. > > > > > > OK, how does it get fixed? > > > > Someone needs to fix the ASPseek source... > > Have we submitted a bug report to them? > The project is more or less dead, only the userbase still exists. And the version we're running is heavily modified. I will get around to fixing this, I just don't have the time at present. ... John ^ permalink raw reply [nested|flat] 21+ messages in thread
end of thread, other threads:[~2006-06-15 02:04 UTC | newest] Thread overview: 21+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-06-09 19:33 List schema contents Jim C. Nasby <[email protected]> 2006-06-09 19:47 ` Martijn van Oosterhout <[email protected]> 2006-06-09 19:52 ` Neil Conway <[email protected]> 2006-06-09 20:22 ` archive threads across months (was Re: [HACKERS] List schema contents) Tom Lane <[email protected]> 2006-06-09 20:33 ` Re: archive threads across months (was Re: [HACKERS] List Bruce Momjian <[email protected]> 2006-06-10 05:20 ` Re: archive threads across months (was Re: [HACKERS] Marc G. Fournier <[email protected]> 2006-06-10 12:48 ` Re: archive threads across months (was Re: [HACKERS] Bruce Momjian <[email protected]> 2006-06-10 13:52 ` Re: archive threads across months (was Re: [HACKERS] Marc G. Fournier <[email protected]> 2006-06-15 01:27 ` Re: archive threads across months (was Re: [HACKERS] John Hansen <[email protected]> 2006-06-15 01:34 ` Re: archive threads across months (was Re: [HACKERS] Bruce Momjian <[email protected]> 2006-06-15 01:47 ` Re: archive threads across months (was Re: [HACKERS] John Hansen <[email protected]> 2006-06-15 02:01 ` Re: archive threads across months (was Re: [HACKERS] Bruce Momjian <[email protected]> 2006-06-15 02:04 ` Re: archive threads across months (was Re: [HACKERS] John Hansen <[email protected]> 2006-06-10 05:20 ` Re: archive threads across months (was Re: [HACKERS] Marc G. Fournier <[email protected]> 2006-06-10 17:57 ` Re: archive threads across months (was Re: [HACKERS] Jim Nasby <[email protected]> 2006-06-10 18:09 ` Re: archive threads across months (was Re: [HACKERS] Marc G. Fournier <[email protected]> 2006-06-09 20:20 ` Tom Lane <[email protected]> 2006-06-09 20:27 ` Jim C. Nasby <[email protected]> 2006-06-09 20:55 ` Tom Lane <[email protected]> 2006-06-09 21:00 ` Jim C. Nasby <[email protected]> 2006-06-09 21:08 ` Tom Lane <[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