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
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
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
On Wed, Sep 07, 2005 at 00:19:19 -0400,
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.
> postmaster.pid is specifically a lock on the directory, and moving it
>
On 9/6/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
On Tue, Sep 06, 2005 at 06:34:44AM -0500, Ben Grimm wrote:> Hi Alvaro,>> Is there any chance of backporting the integrated version to 8.0? We have> about 50,000 tables and the autovacuum daemon churns at 100% cpu for long
> stretches... any impro
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
>> Maybe it would be better to keep this in PGDATA (or even a duplicate
>> copy). Holding a write lock on the file should also help ensure that you
>> can tell if it's stale or not.
> And the end user can do
[EMAIL PROTECTED] (Roman Neuhauser) writes:
> # [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500:
>> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote:
>> > chiranjeevi.i wrote:
>> > > Hi Team Members,
>> > >
>> > > Is it possible to write jobs in postgresql & if possible how
>> > > s
On Tue, Sep 06, 2005 at 17:01:41 -0500,
"Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
>
> Maybe it would be better to keep this in PGDATA (or even a duplicate
> copy). Holding a write lock on the file should also help ensure that you
> can tell if it's stale or not.
And the end user can do that if
On Tue, Sep 06, 2005 at 06:34:44AM -0500, Ben Grimm wrote:
> Hi Alvaro,
>
> Is there any chance of backporting the integrated version to 8.0? We have
> about 50,000 tables and the autovacuum daemon churns at 100% cpu for long
> stretches... any improvement over that would be welcome.
Nope, abo
On Tue, Sep 06, 2005 at 04:25:38PM -0700, Ben wrote:
> So I'm looking for "lock in exclusive mode"?
What version of PostgreSQL are you using? In 8.0 and later a
PL/pgSQL function could trap a unique constraint violation and issue
a SELECT query instead. If that sounds ugly then I'd say locking
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) 1 G
Right, I understand the badness of the situation, but unfortunately the
keys are externally generated and I have no control over them.
So I'm looking for "lock in exclusive mode"?
Tom Lane wrote:
Pretty much the only thing you can do about that is to take an exclusive
table-level lock. This
Ben <[EMAIL PROTECTED]> writes:
> Doesn't select ... for update only lock the rows returned in the select?
Right.
> In my case, I'm worried about situations when no rows will be returned
> and two separate transactions will try to insert the same key.
Pretty much the only thing you can do abou
Doesn't select ... for update only lock the rows returned in the select?
In my case, I'm worried about situations when no rows will be returned
and two separate transactions will try to insert the same key.
Joshua D. Drake wrote:
Ben wrote:
I'm not very familiar with explicitly locking thing
On Tue, Sep 06, 2005 at 04:29:31PM -0500, Guy Rouillier wrote:
> Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500:
> >> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote:
> >>> chiranjeevi.i wrote:
> Hi Team Members,
>
> Is it possible to wr
Kevin Barnard <[EMAIL PROTECTED]> writes:
> FATAL: terminating connection due to administrator command
> CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."client" x WHERE
> "division" = $1 FOR UPDATE OF x"
> That's what happens when I kill the SQL that was locking everything. The
> only prob
On Tue, Sep 06, 2005 at 02:58:52PM -0500, Bruno Wolff III wrote:
> On Tue, Sep 06, 2005 at 13:47:42 -0500,
> "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> > On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote:
> > > On Mon, Sep 05, 2005 at 12:20:24 +0300,
> > > Peter Nixon <[EMAIL PRO
=?ISO-8859-1?Q?J=FCrgen_Rose?= <[EMAIL PROTECTED]> writes:
> enough of ranting, but I'm totally frustrated
So are we, because you haven't provided nearly enough detail to let
anyone help you. A complete test case would be good, for instance.
regards, tom lane
---
Ben wrote:
I'm not very familiar with explicitly locking things in SQL, so this may
be a dumb question, but.
I've got a stored proc that takes a text key and returns an ID. If the
key isn't in a lookup table, it adds it and will return the
auto-generated serial number. If it's already the
On 9/6/05, Jürgen Rose <[EMAIL PROTECTED]> wrote:
> I did some serious stuff with SQLServer and Interbase, and I had
> **never** those performance problems.
>
On a laptop? Under VMWare?
I have used MSSQL Server too, and find PostgreSQL to compare favorably
in most cases. You may have found
I've just upgraded a 7.4 install to 8.0.3 and we've suddenly run into
lock issues that were not present in 7.4. I'm look for help on
this matter, because I'm a little confused. Downgrading is really
not an option at this point, we really really need the 8.0
features on the DB and a dump/restore
Roman Neuhauser wrote:
> # [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500:
>> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote:
>>> chiranjeevi.i wrote:
Hi Team Members,
Is it possible to write jobs in postgresql & if possible how
should I write .please help me.
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) 1 GB Ram, but there
within VMWARE with 512MB assigned RAM. But the ta
I'm not very familiar with explicitly locking things in SQL, so this may
be a dumb question, but.
I've got a stored proc that takes a text key and returns an ID. If the
key isn't in a lookup table, it adds it and will return the
auto-generated serial number. If it's already there, it simpl
# [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500:
> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote:
> > chiranjeevi.i wrote:
> > > Hi Team Members,
> > >
> > > Is it possible to write jobs in postgresql & if possible how
> > > should I write .please help me.
> >
> > See pgjob i
Vlad <[EMAIL PROTECTED]> writes:
> Though question is - doesn't it seem logical to be able to use full
> table names in FOR UPDATE part like I can use them in WHERE part (if I
> don't need/want to use an alias)? Is it something postgresql speciffic
> or it's SQL standard (pardon my ignorance)?
The
Tom,
yes, this part is not well documented - specially double checked
before sendin email to the list.
Though question is - doesn't it seem logical to be able to use full
table names in FOR UPDATE part like I can use them in WHERE part (if I
don't need/want to use an alias)? Is it something postg
Keary Suska <[EMAIL PROTECTED]> writes:
> on 9/5/05 6:51 PM, [EMAIL PROTECTED] purportedly said:
>> In any case, AFAICS this would only be an issue if you do
>> "su postgres -c postmaster" rather than "su -l postgres -c postmaster"
>> and the former is to be avoided for many reasons besides this on
Vlad <[EMAIL PROTECTED]> writes:
> yes, we actually use table alias as a workaround, I thought that it's
> actually looks like error in postgresql parser (or deeper) that needs
> to be reported.
No, it's supposed to be that way: FOR UPDATE items are table aliases.
Perhaps this isn't adequately doc
On Tue, Sep 06, 2005 at 13:47:42 -0500,
"Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote:
> > On Mon, Sep 05, 2005 at 12:20:24 +0300,
> > Peter Nixon <[EMAIL PROTECTED]> wrote:
> > > Hi List
> > >
> > > Does anyone have any comments, H
On Tue, Sep 06, 2005 at 01:47:42PM -0500, Jim C. Nasby wrote:
> On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote:
> > On Mon, Sep 05, 2005 at 12:20:24 +0300,
> > Peter Nixon <[EMAIL PROTECTED]> wrote:
> > > Hi List
> > >
> > > Does anyone have any comments, HOWTOs and experience r
10GB of RAM isn't that farfetched nowadays.
However I/O might be a problem. A single drive can typically write/read
about 10MB a second (64KB chunks random access - not sure if you'd want
to bet on getting sequential throughput ;) ).
Anyway, it'll be something interesting to see ;).
Link.
I have XML support in PostgreSQL in my Todo
http://www.sai.msu.su/~megera/oddmuse/index.cgi/todo
Hopefully, we'll have something for 8.2
Oleg
On Tue, 6 Sep 2005, Doug Bloebaum wrote:
On 9/6/05, Andrey Fomichev <[EMAIL PROTECTED]> wrote:
- Are there any of you who need to store and que
For those who were debating the GUID issue on here a while back, I
thought I'd point out:
http://www.ietf.org/rfc/rfc4122.txt
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Mon, Sep 05, 2005 at 05:17:41PM -0400, Daniel Morgan wrote:
> Richard Huxton wrote:
>
> >Daniel Morgan wrote:
> >
> >>Does PostgreSQL provide a way to step-debug into plpgSQL stored
> >>procedures?
> >
> It is a shame. PostgreSQL is really rocking these days. Especially
> with 8.0 on Window
On 9/6/05, Andrey Fomichev <[EMAIL PROTECTED]> wrote:
- Are there any of you who need to store and query XML data?- Do you already use PostgreSQL to store XML data or you are
just thinking about it?
The project I'm currently working on uses XML for both data extraction
from Postgres and as a mean
on 9/5/05 6:51 PM, [EMAIL PROTECTED] purportedly said:
>> FYI, it appears that you cannot start the postmaster when your current
>> working directory is not accessible by the postgres user:
>
> Is there a good reason that this case should work? I don't think it's
> very easy to fix given that we
On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote:
> On Mon, Sep 05, 2005 at 12:20:24 +0300,
> Peter Nixon <[EMAIL PROTECTED]> wrote:
> > Hi List
> >
> > Does anyone have any comments, HOWTOs and experience running multiple
> > Postgres servers with a shared disk (SAN) in a Hot sta
On Tue, Sep 06, 2005 at 08:55:26AM -0600, Cristian Prieto wrote:
> Thanks a lot!
>
> Well, I just want to avoid a begin...exception when... end block in
> plpgsql, just do it in a few lines of code without a sp...
SAVEPOINT foo;
INSERT ... ;
if it fails
ROLLBACK TO foo;
else
RELEASE foo
Thi
On Tue, 2005-09-06 at 13:45 -0400, Vlad wrote:
> SELECT * FROM one.aa, two.bb WHERE one.aa.a = two.bb.b FOR UPDATE OF
> one.aa;
>
> ERROR: syntax error at or near "." at character 73 (points to the
> last instance of "one.aa" in SQL query
Try using a table alias, and reference that alias in the
Michal,
tsearch2 doesn't supports UTF-8. It might works though.
full support of UTF-8 and other features are planned
http://www.sai.msu.su/~megera/oddmuse/index.cgi/todo
Oleg
On Tue, 6 Sep 2005, Michal Hlavac wrote:
hello,
I have suse 9.3 with installed postgresql 8.0.3 from rpm.
All
yes, we actually use table alias as a workaround, I thought that it's
actually looks like error in postgresql parser (or deeper) that needs
to be reported.
thanks.
On 9/6/05, Matt Miller <[EMAIL PROTECTED]> wrote:
> On Tue, 2005-09-06 at 13:45 -0400, Vlad wrote:
> > SELECT * FROM one.aa, two.bb W
Oleg Bartunov wrote:
> Michal,
>
> tsearch2 doesn't supports UTF-8. It might works though.
> full support of UTF-8 and other features are planned
> http://www.sai.msu.su/~megera/oddmuse/index.cgi/todo
hello Oleg,
thanks for reply... is there any time plan for new release of tsearch2?
miso
CREATE SCHEMA one;
CREATE TABLE one.aa ( a INT );
CREATE SCHEMA two;
CREATE TABLE two.bb ( b INT );
SELECT * FROM one.aa, two.bb WHERE one.aa.a = two.bb.b FOR UPDATE OF one.aa;
ERROR: syntax error at or near "." at character 73 (points to the
last instance of "one.aa" in SQL query)
p.s. in our a
At 09:45 PM 9/5/2005 +0100, Richard Huxton wrote:
Poul Møller Hansen wrote:
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I think you're being horribly optimistic if you actu
hello,
I have suse 9.3 with installed postgresql 8.0.3 from rpm.
All my databases are unicode with locale sk_SK.UTF-8.
I installed slovak ispell dictionary and tsearch2 is working very well.
m13=# SELECT lexize('sk_ispell','Ivana');
lexize
--
{ivana,ivan}
(1 row)
On the other s
Frank Kardel <[EMAIL PROTECTED]> writes:
> As we need to recover from failed statements on statement level we
> encapsulate
> our statements with SAVEPOINT/RELEASE savepoint statements.
How are you doing that exactly? The style
begin;
savepoint x;
...
On Mon, Sep 05, 2005 at 12:20:24 +0300,
Peter Nixon <[EMAIL PROTECTED]> wrote:
> Hi List
>
> Does anyone have any comments, HOWTOs and experience running multiple
> Postgres servers with a shared disk (SAN) in a Hot standby configuration?
>
> Can someone please point me in the direction of any
Thanks a lot!
Well, I just want to avoid a begin...exception when... end block in plpgsql,
just do it in a few lines of code without a sp...
Thanks a lot again!
- Original Message -
From: "Thomas F. O'Connell" <[EMAIL PROTECTED]>
To: "Alvaro Herrera" <[EMAIL PROTECTED]>
Cc: "Cristia
Hello!
I would like to raise a discussion about XML support in PostgreSQL.
I'm a person who is quite experienced in XML data management and new
to PostgreSQL. So, excuse me if I ask trivial questions about
PostgreSQL...
I tried to find something about support for XML in PostrgreSQL. As far
as I u
am 06.09.2005, um 20:13:57 +1000 mailte Peter Cook folgendes:
> My installation has stalled with the following message:
> "User 'postgres' could not be created. The user account already exists!"
Which OS?
Maybe it is useful to delete this account first.
Regards, Andreas
--
Andreas Kretschmer
My installation has
stalled with the following message:"User 'postgres' could not be created.
The user account already exists!"
Initially I had
problems providing a suitable domain name and password. So, I have made several
attempts at installation.
How do I now proceed
to install succ
Hi *,
for our project we use big transactions for application coordination.
As we need to recover from failed statements on statement level we
encapsulate
our statements with SAVEPOINT/RELEASE savepoint statements.
So far this seems to be the only way to recover from failed statements
and to
keep
Look into inheritance. It makes this easier. However, I don't care
which RDBMS you use, management of 1000 identical tables is going to
be a real pain and I think that everyone here will probably suggest
that it is not exactly a sane thing to do.
Thank you, Chris. I have omitted two import
Hi Alvaro,
Is there any chance of backporting the integrated version to 8.0?
We have about 50,000 tables and the autovacuum daemon churns at 100%
cpu for long stretches... any improvement over that would be welcome.
Thanks,
Ben
On 7/29/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
On Fri, Jul
ok, thanks
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 05, 2005 6:15 PM
Subject: Re: [GENERAL] remote connection, web hosting, IP adress
am 05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
How can I connect to remote serve
56 matches
Mail list logo
