Re: [GENERAL] plgpsql and transactions

2006-04-07 Thread Bill Moseley
table in the trigger and check the current status of the table and set the column based on that current status. I want to make sure that between the time the trigger completes and when the insert finally happens that another session can't also do an insert and see the same ta

Re: [GENERAL] plgpsql and transactions

2006-04-06 Thread Bill Moseley
ore than one table insert into semething (default); and: begin; -- fires a trigger that updates more than one table insert into somthing (default); commit; -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TI

[GENERAL] plgpsql and transactions

2006-04-06 Thread Bill Moseley
warning. When would issuing a lock table outside an explicit transaction be of any use? -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

[GENERAL] Table locks and serializable transactions.

2006-03-11 Thread Bill Moseley
't have updates in other sessions due to the lock so I'll see a frozen view of that table regardless of serializable. In other words, using serializable doesn't add anything if the table is already locked in the transaction and all I'm looking at is that one locked table. Thanks,

Re: [GENERAL] Installing PosygreSQL 8.1 on Windows2003 server in terminal session (remote desktop)

2006-03-02 Thread Bill Bartlett
tsc /v:MyRemoteServerName /console". Using the Win2K3 RDP client, I think there is a checkbox to do this.) Don't know if this will help with the PostgreSQL install since I still do all mine at the servers at the moment, but it does work with many other apps that want to be installed "a

Re: [GENERAL] Mixing different LC_COLLATE and database encodings

2006-02-18 Thread Bill Moseley
aracter encodings. Is the Holy Grail encoding and lc_collate settings per column? Changing topics, but I'm going to play with different cluster settings for collate. If I create a cluster in given directory is there any problems with moving that cluster (renaming the directory)? Th

Re: [GENERAL] Mixing different LC_COLLATE and database encodings

2006-02-18 Thread Bill Moseley
On Sat, Feb 18, 2006 at 01:40:09PM -0500, Tom Lane wrote: > Bill Moseley <[EMAIL PROTECTED]> writes: > > - To clarify the first point, if the database is encoded utf-8 and > > lc_collate is en_US then Postgresql does NOT try to convert utf-8 to > > 8859-1 before sorting

Re: [GENERAL] Mixing different LC_COLLATE and database encodings

2006-02-18 Thread Bill Moseley
n that point. > > 5) I suppose there's not way to answer this, short of running > > benchmarks, but any ideas what using a lc_collate with utf-8 would do > > to performance? Is it a big hit? > > I don't know why that would be a problem. Just that sorting utf8 i

[GENERAL] Mixing different LC_COLLATE and database encodings

2006-02-18 Thread Bill Moseley
ee: Zo But, if on that same remote machine I run a unicode xterm (uxterm in Debian) then in that xterm window I do: utf8test=> \encoding UNICODE utf8test=> select first_name from person where last_name = 'Anderson'; Zoƫ (correct)

Re: [GENERAL] Limiting with a left outer join

2006-02-12 Thread Bill Moseley
On Sat, Feb 11, 2006 at 12:35:34AM -0700, Michael Fuhr wrote: > On Fri, Feb 10, 2006 at 11:59:30AM -0800, Bill Moseley wrote: > > How do I make a join on the class table but not effect the left outer > > join? > > Are you looking for something like this? > > LEFT O

[GENERAL] Limiting with a left outer join

2006-02-10 Thread Bill Moseley
review_mode IS FALSE AND class_domain.class = c.id AND class_domain.domain = 1 ) But, that's not part of the join, of course. How do I make a join on the class table but not effect the left outer join? Thanks, -- Bill Moseley [EMAIL PR

Re: [GENERAL] SQL Help: Multiple LEFT OUTER JOINs

2005-11-21 Thread Bill Moseley
On Mon, Nov 21, 2005 at 02:06:35PM -0800, Bill Moseley wrote: > The now working query (thanks to you!) is: No that doesn't work. It's dropping the people that have never been assigned a class to teach (i.e. don't have a row in the "instructors" link table). >

Re: [GENERAL] SQL Help: Multiple LEFT OUTER JOINs

2005-11-21 Thread Bill Moseley
0 |4 31 | 4 | 4 | 0 |4 -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] SQL Help: Multiple LEFT OUTER JOINs

