The Hermit Hacker [EMAIL PROTECTED] writes:
GNUMakefile.in:
opt_files := \
src/tools src/corba src/data src/tutorial \
Ah.
I take it then, that src/data shoudl be removed from there too?
Yep. Sorry I missed it.
regards, tom lane
On Mon, Aug 04, 2003 at 05:03:02PM -0400, Tom Lane wrote:
Julian Satchell [EMAIL PROTECTED] writes:
The implementations of lower and upper in
src/backend/utils/adt/oracle_compat.c use the single byte macros from
ctype.h to alter individual bytes in the text string.
If the text is UTF-8
On Tue, 5 Aug 2003, Bruce Momjian wrote:
Oleg Bartunov wrote:
Bruce, you forgot new contrib/tsearch2 module - full text extension (Oleg,Teodor)
Sorry, added:
New tsearch2 full-text search module (Oleg)
Bruce, I wrote (Oleg,Teodor)
Regards,
Oleg
Joe Conway wrote:
Bruce Momjian wrote:
Here are the changes for 7.4. I am looking for any improvements. This
will be adjusted as we move through beta.
Almost anything with my name on it (but certainly all the array and
polymorphic function stuff) could have Tom's too, since he
Hi there,
I agree with Tom ... even the idea of a TRUNCATE ALL makes me nervous. If
we had such a feature, I'd advocate that it be superuser only.
This superuser only restriction certainly would be sensible.
As for TRUNCATE CASCADE or similar improvements, I agree that they
could be
'K ... I just re-tag'd REL7_4_BETA1 for the changes that were made
(including Bruce's last minute copyright changes) ...
Also, I just modified the script so that it builds both a .gz and a .bz2
version of hte archives ...
Please test and let me know if there are any problems ...
Marc G.
Larry Rosenman writes:
What the fr*** harm is it in passing -D_REENTRANT into the libpq build on
UnixWare
irregardless of the --with-threads* flag?
Indeed for every other sane system out there. Folk are messing around
with the thread stuff using here-say as knowledge. We want to compile
Andreas [EMAIL PROTECTED] writes:
Agreed, workarounds are easy. The original suggestion of TRUNCATE ALL
(or TRUNCATE table CASCADE), however, was motivated by the search for a
simple and efficient truncation of all tables to accelerate unit-testing.
I still think the best suggestion for you is
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
On a philosophical note, I usually don't add core folks to release items
_with_ other folks because we want to encourage non-core contributors,
and because there is already the assumption that core is involved in
many patches.
I
Do you have suggested wording?
---
Andreas Pflug wrote:
Bruce Momjian wrote:
Here are the changes for 7.4. I am looking for any improvements. This
will be adjusted as we move through beta.
Alien ( http://kitenet.net/programs/alien/ ) could possibly help you
handle .deb files (depending on your platform).
cheers
andrew
[EMAIL PROTECTED] wrote:
There is a dbf2pg package on debian that appears to have a higher version
number, but I don't know what to do with a .deb file extension
The Hermit Hacker [EMAIL PROTECTED] writes:
Please test and let me know if there are any problems ...
The .gz tarball matches what I have here. Didn't check the .bz2 one.
regards, tom lane
---(end of broadcast)---
TIP 5:
Bruce Momjian [EMAIL PROTECTED] writes:
How is this?
Prevent timestamp from supressing ':00' seconds display
I think that was type interval, not timestamp.
regards, tom lane
---(end of broadcast)---
TIP 3: if
It's more work for a very small cosmetic benefit, ISTM. Setting up
atomic GUC variables is trivially easy, I'm happy to say. Not that I
can't write a simple parser, but why bother for something so tiny?
Also, would we be saying (or implying) that the order given on the line
would affect the
Updated. Thanks.
---
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
How is this?
Prevent timestamp from supressing ':00' seconds display
I think that was type interval, not timestamp.
Joe Conway wrote:
Andreas Pflug wrote:
But PostgreSQL may be better than Oracle, don't you think? In the
named document,
snip
MSSQL2000 still doesn't have row level triggers, and I doubt that
2003 has.
Right, so as you've pointed out, Postgres trigger implementation is at
least in some
I've been thinking about Ludwig Lim's recent report of a stuck
spinlock failure on a heavily loaded machine. Although I originally
found this hard to believe, there is a scenario which makes it
plausible. Suppose that we have a bunch of recently-started backends
as well as one or more that have
Karel Zak [EMAIL PROTECTED] writes:
On Mon, Aug 04, 2003 at 05:03:02PM -0400, Tom Lane wrote:
Only if you use a locale that is assuming a character set that is not
UTF8 but does have characters with the high bit set. I'm not sure that
we can do anything to defend against locale/charset
Tom Lane wrote:
Andreas Pflug [EMAIL PROTECTED] writes:
- Implement a way to enable triggers to check which columns are affected
by the triggering statement.
This can already be done by comparing old and new values, no?
No, this is not the case.
UPDATE foo SET x=x, y=y
is different
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme:
If we are setting a table level lock
both the blockId and tupleId (in an item pointer this is called
the position) are set to invalid, if it is a page level lock the
blockId is valid, while the
Oh, yes. Let me add that. I didn't realize that was a change of enough
significance.
How is this?
Prevent timestamp from supressing ':00' seconds display
---
Larry Rosenman wrote:
No, the one where we always
Tom Lane wrote:
Andreas Pflug [EMAIL PROTECTED] writes:
Consider this:
Table with one column that is maintained by a trigger for this rule:
- Only one row in a group of rows may have a foo-value of true, all
others must be false.
- If foo=true is inserted/updated, other members of that data
Josh Berkus [EMAIL PROTECTED] writes:
From my perspective, we could really use a delimiter between the
fields of log output which is unlikely to appear within those fields
instead of parsing by character count, rather than making dbname a
special case.
Well, Andrew was arguing that space is a
Bruce Momjian [EMAIL PROTECTED] writes:
I think we need a more general variable that can take several values,
separated by commas, like:
log_line: dbname,user
or something like that.
Strikes me as overkill --- adding two more booleans comparable to
log_pid would do the job just as well
The Hermit Hacker writes:
/usr/bin/cvs -d /cvsroot -q checkout -rREL7_4_BETA1 -P pgsql
/usr/bin/find pgsql -type d -name CVS -print | xargs rm -rf
While I second the note that you really should be using cvs export, the
second line is redundant in any case, because gmake dist already does
that.
If we're looking at this, we might want to look at how apache does it with
it's customlog feature. This allows you to first define custom log types,
then set them according to which virtual server you're setting up.
I could see that being nice so you could create a couple of different
custom
Mike Mascari [EMAIL PROTECTED] writes:
Should there be any correlation between the manner by which the
backoff occurs and the number of active backends?
If we could guess how many are contending for the same spinlock, maybe
we could use that info ... but I don't see a reasonably cheap way to do
Bruce Momjian wrote:
Andreas Pflug wrote:
YATS (yet another TODO suggestion):
provide an official and reliable way to temporarily enable/disable triggers.
ALTER TABLE xxx ENABLE/DISABLE TRIGGER ALL/trgName
We still have that nasty not presently checked everywhere it should be
comment in the
Hi Magnus,
Thanks for that. I always believed that the mcpu flag could enable a C
compiler to generate code that could use the extra instructions on the
newer CPUs - perhaps one day I'll get around to reading the
documentation ;)
Anyway, I've posted the compiled RH 7.3 postgresql-7.3.4 RPMs at
On Mon, Aug 04, 2003 at 10:47:36AM +0200, Andreas Pflug wrote:
AFAICS the current implementation still doesn't have a way to access the
affected rowset, so it'a pretty much like a SELECT without a WHERE.
Yeah, unfortunately I didn't get a chance to implement this functionality
during the 7.4
I too got this error. This happened with Postgres 7.2.3 and Linux 2.4.20 on via
processor. This happened not on just one box but around dozen boxes. This may not be
hardware problem.
In our case, we create the table and use it then delete it. This activity happens very
often, once a day. we
Rod Taylor [EMAIL PROTECTED] writes:
How about (round to nearest 10msec):
time =3D oldtime + oldtime / 2 + oldtime * rand()
while (time 1 second)
time =3D time - 0.80sec
This would stagger the wakeup times, and ensure a larger number of
retries -- but the times should be large
I'm looking over the last bits of translations of pg. Is it to late to
update the translations for 7.4? Should I work on the cvs head version or
is there some branching going on?
It's not too late - translations are allowed during beta I think. And yeah,
use cvs HEAD.
Chris
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Adding several new variables is fine, but what do we call the hostname
option if we already have log_hostname?
shrug We've renamed GUC variables before for consistency. I'd opt
for picking names that show the common purpose, maybe
I'm using 7.3.3 of the server, and pg73b1jdbc2.jar for the JDBC driver.
Various permutations of calls to the setTransactionIsolation all fail to
yield a driver state that will tell me that it is set up for
serializable transactions.
Help!?
I googled, I grepped. I find mention of problems
Rod Taylor [EMAIL PROTECTED] writes:
After the first few sleeps should it add a random() element to the delay
time?
Hmm, that's a thought --- but how big a random element?
Fooling with the original idea, I'm having trouble with getting both
plausible backoff and a reasonable number of attempts
On 5 Aug 2003 at 9:40, Lamar Owen wrote:
On Tuesday 05 August 2003 03:15, Shridhar Daithankar wrote:
I am willing to build 7.4beta binaries on slackware and upload them
someplace. This is just to add to binary packages readily available.
Can anybody tell me what flags etc. are to be
37 matches
Mail list logo