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
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 breakage
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: [HAC
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 Mom
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" <[EMAIL PROTECTED]>
To: "Hacker
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 out
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!
-M
> 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
> 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 corre
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 PROTECTED]>
Sent: Sunday, Ap
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
Sub
> 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
Well, what is being discussed here would require a *recompile* to change the
values, so you sure wouldn't want that! :-)
Currently you can set a lot of internal variables with the SET command in any PG
session.. It's useful for forcing index or sequential scans and such (and I'm
sure a lot more).
Indeed, as an avid user (and tuner, I suppose) of PostgreSQL, I can't
see how any configure option would be faster or better than the existing
command line /config file parameters -- it would only serve to make things
harder to deal with IMHO. "Tuning" PostgreSQL is pretty simple, and is
expla
> 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 t
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:
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 don
I sure hope it gets more attention than some of the other PHP PostgreSQL
bugs.. I don't mean to trash anyone here but the pg_connect problem has been
around since 4.0.1 and has yet to be addressed. One of our programmers is
taking a look at that one but he's not been able to fix it yet.
*crosses
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: BUSTED WITH CURRENT CVS
> PHP
t; Chris
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[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 Consecutive pg_open statements cause second statement to
>fail
> > 6525 Open Connection problem
> > 7007 Open The pg_close function doesn't close the conne
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 compi
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]>
Cc: <[EMAIL PROTECTED]>
Sent: Mon
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
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
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]&
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;
$77,000
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
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.. I'v
> 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
ser
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
dat
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 i
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" <[EM
> > 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,
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: <[EMAIL PROTECTED]>
Sent: Mo
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 a
> 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
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
comput
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 Hacker" <[EMAIL PROTEC
tomic' by the operating
> system. Hence, 32k blocks would break the transactions system. (Or
> something like that - am I correct?)
>
> Chris
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Mitch Vincent
>
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 dis
heck into it.
Thanks!
-Mitch
- 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
Subj
I've tried quite a bit to use persistent connections with PHP (for over
a year) and always the scripts that I try to use them with behave crazy...
The last time I tried there were problems all over the place with PHP,
variables getting overwritten, certain functions just totally breaking
(date
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 K
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 u
I've been wondering the difference in varchar and TEXT in the aspect of
length and indexing - what would happen if you tried to index a
varchar(BLCKSZ) ? I know you can index smaller portions of text (at least it
appears you can) so why not larger alphanumeric data? (I'm not complaining,
just tryi
, 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
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 2>&1 &
.. as I've done with 7.0.2, it failed to start and got this in my
postgresql.log :
DEBUG: Data Base System is
I didn't see any mention of it on the TODO so I thought I'd ask if anyone
had thought about full test indexing for 7.1 (I'm guessing not)..
If not, I'd like to suggest it be put on the TODO -- if nothing else so
someone could pick it up in the far future if they wanted to.. It doesn't
seem like t
> I should point out that it works as I expected it to on other values..
>
> 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
Maybe I'm just overlooking something really simple but this has me a bit
confused.
What I'm trying to do is get the amount of time from A to B -- I thought
age() would do just that but it seems to be about a day off sometimes.
hhs=# SELECT age('Sun Dec 03 08:00:00 2000 EST','Tue Oct 10 08:00:00
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 lis
59 matches
Mail list logo