2005-11-21 Thread Bill Moseley
On Mon, Nov 21, 2005 at 11:45:34AM -0600, Bruno Wolff III wrote: > On Mon, Nov 21, 2005 at 05:40:10 -0800, > Bill Moseley <[EMAIL PROTECTED]> wrote: > > > > Here's where I'm missing something. Trying to do an outer join on > > to bring in the class

[GENERAL] SQL Help: Multiple LEFT OUTER JOINs

2005-11-21 Thread Bill Moseley
class = class.id ), person_role WHERE person_role.person = person.id AND person_role.role = 3 GROUP BY person.id, last_name; -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading throug

Re: [GENERAL] Wrong rows selected with view

2005-11-17 Thread Bill Moseley
On Wed, Nov 16, 2005 at 11:34:21PM -0500, Tom Lane wrote: > No, I'm saying that the underlying data (the join result before applying > DISTINCT ON) looks like this: > > bill=# select "class".id, person.id AS person_id > bill-#FROM "class", "

Re: [GENERAL] Wrong rows selected with view

2005-11-16 Thread Bill Moseley
On Wed, Nov 16, 2005 at 07:48:06PM -0500, Tom Lane wrote: > Bill Moseley <[EMAIL PROTECTED]> writes: > > [ strange behavior ] > > Oh, duh, it's not a PG bug: the problem is that the view is > underspecified. You have > > SELECT DISTINCT ON (class.id) >

Re: [GENERAL] Wrong rows selected with view

2005-11-16 Thread Bill Moseley
On Wed, Nov 16, 2005 at 10:53:21AM -0500, Tom Lane wrote: > Bill Moseley <[EMAIL PROTECTED]> writes: > > The first plan below returns the correct number of rows, the second plan > > does > > not. These are after I did the reindex, btw. > > Bizarre. What are t

Re: [GENERAL] Wrong rows selected with view

2005-11-16 Thread Bill Moseley
; Index Scan using instructors_class_index on instructors (cost=0.00..52.00 rows=1000 width=8) -> Hash (cost=20.00..20.00 rows=1000 width=142) -> Seq Scan on "location" (cost=0.00..20.00 rows=1000 width=

[GENERAL] Wrong rows selected with view

2005-11-15 Thread Bill Moseley
begin_reg_time | @@ -27 +27 @@ -register_cutoff_time| 2005-12-11 19:00:00-08 +register_cutoff_time| 2005-12-24 19:15:00-08 Thanks, -- Bill "stabbing in the dark" Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Permissions required for service user account _after_ installation

2005-11-15 Thread Bill Bartlett
ed, and so far everything seems to be working properly. Or is just a matter of my not having bumped into a problem yet? - Bill ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Using native win32 psql.exe using alternative cygwin - psql 8.0.0 beta 3 question

2005-11-11 Thread Bill Bartlett
> > Bill Bartlett wrote: > > >I hit this exact same problem, and my initial reaction was > the same as > >yours -- psql was "hanging". After much head-banging, I discovered > >that it is not in fact hanging, but is instead getting confused by >

Re: [GENERAL] Using native win32 psql.exe using alternative cygwin terminal

2005-11-06 Thread Bill Bartlett
Cygwin is v7.4.5. There is v8.x code available in CVS, but you'll have to compile it yourself. I'm also planning on doing this too, but I haven't had the time. - Bill Bill Bartlett meridianEMR, Inc. http://www.meridianemr.com/ > -Original Message- > From: [EMAIL PROTE

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-11-01 Thread Bill Bartlett
a new platform: most of the time they'll go with the safer solution rather than the riskier one -- there's always one eye on future consulting business.) No, this obviously won't always be the case, but it's inevitable that at least some portion of the projects that would have chosen Pos

Re: [GENERAL] Limitations of PostgreSQL

