am Tue, dem 30.01.2007, um 8:47:48 +0100 mailte Peter Eisentraut folgendes:
> Karen Hill wrote:
> > I was just looking at all the upcoming features scheduled to make it
> > into 8.3, and with all those goodies, wouldn't it make sense for this
> > to be a 9.0 release instead of an 8.3?
>
> If eve
Karen Hill wrote:
> I was just looking at all the upcoming features scheduled to make it
> into 8.3, and with all those goodies, wouldn't it make sense for this
> to be a 9.0 release instead of an 8.3?
If every release got all the features "scheduled" for it, we'd be at
version 37.0 now. At this
Furface wrote:
2. Restricting certain tables to certain users. Well that's easy. You
just use the "grant" command.
3. Restricting certain columns of certain tables to certain users. This
would be something like an "approved" or "active" column where only
administrators can set these value
On 29 Jan 2007 13:25:31 -0800, Karen Hill <[EMAIL PROTECTED]> wrote:
I was just looking at all the upcoming features scheduled to make it
into 8.3, and with all those goodies, wouldn't it make sense for this
to be a 9.0 release instead of an 8.3? It looks like postgresql is
rapidly catching up t
Hi,
you can find a nice virtual folder implementation in the Opera-Mailclient M2.
Not sure if this also works with IMAP (don't use IMAP yet).
Virtual folders are based on regexes over various fields of a
mail(Subject,From,to,Body,etc.).
Of course this is not db-based, but the feature is neat.
J
am Sat, dem 27.01.2007, um 17:57:06 -0800 mailte Timasmith folgendes:
> Hi,
>
> What query can I run to get the comments for my table columns.
>
> i.e. the ones on my 8.1 database added with this command:
>
> COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the
> addresses tabl
On Mon, Jan 29, 2007 at 12:52:33PM -0500, Michael Artz wrote:
> On 1/27/07, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> >SELECT decode(lower(textin(byteaout(bytes))), 'escape') FROM mytable;
>
> That seems to work correctly, however I missed the functions textin'
> and 'byteaout' in the docs ... are
> Err... I do not understand "copy an email in 1 folder" - I use
IMAP which stores all the mail on the server.
(That is what dbmail does too)
In the traditional imap server the mail is stored in folders on the server that are accessed by the
client. Therefore you are limited to one indexed lo
Korry Douglas has an EDB sponsored project called pg_migrator on
pgfoundry. I believe it works for upgrading from 8.1 to 8.2 except
for tables that use the ip address datatype. It works by just
replacing the 8.1 system catalogs with the 8.2 system catalogs. I
believe the on-disk images for 8.1
On Mon, Jan 29, 2007 at 15:51:54 -0800,
Rich Shepard <[EMAIL PROTECTED]> wrote:
> On Tue, 30 Jan 2007, Michael Glaesemann wrote:
>
> >It was *discussed*. 8.1 to 8.2 (as does any move from M.x to M.y where x
> >y) requires a dump and reload.
>
> Michael,
>
> That's what I thought. However,
Sim Zacks <[EMAIL PROTECTED]> wrote:
> DBMail is an interesting concept, but I think the real advantage would
> be if there were a client that could take advantage of the power of a
> database backend.
>
> For example, instead of saving a copy of an email in 1 folder, the
> same email could be inde
Ron Peterson <[EMAIL PROTECTED]> writes:
> Anyone have any tips for an earnest aspiring but somewhat befuddled
> PostgreSQL acolyte as to what's required to program (in C) a 'like'
> operator for a user defined type?
Well, you could look at the existing code which is in
src/backend/utils/a
Tom Lane wrote:
Since the tables you need to touch are all shared, it's conceivable
that
this could be hacked around, but it seems awfully messy. Another
consideration is that this'd significantly increase the amount of work
done before validating that the connection request is authorized,
Anyone have any tips for an earnest aspiring but somewhat befuddled
PostgreSQL acolyte as to what's required to program (in C) a 'like'
operator for a user defined type?
--
Ron Peterson
https://www.yellowbank.com/
---(end of broadcast)---
TIP 2: Do
Doesn't pg_hba.conf just deal with user connections? If you denied via
pg_hba.conf, wouldn't you also deny access for the application? Can
pg_hba.conf authenticate based on a per application basis? I wasn't
aware of anything like that. I'm not an expert on this, so I could be
wrong.
This
"John D. Burger" <[EMAIL PROTECTED]> writes:
> Someone talked about the postmaster having to be "at arms' length"
> from the actual tables. But I was looking at the postmaster code,
> and it seems to fork a new backend as soon as select indicates
> there's a new request, without checking aut
Joris Dobbelsteen wrote:
Personally I've found nothing that will beat Excel for doing data
analysis. Learn to use the pivot table and pivot charts. They are
extremely powerful.
Funny, there is an on-going discussion about this on one of our
internal mailing lists. Excel is perhaps okay for
"Angva" <[EMAIL PROTECTED]> writes:
> Our company's application runs searches with "like" where clauses, for
> example: "where id like '38F20A%'". This query once ran in under 10 ms,
> but since upgrading from 8.1.3 to 8.2.0, it now takes about 500 ms to
> run. The problem appears to be that the pl
I had some ideas about this slow flat file issue, but it's apparently
not yet much of an issue, in fact ...
Someone talked about the postmaster having to be "at arms' length"
from the actual tables. But I was looking at the postmaster code,
and it seems to fork a new backend as soon as sel
On Tue, 30 Jan 2007, Michael Glaesemann wrote:
Or check the release notes :)
Oooh! What a novel idea. :-)
I don't have the time -- or the need right now -- to upgrade so it's on
the back burner.
Thanks, Michael,
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Per
Andrus wrote:
My application implements field and row level security.
I have custom table of users where user privileges are described.
However user can login directly to database using pgAdmin. This bypasses
the security.
How to allow users to login only from my application ?
I think I must c
Hi.
I have a strange problem in postgres 8.1.4 (gentoo 64bit on AMD64
platform)
My database is created vith LATIN-2 encoding for correct vieving of
nacional specific characters ( czech language )
inside code of my php application is setting client encoding to win1250
because I need
> You are looking for tablespaces :).
I don't doubt that he is.
... but wouldn't something as simple as RAID 1+0 give much of the same
benefit (being able to distribute the IO load to more disks), but without
the danger of incorrectly placing the table spaces?
---(end o
Hi,
What query can I run to get the comments for my table columns.
i.e. the ones on my 8.1 database added with this command:
COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the
addresses table';
thanks
Tim
---(end of broadcast)---
Thanks for the quick response.
It is PostgreSQL 8.0.6 running on Windows 2003 Server.
I haven't had any other issues with this particular piece of hardware
and it is fairly new and well maintained (not that this matters much).
I am going to try to drop and recreate this table, index, and the
c
Never mind.
I found "vacuum_cost_delay" in the docs, I had it set to 70. I set it
to 0 and watched CPU and I/O% peg to 100%.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
While VACUUMing a large table, why aren't the CPU and/or I/O
percentages pegged?
I kicked off a VACUUM ANALYZE on a database containing a 20 million
row table (~250 bytes/row). It's been running for > 2 hours now, with
%CPU and %I/O rarely exceeding 1% (as reported by top), e.g.:
Tasks: 120
On Jan 30, 2007, at 8:51 , Rich Shepard wrote:
On Tue, 30 Jan 2007, Michael Glaesemann wrote:
It was *discussed*. 8.1 to 8.2 (as does any move from M.x to M.y
where x
y) requires a dump and reload.
Michael,
That's what I thought. However, it never hurts to ask. :-)
Or check the relea
On 26 Gen, 22:44, [EMAIL PROTECTED] ("Joshua D. Drake") wrote:
> Scott Marlowe wrote:
> > On Fri, 2007-01-26 at 15:06, Bill Moran wrote:
> >> In response to BluDes <[EMAIL PROTECTED]>:
>
> >>> Any suggestion?
>
> >> In any event, refuse to ever do any business with him again. In my
> >> experien
Hi Martin,
I have got same problem as mentioned by you. As per your comment it
seems this problem is due to memory leak. Could you explain the exact
reason of this problem. How it is related to mem-leak.
Regards & Thanks
-Shalendra
On Jan 15, 3:51 pm, [EMAIL PROTECTED] (Steve Martin) wrote:
>
My application implements field and row level security.
I have custom table of users where user privileges are described.
However user can login directly to database using pgAdmin. This bypasses
the security.
How to allow users to login only from my application ?
I think I must create server-side
This is how I loop through a record:
for rec in (select * from yourtable where somevar=3) loop
--output the record
raise notice '%', rec.somevar
end loop;
--
Mark
On Jan 25, 2:46 pm, [EMAIL PROTECTED] ("Furesz Peter") wrote:
> Hello,
>
> How can I loop a PL/PgSQL recorset variable? The
Hello,
I have a question regarding Postgres 8.2 and the planner.
Our company's application runs searches with "like" where clauses, for
example: "where id like '38F20A%'". This query once ran in under 10 ms,
but since upgrading from 8.1.3 to 8.2.0, it now takes about 500 ms to
run. The problem ap
If the index exists, you will find it in pg_indexes.
Mark
On Jan 25, 5:29 pm, [EMAIL PROTECTED] wrote:
> Buen Dia.
>
> Por favor si saben como, me gustaria saber como puedo eliminar un indice
> PERO SOLO si este existe. Como valido si existe o no el indice para luego
> eliminarlo ??
>
> Gracias.
On Tue, 30 Jan 2007, Michael Glaesemann wrote:
It was *discussed*. 8.1 to 8.2 (as does any move from M.x to M.y where x
y) requires a dump and reload.
Michael,
That's what I thought. However, it never hurts to ask. :-)
Rich
--
Richard B. Shepard, Ph.D. |The Environment
On Jan 30, 2007, at 8:38 , Rich Shepard wrote:
On Mon, 29 Jan 2007, Bruno Wolff III wrote:
At one point there was discussion about using changes to the first
digit
to indicate that a dump and restore was needed because of an on disk
format change and that changes to the second digit would i
On Mon, 29 Jan 2007, Bruno Wolff III wrote:
At one point there was discussion about using changes to the first digit
to indicate that a dump and restore was needed because of an on disk
format change and that changes to the second digit would indicate that
only catalog entries have changed and t
Dave Page wrote:
>
>
> > --- Original Message ---
> > From: Bruce Momjian <[EMAIL PROTECTED]>
> > To: Dave Page <[EMAIL PROTECTED]>
> > Sent: 29/01/07, 21:12:30
> > Subject: Re: [GENERAL] Predicted lifespan of different PostgreSQLbranches
> >
> > I am pretty amazed people are considering
On 1/29/07, Ray Stell <[EMAIL PROTECTED]> wrote:
That said, probably, lasts gasps from a legacy system. I'm wondering
when ora will open up its code ala sun/solaris.
According to a recent Gartner study, Oracle has 48% market share (in other
words they are the market leader by a margin of 26%
Ray Stell wrote:
> On Mon, Jan 29, 2007 at 01:27:19PM -0800, Karen Hill wrote:
> > there any worry in the community that oracle will begin to target
> > postgres like they're targeting mySQL?
>
> I attended a big ora conference in 2006 and was a bit surprised to
> observe the fact that ora corp k
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am pretty amazed people are considering shortening the release cycle
> > for our most popular platform.
>
> Are you volunteering to back-port and test all the Windows fixes that
> never went into 8.0?
>
> I think we should either d
ZappA <[EMAIL PROTECTED]> writes:
> My PostgreSQL version is 7.4.1, and I performed a Reindex and the problem
> still remains.
You must've reindexed the wrong thing then.
> due to our system configuration, we cannot Upgrade it. (cluster
> environment).
This approach to system management is serio
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am pretty amazed people are considering shortening the release cycle
> for our most popular platform.
Are you volunteering to back-port and test all the Windows fixes that
never went into 8.0?
I think we should either do that, or admit that we're not
Hi again ..
My PostgreSQL version is 7.4.1, and I performed a Reindex and the problem
still remains.
due to our system configuration, we cannot Upgrade it. (cluster
environment).
help is very appreciated.
Thanks
Zappa
On 1/29/07, ZappA <[EMAIL PROTECTED]> wrote:
Thanks ..
My PostgreSQL ve
> --- Original Message ---
> From: Bruce Momjian <[EMAIL PROTECTED]>
> To: Dave Page <[EMAIL PROTECTED]>
> Sent: 29/01/07, 21:12:30
> Subject: Re: [GENERAL] Predicted lifespan of different PostgreSQLbranches
>
> I am pretty amazed people are considering shortening the release cycle
> for
On Mon, Jan 29, 2007 at 01:27:19PM -0800, Karen Hill wrote:
> there any worry in the community that oracle will begin to target
> postgres like they're targeting mySQL?
I attended a big ora conference in 2006 and was a bit surprised to
observe the fact that ora corp keynote addresses did not even
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/29/07 16:05, tom wrote:
> No.
> Postgres does not represent an economic entity that can compete for $$
> with Oracle.
>
> It's also not nearly as popular. And I mean that in a very pop-culture
> way.
> How long did it take Oracle to support Lin
> On Jan 29, 2007, at 4:27 PM, Karen Hill wrote:
>
> >I was just looking at all the upcoming features scheduled to make it
> >into 8.3, and with all those goodies, wouldn't it make sense for this
> >to be a 9.0 release instead of an 8.3? It looks like postgresql is
> >rapidly catching up to oracl
No.
Postgres does not represent an economic entity that can compete for $
$ with Oracle.
It's also not nearly as popular. And I mean that in a very pop-
culture way.
How long did it take Oracle to support Linux? Only when it became
"pop"ular to do so.
Who would they target anyways?
There
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/29/07 13:20, Vivek Khera wrote:
>
> On Jan 27, 2007, at 10:45 AM, Ron Johnson wrote:
>
>> Using slony or "piped pg_dump" requires that you have *double* the
>> amount of disk space. Having a *very large* database and double
>> capacity of SCSI
Brilliant! Thank you!
> In tsearch2, I would like to use the "simple" dictionary along with my
> own list of stopwords.
> [...]
sure, just specify dict_initoption. For example,
test=# update pg_ts_dict set dict_initoption='contrib/english.stop' where
dict_name='simple';
UPDATE 1
test=# selec
I was just looking at all the upcoming features scheduled to make it
into 8.3, and with all those goodies, wouldn't it make sense for this
to be a 9.0 release instead of an 8.3? It looks like postgresql is
rapidly catching up to oracle if 8.3 branch gets every feature
scheduled for it.
About
I was just looking at all the upcoming features scheduled to make it
into 8.3, and with all those goodies, wouldn't it make sense for this
to be a 9.0 release instead of an 8.3? It looks like postgresql is
rapidly catching up to oracle if 8.3 branch gets every feature
scheduled for it.
About
On Mon, 29 Jan 2007, Pierre Thibaudeau wrote:
In tsearch2, I would like to use the "simple" dictionary along with my
own list of stopwords.
In other words, once the text is parsed into tokens, no stemming
whatsoever, but stopwords are removed.
Is there an easy way to produce that result, using
On 29-Jan-07, at 1:06 PM, [EMAIL PROTECTED] wrote:
I was wondering if there is any way to use psql to list tables that
are dependent to a specific table. Instead of going through every
table
in my database and looking for foreign keys, can I somehow get an
entire
list of these dependent ta
In tsearch2, I would like to use the "simple" dictionary along with my
own list of stopwords.
In other words, once the text is parsed into tokens, no stemming
whatsoever, but stopwords are removed.
Is there an easy way to produce that result, using the standard
"simple" dictionary?
Dave Page wrote:
>
>
> > --- Original Message ---
> > From: Peter Eisentraut <[EMAIL PROTECTED]>
> > To: pgsql-general@postgresql.org
> > Sent: 28/01/07, 17:39:00
> > Subject: Re: [GENERAL] Predicted lifespan of different PostgreSQL branches
> >
> > Dave Page wrote:
> > > Also, three jus
Thanks, Tom, for the comment. (Sorry for emailing directly to you:
pressed "send" too quickly!)
Although that raises further questions:
* Is there a text that documents all that is known about the encoding
issues between PostgreSQL and Windows? Surely, this is likely to be a
"fairly" widesprea
[EMAIL PROTECTED] writes:
> I was wondering if there is any way to use psql to list tables that
> are dependent to a specific table. Instead of going through every table
> in my database and looking for foreign keys, can I somehow get an entire
> list of these dependent tables? Any help would b
Thank you Alvaro :)
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/30/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Shoaib Mir wrote:
> While debugging an application, I just wanted to confirm from the list
here:
>
> Suppose I have a long running transaction which has a
John D. Burger wrote:
> Tom Lane wrote:
>
> >>What you describe Tom (flat file), sounds a bit strange to me.
> >>Aren't users
> >>stored in a table? (pg_catalog.pg_authid)
> >
> >Yeah, but the postmaster can't read pg_authid, nor any other table,
> >because it's not logically connected to the da
Hi,
I was wondering if there is any way to use psql to list tables that
are dependent to a specific table. Instead of going through every table
in my database and looking for foreign keys, can I somehow get an entire
list of these dependent tables? Any help would be much appreciated, thanks!
T
> The more I think about it, the more I think a proxy app is necessary.
> It seems like a lot of work just for security issues, but basically most
> web based database apps use this model, with the web application acting
> as a proxy between the database and the client.
This is how I've seen i
Shoaib Mir wrote:
> While debugging an application, I just wanted to confirm from the list here:
>
> Suppose I have a long running transaction which has a few updates and
> inserts running on some specific tables which means it has acquired
> Exclusive locks too during the transaction on specific
While debugging an application, I just wanted to confirm from the list here:
Suppose I have a long running transaction which has a few updates and
inserts running on some specific tables which means it has acquired
Exclusive locks too during the transaction on specific table but if just
before co
"John D. Burger" <[EMAIL PROTECTED]> writes:
> Why doesn't the postmaster read the db files directly, presumably
> using some of the same code the backends do, or is too hard to bypass
> the shared memory layer?
It's not "too hard", it's simply wrong. The copy on disk may be out of
date due t
Tom Lane wrote:
What you describe Tom (flat file), sounds a bit strange to me.
Aren't users
stored in a table? (pg_catalog.pg_authid)
Yeah, but the postmaster can't read pg_authid, nor any other table,
because it's not logically connected to the database. So any change
to pg_authid gets cop
On Jan 27, 2007, at 10:45 AM, Ron Johnson wrote:
Using slony or "piped pg_dump" requires that you have *double* the
amount of disk space. Having a *very large* database and double
capacity of SCSI disks (including storage controllers, shelves, etc,
etc) is expensive, and might not be available
Bill Moran wrote:
> In response to Tom Lane <[EMAIL PROTECTED]>:
>
> > Bill Moran <[EMAIL PROTECTED]> writes:
> > > In response to Tom Lane <[EMAIL PROTECTED]>:
> > >> Yeah, but the postmaster can't read pg_authid, nor any other table,
> > >> because it's not logically connected to the database.
Might I suggest you consider using dbmail as an IMAP server.
This indexing you speak of is exactly what it will do.
But the additional advantage with IMAP is that you can have multiple
clients attached to the same folders (especially useful if shared) or be
able to attach from multiple sources (
In response to Tom Lane <[EMAIL PROTECTED]>:
> Bill Moran <[EMAIL PROTECTED]> writes:
> > In response to Tom Lane <[EMAIL PROTECTED]>:
> >> Yeah, but the postmaster can't read pg_authid, nor any other table,
> >> because it's not logically connected to the database. So any change
> >> to pg_authi
On 1/27/07, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Thu, Jan 25, 2007 at 02:28:38PM -0500, Michael Artz wrote:
> Perhaps my understanding of the 'encode' function is incorrect, but I
> was under the impression that I could do something like:
>
> SELECT lower(encode(bytes, 'escape')) FROM mytab
Sim Zacks schrieb:
DBMail is an interesting concept, but I think the real advantage would
be if there were a client that could take advantage of the power of a
database backend.
For example, instead of saving a copy of an email in 1 folder, the same
email could be indexed to multiple folders.
Hello list,
Has anyone checked out
http://www.archiveopteryx.org/
looks very promising!
Cheers,
Mike
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ZappA <[EMAIL PROTECTED]> writes:
> Well, I have a problem with Postgres 7.4.
7.4.what?
> Jan 29 11:40:59 mw-db2 postgres[31921]: [6-1] PANIC: right sibling's
> left-link doesn't match
You've got a corrupted index --- try REINDEXing that table. And
consider updating to a newer Postgres, if it'
"Pierre Thibaudeau" <[EMAIL PROTECTED]> writes:
> My setup is as follows:
> PostgreSQL 8.2.1 on WindowsXP
> The database has UTF8 encoding.
> SHOW lc_ctype; gives: "French_Canada.1252"
I'm not sure about any Windows-specific issues, but in general it's a
really bad idea to be using lc_collate or l
Hey..
First .. I´m sorry for my english! ..
Well, I have a problem with Postgres 7.4.
It´s very very crazy, this error!...
I have a problem with a command of insert. And this problem is resulting in
a error Panic! . (I will put the error below).
The more problem is that I have two insert equa
On Mon, Jan 29, 2007 at 11:50:35 +0900,
Paul Lambert <[EMAIL PROTECTED]> wrote:
>
> In order to balance disk load and ensure faster data access, my current
> SQL server setup has the data spread across 3 physical disk devices. One
> question I would like to know which I can't find in the docum
Tomas Vondra wrote:
> So far everything seems ok, but let's create another child table
>
[...]
> ==
>
> and do the execution plan again:
>
> ==
>
> EXPLAIN EX
Bill Moran <[EMAIL PROTECTED]> writes:
> In response to Tom Lane <[EMAIL PROTECTED]>:
>> Yeah, but the postmaster can't read pg_authid, nor any other table,
>> because it's not logically connected to the database. So any change
>> to pg_authid gets copied to a "flat" ASCII-text file for the postma
> "Michael" == Michael Fuhr <[EMAIL PROTECTED]> writes:
Michael> Isn't that the situation here? The PL/Perl function body is a
Michael> string encoded in the database's encoding, which in this case is
Michael> UTF-8.
If that's always the case, then the embedded Perl interpreter should
be sta
In response to Tom Lane <[EMAIL PROTECTED]>:
> "Willy-Bas Loos" <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> I think that the
> >> main bottleneck would be the "flat file" that's used to tell the
> >> postmaster about the set of valid users --- every time a user is
> >> added/dropped/chang
On Mon, Jan 29, 2007 at 01:34:47PM +0100, [EMAIL PROTECTED] wrote:
> > If you can't upgrade to 8.2 then you might be able to work around
> > the problem by creating the function as plperlu and adding 'use utf8;'.
>
> As fas as i know 'use utf8;' normally just tells Perl that the source code
> is w
"Willy-Bas Loos" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I think that the
>> main bottleneck would be the "flat file" that's used to tell the
>> postmaster about the set of valid users --- every time a user is
>> added/dropped/changed, that file gets rewritten and then re-parsed
>> by the
In response to Ron Mayer <[EMAIL PROTECTED]>:
> Bill Moran wrote:
> > Does the PostgreSQL project have any similar policy about EoLs?
>
> Is it a question for community support, or for various
> commercial vendor's support policies?
I'm not worried about vendors. If we're relying on vendor suppo
Bill Moran wrote:
> Does the PostgreSQL project have any similar policy about EoLs?
Is it a question for community support, or for various
commercial vendor's support policies?
How long companies selling "postgresql support" support each
release could be one of the more important characteristics
On second thought, you might be referring to pg_hba.conf?
That would not be applicable for a web-service, since all users would
connect through the same IP-adress..
On 1/29/07, Willy-Bas Loos <[EMAIL PROTECTED]> wrote:
Tom Lane wrote:
>I think that the
>main bottleneck would be the "flat file"
> In an 8.1.6 UTF-8 database this example returns false; in 8.2.1 it
> returns true. See the following commit message and the related bug
> report regarding PL/Perl and UTF-8:
>
> http://archives.postgresql.org/pgsql-committers/2006-10/msg00277.php
> http://archives.postgresql.org/pgsql-bugs/2006
Tino Wildenhain wrote:
Sim Zacks schrieb:
Are there any postgresql based email clients that anyone has
experience with?
Well "client" would be the wrong approach imho, but there
is for example dbmail which can use postgres as storage
for mail and opens a lot of the usecases above. You would
c
DBMail is an interesting concept, but I think the real advantage would be if there were a client
that could take advantage of the power of a database backend.
For example, instead of saving a copy of an email in 1 folder, the same email could be indexed to
multiple folders. Current email client
Sim Zacks schrieb:
Are there any postgresql based email clients that anyone has experience
with?
Is there a good technical reason why everyone is not doing this? It
would seem to me to be a super CRM/ERP enhancement.
I am toying with the idea of fully integrating email into our ERP system
so
[EMAIL PROTECTED] wrote:
> If you can't upgrade to 8.2 then you might be able to work around the
> problem by creating the function as plperlu and adding 'use utf8;'.
After upgrading to 8.2.1, everything runs just fine. Thanks a lot for
your help,
Regards,
Philippe Lang
--
Hello,
I've encountered a 'strange' behavior when using partitioning and
prepared statements (or SQL in PL/pgSQL procedures) on 8.1.5. Imagine
you have a table partitioned by an ID (say in 1 milion blocks), thus you
have an empty 'parent' table PARENT and child tables CHILD_0, CHILD_1, ...
==
Furesz Peter wrote:
> FOR v_tmp IN v_tmp_regi LOOP
> --I would like to work here with the old recordset!
> END LOOP;
> ^^
>-- This is not working !!!
How do you expect to loop one record?
In a recent thread (with a remarkably similar questio
Tom Lane wrote:
I think that the
main bottleneck would be the "flat file" that's used to tell the
postmaster about the set of valid users --- every time a user is
added/dropped/changed, that file gets rewritten and then re-parsed
by the postmaster. So you could eat a lot of overhead if you chang
Are there any postgresql based email clients that anyone has experience with?
Is there a good technical reason why everyone is not doing this? It would seem to me to be a super
CRM/ERP enhancement.
I am toying with the idea of fully integrating email into our ERP system so that our email can be
96 matches
Mail list logo
