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/subtract
Perhaps I'm not thinking correctly but isn't it the job of the application
that's using the libpq library to escape special characters? I guess I don't
see a down side though, if it's implemented correctly to check and see if
characters are already escaped before escaping them (else major
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 [EMAIL PROTECTED]
Cc: [EMAIL
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 Message -
From: Bruce
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
[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 4:24 PM
Subject: [HACKERS] Re: List
First, are you using the latest PG? I was under the impression that all
the hard-coded limitations on size had been eliminated in the latest
releases. I know for an absolute fact that I can insert multi-megabyte sized
text chunks in PG 7.1.2 as I've done just that before...
Good luck!
Hi Steve, lets approach this from the other angle...
I don't see anywhere in your email where you say what makes you think that
you can only pass a query 8191 bytes in size to PG. What exactly makes you
think that there is some hard coded limit? This limit is not in 7.1.2 so
either you have
If _you_ had been deluged with that kind of vitriol, what kind of favors
would you feel like doing?
Well, one person's opinion on the article that was perhaps expressed a
little harshly shouldn't cause the company to cover their ears and hum when
their article is in need of multiple
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 PROTECTED]
Sent: Sunday, April
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
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, April 12, 2001 6:10 PM
Hmm. I'm pretty sure that a single index on the entire contents of a
resume *as a single field* is close to useless. And an index on an 8k
piece is also useless. Presumably you really want an index covering each
significant word of each resume, in which case you would not run into
the 4k
I know your situations, your DB is not updated and inserted lots of
records in few minutes,
mine is difference, I have a real time Stock Trading system, you know,
stock, its price
is changed every minute or even every second , I need update and insert
delta change into DB,
draw their
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]; [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 7:53 AM
Subject: Re:
I have a bunch of machines here, some are rather old (K6-200s,P133s, some
486s etc) but they're just collecting dust now. I would be more than happy
to install any OS and do build testing for PostgreSQL is there is a need..
What OSes need to have PostgreSQL built/tested on that the developers
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
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: Re: Like vs '='
Hi there,
I am compiling
In the PHP bugs I see...
===[PostgreSQL
related]===
5862 Open Consecutive pg_open statements cause second statement to
fail
6525 Open Connection problem
7007 Open The pg_close function doesn't close the connection.
lto:[EMAIL PROTECTED]]On Behalf Of Mitch Vincent
Sent: Tuesday, February 06, 2001 2:29 AM
To: [EMAIL PROTECTED]
Subject: [HACKERS] Re: PostgreSQL - PHP problem
In the PHP bugs I see...
===[PostgreSQL
related]===
5862 Open C
FreeBSD 4.2, PostgreSQL 7.0.3
The attached file is the schema and data to the app_degrees table. Now check
this out :
select * from app_degrees gives (expected) :
degree_id | abbr | description
---++--
1818 | ACC
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, PostgreSQL 7.0.3
The att
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]
To: "Mitch Vincent&qu
..
-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 11:39:29AM -0500, Mitch Vincent wrote:
What's the standard on
hhs= select version();
version
---
PostgreSQL 6.4.2 on i386-unknown-freebsd3.1, compiled by gcc 2.7.2.
| currentsalary| money|
4 |
hhs= select currentsalary from applicants;
I've been using the 7.1 beta version for quite a while now and just upgraded
to beta 4, I've noticed my application is reporting that the backend shuts
down prematurely... (I'm using PHP).. I'm having a time trying to debug
this.. I know it's not my code as this works fine on a 7.0.3 install..
When Postgresql 6.5 came out it, it was VERY MUCH better ( many many
thanks
to the developers and all involved). And I'm waiting for a solid 7.1 to
fix
that 8KB issue.
Technically..
= BLCKSZ (can be up to 32k)
I've been using PostgreSQL with a 32k BLCKSZ since 7.0 (on a productions
server)
Hey guys, I am just getting back into the swing of things (after a nice
vacation and a not-so-nice move across country).. I just installed 7.1 Beta
3 and am playing with it (I'm impressed with the speed increase I've seen
with virtually no tweaking BTW).. I see a lot of this when I'm importing
Regardless of what license is best, could the license even be changed now? I
mean, some of the initial Berkeley code is still in there in some sense and
I would think that the original license (BSD I assume) of the initial source
code release would have to be somehow honored.. I'm just wondering
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: "Nathan Myers"
If you installed in the default directory then the files relating to a
database are in
/usr/local/pgsql/data/base/databasename
So you could just total up the size of everything under that directory.
-Mitch
- Original Message -
From: "Guus Kerpel" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
No, WAL does help, cause you can then pull in your last dump and recover
up to the moment that power cable was pulled out of the wall ...
False, on so many counts I can't list them all.
Why? If we're not talking hardware damage and you have a dump made sometime
previous to the crash, why
I guess it depends on what you're using it for -- disk space is cheap and
abundant anymore, I can see some advantages of having it computed only once
rather than X times, where X is the number of SELECTs as that could get
costly on really high traffic servers.. Costly not so much for simple
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
This is one of the not-so-stomped boxes running PostgreSQL -- I've never
restarted PostgreSQL on it since it was installed.
12:03pm up 122 days, 7:54, 1 user, load average: 0.08, 0.11, 0.09
I had some index corruption problems in 6.5.3 but since 7.0.X I haven't
heard so much as a peep from
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
file systems, high speed DMA disks,
- Original Message -
From: "Don Baccus" [EMAIL PROTECTED]
To: "Mitch Vincent" [EMAIL PROTECTED]; "PostgreSQL Hackers List"
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, November 25, 2000 9:18 PM
Subject: Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent co
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'" [EMAIL PROTECTED]; "Christopher
I've wondered and am still wondering what a lot of these benchmark tests
are out to prove. I'm not sure that any PostgreSQL advocate has ever said or
implied that PostgreSQL is faster than anything, much less MySQL. While I'm
sure it's faster than some, I've just never heard the argument for
I just upgraded to 7.0.3 and tried to start the backend like
/usr/local/pgsql/bin/postmaster -B 256 -o '-S 10240 -s' -D
/usr/local/pgsql/data -i /usr/local/pgsql/postgres.log 21
.. as I've done with 7.0.2, it failed to start and got this in my
postgresql.log :
DEBUG: Data Base System is
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
Subject: RE: [HACKERS] 7.0.2 - 7.0.3
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 - anyone?
Quite strange. There isn't
I think it's against the Oracle license to run it under any kind of
emulation (which is what you would have to do with FreeBSD, run it under
Linux emulation).. All that's void if they support FreeBSD natively now
(which I don't think they do)..
Wouldn't this be a better question for an Oracle
42 matches
Mail list logo