2005-10-13 Thread Bill Bartlett
[snipped] > May not be the best choice on Windows for production use, though for > development, it should be adequate. Are there known issues with the Windows version for production use, or is this simply because of the relative newness of the Windows-native version?

Re: [GENERAL] Question about a query plan

2005-09-20 Thread Bill Moseley
integer | not null Indexes: "person_role_pkey" primary key, btree (person, role) Foreign-key constraints: "$2" FOREIGN KEY (role) REFERENCES role(id) ON DELETE RESTRICT "$1" FOREIGN KEY (person) REFERENCES person(id) ON DELETE CASCADE Thanks, -- Bil

Re: [GENERAL] Setting WHERE on a VIEW with aggregate function.

2005-09-16 Thread Bill Moseley
e-normalize the data. Maybe I can just create three views (future, recent, old) and live with that. The temporary table is another possibility I'll look into. Thank you very much for spending time on this. I really appreciate it. -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Setting WHERE on a VIEW with aggregate function.

2005-09-16 Thread Bill Moseley
SELECT * FROM (SELECT person.id AS person_id, first_name FROM person) p INNER JOIN (SELECT class.id AS class_id, class_time FROM class) c INNER JOIN (SELECT person, count(class) AS class_count

[GENERAL] Setting WHERE on a VIEW with aggregate function.

2005-09-16 Thread Bill Moseley
UP BY clause or be used in an aggregate function Is there a reason Postgresql doesn't just add the column automatically? It does in other cases (like a missing table in a join). Thanks -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Question about a query plan

2005-09-16 Thread Bill Moseley
On Fri, Sep 16, 2005 at 10:02:28AM -0500, Thomas O'Connell wrote: > > On Sep 16, 2005, at 9:18 AM, Bill Moseley wrote: > > >First question is why the planner is not using an index scan when I > >use "now()" or CURRENT_TIMESTAMP? > > It also used to be

Re: [GENERAL] Question about a query plan

2005-09-16 Thread Bill Moseley
ACUUM (or > both) or tweaking the statistics parameters of the columns. I did wonder about the planner stats, so I had run ANALYZE on the database with no change. I just now ran VACUUM (and VACUUM ANALYZE), and again see no change. Perhaps my table is just too small for this test. -- Bill Mo

[GENERAL] Question about a query plan

2005-09-16 Thread Bill Moseley
81..707.90 rows=437 width=8) Sort Key: instructors.person -> Hash IN Join (cost=656.65..687.64 rows=437 width=8) Hash Cond: ("outer"."class" = "inner".id) -> Seq Scan on instructors (cost=0

[GENERAL] GROUP BY requirement

2005-08-26 Thread Bill Moseley
rouped columns except within aggregate functions, since there would be more than one possible value to return for an ungrouped column. Frankly, I cannot see how it might change results of a select between the two views. Am I missing something? -- Bill Mosele

Re: [GENERAL] Help with a subselect inside a view

2005-08-25 Thread Bill Moseley
't really care), but class_time is a column in the "class" table which I'm using DISTINCT ON on, so that should be unique as well. So I assume you meant random choice of first_name, not class_time. Thanks, -- Bill Moseley [EMAIL PROTECTED] ---(end o

Re: [GENERAL] Help with a subselect inside a view

2005-08-25 Thread Bill Moseley
And about being efficient: On Thu, Aug 25, 2005 at 08:01:26AM -0700, Bill Moseley wrote: > DROP VIEW cl; > CREATE VIEW cl (id, class_time, instructor) > AS > SELECT DISTINCT ON(class.id) >class.id, class.class_time, pe

Re: [GENERAL] Help with a subselect inside a view

2005-08-25 Thread Bill Moseley
On Thu, Aug 25, 2005 at 08:05:36AM -0500, Bruno Wolff III wrote: > On Wed, Aug 24, 2005 at 23:12:17 -0700, > Bill Moseley <[EMAIL PROTECTED]> wrote: > > I need a little SQL help: > > > > I'm trying to get a subselect working inside a view. > > Unfort

Re: [GENERAL] Help with a subselect inside a view

2005-08-25 Thread Bill Moseley
ass_time | instructor -++ 544 | 2005-08-31 09:00:00-07 | Cheryl 555 | 2005-09-30 09:00:00-07 | Cheryl 737 | 2005-08-30 09:00:00-07 | Cynthia -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Help with a subselect inside a view

2005-08-24 Thread Bill Moseley
k. I suspect I'm missing something obvious. Thanks, Oh BTW -- If I do a count(*) and a WHERE that only includes columns in the "class" table on the VIEW, will Postgresql still do the joins? Or will it only do the select on the "class" table. I

[GENERAL] Optimize a VIEW question

2005-08-23 Thread Bill Moseley
ExecNestLoop () #4 0x08102ceb in ExecProcNode () #5 0x081093a4 in ExecAgg () #6 0x08102c79 in ExecProcNode () #7 0x08101ecc in ExecutorRun () #8 0x0816f58b in PortalSetResultFormat () #9 0x0816f8c7 in PortalRun () #10 0x0816da9f in PostgresMain () #11 0x08148b4e i

[GENERAL] Input timestamp from epoch?

2005-08-19 Thread Bill Moseley
ably faster for my client application to parse epoch from the database, though. -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Waiting on a transaction

2005-08-18 Thread Bill Moseley
unset when the next connection > uses the DB... You mean other than setting "alarm 0;"? -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscri

Re: [GENERAL] How to "ping" the database

2005-08-17 Thread Bill Moseley
27;s that. I'm not really sure why there's a need for a ping -- and I've heard others question it, too. Perl's DBI has a connect_cached() function that is suppose to return a cached connection if it's still alive. So that is one place "ping" is used. If ping fail

Re: [GENERAL] Schema design question

2005-08-17 Thread Bill Moseley
selects are always going to have something like WHERE type = 'course' added onto the WHERE. That's extra processing for no good reason. > I'm sure there are many ways to get there. To me, the way I've > described is the most-direct way to represent the relationships y

[GENERAL] Schema design question

2005-08-17 Thread Bill Moseley
us classes. There also needs to be a link between the two. For example, you might want to show a list of courses, and then see what classes are scheduled for a given course, so a class should reference its parent course. Thanks very much, -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] How to "ping" the database

2005-08-17 Thread Bill Moseley
is not allowing SELECTS. What I did in my code was if ping fails, call rollback and then try ping one more time. But, I'm not clear if that works in a more general case or what might happen if the connection really is broken. -- Bill Moseley [EMAIL PROTECTED]

Re: [GENERAL] Waiting on a transaction

2005-08-16 Thread Bill Moseley
On Tue, Aug 16, 2005 at 08:25:25PM +0200, Martijn van Oosterhout wrote: > On Tue, Aug 16, 2005 at 11:05:35AM -0700, Bill Moseley wrote: > > I've read over the docs on Concurrency Control but still not clear > > about when transactions block other updates, and how to deal

[GENERAL] Waiting on a transaction

2005-08-16 Thread Bill Moseley
until either a COMMIT or ROLLBACK. Is it common for applications using Postgresql to set a timer on updates and abort? -- Bill Moseley [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Sorting by related tables

2005-08-15 Thread Bill Moseley
so I'm thinking of just manually updating all the rows in sequence to adjust the order when needed -- to make things a bit more simple. But it is a problem that I am curious about how best to solve in a scalable way. Thanks very much for your feedback. -- Bill Moseley [EMAIL PROTECTED

Re: [GENERAL] Sorting by related tables

2005-08-15 Thread Bill Moseley
e SELECT and then *only* do an UPDATE if the SELECT returns at least one row. So, I should do: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; Before the SELECT. And when I UPDATE I need to be prepared to do a ROLLBACK if I get an error and repeat the process. (And, I assume, take some precauti

[GENERAL] Sorting by related tables

2005-08-13 Thread Bill Moseley
up in the sort order relative to others. SELECT id FROM __TABLE__ WHERE sort_order <= (SELECT sort_order FROM __TABLE__ WHERE id = ?) AND id != ?; If that returns any rows then I know I can call the UPDATE to move the item up. Again,

[GENERAL] Finding cardinality of an index

2005-04-21 Thread Bill Chandler
All, Is there a way to determine cardinality (size) of an index? In general how to you query the 'attributes' (for lack of a better word) of an index. thanks, Bill __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protect

Re: [GENERAL] Unique constraint violation on serial column

2005-04-12 Thread Bill Chandler
not specify 'evt_id' values directly. Does anybody have any ideas about how this could have gotten out of sync? thanks, Bill --- Alvaro Herrera <[EMAIL PROTECTED]> wrote: > On Tue, Apr 12, 2005 at 08:48:15AM -0700, Bill > Chandler wrote: > > > How does one find ou

Re: [GENERAL] Unique constraint violation on serial column

2005-04-12 Thread Bill Chandler
Is that not correct? Bill --- Alvaro Herrera <[EMAIL PROTECTED]> wrote: > On Tue, Apr 12, 2005 at 07:59:55AM -0700, Bill > Chandler wrote: > > I'm sorry, was working on little sleep yesterday. > You > > are right, the table was created with the columns > i

Re: [GENERAL] Unique constraint violation on serial column

2005-04-12 Thread Bill Chandler
the pg_dump output conatins explicit evt_id values for each row added so after creating the database from the pg_dump output the sequence is still at 1 when it should really be at 23040. How does one find out the current sequence value? Is there a way to change it? Bill --- Bill Chandler

Re: [GENERAL] Unique constraint violation on serial column

2005-04-12 Thread Bill Chandler
;10.25', 1, 739950991) Bill --- Ragnar HafstaĆ° <[EMAIL PROTECTED]> wrote: > On Mon, 2005-04-11 at 11:03 -0700, Bill Chandler > wrote: > > > ERROR: duplicate key violates unique constraint > > event_tbl_evt_id_key > > > EVENT_TBL > > evt_id

Re: [GENERAL] Unique constraint violation on serial column

2005-04-11 Thread Bill Chandler
For what its worth, the command is being issued via JDBC app. If the exact command is important I could have them turn on logging and I could get that for you. Bill --- Tom Lane <[EMAIL PROTECTED]> wrote: > Bill Chandler <[EMAIL PROTECTED]> writes: > > Client is getting the

[GENERAL] Unique constraint violation on serial column

2005-04-11 Thread Bill Chandler
never attempt to minipulate the sequence/index for the column in any way. Short of the client mucking around with the column in an unauthorized manner, can anybody think of a reason how things might get confused and an already used 'evt_id' value is used again? Regards, Bill ___

Re: [GENERAL] Questions regarding interaction of stored functions

2005-03-27 Thread Bill Moran
Tom Lane <[EMAIL PROTECTED]> wrote: > Bill Moran <[EMAIL PROTECTED]> writes: > > Let's take the following fictional scenerio: > > > BEGIN; > > INSERT INTO table1 VALUES ('somestring'); > > INSERT INTO table1 VALUES ('anotherstring

[GENERAL] Questions regarding interaction of stored functions and transactions

2005-03-24 Thread Bill Moran
he second INSERT is not executed if the first fails, but the function is always called. So ... I'm a little fuzzy on this. Is there a doc that details this behaviour? TIA. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)-

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2005-03-20 Thread Woodchuck Bill
rarchy. I'm no longer sure if it would be a good thing or not. The proponent certainly left a bad taste in my mouth after his little crossposting stunt - but I will still vote on the *proposal*, and not the *proponent*. -- Bill ---(end of broadcast)

[GENERAL] CFV: comp.databases.postgresql

2005-03-20 Thread Bill Aten
third party. Questions about the proposed group should be directed to the proponent. Proponent: Mike Cox <[EMAIL PROTECTED]> Votetaker: Bill Aten <[EMAIL PROTECTED]> RATIONALE: comp.databases.postgresql To provide a Big-Eight usenet group for users of the PostgreSQL Relational Databas

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2005-03-20 Thread Woodchuck Bill
tm <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > Woodchuck Bill <[EMAIL PROTECTED]> wrote: > >> The proponent certainly left a bad taste in my mouth after his >> little ... > > Too much information. > LOL. Get your

[GENERAL] Clay Shirky observation regarding MySQL

2005-02-28 Thread bill
Hello! Clay Shirky made a comment about MySQL that I thought the PostgreSQL community should be aware of: http://www.shirky.com/writings/situated_software.html It's the section (mostly toward the bottom) entitled, "The Nature of Programming, and the Curious Case of MySQL". The whole article

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2004-12-03 Thread Woodchuck Bill
al of the large usenet servers. > > What are the rules for creating new groups in pgsgl.*? > > Fiat-only by Marc. ;-) -- Bill ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] 3rd RFD: comp.databases.postgresql

2004-12-03 Thread Woodchuck Bill
[EMAIL PROTECTED] ("Joshua D. Drake") wrote in news:[EMAIL PROTECTED]: > >> So the current state of affairs is that we have the gated, official >> pgsql.* newsgroups, and the comp.* stuff is not gated in either >> direction? Yes. >> If that's the case, there should be a weekly/monthly remind

[GENERAL] md5 checksum mismatch

2004-12-01 Thread Bill Kurland
et I don't see what I could be doing wrong. Has anyone actually done this process successfully? Could you let me know which version and which mirror? Bill Kurland Shakespeare & Co. -- Leibniz never married; he had considered it at the age of fifty; but the person he had in mind asked

Re: [GENERAL] Upcoming Changes to News Server ...

2004-12-01 Thread Woodchuck Bill
[EMAIL PROTECTED] (Jan Wieck) wrote in news:[EMAIL PROTECTED]: > On 11/30/2004 2:37 PM, Gary L. Burnore wrote: > >> Perhaps I wasn't clear. I don't care WHO you are. I've already asked >> you once to stay out of my email. Further emails from you will be >> reported to both Yahoo and Comcast as

Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...

2004-11-30 Thread Woodchuck Bill
Marc G. Fournier From: <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > [EMAIL PROTECTED] (Bill Harris) writes: > >>"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > >>> "If there was an official newsgroup for postgresql, would you swit

Re: [GENERAL] USENET vs Mailing Lists Poll ...

2004-11-30 Thread Woodchuck Bill
[EMAIL PROTECTED] (Joel) wrote in news:[EMAIL PROTECTED]: (crosspost added to news.groups) > As long as the web page maintainers are going to the trouble of taking a > survey, might I (at the risk of being tarred and feathered :-p) suggest > a more thorough survey? > > Suggested questions: > >

Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...

2004-11-30 Thread Woodchuck Bill
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: >>Trying to sway the vote? > > There has been no CFV. During an RFD, he's completely entitled to try > to persuade others people to vote yes or no when the time comes. I didn't say that he was not entitled. > Bil

Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...

2004-11-30 Thread Woodchuck Bill
Marc G. Fournier From: <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > [EMAIL PROTECTED] writes: > >>On 30 Nov 2004 22:55:00 GMT, Woodchuck Bill <[EMAIL PROTECTED]> >>wrote: > >>>Marc G. Fournier From: <[EMAIL PROTECTED]> wrote in >

Re: [GENERAL] [ANNOUNCE] USENET vs Mailing Lists Poll ...

2004-11-30 Thread Bill Harris
s worth, even if it does seem more painful at the time. My $0.02. Bill -- Bill Harris Facilitated Systems http://facilitatedsystems.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] PGSQL: The Gateway will be kept.

2004-11-29 Thread Woodchuck Bill
7;s, I want to know why... > The pgsql.* groups are now on the ISC list.. ftp://ftp.isc.org/pub/usenet/CONFIG/newsgroups -- Bill ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Why the current setup of pgsql.* and comp.databases.postresql.general are BROKEN

2004-11-27 Thread Woodchuck Bill
Robert McClenon <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > On 27 Nov 2004 18:32:35 GMT, Woodchuck Bill <[EMAIL PROTECTED]> > wrote: > >>Robert McClenon <[EMAIL PROTECTED]> wrote in >>news:[EMAIL PROTECTED]: >> >>> However, I wi

Re: [GENERAL] comp.databases.postgresql.* groups and RFD

2004-11-27 Thread Woodchuck Bill
tion. He gets an e-mail from a moderator's robot. This creates major confusion. He is not aware that 99 percent of the NG volume comes from e-mails to mailing lists. -- Bill ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] comp.databases.postgresql.* groups and RFD

2004-11-27 Thread Woodchuck Bill
ny of these >>newsgroups. > > Newbies would, yeah. but pgsql is a common reference to it. Newbies looking for an entry level group might pass novice or general and find a dead alt.* group as the only newsgroup with "postgresql" in the name. Something to consider. -- Bill

Re: [GENERAL] Why the current setup of pgsql.* and comp.databases.postresql.general are BROKEN

2004-11-27 Thread Woodchuck Bill
m's spoofed e-mail address. This system is too vulnerable to abuse. The groups should be moderated, for one. Second, Marc needs to decide whether he wants the groups to be in pgsql.*, *or* comp.* ... not both. The lists and gating methods should all be explained in detail on t

Re: [GENERAL] comp.databases.postgresql.* groups and RFD

2004-11-27 Thread Woodchuck Bill
Woodchuck Bill <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > "Adam H. Kerman" <[EMAIL PROTECTED]> wrote in > news:pIOdndYMRqGJ7DrcRVn- [EMAIL PROTECTED]: > >> Are these meant to be worldwide Usenet groups >> or newsgroups local to your server

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Woodchuck Bill
u're still trying to shove your list up USENet's ass instead of >> doing it the proper way. Why is that? > > I will not speak for Marc but say that as a member of the mailing list, > I think he does an excellent job of advocating the best inte

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Woodchuck Bill
s pretty much the point > somebody else made to a similar suggestion. (I.e.: Propagation might > be poor.) It might take a long time for a new hierarchy to become universally accepted and well propagated, but it is marginally better than having rogue groups in unauthorized

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Woodchuck Bill
ral? Different message IDs for each of the dupes. -- Bill ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Woodchuck Bill
[EMAIL PROTECTED] ("Marc G. Fournier") wrote in news:[EMAIL PROTECTED]: > > Due to recent action by Google concerning the > comp.databases.postgresql.* hierarchy, we are going to make some > changes that should satisfy just about everyone ... over the next > 24hrs or so, traffic *to* comp.databa

Re: [GENERAL] RFD: comp.databases.postgresql.*

2004-11-23 Thread Woodchuck Bill
stubborn and keep things the way they are, which has already resulted in fragmentation of his rogue hierarchy as Google has dropped them, and other servers will probably follow now that the rogue nature of these groups is being more publicized due to this RFD. Somethin

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Woodchuck Bill
ou know that? Marc can use this as an opportunity to start fresh, but now he wants to have 2 newsgroups for each list? And you say that he is making things better? -- Bill ---(end of broadcast)--- TIP 9: the planner will ignore your desire to cho

Re: [GENERAL] Google (was RFD: comp.databases.postgresql.*)

2004-11-23 Thread Woodchuck Bill
and now allow the poster to set a follow-up group on crossposted articles. Applause! -- Bill ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Woodchuck Bill
one in comp.* and one in pgsql.*) then the credibility of his hierarchy will go further down the drain. > So much for working out the problems. No further comment. -- Bill ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] How to make a good documentation of a database ?

