OK. I'll suggest people to try new tsearch2 in README file of old
tsearch.
Oleg
On Tue, 22 Jul 2003, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > We don't normally issue new features in minor releases, but for a
> > /contrib, we could consider it.
>
> I can't see sticki
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 23:43, Oleg Bartunov wrote:
> On Mon, 21 Jul 2003, Andreas Joseph Krogh wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Monday 21 July 2003 22:46, Bruce Momjian wrote:
> > > We don't normally issue new fea
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes:
> There is one nifty detail which seems VERY strange to me: If
> serializable mode is set in postgresql.conf the system was 3 times
> faster (~ 7.5 sec. vs. 2.5sec). If serializable mode was set for every
> transaction (using s
Hello Bruce,
Monday, July 21, 2003, 9:37:08 PM, you wrote:
BM> Marcus B?rger wrote:
>> BM> Marcus, would you check if PHP is using RESET ALL when passing
>> BM> persistent connection to new clients? We added that capability a few
>> BM> releases ago, specifically for PHP persistent connections,
Hello Bruce,
Monday, July 21, 2003, 9:15:05 PM, you wrote:
BM> Glad you got in touch with the right guys. Joe and Jan have both talked
BM> about doing PlPHP for a while.
:-)
BM> Marcus, would you check if PHP is using RESET ALL when passing
BM> persistent connection to new clients? We added
Bruce Momjian wrote:
Hans, I am a little confused about what you are suggesting. Are you
suggesting flag to the make of the contrib module rather than configure
tests?
I agree this is a killer feature for many people and would like to have
it in 7.4.
Under these circumstances I was thinking of i
On Mon, 21 Jul 2003, [ISO-8859-1] Hans-Jürgen Schönig wrote:
> > Why was SERIALIZABLE faster? I know SERIALIZABLE doesn't have the
> > rollback penalty in read-only queries, but I don't understand why it
> > would be faster.
> >
>
>
> To be honest I don't have the slightest idea. Maybe it has
I think for that very reason (SQL-MED) we need to come to terms with
this issue. If/when connections to external data sources is in the
backend, you'll have those exact same dependencies. And in fact, we do
today: consider '--with-openssl' or '--with-tcl'.
I had always assumed we would need '--
Bruce Momjian wrote:
Hans-J?rgen Sch?nig wrote:
This week I have done some performance tuning at a customer's office. We
have beaten (demoralized) MS SQL and DB2 in serializable mode and DB2 in
any transaction isolation level :).
By the way: In case of very simple statements SERIALIZABLE is abo
Bruce Momjian <[EMAIL PROTECTED]> writes:
> We don't normally issue new features in minor releases, but for a
> /contrib, we could consider it.
I can't see sticking code that hasn't been through any public beta
testing into 7.3.4. Not even as contrib material --- how embarrassed
would you be if t
Edin Kadribasic wrote:
Help on the PHP side of things would be most appreciated, because that's
the part I'm least familiar with.
SAPI/Embed in PHP is very experimental which means that it can be molded to
suit PL/PHP needs. To my knowlege its only used as a plugin for irssi (irc
client which you
Hi guys,
Wasn't sure if this is a valid idea, but Bruce's response made me think it was worth forwarding here to see if anyone had/has considered it before.
As everyone is aware, I'm not up for coding it, but am mentioning it Just In Case it's deemed worthy of adding to the TODO list in case some
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > The following patch automatically enables 64-bit mode on AMD opteron.
> > We already had spinlock support for it, but I added some comments.
>
> This sort of thing belongs into the template file, not directly in
> configure.in.
I knew you wer
Jan Wieck wrote:
> Bruce Momjian wrote:
> > Marcus B?rger wrote:
> >> BM> Marcus, would you check if PHP is using RESET ALL when passing
> >> BM> persistent connection to new clients? We added that capability a few
> >> BM> releases ago, specifically for PHP persistent connections, but I don't
> >
Bruce Momjian wrote:
Marcus B?rger wrote:
BM> Marcus, would you check if PHP is using RESET ALL when passing
BM> persistent connection to new clients? We added that capability a few
BM> releases ago, specifically for PHP persistent connections, but I don't
BM> think that ever got into the PHP code
Rod Taylor wrote:
-- Start of PGP signed section.
> On Fri, 2003-07-18 at 19:46, Paulo Scardine wrote:
> > My boss is asking for something like Oracle's "SELECT FOR UPDATE NOWAIT".
> >
> > Is there any such feature? If no, should I look forward into implementing
> > this? Any advice?
>
> Lookup S
Added to TODO:
o Allow PL/pgSQL to name columns by ordinal position, e.g. rec.(3)
---
Josh Berkus wrote:
> Developers,
>
> While I realize that we already have a number of TODOs on the list for
> PL/pgSQL which n
Added to TODO:
* Prevent COMMENT ON DATABASE from using a database name
---
Rod Taylor wrote:
-- Start of PGP signed section.
> > For COMMENT ON DATABASE where database name is unknown or not the current
> >
> Help on the PHP side of things would be most appreciated, because that's
> the part I'm least familiar with.
SAPI/Embed in PHP is very experimental which means that it can be molded to
suit PL/PHP needs. To my knowlege its only used as a plugin for irssi (irc
client which you can script using PH
[EMAIL PROTECTED] wrote:
>
> > - allows us to say that PostgreSQL ships with field-tested
> > replication in the source tree
>
>
> We have a winner! I think this one trumps all the rest.
Can we say field-tested and Java in the same sentence?
--
Bruce Momjian| http
File IO, now that's something I would like to see. I will need that "REAL SOON NOW".
RIck
Bruce Momjian wrote:
> I haven't seen those myself.
>
> ---
>
> ivan wrote:
> >
> > functions to open,read,write etc files
> >
> > On
On Mon, 21 Jul 2003, Andreas Joseph Krogh wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Monday 21 July 2003 22:46, Bruce Momjian wrote:
> > We don't normally issue new features in minor releases, but for a
> > /contrib, we could consider it.
> >
> > --
I haven't seen those myself.
---
ivan wrote:
>
> functions to open,read,write etc files
>
> On Mon, 21 Jul 2003, Bruce Momjian wrote:
>
> >
> > What functions are they?
> >
> >
functions to open,read,write etc files
On Mon, 21 Jul 2003, Bruce Momjian wrote:
>
> What functions are they?
>
> ---
>
> ivan wrote:
> >
> > someone looked at my files function ??
> >
> >
> >
> > ---
Tom Lane wrote:
> Joe Conway <[EMAIL PROTECTED]> writes:
> > I was looking through elog.h and noticed this at about line 36:
> > #define ERROR 20 /* user error - abort transaction; return
> > * to known state */
> > #define ERROR 20 /* user error - abort t
Marcus B?rger wrote:
> Hello Bruce,
>
> Monday, July 21, 2003, 9:37:08 PM, you wrote:
>
> BM> Marcus B?rger wrote:
> >> BM> Marcus, would you check if PHP is using RESET ALL when passing
> >> BM> persistent connection to new clients? We added that capability a few
> >> BM> releases ago, specific
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 22:46, Bruce Momjian wrote:
> We don't normally issue new features in minor releases, but for a
> /contrib, we could consider it.
>
> ---
>
> Oleg Bartunov w
Is this a TODO?
---
Tom Lane wrote:
> [ reply redirected to a more appropriate list ]
>
> Dmitry Tkach <[EMAIL PROTECTED]> writes:
> > I am not sure if this is really a bug, but it certainly looks like one
> > to me...
>
We don't normally issue new features in minor releases, but for a
/contrib, we could consider it.
---
Oleg Bartunov wrote:
> Hi there,
>
> seems we'll have 7.3.4 release. Is't worth to submit new tsearch2
> module for this
Hi there,
seems we'll have 7.3.4 release. Is't worth to submit new tsearch2
module for this release ? People could play with new module
without waiting 7.4 release.
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, h
What functions are they?
---
ivan wrote:
>
> someone looked at my files function ??
>
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map s
Marcus B?rger wrote:
> BM> Marcus, would you check if PHP is using RESET ALL when passing
> BM> persistent connection to new clients? We added that capability a few
> BM> releases ago, specifically for PHP persistent connections, but I don't
> BM> think that ever got into the PHP code.
>
> Unfort
Control-C works here. What platform are you on? Can you reproduce it?
I just tried:
psql -c 'select * from pg_class, pg_proc' test
and control-C terminated the query.
---
Kenji Sugita wrote:
> Vacuumdb command c
Sorry, my testing was on CVS version of PostgreSQL.
---
Kenji Sugita wrote:
> Vacuumdb command can't be canceled by Control-C and VACUUM is still running.
> When wrong database name is specified to vacuumdb, cancellation is
Glad you got in touch with the right guys. Joe and Jan have both talked
about doing PlPHP for a while.
Marcus, would you check if PHP is using RESET ALL when passing
persistent connection to new clients? We added that capability a few
releases ago, specifically for PHP persistent connections, b
Added to TODO:
o Add PL/PHP (Joe, Jan)
---
Joe Conway wrote:
> Jan Wieck wrote:
> > I had been briefly talking with Marcus Boerger (included in CC) from the
> > PHP team about it. He knows the PHP5 SAPI embed well
Added to TODO:
* Have AFTER triggers execute after the appropriate SQL statement in a
function, not at the end of the function
---
Philip Warner wrote:
> At 11:51 PM 1/06/2003 -0400, Bruce Momjian wrote:
> >Does anyone h
Here is someone looking for dblink with Oracle capability. It is not in
CVS yet, but we are trying to get it for 7.4. You might be able to run
/contrib/dblink from CVS in a few weeks without waiting for a 7.4 release.
---
Hans, I am a little confused about what you are suggesting. Are you
suggesting flag to the make of the contrib module rather than configure
tests?
I agree this is a killer feature for many people and would like to have
it in 7.4.
-
Is there a TODO here?
---
Peter Eisentraut wrote:
> On Mon, 14 Jul 2003, Tom Lane wrote:
>
> > Probably the only real solution is to implement DROP-CASCADE-like
> > checking when a privilege is revoked. Seems like rather a
On 7/21/2003 9:16 AM, Tom Lane wrote:
>Bruce Momjian <[EMAIL PROTECTED]> writes:
>
>
>>I don't see the problem.
>>
>>
>
>I tend to agree with Peter: if dblink is going to start depending on
>stuff outside Postgres, it ought to be become a separate project,
>if only to simplify distribution a
Joe Conway wrote:
> > PS: Has anyone looked any further at the SQL-MED standard? ISTM that's
> > where we ought to head in the long run.
>
> I think for that very reason (SQL-MED) we need to come to terms with
> this issue. If/when connections to external data sources is in the
> backend, you'l
Joe Conway writes:
> I think for that very reason (SQL-MED) we need to come to terms with
> this issue. If/when connections to external data sources is in the
> backend, you'll have those exact same dependencies.
No, SQL-MED is a framework to plug in different connectors -- exactly what
some are
Tom Lane wrote:
I tend to agree with Peter: if dblink is going to start depending on
stuff outside Postgres, it ought to be become a separate project,
if only to simplify distribution and configuration issues.
Perhaps it could be split into two parts, a PG-specific part and
a cross-DBMS part?
re
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I don't see the problem.
I tend to agree with Peter: if dblink is going to start depending on
stuff outside Postgres, it ought to be become a separate project,
if only to simplify distribution and configuration issues.
Perhaps it could be split into two
On Mon, Jul 21, 2003 at 10:11:38AM -0300, The Hermit Hacker wrote:
>
> check it now, should be fine ...
Works now, thanks.
Kurt
---(end of broadcast)---
TIP 8: explain analyze is your friend
Rod Taylor wrote:
-- Start of PGP signed section.
> > I don't see the problem.
>
> How about a (simple!) configure process in the dblink directory only
> which detects the various items.
I thought of that but configure seems so confusing that setting up
another on in a contrib directory seemed pr
Teodor Sigaev <[EMAIL PROTECTED]> writes:
> Mark, you don't set right umask for me, IMHO.
There seems to be more to it than that: I can do "cvs update" just fine
from the master server. So I'd guess that the issue is not with your
own permissions, but with what happens when a new directory is
pro
> I don't see the problem.
How about a (simple!) configure process in the dblink directory only
which detects the various items.
signature.asc
Description: This is a digitally signed message part
Of course, PostgreSQL will still install without the Oracle libraries.
Of course, if you want dblink to use Oracle libraries, you have to
install the Oracle libraries first, or rerun configure after you install
them and reinstall dblink.
I don't see the problem.
---
check it now, should be fine ...
On Mon, 21 Jul 2003, Kurt Roeckx wrote:
> When doing cvs update I get:
>
> cvs server: Updating contrib/tsearch2
> cvs server: failed to create lock directory for
> `/projects/cvsroot/pgsql-server/contrib/tsearch2'
> (/projects/cvsroot/pgsql-server/contrib/tsearc
Mark, you don't set right umask for me, IMHO.
Kurt Roeckx wrote:
When doing cvs update I get:
cvs server: Updating contrib/tsearch2
cvs server: failed to create lock directory for
`/projects/cvsroot/pgsql-server/contrib/tsearch2'
(/projects/cvsroot/pgsql-server/contrib/tsearch2/#cvs.lock):
Permis
When doing cvs update I get:
cvs server: Updating contrib/tsearch2
cvs server: failed to create lock directory for
`/projects/cvsroot/pgsql-server/contrib/tsearch2'
(/projects/cvsroot/pgsql-server/contrib/tsearch2/#cvs.lock):
Permission denied
cvs server: failed to obtain dir lock in repository
`/
Sean Chittenden wrote:
> To prevent lib naming collisions with machines that have libevent
> installed, I plan on renaming all of the functions from event_* to
> pgevent_*. libevent also has the appropriate autoconf goo to make
> detection of the right library pretty seamless. It even supports th
Bruce Momjian writes:
> Joe, I can do the configure detection of the Oracle library needed for
> /contrib.
I have a philosophical problem with putting Oracle detection code into the
PostgreSQL build system. That way, you create a dependency that Oracle
needs to be installed before you install Po
Bruce Momjian writes:
> The following patch automatically enables 64-bit mode on AMD opteron.
> We already had spinlock support for it, but I added some comments.
This sort of thing belongs into the template file, not directly in
configure.in.
--
Peter Eisentraut [EMAIL PROTECTED]
--
56 matches
Mail list logo