This would be another forgery.
In case anyone's curious, this looks like the work of the well known net.kook,
Steve Young <[EMAIL PROTECTED]>.
He seems to be a well known personality on news.groups (and alt.usenet.kooks).
He has a strange obsession with newsgroup charters and he's been forging v
MIKE COCKS loves SUCKING DICKS and BALLS
FUCK THAT ASSHOLE MIKE COX! HE loves SUCKING COCK!!!
Kevin Barnard
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROT
FUCK THAT ASSHOLE MIKE COX! HE loves SUCKING COCK!!!
Kevin Barnard
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Wed, 10 Nov 2004 08:11:01 -0800 (PST)
Jeff Eckermann <[EMAIL PROTECTED]> wrote:
> --- Liviu BURCUSEL <[EMAIL PROTECTED]> wrote:
>
> > Hi !
> >
> > I'm in the ultimate state of dispair. Over the night
> > some of my
> > databases just disapeared. But they did not dissaper
> > totally. I can
>
On 7.4.6 and earlier, we use apache's log rotation program as follows:
pg_ctl start | rotatelogs ...
If we have a configuration failure, say a bad parameter in postgresql.conf,
we often don't quickly notice because it goes to stdout (into the log).
It'd be nice if it went to stderr a
Hello list,
I'm a postgres-newbie with a maybe silly question.
I'm working on a SuSE-Linux 9.1 with PostgreSQL 7.4.6 with PostGIS 0.9.
My problem is, that I can't insert data into a table because I get the
error, that there is no corresponding value in the referenced field.
But when I query the r
[EMAIL PROTECTED] ("Net Virtual Mailing Lists") wrote in
news:[EMAIL PROTECTED]:
> Yeah.. I'm with you.. I don't really know what all of this is about - I
> like the way the Postgres mailing list works as it is Are any of the
> changes being discussed here going to change the content or how w
MIKE COX, EAT SHIT AND FUCK OFF YOU ASSHOLE.
LEAVE us ALONE!
Goutam Paruchuri
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Currently the mailing list is also hosted in a newsgroup at
new.postgresql.org. The news group is not "Official" so it is not
carried by all news servers. There are some users who can not
participate in a mailing list comfortably for one reason or another.
Some of these individuals would like t
I looked over this thread and can't see any TODO item. Having GRANT
just propogate from the table to a SERIAL sequence doesn't work because
an INSERT into a table is an UPDATE of the sequence.
Is there a TODO here?
---
Tom
On Wed, 10 Nov 2004, Suha Onay wrote:
> st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_UPDATABLE);
> rs = st.executeQuery("select * ...";
>
> Then:
> rs.updateString(20 , ...);
>
> The error is:
> org.postgresql.util.PSQLException: Cannot upd
I've blacklisted this IP ... not sure if that will help or not *shrug*
On Wed, 11 Nov 2004, Mike Cox wrote:
I am proposing some new changes for this list.
1) Black spook jiggaboo watermelon-eating niggers may not post
2) Penny-pinching Jewish kikes may only post if they contribute money
3) Slant-e
I am proposing some new changes for this list.
1) Black spook jiggaboo watermelon-eating niggers may not post
2) Penny-pinching Jewish kikes may only post if they contribute money
3) Slant-eyed Asian chinks and gooks may post as much as they like
4) Hairy dago greaseball Italians may only post rec
John Fabiani <[EMAIL PROTECTED]> writes:
> Thanks but in the doc's it uses the term 'columnname'. The real issue is the
> tablename.columnname is supported in MySQL and I'm trying to support Postgres
> and MySQL with a single code routine.
If you want portable code, I suggest conforming to the SQ
Yeah.. I'm with you.. I don't really know what all of this is about - I
like the way the Postgres mailing list works as it is Are any of the
changes being discussed here going to change the content or how we
receive the mailing lists?..
.. The only change I've noticed is that in all the time o
Yeah.. I'm with you.. I don't really know what all of this is about - I
like the way the Postgres mailing list works as it is Are any of the
changes being discussed here going to change the content or how we
receive the mailing lists?..
What exactly is the problem they thing exists anyways?..
John Fabiani wrote:
> Thanks but in the doc's it uses the term 'columnname'. The real
> issue is the tablename.columnname is supported in MySQL and I'm
> trying to support Postgres and MySQL with a single code routine.
Surely MySQL would also support writing a column name without a table
name?
Thanks but in the doc's it uses the term 'columnname'. The real issue is the
tablename.columnname is supported in MySQL and I'm trying to support Postgres
and MySQL with a single code routine.
John
On Wednesday 10 November 2004 03:31, Martijn van Oosterhout wrote:
> Probably because the bit afte
In article <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
>[EMAIL PROTECTED] ("Miquel van Smoorenburg" ) writes:
>> techdb2=> explain select * from lines where (removed > CURRENT_DATE
>AND removed < '-01-01');
>
>> With 7.3, this query used the index, while with 7.4 it doesn't.
>
>P
Cheers,
The Problems with the database still show up.
We upgraded the database to 7.4.6
>From postgresql.conf:
shared_buffers = 1 # min 16, at least max_connections*2, 8KB each
sort_mem = 2048 # min 64, size in KB
vacuum_mem = 8192 # min 1024, size in KB
# - Fre
On Thu, 11 Nov 2004 03:31 am, Goutam Paruchuri wrote:
> Hello,
>
> I get an error in my log when connecting to postgres server on Windows.
> Postgres version : 8.0.0-beta4
>
> LOG TEXT
>
> 2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
> Files/PostgreSQL/8.0.0-beta4/data/pg_hba.con
Look it at: ~/usr/local/pgsql
Libs: ~/usr/libs/postgresql
Francisco Jose Bernabe Pellicer wrote:
Hello everybody,
I have a computer with Scientific Linux. From a repository I downloaded
the packages rh-postgresql-* with the command apt-get install... The
thing is that after installing all the p
??? As a longstanding reader of the pgsql-
mailinglists, (including via news.postgresql.org on
occasion), all I see is some outsiders trying to help
us "fix" a problem that does not exist. And yes, I
have read most of the messages that have passed by in
these threads. After all that, I still don
"Goutam Paruchuri" <[EMAIL PROTECTED]> writes:
> My understanding was it means ip range of 1 to 254.
You're mistaken. /n means an n-bit netmask. /254 is nonsense.
What you probably want is 192.168.2.0/24, which effectively
means "all of 192.168.2.*".
regards, tom lane
-
Its works if I specify the ipaddress of each client which is being
connecting to the server.
Its hard to do it on a DHCP network . Any roundabouts ?
- Goutam
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Goutam Paruchuri
> Sent: Wednesday,
In order to find all FK declared on a table I query tg_trigger view. The
query lists all FKs declared on the table as well as all the ones
referencing the table. I noticed that FKs that are declared on the table
have pgtype equal to 21, and FKs referencing the table have pgtype 9 or
17.
The foll
On Wed, 10 Nov 2004, Mike Nolan wrote:
Perhaps in parallel with the Usenet community voting whether they want
to receive posts from the mailing lists, we can have the mailing list
subscribers vote on whether they want to receive messages from the
Usenet or want to have their messages forwarded to t
My understanding was it means ip range of 1 to 254.
192.168.2.1 to 192.168.1.254
> -Original Message-
> From: Wilson, David [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 10, 2004 12:05 PM
> To: Goutam Paruchuri
> Subject: RE: [GENERAL] Error connecting using pgadmin from
> diff
Phil Endecott <[EMAIL PROTECTED]> writes:
> Naively I imagined that ANALYSE looks at each table in turn,
> independently. So why does it need more locks when there are more
> tables?
7.4 runs a database-wide ANALYZE as a single transaction, so the locks
accumulate. This was recognized to be a
On Wed, 10 Nov 2004, Oleg Lebedev wrote:
> Is it possible to modify a foreign key constraint and force it to
> cascade on update? If there is no such SQL command, then is it possible
> to update some system tables to accomplish this?
>
> The problem is that I have a bunch of tables with FK constra
Thanks, but the problem here is that I have multiple replicated
databases with the same schema and each of them contains numerous
tables. So, dropping and re-creating FK constraints manualy is not
feasible, and I am trying to automate this process.
Each table contains a primary key column "object
On Wed, Nov 10, 2004 at 10:00:02AM -0700, Oleg Lebedev wrote:
> Is it possible to modify a foreign key constraint and force it to
> cascade on update? If there is no such SQL command, then is it possible
> to update some system tables to accomplish this?
You can drop and add constraints with ALTE
> Perhaps in parallel with the Usenet community voting whether they want
> to receive posts from the mailing lists, we can have the mailing list
> subscribers vote on whether they want to receive messages from the
> Usenet or want to have their messages forwarded to the Usenet. That
> might be
Oleg Lebedev wrote:
Greetings.
Is it possible to modify a foreign key constraint and force it to
cascade on update? If there is no such SQL command, then is it possible
to update some system tables to accomplish this?
BEGIN;
ALTER TABLE t1 DROP CONSTRAINT ...
ALTER TABLE t1 ADD CONSTRAINT ...
COM
Title: Message
Greetings.
Is it possible to
modify a foreign key constraint and force it to cascade on update? If there is
no such SQL command, then is it possible to update some system tables to
accomplish this?
The problem is
that I have a bunch of tables with FK constraints and I need
Hello,
I get an error in my log when connecting to postgres server on Windows.
Postgres version : 8.0.0-beta4
LOG TEXT
2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
"192.168.2.1/254"
2004-11-10 11:22:47 FATAL: missi
Jeff Eckermann wrote:
> ??? As a longstanding reader of the pgsql-
> mailinglists, (including via news.postgresql.org on
> occasion), all I see is some outsiders trying to help
> us "fix" a problem that does not exist. And yes, I
> have read most of the messages that have passed by in
> these thr
--- Liviu BURCUSEL <[EMAIL PROTECTED]> wrote:
> Hi !
>
> I'm in the ultimate state of dispair. Over the night
> some of my
> databases just disapeared. But they did not dissaper
> totally. I can
> still connect to them but I cannot dump them. When
> doing a "select *
> from pg_database" I see onl
--- "Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
> On 9 Nov 2004 15:51:24 -0800,
> [EMAIL PROTECTED] wrote:
>
> >This is a very unfair limitation.
>
> Stop top posting.
>
> >If there is a ballot, it should be posted to each
> of the individual mailing lists.
>
> That's not how it works.
>
>
mike wrote:
> Is it possible to undo a transaction after it has completed (using 8
> beta1)
Using the new point-in-time recovery feature, but you need to set that
up first.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)--
On Wed, 10 Nov 2004, Oliver Elphick wrote:
On Wed, 2004-11-10 at 13:56 +, Mike Cox wrote:
I've had it up to my...
I presume this is another forged mail; the headers show that it came
through mail3.lidya.net, not yahoo.com.
Marc, if we are to be subjected to offensive forgeries like this, do you
On Wed, 10 Nov 2004, Michael Glaesemann wrote:
On Nov 10, 2004, at 6:23 PM, Joel wrote:
Hello. My name is Mike Cox. I am in charge of the changing of these
postgresql lists. ...
(That was a mock diatribe, correct?)
Joel,
I believe these posts are spoofs. Mike has not posted anything along these
li
Dear PostgreSQL experts,
This is with version 7.4.2.
My database has grown a bit recently, mostly in number of tables but
also their size, and I started to see ANALYSE failing with this message:
WARNING: out of shared memory
ERROR: out of shared memory
HINT: You may need to increase max_locks_
I missed the original post, but I think you both might want to do some
googling on nested set.
Robert Treat
On Tue, 2004-11-09 at 11:40, Garris, Nicole wrote:
> We've actually implemented this kind of thing in a different DBMS. The
> physical design consists of a single "organization" table that
Is it possible to undo a transaction after it has completed (using 8
beta1)
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
is someone under way to tar-and-feather the originator of that nuisance?
Mit freundlichem Gruß / With kind regards
Holger Klawitter
- --
lists klawitter de
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQFBki281Xd
* Oliver Elphick ([EMAIL PROTECTED]) wrote:
> Twits like you make me proud to be a Brit.
Gee, I wonder if it was forged...?
<[EMAIL PROTECTED]>
Yup.
Stephen
signature.asc
Description: Digital signature
On Tue, 2004-11-09 at 16:37 -0800, Mike Cox wrote:
> The ones not on the list to be made into the big 8 will always be accessible
> from the news.postgresql.org server.
>
> Also, please, if I've missed an important group you think SHOULD be in the
> big 8, please let me know in this thread.
pgsq
Hey Mike Cocks!!! Kiss my bullocks you bloody wanker! Go bugger off and
take your yank arse to Burger King, you uncultured American cretin.
Twits like you make me proud to be a Brit.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight
[all content snipped]
Spoofed again. Nothing to see here.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
---(end of broadcast)---
TIP 5: Have you che
On Wed, 2004-11-10 at 14:56, Mike Cox wrote (or didn't write):
I guess that pretty much firmly identifies this list as an unmoderated
list, non?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Wed, 2004-11-10 at 13:56 +, Mike Cox wrote:
> I've had it up to my...
I presume this is another forged mail; the headers show that it came
through mail3.lidya.net, not yahoo.com.
Marc, if we are to be subjected to offensive forgeries like this, do you
need to put something in the automatic
I've had it up to my testicles with this fucking RFD. I can't take it no
more. Somebody really needs to take over for me. God damn that
cum-swallowing nigger-loving faggot-ass cocksucker Marc for creating
such a fucking mess. Let him clean it up, that cocky son of a cunt that
his mother was. I quit
It is ok. I fetch the row with no problem.
The error is only in update types like updateString , updateRow,
updateInt...
ps.You are right JDBC list is appropriate.
Richard Huxton wrote:
Suha Onay wrote:
Hi,
I have a problem with PostgreSQL 7.4. (With the old one 7.3 no
probllem.)
You might get
Richard Huxton wrote
> Joel wrote:
> >
> > But we probably do need someone from the mail list to go co-proponent
> > with Mike.
> >
> > Unless, of course, the majority of the list would prefer to keep the
> > status quo.
>
> I must admit I'm not clear what difference this makes to those of us
Let's start with the version of postgresql you're using.
Next, were you running VACUUM FULL regularly?
It sounds like XID wraparound to me, no idea how to solve that. Got
backups?
On Wed, Nov 10, 2004 at 12:56:33PM +0200, Liviu BURCUSEL wrote:
> Hi !
>
> I'm in the ultimate state of dispair. Ove
Hi,
I have a problem with PostgreSQL 7.4. (With the old one 7.3 no probllem.)
I create a connection and a statement :
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection(
O_Constants.DB_CONNECTION_URL,
O_Constants.DB
Probably because the bit after the SET is a "column-name" not a
reference to a column. There's no point qualifying it in any way since
the tablename is given as part of the UPDATE statement.
On Tue, Nov 09, 2004 at 06:33:55PM -0800, John Fabiani wrote:
> From the 7.4 docs:
> A column can be refer
Firstly, check that all your columns are actually of the same type and
the indexes are where you say they are. Using \d will show this.
Secondly, if you do the EXPLAIN ANALYZE with "set enable_seqscan=off",
what is the output?
Hope this helps,
On Tue, Nov 09, 2004 at 05:02:01PM -0800, Mike Werthe
Hi !
I'm in the ultimate state of dispair. Over the night some of my
databases just disapeared. But they did not dissaper totally. I can
still connect to them but I cannot dump them. When doing a "select *
from pg_database" I see only 2 databases I hardly ever use (they are
used once in a couple o
> ...
> I believe these posts are spoofs. Mike has not posted anything along
> these lines before, and the headers are different from his usual posts.
Hmm.
>>> X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char DD hex) in message
>>> header 'X-Mailer' X-Mailer: B\335ANet.org\n
I'm pretty sure the real poster was not Mike. It's very easy to forge
the mail headers, including the From, and comparing this mail with other
posts from Mike it's pretty obvious they were written from different
places.
Cheers,
Csaba.
On Wed, 2004-11-10 at 10:23, Joel wrote:
> > Hello. My name is
On Nov 10, 2004, at 6:23 PM, Joel wrote:
Hello. My name is Mike Cox. I am in charge of the changing of these
postgresql lists. ...
(That was a mock diatribe, correct?)
Joel,
I believe these posts are spoofs. Mike has not posted anything along
these lines before, and the headers are different from
> Hello. My name is Mike Cox. I am in charge of the changing of these
> postgresql lists. ...
(That was a mock diatribe, correct?)
Mike, you are not in charge, you are just leading the point on the RFD
since Marc has other priorities. (And believe me, he does.)
Take a break from the process for
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Robert Treat
> Sent: 09 November 2004 21:14
> To: Marc G. Fournier
> Cc: Greg Sabino Mullane; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: [pgsql-www] [GENERAL] FTP mirror problems
>
>
>
65 matches
Mail list logo
