On 5/4/05, Russell Smith <[EMAIL PROTECTED]> wrote:
> On Wed, 4 May 2005 04:40 am, Tom Copeland wrote:
> > On Tue, 2005-05-03 at 14:26 -0400, Mitch Pirtle wrote:
> >
> > Of course, Mitch is running the second largest GForge site on the planet
> > (as far as
It seems that the Hackers list isn't in the list to
subscribe/unsubscribe at http://developer.postgresql.org/mailsub.php
Just an FYI.
-Mitch
Computers are like Air Conditioners, they don't work when you open
Windows.
---(end of
Will
SELECT now() - 'nummonths months'::interval ;
work?
- Original Message -
From: "Vince Vielhaber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 4:30 PM
Subject: [HACKERS] casting for dates
>
> I'm trying to use an integer from a table to add/subt
Ok, I misudnerstood, I had long included my own escaping function in
programs that used libpq, I thought the intent was to make escaping happen
automatically..
Thanks!
-Mitch
- Original Message -
From: "Alex Pilosov" <[EMAIL PROTECTED]>
To: "Mitch Vincent&qu
escaping them (else major breakage of
existing application would occur).. I didn't see the patch but I assume that
someone took a look to make sure before applying it.
-Mitch
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Florian Weimer" &l
I've had great luck with Postfix as well.
-Mitch
- Original Message -
From: "Ian Lance Taylor" <[EMAIL PROTECTED]>
To: "Lamar Owen" <[EMAIL PROTECTED]>
Cc: "Serguei Mokhov" <[EMAIL PROTECTED]>; "PostgreSQL Hackers"
<
MySQL has to first add some features in order to have some bugs, don't they?
:-)
Some people crack me up in their opinions.. If it took him 6 hours to figure
out "int8" then I'm not really interested in anything else he has to say...
Lord...
-Mitch
- Original Messag
I've used select count(), then a select LIMIT/OFFSET for the pages.. A
cursor might be a better idea though I don't think you can get the total
number of rows without count()'ing them.
Good luck!
-Mitch
- Original Message -
From: "Christopher Kings-Lynne&quo
you have outdated source code or the problem is somewhere else..
Good luck!
-Mitch
- Original Message -
From: "Steve Howe" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 1:30 PM
Subject: Re
luck!
-Mitch
- Original Message -
From: "Steve Howe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 4:51 AM
Subject: [HACKERS] PQexec() 8191 bytes limit and text fields
> Hello all,
>
>
> Writing my interface application,
> explain select * from forsamling where klar = 1;
Try SELECT * FROM forsampling WHERE klar = 1::int2
-Mitch
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
used) it for every database-driven project I've done to
date. I haven't had any trouble convincing clients to use PostgreSQL over Oracle
(and everyone that wants some software written always wants to use Oracle!). I
present the facts of PostgreSQL and in ev
The "Current Release Docs" on the PostgreSQL website still look 7.0.Xish..
Just an FYI...
-Mitch
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
To top it all off, their comments are broken -- I submitted mine and it
displays Marc's again (until you click on the link of course)..
*sigh* they must be using MySQL. :-)
-Mitch
- Original Message -
From: "The Hermit Hacker" <[EMAIL PROTECTED]>
To: <[EMAIL
In the FAQ..
http://www.postgresql.org/docs/faq-english.html#4.7
Good luck!
-Mitch
Software development :
You can have it cheap, fast or working. Choose two.
- Original Message -
From: "Mitesh Shah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday,
e (Tom?) told me it was about 2k..
-Mitch
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
sure a lot more)..
-Mitch
Software development :
You can have it cheap, fast or working. Choose two.
- Original Message -
From: "Darren King" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 11:13 AM
Subject: RE: Re: Re: "--tuning" c
uning should be left up to the administrator as that's what
administrators are for :-)
Just my humble $0.02 worth..
-Mitch
Software development :
You can have it cheap, fast or working. Choose two.
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Joh
ase or putting up with the missing
features of MySQL..
All my humble opinion of course, I wish you the best of luck.
-Mitch
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Just an FYI -- It works well from behind my proxy..
-Mitch
- Original Message -
From: "Vince Vielhaber" <[EMAIL PROTECTED]>
To: "Zeugswetter Andreas SB" <[EMAIL PROTECTED]>
Cc: "'The Hermit Hacker'" <[EMAIL PROTECTED]>; <[EMAI
beta 4 now, but I'd bet at least one
of you is using FreeBSD (and it compiles and installs rather nicely
anyway)..
-Mitch
*crosses fingers*
Is there anything stupendously broken in PG beta 4? I have it on my devel
server and don't want to have to recompile (right now at least, deadlines
are growing close) unless I stand a large chance of pulling the pin on a
grenade somewhere.
Thanks!!
-Mitch
- O
Just an FYI... PHP compiles with up to and including PG-Beta4..
-Mitch
- Original Message -
From: "Larry Rosenman" <[EMAIL PROTECTED]>
To: "PostgreSQL Hackers List" <[EMAIL PROTECTED]>
Sent: Sunday, February 18, 2001 3:18 PM
Subject: PHP 4.0.4pl1 BUILD:
Bruce said he and Rasmus (from PHP devel) were fixing this. That'll be
great!
-Mitch
- Original Message -
From: "Christopher Kings-Lynne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 8:55 PM
Subject: RE: Re: PostgreSQL -> P
4.0.2
Ouch. It looks like this is exactly what is happening to me. pg_open gets
called several times in these scripts.. It looks like I'll have to install
an old version of PHP.. Son of a er nevermind..
Thanks guys..
-Mitch
There isn't any row or query size limit in 7.1 thanks to TOAST!
-Mitch
- Original Message -
From: "Manuel Cabido" <[EMAIL PROTECTED]>
To: "m w" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 10:18 PM
Subject:
This is the debug output for the last query that seems to be throwing PHP
into a fit (a fit that somehow closes the backend connection - note, it
doesn't crash, it just closes)..
I don't think anything is going on here that shouldn't be, it looks the same
as any other query that succeeds.. I just
You need to compile PostgreSQL from source with -g ..
ftp.postgresql.org is the main FTP, there are many mirrors. Look for the
source tarball there..
-Mitch
- Original Message -
From: "Mathieu Dube" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]&
I found the problem. User error, it's been a long Sunday.
Sorry!
-Mitch
- Original Message -
From: "Mitch Vincent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 11:00 PM
Subject: Very odd order by behavior
> FreeBSD 4.2, Pos
[ACC]
1818 | ACC| Accounting [ACC]
1819 | ACD| Acoustics [ACD]
1819 | ACD| Acoustics [ACD]
1820 | ADV| Advertising [ADV]
1820 | ADV| Advertising [ADV]
Either I'm seeing double or something isn't right here :-)
Thanks for any insights.
-Mitch
email directly to Peter -- I
was too quick on the send..
-Mitch
- Original Message -
From: "Dave Mertens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 2:12 PM
Subject: Re: Re: Format of the Money field
> On Sat, Feb 03, 2001 at
se for all fields that need to hold a dollar amount so I'm curious.. I
remember reading in the documentation that money was numeric(9,2) with the
dollar sign added but I wanted to check with the man :-)
-Mitch
- Original Message -
From: "Peter Mount" <[EMAIL PROTECTED]&
icants;
$77,000.00
$43,500.00
$0.00
$93,000.00
...
If it changed, it looks like it changed a long time ago! :-)
-Mitch
- Original Message -
From: "The Hermit Hacker" <[EMAIL PROTECTED]>
To: "Peter T Mount" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent
Yes, I did..
-Mitch
- Original Message -
From: "Matthew" <[EMAIL PROTECTED]>
To: "'Mitch Vincent'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 10:33 AM
Subject: RE: [HACKERS] Beta 4 problem(s)
> D
ssues in beta4
that might cause this kind of thing to happen? Are there any changes that
anyone can think of that might need to happen to the PHP PostgreSQL support
for 7.1? I'd be happy to look into doing making the changes if so..
Thanks!!
-Mitch
nce 7.0 (on a productions
server) and haven't had a problem one..
-Mitch
x27;m importing
data :
DEBUG: copy: line 2865, XLogWrite: new log file created - try to increase
WAL_FILES
Is that anything to be concerned about? Do I need to increase WAL_FILES? If
so, how?
Thanks!
-Mitch
there will always be the base PostgreSQL out there for everyone.. I
hope.
Just my $0.02 worth..
-Mitch
- Original Message -
From: "Lamar Owen" <[EMAIL PROTECTED]>
To: "PostgreSQL Development" <[EMAIL PROTECTED]>
Sent: Tuesday, December 05, 2000 1:45 PM
Sub
Ok, this has peaked my interest in learning exactly what WAL is and what it
does... I don't see any in-depth explanation of WAL on the postgresql.org
site, can someone point me to some documentation? (if any exists, that is).
Thanks!
-Mitch
- Original Message -
From: "Na
;t see why this wouldn't
work...
Note I'm not saying you're wrong, just asking that you explain your comment
a little more. If WAL can't be used to help recover from crashes where
database corruption occurs, what good is it?
-Mitch
If you installed in the default directory then the files relating to a
database are in
/usr/local/pgsql/data/base/
So you could just total up the size of everything under that directory.
-Mitch
- Original Message -
From: "Guus Kerpel" <[EMAIL PROTECTED]>
To: <[EMA
peep from any PostgreSQL backend. It's superbly stable on
all my machines..
Damn good work guys.
-Mitch
- Original Message -
From: "The Hermit Hacker" <[EMAIL PROTECTED]>
To: "Hannu Krosing" <[EMAIL PROTECTED]>
Cc: "xuyifeng" <[EMAIL PROT
> So, having _both_ is the best thing.
Absolutely, that's always what I meant -- we already have views and views
can do this type of stuff at SELECT time can't they? So it's not a change,
just an addition
-Mitch
imple
computations like that but more complex ones.
Just playing the devil's advocate a bit.
-Mitch
- Original Message -
From: "Zeugswetter Andreas SB" <[EMAIL PROTECTED]>
To: "'Ross J. Reedstrom'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED
I modified the FTI trigger for my own use a while ago (indexes whole
words, eliminates duplicate a few other things) -- I'm not sure if it would
do anyone any good but you're welcome to it. To whom should I send it?
-Mitch
- Original Message -
From: "The Hermit
If it breaks anything in PostgreSQL I sure haven't seen any evidence -- the
box this database is running on gets hit pretty hard and I haven't had a
single ounce of trouble since I went to 7.0.X
-Mitch
- Original Message -
From: "Christopher Kings-Lynne" <[EMAIL P
I've been using a 32k BLCKSZ for months now without any trouble, though I've
not benchmarked it to see if it's any faster than one with a BLCKSZ of 8k..
-Mitch
> This is just a curiosity.
>
> Why is the default postgres block size 8192? These days, with caching
> f
I'm sure that this, if true, could certainly be the source of the problems
I've seen... I can't comment on if PHP is completely threadsafe, I know that
some of the modules (for lack of a better word) aren't, possible the ClibPDF
library I'm using. I'll c
ust at the bottom of the
to-do list I'm sure (as that was back before PHP 4 was even released and
obviously the problem remains)..
Just my $0.02 worth.
-Mitch
- Original Message -
From: "Ron Chmara" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTEC
Just speaking Russian and English both (to any degree) is absolutely
amazing, put that on top of MVCC and WAL and we have Vadim, the smartest
person alive! *grin*
-Mitch
- Original Message -
From: "Mikheev, Vadim" <[EMAIL PROTECTED]>
To: "'Don Baccus'&quo
s good for some things and some
people, I've tried MySQL, tested MySQL and then tossed MySQL into the
garbage can...
I found some very educational conversation here :
http://openacs.org/philosophy/why-not-mysql.html courtesy of Don and others.
-Mitch
- Original Message -
From:
ning,
just trying to understand.)
I just made a varchar(3) field, inserted some data into it and created
an index on it, it seemed to work OK -- is it really only indexing X
characters or something?
-Mitch
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
T
, I'm off to sit in the corner for a while...
-Mitch
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Mitch Vincent" <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 6:47 PM
Subject: Re: [HACKERS] 7.0.2 -> 7.0.3 problem - anyo
oncerned was the same as when I
was running 7.0.2
Knowing all the above, do you still think a dump and reload was required? If
so that's fine, I just need to know..
-Mitch
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Mitch Vincent" <
ssing the same file seconds before I upgraded, that and the fact
that I changed permissions to 777 all the way down the tree to make sure..
-Mitch
> You have to dump/initdb/reload if you change the block size. Simply
> recompiling is not going to work.
>
> Cheers...
>
>
> MikeA
By the way, what is pg_control and what does it do?
-Mitch
- Original Message -
From: "Michael Ansley" <[EMAIL PROTECTED]>
To: "'Mitch Vincent '" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 4:02 PM
Subje
Open() that
fails..
I did nothing but stop the postmaster, compile and install 7.0.3 and start
the postmaster. then compiled and installed 7.0.2 again and all of the
sudden the 7.0.2 or 7.0.3 backend doesn't start -- it makes no sense.
As always, any help is appreciated. Thanks!
-Mitch
It doesn't
seem like too many are worried about it so the request is pretty selfish,
though I'm sure it would help many people especially after 7.1 and TOAST
make text fields unlimited in size.
Thanks!
-Mitch
08:00:00 2000 EDT'::timestamp + '1 mon 24 days 1
hour'::interval);
?column?
----
Sun Dec 03 07:00:00 2000 CST
(1 row)
(Timezone differences are there and expected, these boxes are all across the
country).
-Mitch
s..
hhs=# SELECT age('Sun Nov 05 08:00:00 2000 EST','Tue Oct 10 08:00:00 2000
EDT') as esec;
esec
--
@ 26 days 1 hour
(1 row)
hhs=# SELECT ('Tue Oct 10 08:00:00 2000 EDT'::timestamp + '1 mon 24 days 1
hour'::interval);
?column?
--
Mon Dec 04 08:00:00 2000 EST
(1 row)
*shrug*
Thanks!
-Mitch
estion for an Oracle list since this has nothing
to do with PostgreSQL? (Just a friendly suggestion) :-)
Good luck!!
-Mitch
- Original Message -
From: "Jim Mercer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 02, 2000 12:43 PM
Subject: [HAC
61 matches
Mail list logo