2004-11-22 Thread Bill Harris
o document an existing PostgreSQL database. I've also designed more than one database in Druid and then exported the result to PostgreSQL. > Thanks all the same, Bill, I'll try to keep an eye on this project. You're welcome. Bill - -- Bill Harris

[GENERAL] Moving from 7.x to 8.0beta4 with a backup

2004-11-20 Thread Bill Harris
SER statement in database.backup, to no avail. Any suggestions? I'm guessing it's an easy answer that just escapes me. <*> Once I get that done, I might as well get rid of the cygwin PostgreSQL. Is there any problem in simply uninstalling it usin

Re: [GENERAL] Moving from 7.x to 8.0beta4 with a backup

2004-11-20 Thread Bill Harris
Bill Harris <[EMAIL PROTECTED]> writes: > $ /cygdrive/c/Program\ Files/PostgreSQL/8.0.0-beta4/bin/psql.exe template1 < > da > tabase.backup > Password: > psql: FATAL: password authentication failed for user "user name" It was a relatively easy answer. I tempo

Re: [GENERAL] How to make a good documentation of a database ?

2004-11-20 Thread Bill Harris
which depends on the type of another column...). Would Druid (http://druid.sourceforge.net/) help? Bill -- Bill Harris Facilitated Systems http://facilitatedsystems.com/ ---

Re: [GENERAL] I resign as the promoter of the PostgreSQL groups.

2004-11-13 Thread Woodchuck Bill
sgrace. Mike, please reconsider your position. Your second RFD looks really good, and the 5 groups that you chose are right on the money. You are a good proponent. You've taken all of the feedback into account, good and bad, and implemented the appropriate changes. Don't let

Re: [GENERAL] I'm about to release the next postgresql RFD. Comments

2004-11-13 Thread Woodchuck Bill
[EMAIL PROTECTED] ("Marc G. Fournier") wrote in news:[EMAIL PROTECTED]: > As a side note ... if/when the CFV is called and those 4 are > approved/rejected, that will not change what is available on > news.postgresql.org, it will only improve the propogation of those 4 > specific groups so that

Re: [GENERAL] RFD: comp.databases.postgresql.general

2004-11-13 Thread Woodchuck Bill
> > That's my whole point.. He's responded in the mailing list to an issue > being raised here. That does him about as much good as wiping his rear > with 20 grit sandpaper. He's being defiant .. Rebel without a CFV! ;-) -- Bill ---(end

Re: [GENERAL] Important Info on comp.databases.postgresql.general

2004-11-13 Thread Woodchuck Bill
is acceptable for anyone to create as many Big-8 rogue groups as they like? Some servers will carry the groups, others will not. There should be no accountability for someone doing this. There is nothing wrong with it. -- Bill ---(end of broadcast)-

Re: [GENERAL] Important Info on comp.databases.postgresql.general

2004-11-13 Thread Woodchuck Bill
result in the next few days, would you have any problem with the proponents sending out a control message anyway? Archiving the rogue group in Google Groups? If nothing else, taking no steps toward action sets a bad example, and might encourage others to skip the RFD and create more rogue groups.

Re: [GENERAL] Important Info on comp.databases.postgresql.general

2004-11-13 Thread Woodchuck Bill
[EMAIL PROTECTED] (John Stanley) wrote in news:[EMAIL PROTECTED]: > Obviously there is nothing wrong with it. As I seem to recall, one of > the admins who (routinely?) created bogus groups is now part of the NAN > moderating team. Who would that be? -- Bill --

Re: [GENERAL] Important Info on comp.databases.postgresql.general

2004-11-13 Thread Woodchuck Bill
rogue groups will continue to operate as they currently do, regardless of the CFV outcome. -- Bill ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] RFD: comp.databases.postgresql.general

2004-11-13 Thread Woodchuck Bill
nd post *something* to news.groups. -- Bill ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] RFD: comp.databases.postgresql.general

2004-11-13 Thread Woodchuck Bill
[EMAIL PROTECTED] ("Marc G. Fournier") wrote in news:[EMAIL PROTECTED]: > Unless its spam, it goes through ... I don't (nor have I ever) refused a > post based on content other then spam ... even if its anti-PostgreSQL > *shrug* The problem with the system is that the spam *all* gets posted to

Re: [GENERAL] The Big 9?

2004-11-13 Thread Woodchuck Bill
ay their status is clear to all subscribers, the commercial > usnet providers would have a well managed big 9, and would not be > forced to choose between having a well managed hierarchy or doing > carrying the groups customers demand. You frighten me. ;-) -- Bill -

<    6   7   8   9   10   11   12   >