[EMAIL PROTECTED] (Kathy Morgan) wrote in
news:[EMAIL PROTECTED]:
> Max <[EMAIL PROTECTED]> wrote:
>
>> Yeah, I've seen these forged emails on the mailing list, plus a few
>> other colorfull ones. You should see that people on the list are not
>> completely against this idea, and they are not fo
Jeff Eckermann wrote:
> The "problem" that is being solved is, as presented so
> far, too abstract to be convincing, at least for me.
If you say so. The problem that Mark (Marc?) is trying to solve is that his
ISP doesn't give access to this newsgroup because it is NOT in the Big-8.
The solution
Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
>
> And now, some time ago, PostgreSQL mailing lists were gatewayed
> into Big8 namespace, to help people access them by other means.
> Only it was done "unoffically", i.e. not following standard procedure
> for such things. It could be thought of as "hoo
Seriously, the usenet people losing interest in this "problem" might
be the best case scenario.
Ya know, that's kinda like when a business owner hopes the neigborhood
will forget about a toxic waste spill.
In this case, it's not going to be forgotten as long as someone's
shoving your emails up
The new proposal should have all of the lists. I am amazed that an
unknown interloper is trying to dictate which lists should be voted on.
I am affiliated with a network of over 60 PostgreSql users/developers,
and I will e-mail each one of those people a ballot. If your next
proposal does not conta
Dawid Kuroczko wrote:
On Fri, 12 Nov 2004 17:20:59 +0100, Michelle Konzack
<[EMAIL PROTECTED]> wrote:
Please note, that I do not run seperatly databases.
I like only to split it per $USER physicaly from the main database.
I like to have this setup for my new Virtual-Webserver where I have
for ea
hello all,
i've got a database that takes up 4G of space. when i run a script that
deletes all rows and then vacuum, the data directory gets down to
around 3-3.5G. what i'd like is to get a blank database structure that
really contains no data at all, or any unused space at all. apparently
tha
On Wed, Nov 10, 2004 at 04:10:43PM +0200, Alexander Antonakakis wrote:
> I will have to make sql queries in the form "select value from
> product_actions where who='someone' and where='somewhere' and maybe make
> also some calculations on these results. I allready have made some
> indexes on th
In article <[EMAIL PROTECTED]>,
Mike Cox <[EMAIL PROTECTED]> wrote:
> comp.databases.postgresql.general
How about just comp.databases.postgresql or (shudder)
comp.databases.postgresql.misc?
-Mike
---(end of broadcast)---
TIP 3: if posting/readin
BTW, in Outlook Express if you are posting to the news.postgresql.org server
it will not send a message to news.groups. So this message will not get
there unless someone puts it there.
If 4 are official and 16 are unofficial, why would that bother you?
You can still access all of them the same way
In news.groups, Klaas <[EMAIL PROTECTED]> writes:
> Mike Cox <[EMAIL PROTECTED]> wrote:
>> comp.databases.postgresql.general
> How about just comp.databases.postgresql or (shudder)
> comp.databases.postgresql.misc?
In this particular situation, I think .general may actually be a better
name tha
Since nobody has mentioned any nuances about mapping these keys to system
tables in this particular database, I'll assume this is a good idea for
now.
--
TJ Talluto
torpedo51 at yahoo dot com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the post
On Wed, Nov 10, 2004 at 02:34:22PM -0500, Ernest Kim wrote:
> I was wondering if there was a way to get the value of serial data
> type after an insert.
Use currval():
http://www.postgresql.org/docs/7.4/static/functions-sequence.html
Race condtions aren't a problem:
"Notice that because this i
[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
[EMAIL PROTECTED] (Jon Bell) wrote:
> In article <[EMAIL PROTECTED]>,
> Klaas <[EMAIL PROTECTED]> wrote:
> >In article <[EMAIL PROTECTED]>,
> > Mike Cox <[EMAIL PROTECTED]> wrote:
> >
> >> comp.databases.postgresql.general
> >
> >How about just comp.databases.postgresql or (shudder)
> >comp.data
Mike Cox <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]
berlin.de:
> Obviously, there cannot be 21 postgresql groups in the comp.* hierarchy.
I agree
> I did a check on news.postgresql.org to see which newsgroups are the most
> popular and also the ones which cover the relevant postgresql
[EMAIL PROTECTED] (Jeff Eckermann) wrote in
news:[EMAIL PROTECTED]:
> --- "Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
>> Please. We're trying to help you fix something
>> that's broken.
>
> ??? As a longstanding reader of the pgsql-
> mailinglists, (including via news.postgresql.org on
> occa
pgsql-general
I am a new user for pgsql.I has a question is, does pgsql(7.5 for
win32) has a jdbc or a odbc ? If have ,how can i take it ?
thank for your replying.
suon
[EMAIL PROTECTED]
2004-11-10
---(end of broadcast)---
Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> I believe these posts are spoofs. Mike has not posted anything along
> these lines before, and the headers are different from his usual posts.
I'm sure you're right. There's been some idiot trolling news.groups
for the past several weeks, impers
Joseph Daniel Zukiger wrote:
> [EMAIL PROTECTED] wrote in message
> news:<[EMAIL PROTECTED]>...
>> The lists are not bogus and your suggestion is not acceptable. Many of
>> the list subscribers have no connection to Usenet. They will be mailed
>> the ballots, regardless of what you or anyone else
[EMAIL PROTECTED] wrote:
> This is my last post to news.groups about this.
Good. With any luck, Marc will block you from the mailing
lists for spamming those lists.
---(end of broadcast)---
TIP 8: explain analyze is your friend
I think this is disgusting.
I feel that if someone does not like what Mike is doing the appropriate way
of dealing with it would be to post a rational argument. Not to send an
obviously forged email with his name on the from line.
""Mike Cox"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROT
I was wondering if there was a way to get the value of serial data
type after an insert. For example, you have the following table:
create table my_names (
id serial unique,
name varchar(10)
);
And then you do the following:
insert into my_names values ('Ernie');
How
In article <[EMAIL PROTECTED]>,
Klaas <[EMAIL PROTECTED]> wrote:
>In article <[EMAIL PROTECTED]>,
> Mike Cox <[EMAIL PROTECTED]> wrote:
>
>> comp.databases.postgresql.general
>
>How about just comp.databases.postgresql or (shudder)
>comp.databases.postgresql.misc?
The whole point of this proposa
[EMAIL PROTECTED] wrote:
I am affiliated with a network of over 60 PostgreSql users/developers,
and I will e-mail each one of those people a ballot...
You should not do that.
Those ballots will be invalidated since only the official ballots that
are posted or obtained directly from the votetaker a
[EMAIL PROTECTED] wrote in message news:<[EMAIL PROTECTED]>...
> The lists are not bogus and your suggestion is not acceptable. Many of
> the list subscribers have no connection to Usenet. They will be mailed
> the ballots, regardless of what you or anyone else say. They are the
> people who will b
[EMAIL PROTECTED] wrote:
> The new proposal should have all of the lists. I am amazed that an
> unknown interloper is trying to dictate which lists should be voted on.
> I am affiliated with a network of over 60 PostgreSql users/developers,
> and I will e-mail each one of those people a ballot. If
I would like to ask the more experienced users on Postgres database a
couple of questions I have on a db I manage with a lot of data. A lot of
data means something like 15.000.000 rows in a table. I will try to
describe the tables and what I will have to do on them :)
There is a table that has p
How the function written on pl/pgsql can be called
by the function written on plperl.
Error is:
error from function: Undefined subroutine
&Safe::Root2::get_national_code called.
At 07:30 PM 11/13/2004, you wrote:
If the process drags on for too long, people will start to get annoyed
with the process and lose interest. I speak from experience.
This hasn't dragged on too long?
Not at all.
People aren't already annoyed?
Not those that matter.
Seriously, the usenet people lo
On Tue, 09 Nov 2004 19:20:20 GMT, TJ Talluto <[EMAIL PROTECTED]> wrote:
> This new table would act as a universal extension table. Instead of having
> FKs back to any particular table, it would contain regular keys that point
> back to whatever table::record is its source.
>
> I was thinking of u
If the process drags on for too long, people will start to get
annoyed with the process and lose interest. I speak from experience.
This hasn't dragged on too long? People aren't already annoyed?
Seriously, the usenet people losing interest in this "problem" might be
the best case scenario.
P
Thanks Alvaro and Steven -- this may in fact be what happened as the monitor
showed that at about that time memory definitely was taxed and showed oddnesses.
I'll read up on this -- thanks very much for the (promising) clue!
Greg W.
-Original Message-
From: Alvaro Herrera [mailto:[E
On Mon, Nov 08, 2004 at 05:28:57PM +, Woodchuck Bill wrote:
> [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
>
On Sat, Nov 13, 2004 at 02:39:38PM -0800, Gregory S. Williamson wrote:
Gregory,
> We had an oddness today with one of of postgres servers (Dell 2 CPU box
> running linux) and postgres 7.4. The server was under heavy load (50+ for a 1
> minutes spike; about 20 for the 15 minute average) with about
On Sat, 13 Nov 2004, Gregory S. Williamson wrote:
> Looking in the logs I see:
> 2004-11-13 13:30:28 LOG: unexpected EOF on client connection
> 2004-11-13 13:30:40 LOG: unexpected EOF on client connection
> 2004-11-13 13:38:28 LOG: could not send data to client: Broken pipe
> 2004-11-13 13:42:1
Dear peoples,
We had an oddness today with one of of postgres servers (Dell 2 CPU box running
linux) and postgres 7.4. The server was under heavy load (50+ for a 1 minutes
spike; about 20 for the 15 minute average) with about 250 connections (we still
don't understand the heavy load itself).
L
On Tue, Nov 09, 2004 at 01:53:18PM +0200, Sim Zacks wrote:
> I have a postgresql backend with an access front end and I am trying to
> redefine the recordset of the form to use an ADO recordset. The problem is
> that the CursorType always changes to AdOpenStatic, even if I choose
> adOpenDynamic. I
On Tue, Nov 09, 2004 at 11:00:57PM -, John White wrote:
> It seems I'm not the first to ask this question but there seem to be
> very few answers. I am implementing an audit log facility where INSERT's
> or UPDATE's to a number tables get logged to a single table. Each row in
> the logging tabl
>
> [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]:
>
> >>The other issue is that I would like to add the other postgresql
> >>groups for consideration to be included into the big 8. However there
> >>are quite a few of them, and I don't know if all of them deserve to be
> >>there. They are all
On Fri, 12 Nov 2004 17:20:59 +0100, Michelle Konzack
<[EMAIL PROTECTED]> wrote:
> Please note, that I do not run seperatly databases.
> I like only to split it per $USER physicaly from the main database.
>
> I like to have this setup for my new Virtual-Webserver where I have
> for each VHost a loc
Instead of putting the same 12 columns on every table (these 12 columns
contain info about who created the record and when, for example)... It may
be more efficient to make a new table to hold that data.
This new table would act as a universal extension table. Instead of having
FKs back to any pa
Joseph Daniel Zukiger wrote:
>
> "Arthur L. Rubin" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL
> PROTECTED]>...
> > Rebecca Ore wrote:
> >
> > > Since they have traffic and are bidirectional, and since he doesn't have
> > > any objections, it looks like creating the groups by fiat would wor
Polarhound <[EMAIL PROTECTED]> wrote in news:kM2dnd_0xq99yw3cRVn-
[EMAIL PROTECTED]:
>> (BTW, since the person responsible for setting up the rogue groups
>> appears to be aware of the discussion to legitimize the groups, why
>> isn't he taking part in it?)
>>
>
> That's my whole point.. He's re
It would seem that trying to hide code while using
an open source system is just wrong. 8-)
That being said -- You would grant the
user/group execute rights on the function, but no read rights on the system
table that contains the function definition, pg_proc.
How is this user supposed to
Eric wrote:
> Is there a visual designer (open source) in linux for database? I would
> like to developp my data model on the computer...
>
> I see "dia" with uml library but... it won't export to SQL.
GerWin: http://es.gnu.org/~jemarch/cgi-bin/index.pl?Site=GerWin
Design your database as t
I have a postgresql backend with an access front end and I am trying to
redefine the recordset of the form to use an ADO recordset. The problem is
that the CursorType always changes to AdOpenStatic, even if I choose
adOpenDynamic. If anyone has any thoughts, please let me know. The form
works great
"Arthur L. Rubin" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL
PROTECTED]>...
> Rebecca Ore wrote:
>
> > Since they have traffic and are bidirectional, and since he doesn't have
> > any objections, it looks like creating the groups by fiat would work
> > just fine and avoid a lot of misinfor
On Mon, 2004-11-08 at 05:54, Stephan Szabo wrote:
> > If I have a subselect with an ORDER BY, and I LEFT JOIN the result with the
> > other table, is the order maintained? Or is PostgreSQL free to return the
> > rows
> > in any order, after the join?
>
> AFAIK, you have no guarantees as to the ou
On Sun, 2004-11-07 at 20:36, Thomas F.O'Connell wrote:
> What version of postgres are you using? In postgresql-7.4.6, I get an
> empty query buffer when I try what you describe here.
7.4.5
I got it. Apparently the query buffer is the last run query (good or
bad). So, to get my function into the
It seems I'm not the first to ask this question but there seem to be
very few answers. I am implementing an audit log facility where INSERT's
or UPDATE's to a number tables get logged to a single table. Each row in
the logging table stores data on one field change in the tables being
logged. My fun
Woodchuck Bill <[EMAIL PROTECTED]> wrote:
>[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]:
>> That's his perogative. His server, his rules (or whoever's he set the
>> groups up on). We don't have the right to dictate what groups he puts
>> on his news server. If someone else decides to take
Woodchuck Bill <[EMAIL PROTECTED]> writes:
> If the NAN team announces a reversal of the rec.woodworking.all-ages
> result in the next few days, would you have any problem with the
> proponents sending out a control message anyway?
The proponents are entirely welcome to do so, so long as they send
thanks for your reply. My distutils was in /usr/lib64/python2.2 . I installed
python.i386 (so I had distutils in /usr/lib thereafter). No change.
I applied the patch, again no change. My error still persists.
I would be happy if I could build postgresql without python support. Is there
an easy w
Woodchuck Bill <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> OK, so you think it 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 nothi
On 9 Nov 2004 20:36:47 GMT, Woodchuck Bill <[EMAIL PROTECTED]> wrote:
> OK, so you think it 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 n
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]:
> Who's being abused here? Russ & Co.? By their own admission, no.
> The Big-8? No, the groups don't exist in the Big-8? The existing
> readers? No, they can read the group. The rest of the world? No
> more so than those that don't have gro
Woodchuck Bill <[EMAIL PROTECTED]> wrote:
>Russ Allbery <[EMAIL PROTECTED]> wrote in
>news:[EMAIL PROTECTED]:
>>> The UDP would be aimed at the news server(s) at which the mailing list
>>> is being improperly gated. It is their responsibility to reject
>>> improper traffic. As these same server
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]:
> That's his perogative. His server, his rules (or whoever's he set the
> groups up on). We don't have the right to dictate what groups he puts
> on his news server. If someone else decides to take a feed from him
> and allow the group on thei
[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
---(end of
Russ Allbery <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
>> The UDP would be aimed at the news server(s) at which the mailing list
>> is being improperly gated. It is their responsibility to reject
>> improper traffic. As these same servers would also likely carry the
>> group in quest
Andrew - Supernews <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
>> Marc, please stop removing news.groups from your replies.
>
> He's posting to the mailing list; he probably can't avoid dropping the
> crosspost.
>
He can make a nominal effort and post *something* to news.groups.
--
On Saturday, in article <[EMAIL PROTECTED]>
[EMAIL PROTECTED] "Mike Cox" wrote:
> Woodchuck Bill wrote:
>
> > Mike Cox <[EMAIL PROTECTED]> wrote in
> > news:[EMAIL PROTECTED]:
> >
> >> I cannot handle the volume of email that a mailing list would place
> >> on my
> >> inbox.
> >
> > Ever
Mike Cox <[EMAIL PROTECTED]> wrote:
>I also offered to let him take over the process as he understands gatewaying
>and the details better than I. I also offered to let him create the next
>RFD, and hopefully he will agree to do it if he has the time. He is the
>most connected member of the postg
Hello, there! I recently migrated a medium-sized db from SQL Server to
postgres. A couple months after the migration, I noticed I was having
some problems retrieving some data via the JDBC driver. The problem
turned out to be multi-byte characters (smart quotes, etc) in the
SQL_ASCII database.
On Sun, 2004-11-07 at 21:16, Christopher Browne wrote:
> None of these systems _directly_ address how apps would get pointed to
> the shifting servers.
> Something needs to be "smart enough" to point apps to the right place;
> that's something to think about...
Seems like it would be pretty easy
[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
On Sun, 7 Nov 2004 17:29:28 -0400 (AST), [EMAIL PROTECTED] ("Marc
G. Fournier") wrote:
>On Sun, 7 Nov 2004, Gary L. Burnore wrote:
>
>> The groups aren't listed as moderated. Anyone who wants to post is
>> able to. Those not on the mailing list don't go through. That's the
>> problem.
>
>As long
Mike Cox <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> Wouldn't a good solution to the "bogus" and rogue groups be a creation
> of a new domain in the big 8? Suppose there was a rogue.* domain.
> All the groups that were rogue would be placed there by the usenet
> providers. Therefore
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]:
>>The other issue is that I would like to add the other postgresql
>>groups for consideration to be included into the big 8. However there
>>are quite a few of them, and I don't know if all of them deserve to be
>>there. They are all under comp.d
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Brian {Hamilton Kelly}) wrote:
> newsgroups from ONE server, that of their university/employer/ISP. Since
> that capability appeared in Netscape, and other browser/newsreaders,
> there has been a proliferation of *really* private newsgroups, suc
Just a heads up folks, someone has harvested emails out of this list,
or one of the windows users has a virus. Be on the lookout
Full header below.
From [EMAIL PROTECTED] Sat Nov 13 13:16:34 2004
Return-Path: [EMAIL PROTECTED]
Received: from [62.213.193.131] (HELO alibi.mail) by genium.com
(Stal
I'm getting more spam also, though not an inordinate amount. A couple a
week.
The guy from UAE who wants to send me millions, and the v drug.
Didn't happen when I signed on months ago.
On Nov 13, 2004, at 7:47 PM, BARD ROCK wrote:
It is now time to cast your vote as to whether you would like these
mailing lists to become legal USENET newsgroups.
Don't bother. Nothing to see here. Not Usenet site.
Michael Glaesemann
grzm myrealbox com
---(end of broadcast)
It is now time to cast your vote as to whether you would like these
mailing lists to become legal USENET newsgroups.
To vote, visit this web page:
http://party.to/bardrock
Fill out the ballot and email it to the address provided.
Thanks.
BARD ROCK
---(end of broadcast)
75 matches
Mail list logo
