On Wed, Sep 07, 2005 at 12:19:19AM -0400, Tom Lane wrote:
Having said that, I'm not sure I believe in filesystem locks as doing
much to improve security in the case of multiple hosts attached to a SAN
filesystem. Does the locking work at all across hosts, and if it does,
does the lock get
Jim C. Nasby wrote:
On Wed, Sep 07, 2005 at 12:19:19AM -0400, Tom Lane wrote:
Having said that, I'm not sure I believe in filesystem locks as doing
much to improve security in the case of multiple hosts attached to a SAN
filesystem. Does the locking work at all across hosts, and if it does,
Hi.
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.
Anyone know how it could be done using regular
expressions natively? I read the doc but it didn't
help me much.
Many thanks.
MP
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
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 =
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 index.
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
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
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 /var/run
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
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
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
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
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
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.
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
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: pgsql-general@postgresql.org
Sent: Wednesday, September 07, 2005 9:41 AM
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}$
Markus but i
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).
-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 =
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!
-
Xlogwill bethe 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,
Doesit make any sense to change the pg_xlog position if
Randal L. Schwartz wrote:
Absolutely not. It rejects fred[EMAIL PROTECTED] 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
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
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
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
--
What
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 on
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 point is
# [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
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
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
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
On Wed, Sep 07, 2005 at 12:21:45 -0700,
Steve Atkins [EMAIL PROTECTED] wrote:
/[EMAIL PROTECTED]@(?:[EMAIL
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 of syntax
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.
If
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
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 stuff in
Klint Gore schrieb:
On Mon, 05 Sep 2005 21:59:33 +0100, Richard Huxton dev@archonet.com 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, but I
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 deliverable and in
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 that is
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
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
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
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 = old,
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
45 matches
Mail list logo