On Wed, Sep 07, 2005 at 05:26:07PM -0700, Matthew Peter wrote:
> Thanks. I'll check it out asap. I didn't realize the
> regex expressions needed to be escaped for it to be a
> valid expression.
If you use ordinary quotes (') around the regular expression then
you have to escape the backslashes bec
On Thu, Sep 08, 2005 at 04:22:07AM +0200, [EMAIL PROTECTED] wrote:
Hi,
> we run 'out of space' in one of our columns which is smallint and we
> need to make it integer.
>
> I did some research and found out that the only way is to create a new
> column with integer data type, then SET new = ol
Hi, ppl
Is there any way to do SELECTs with different priorities?
Once a month I need to do some complex reports on table with over 7
billion rows, which implies several nested SELECTS and grouping (query
runs over 20 minutes on P4/2.4GHz). Concurrently, there are over 50
processes updating table
Hello,
we run 'out of space' in one of our columns which is smallint and we
need to make it integer.
I did some research and found out that the only way is to create a new
column with integer data type, then SET new = old, then drop old and
rename new like old [1].
Could somebody confirm i
Brad Nicholson wrote:
> Does anybody have regular expression handy to verfiy email addresses?
There are Perl modules on CPAN to verify just about anything.
Email::Valid comes to mind here. These can of course be plugged into a
PL/Perl function.
--
Peter Eisentraut
http://developer.postgresql.
> "Steve" == Steve Atkins <[EMAIL PROTECTED]> writes:
Steve> So I consider any use of characters outside that set in a hostname or
Steve> "domain name" to be invalid. Specifically an underscore is not a valid
Steve> character, so any use of an underscore in the domain-part of an
Steve> address
On Wed, Sep 07, 2005 at 01:33:51PM -0700, Randal L. Schwartz wrote:
> > "Steve" == Steve Atkins <[EMAIL PROTECTED]> writes:
>
> Steve> But, depending on what you're doing, validation may not be a good
> Steve> idea. There are email addresses that are syntactically invalid that
> Steve> are del
Klint Gore schrieb:
>On Mon, 05 Sep 2005 21:59:33 +0100, Richard Huxton wrote:
>
>
>>Daniel Morgan wrote:
>>
>>
>>>Does PostgreSQL provide a way to step-debug into plpgSQL stored procedures?
>>>
>>>
>>Afraid not. One of the commercial versions of PG offered it as a feature
>>IIRC, b
On Wed, Sep 07, 2005 at 01:02:18PM -0500, Scott Marlowe wrote:
> On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote:
> > On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote:
> > > Xlog will be the only believable data if your system crashed. So it is a
> > > dangerous practice to put xlog s
On Wed, Sep 07, 2005 at 03:52:11PM -0500, Bruno Wolff III wrote:
> On Wed, Sep 07, 2005 at 12:21:45 -0700,
> Steve Atkins <[EMAIL PROTECTED]> wrote:
> >
> > /[EMAIL PROTECTED]@(?:[EMAIL
> > PROTECTED])?[a-z0-9-_]+\.(?:a[defgilmnoqrstuwz]|b[abdefghijmnorstvwyz]|c[acdfghiklmnoruvxyz]|d[ejkmoz]|e[
On Wed, 2005-09-07 at 14:17, J wrote:
> Hi,
> I was wondering if there's a recommended maximum number of triggers in a
> table?
> Will having 3 triggers, one for insert or update, one for insert and one
> for delete greatly impact performance?
It's not the number so much as what they're doing.
> "Steve" == Steve Atkins <[EMAIL PROTECTED]> writes:
Steve> But, depending on what you're doing, validation may not be a good
Steve> idea. There are email addresses that are syntactically invalid that
Steve> are deliverable and in active use.
Really? Name one. Or maybe it's just your idea o
On Wed, Sep 07, 2005 at 12:21:45 -0700,
Steve Atkins <[EMAIL PROTECTED]> wrote:
>
> /[EMAIL PROTECTED]@(?:[EMAIL
> PROTECTED])?[a-z0-9-_]+\.(?:a[defgilmnoqrstuwz]|b[abdefghijmnorstvwyz]|c[acdfghiklmnoruvxyz]|d[ejkmoz]|e[ceghrst]|f[ijkmorx]|g[abdefhilmnpqrstuwy]|h[kmnrtu]|i[delnoqrst]|j[mop]|k[e
On Wed, Sep 07, 2005 at 11:17:10AM -0400, Brad Nicholson wrote:
> Does anybody have regular expression handy to verfiy email addresses?
It's not possible to validate an email address with a regex. If
you're prepared to handwave over things like whitespace and
embedded comments you can validate wit
On Tue, Sep 06, 2005 at 11:40:18PM -0700, Matthew Peter wrote:
> I'm trying to do a slice directly from a table so I
> can get a brief preview of the articles content by
> counting \s (spaces), not new paragraphs.
Are you trying to extract the first N words from a string? If
that's not what you m
Hi,
I was wondering if there's a recommended maximum number of triggers in a
table?
Will having 3 triggers, one for insert or update, one for insert and one
for delete greatly impact performance?
Thanks,
J
---(end of broadcast)---
TIP 9: In ver
# [EMAIL PROTECTED] / 2005-09-07 11:17:10 -0400:
> Does anybody have regular expression handy to verfiy email addresses?
This is what I have. The comment notes the caveats.
-- CREATE FUNCTION IS_EMAILADDRESS {{{
-- returns TRUE if $1 matches the rules for RFC2822 addr-spec token,
-- ignoring
On Wed, 2005-09-07 at 01:50, Jürgen Rose wrote:
> Scott Marlowe wrote:
> >
> > A couple of points:
> >
> > 1: You wouldn't buy the QE II (a big luxery liner) and complain that it
> > doesn't work well for water skiing and is too complex. It's the QE II.
>
> I don't get that argument.
The real
On Wed, 2005-09-07 at 12:40, Jim C. Nasby wrote:
> On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote:
> > Xlog will be the only believable data if your system crashed. So it is a
> > dangerous practice to put xlog stuff in RAID0.
>
> No more or less so than putting your main database
Dinesh Pandey wrote:
> You can use Postgres 8.x, it supports 64 bit (if your OS supports 64
> bit).
>
> But you have to install it
> --
> ./configure --enable-integer-datetimes
> make
> make install
> --
Jim C. Nasby wrote:
>No more or less so than putting your main database on RAID0. If any
>drive fails, you lose everything.
perhaps it's time to start writing it [^r]A[^i]D 0 to try and make
the point.
richard
---(end of broadcast)---
TIP 5: don't
On Wed, Sep 07, 2005 at 12:47:43PM -0700, Qingqing Zhuo wrote:
> Xlog will be the only believable data if your system crashed. So it is a
> dangerous practice to put xlog stuff in RAID0.
No more or less so than putting your main database on RAID0. If any
drive fails, you lose everything.
--
Jim
Randal L. Schwartz wrote:
>Absolutely not. It rejects which is a perfectly
>valid email address. (Try it, you'll get my autoresponder.)
>Google for "RFC 822" and "RFC 2822" to see the *real* rules. An
>actual regex for an email address is rather large.
there's an extended example in appendix
Xlog will be the only believable data if
your system crashed. So it is a dangerous practice to put xlog stuff in
RAID0.
Regards,
Qingqing
"Carlos Benkendorf" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...
Hi,
Does it make any sense to change the pg_xlog position
Not knowing your application, keep in mind that just because somebody
enters a syntactically correct email address doesn't mean they entered
the right one.
Cristian Prieto wrote:
Does somebody could embed this regex into a pgsql ~ statement? (maybe
in a DOMAIN type?)
Thanks a lot!
- Or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Does anybody have regular expression handy to verfiy email addresses?
CREATE OR REPLACE FUNCTION goodemail(text) RETURNS BOOL LANGUAGE plperl AS
$$
my $lwsp = "(?:(?:\\r\\n)?[ \\t])";
my $specials = '()<>@,;:".\\[\\]';
my $controls = '\\000-\\
Apparently postgresql runs at 11% to 45% of normal speed in VMware
workstation. Basically it could be about 1/10th the performance for OLTP
stuff.
See here:
http://www.cl.cam.ac.uk/Research/SRG/netos/xen/performance.html
(Notice also that the web server performance is less than 30% of native).
> "Markus" == Markus Rebbert <[EMAIL PROTECTED]> writes:
Markus> Am Mittwoch, den 07.09.2005, 11:17 -0400 schrieb Brad Nicholson:
>> Does anybody have regular expression handy to verfiy email addresses?
Markus>
^([a-zA-Z0-9._-]+)\@(([a-zA-Z0-9-]+[.]?){1,}[a-zA-Z0-9-]*+\.){1,}[a-zA-Z]{2,4}$
Does somebody could embed this regex into a pgsql ~ statement? (maybe in a
DOMAIN type?)
Thanks a lot!
- Original Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Brad Nicholson" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, September 07, 2005 9:41 AM
Subject: Re: [GENERAL] E
Thought I would add some comments to this thread. I recently bought
the K. Douglas & S. Douglas (2006) "PostgreSQL: The comprehensive guide to
building, programming, and administering PostgreSQL databases", 2nd ed (1006
pages). At $50, it is a bit pricey, but that is the case with all
tech
Brad Nicholson <[EMAIL PROTECTED]> writes:
> Does anybody have regular expression handy to verfiy email addresses?
It's harder than you think. For one that handles it in fairly full
generality, see Jeffrey Friedl's book _Mastering Reguar Expressions_.
The regex he comes up with is quite a beast.
On Sep 8, 2005, at 12:17 AM, Brad Nicholson wrote:
Does anybody have regular expression handy to verfiy email addresses?
http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html
:)
Michael Glaesemann
grzm myrealbox com
---(end of broadcast)--
Am Mittwoch, den 07.09.2005, 11:17 -0400 schrieb Brad Nicholson:
> Does anybody have regular expression handy to verfiy email addresses?
^([a-zA-Z0-9._-]+)\@(([a-zA-Z0-9-]+[.]?){1,}[a-zA-Z0-9-]*+\.){1,}[a-zA-Z]{2,4}$
but i don't think, it's really complete.
best regards,
Markus
---
Does anybody have regular expression handy to verfiy email addresses?
--
Brad Nicholson
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an ind
Hi,
This is my first mail to this list, so please bear with me.
I'm a computer science student doing a thesis on paging
algorithms, both from a theoretical and practical viewpoint.
I'm currently looking for some standard way of testing the
performance of paging alogrithms. But I haven't been able
hi folks
the lastest postgres odbc driver don't work into
winxp64 ( AKA Windows Vista) Operative System.
The installer fail, i'm try to register dll manually
but still fail at add conection time into control
panel
any ideas
best regards
mdc
___
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> wrote:
>> Well, if you know any vendors who move postmaster.pid out of the PGDATA
>> directory, let us know so we can knock some sense into their heads.
> I thought Fedora did, but there are actually two files, one in /va
You can use Postgres 8.x, it supports 64 bit (if your OS supports 64 bit).
But you have to install it
--
./configure --enable-integer-datetimes
make
make install
--
Thanks
Dinesh Pandey
-Origi
Hi,
I just wanted to know if there is a specific version of PostGreSQL for 64
Bits CPU (AMD/Intel) on a platform like Linux or Windows XP 64.
thx
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
am 07.09.2005, um 1:01:11 -0700 mailte Matthew Peter folgendes:
> How many rows does it take for select performance on a
> table to degrade? I hope this question isn't to
> ambiguous (ie lollipop licks). But seriously, 100,000?
> 1,000,000? 10,000,000? With just a regular lookup on
> an unique in
How many rows does it take for select performance on a
table to degrade? I hope this question isn't to
ambiguous (ie lollipop licks). But seriously, 100,000?
1,000,000? 10,000,000? With just a regular lookup on
an unique index. Nothing crazy or aggregate.
EX: select * from bigtable where id = 1234
Scott Marlowe wrote:
On Tue, 2005-09-06 at 16:09, Jürgen Rose wrote:
Sorry, but I better use this email address, I just hate to use Outlook
for this stuff.
To Peter Eisentraut
Yes, I've read the chapter in the manual.
To Michael Glaesemann
locally I run the database on my laptop (Dell D800
42 matches
Mail list logo
