On Fri, 2 Aug 2002, Thomas Lockhart wrote:
> > > I am wondering why we even want to specify the WAL location anywhere
> > > except as a flag to initdb. If you specify a location at initdb time,
> > > it creates the /xlog directory, then symlinks it into /data.
> > Does this have any negative imp
On Mon, 12 Aug 2002, Thomas Lockhart wrote:
> > If you move pg_xlog, you have to create a symlink in /data that points
> > to the new location. Initdb would do that automatically, but if you
> > move it after initdb, you would have to create the symlink yourself.
> > With Thomas's current code,
On Tue, 27 Aug 2002, Bruce Momjian wrote:
>
> I had a good chuckle with this. It is the type of "shoot for the moon"
> idea I would have. Maybe I am rubbing off on you. :-)
>
> The only problem I see with this solution is it makes admins think their
> template1 is safe, when it really isn't.
On Tue, 27 Aug 2002, Bruce Momjian wrote:
> Christopher Kings-Lynne wrote:
> > Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands?
> > This would be neat. Plus, it means we don't have to worry about having
> > unix-only script in the distro once we have Win32 support.
>
t; have a reindexdb script.
>
> ---
>
> scott.marlowe wrote:
> > On Tue, 27 Aug 2002, Bruce Momjian wrote:
> >
> > > Christopher Kings-Lynne wrote:
> > > > Would it be worth adding
it to fail, however.
>
> ---
>
> scott.marlowe wrote:
> > Sorry, that should have been:
> >
> > Isn't it true that reindex's behavior ON A FAILURE is to simply, quietly
> > delete the index? t
On Thu, 5 Sep 2002, Stephan Szabo wrote:
>
> On Thu, 5 Sep 2002, Peter Eisentraut wrote:
>
> > The following happens in latest CVS and a fresh database:
> >
> > create table test (a int);
> > insert into test values (1);
> > alter table test add column b text check (b <> '');
> > alter table te
I'm getting an infinite wait on that file, could someone post it to the
list please?
On Mon, 9 Sep 2002, Bruce Momjian wrote:
>
> OK, turns out that the loop for sequential scan ran fewer times and was
> skewing the numbers. I have a new version at:
>
> ftp://candle.pha.pa.us/pub/pos
On Mon, 9 Sep 2002, Laurette Cisneros wrote:
>
> I am trying move my development database to 7.3b1.
>
> However, when I try to restore from a 7.2.2 dump to the 7.3.b1 server I get
> the following error:
>
> pg_restore -U nbadmin -h lnc -p 5432 -d stats -Fc /tmp/stats.pgdmp
>
> pg_restore: [ar
On Tue, 10 Sep 2002, Stephan Szabo wrote:
> > > > > It starts a transaction, failes the first command and goes into the
> > > > > error has occurred in this transaction state. Seems like reasonable
> > > > > behavior.
> > > >
> > > > Select command don't start transaction - it is not good
> > >
On Tue, 10 Sep 2002, Stephan Szabo wrote:
> On Tue, 10 Sep 2002, scott.marlowe wrote:
>
> > On Tue, 10 Sep 2002, Stephan Szabo wrote:
> >
> > > > > > > It starts a transaction, failes the first command and goes into the
> > > > > > &g
On Thu, 12 Sep 2002, Justin Clift wrote:
> Mike Mascari wrote:
>
> > In Windows 2000 and Windows XP with an NTFS filesystem,
> > Microsoft has added Reparse Points, which allow for the
> > implementation of symbolic links for directories. Microsoft
> > calls them "Junctions". I *believe* the fun
On Fri, 13 Sep 2002, Justin Clift wrote:
> "scott.marlowe" wrote:
>
> > > Seems like the NT4 users are left out in the cold though until we add
> > > some kind of ability for PostgreSQL to not look at the filesystem for
> > > info about where to p
On Thu, 12 Sep 2002, Matthew T. OConnor wrote:
> > > The count approach seems definitely the right way, but a check (possibly
> > > a slow one) can be probably done without initdb.
> >
> > We can certainly do the proper fix in 7.4; do we consider this bug
> > important enough to do an initdb for
On Thu, 12 Sep 2002, scott.marlowe wrote:
> Agreed.
>
> Actually, an argument could likely be made that changes that require
> initdb should be done as early as possible since the later the change the
> more people there will be to test the change, and there will be fewe
On Fri, 13 Sep 2002, Peter Eisentraut wrote:
> Alvaro Herrera writes:
>
> > Is there some documentation on TOAST?
>
> No. Why do you need any?
I think I saw some docs in the
/usr/local/src/postgresql-7.2.1/src/backend/access/heap/tuptoaster.c
file on my box. :-)
Actually it is pretty wel
Hey, me and a few other folks were having a discussion off list, and the
subject of inserts and missing columns came up. you may remember the point
in the "I'm done" post by Bruce. It said:
> o -Disallow missing columns in INSERT ... VALUES, per ANSI
> > What is this, and why is it marked done
I have to say that during beta testing I ALWAYS do an initdb and a reload
just to make sure the pg_dumpall and pg_restore stuff works right. Plus
to make sure problems that might only pop up with a new initdb are found
as well. I probably "burn it to the ground" several times on a single
bet
On 19 Sep 2002, Greg Copeland wrote:
> I think Marc made a pretty good case about the use of command line
> arguments but I think I have to vote with Tom. Many of the command line
> arguments you seem to be using do sorta make sense to have for easy
> reference or to help validate your runtime e
On Wed, 25 Sep 2002, Curt Sampson wrote:
> On Tue, 24 Sep 2002, Jan Wieck wrote:
>
> > And AFAICS it is scary only because screwing that up will simply corrupt
> > your database. Thus, a simple random number (okay, and a timestamp of
> > initdb) in two files, one in $PGDATA and one in $PGXLOG wo
d, 25 Sep 2002, Bruce Momjian wrote:
>
> I don't see the gain of having a file called pg_xlog vs. using GUC.
>
> ---
>
> scott.marlowe wrote:
> > On Wed, 25 Sep 2002, Curt Sampson wrote:
>
On Wed, 25 Sep 2002, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I don't see the gain of having a file called pg_xlog vs. using GUC.
>
> Well, the point is to have a safety interlock --- but I like Jan's
> idea of using matching identification files in both directories.
> Wit
On Wed, 25 Sep 2002, Jan Wieck wrote:
> "scott.marlowe" wrote:
>
> > Having a FILE called pg_xlog isn't the fix here, it's the result of the
> > fix, which is to take all the steps of moving the pg_xlog directory and
> > put them into one script file
If you are seeing very slow performance on a drive set, check dmesg to see
if you're getting SCSI bus errors or something similar. If your drives
aren't properly terminated then the performance will suffer a great deal.
---(end of broadcast)---
On Tue, 1 Oct 2002, John Liu wrote:
> what's the default lock in pgsql?
>
> if I issued insert(copy)/or update processed
> on the same table but on different records
> the same time, how those processes will
> affect each other?
postgresql does not do "locking" in the sense of how most databas
Have you looked at transform_null_equals in the postgresql.conf file to
see if turning that on makes this work like oracle?
On Wed, 2 Oct 2002, Mario Weilguni wrote:
> Ok, I checked this again. Up until 7.2, it was possible to compare an empty string
>to a number, and it worked::
> e.g.: selec
On Wed, 2 Oct 2002, Manfred Koizar wrote:
> As nobody knows how each of these proposals performs in real life
> under different conditions, I suggest to leave the current
> implementation in, add all three algorithms, and supply a GUC variable
> to select a cost function.
I'd certainly be willin
On Thu, 3 Oct 2002, Manfred Koizar wrote:
> On Wed, 2 Oct 2002 14:07:19 -0600 (MDT), "scott.marlowe"
> <[EMAIL PROTECTED]> wrote:
> >I'd certainly be willing to do some testing on my own data with them.
>
> Great!
>
> >Gotta patch?
>
On Thu, 3 Oct 2002, Manfred Koizar wrote:
> On Wed, 2 Oct 2002 14:07:19 -0600 (MDT), "scott.marlowe"
> <[EMAIL PROTECTED]> wrote:
> >I've found that when the planner misses, sometimes it misses
> >by HUGE amounts on large tables,
>
> Scott,
>
On Fri, 4 Oct 2002, Bruce Momjian wrote:
> Hans-Jürgen Schönig wrote:
> > Did anybody think about threaded sorting so far?
> > Assume an SMP machine. In the case of building an index or in the case
> > of sorting a lot of data there is just one backend working. Therefore
> > just one CPU is use
Hi Sandeep. What you were calling Hot Backup is really called Point in
Time Recovery (PITR). Hot Backup means making a complete backup of the
database while it is running, something Postgresql has supported for a
very long time.
On Mon, 7 Oct 2002, Sandeep Chadha wrote:
> Hello to all the D
It's on Slashdot, but there's only one post there that mentions the use of
Postgresql.
On 14 Oct 2002, Robert Treat wrote:
> Yep, that's them. This is a big win from a PostgreSQL advocacy position,
> especially since oracle pr made an official statement against the use of
> PostgreSQL. Has this
On 16 Oct 2002, Karl DeBisschop wrote:
> On Mon, 2002-10-14 at 16:14, scott.marlowe wrote:
> > It's on Slashdot, but there's only one post there that mentions the use of
> > Postgresql.
> >
> > On 14 Oct 2002, Robert Treat wrote:
> >
> > > Ye
On Fri, 11 Oct 2002, Jeff Davis wrote:
> > They also state that they have more sophisticated ALTER TABLE...
> >
> > Only usable feature in their ALTER TABLE that doesn't (yet) exist in
> > PostgreSQL was changing column order (ok, the order by in table creation
> > could be nice), and that's still
On Thu, 31 Oct 2002, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > Ok, fair enough -- I agree that we should treat the two cases
> > differently. But one thing I think we should do in any case is improve
> > the wording of the error message.
>
> Got a suggestion?
Change: Relatio
On Tue, 22 Oct 2002, Igor Georgiev wrote:
> > > edit *pg_hba.conf *
> > > # Allow any user on the local system to connect to any
> > > # database under any username, but only via an IP connection:
> > > host all 127.0.0.1 255.255.255.255trust
I would recommend checking your memory (look for memtest86 online
somewhere. Good tool.) Anytime a machine seems to act flakely there's a
better than even chance it has a bad bit of memory in it.
On Wed, 6 Nov 2002, Nicolas VERGER wrote:
> Hi,
> I have strange stability problems.
> I can't ac
On Tue, 5 Nov 2002, Florian Litot wrote:
> what is the command to launch a sql script not in psql
> thanks
without actually being IN psql, you can use it to run one line scripts
like this:
psql dbname -c -- 'single query goes here'
or you can run a large file full of sql queries like this:
ps
On Tue, 12 Nov 2002, Nicolas VERGER wrote:
> Scott you're right, it was a hardware problem.
> Thanks for your help.
>
Glad to be of help. What was the problem? Bad memory or bad hard drive?
Just curious.
---(end of broadcast)---
TIP 6: Have y
Curtis, have you considered comparing raw writes versus file system writes
on a raw multi-disk partition?
I always set up my machines to store data on a mirror set (RAID1) or RAID5
set, and it seems your method should be tested there too.
P.s., Tom, the postgresql user would NOT need to run as
On 12 Nov 2002, Robert Treat wrote:
> On Tue, 2002-11-12 at 16:27, Tom Lane wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > > Bruce Momjian writes:
> > >> Are we ready for RC1 yet?
> >
> > > Questionable. We don't even have 50% confirmation coverage for the
> > > supported platforms
On 12 Nov 2002, Robert Treat wrote:
> On Tue, 2002-11-12 at 16:27, Tom Lane wrote:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > > Bruce Momjian writes:
> > >> Are we ready for RC1 yet?
> >
> > > Questionable. We don't even have 50% confirmation coverage for the
> > > supported platforms
On Tue, 12 Nov 2002, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > And then it stops. Anyone know why it doesn't run the rest of the
> > regresssion tests?
>
> Somebody else just reported the same thing on Solaris. Must be
&g
On Tue, 12 Nov 2002, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > And then it stops. Anyone know why it doesn't run the rest of the
> > regresssion tests?
>
> Somebody else just reported the same thing on Solaris. Must be
&g
On Tue, 12 Nov 2002, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > OK, make -x check fails, is there some other way to use -x I'm not
> > thinking of here?
>
> I was thinking of running the script by hand, not via make:
>
&
On Tue, 12 Nov 2002, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Ok, now that I've run it that way, the last couple of pages of output
> > look like this:
>
> Hm. So the "while read line" loop is iterating only once.
>
On Thu, 21 Nov 2002, Christopher Kings-Lynne wrote:
> > > I think his point is that they _should_ be equivalent. Surely there's
> > > something in the optimiser that discards '=true' stuff, like 'a=a'
> should be
> > > discarded?
> >
> > I figure that's what he meant, but it isn't what was said.
On Thu, 21 Nov 2002, Christopher Kings-Lynne wrote:
> > > I think his point is that they _should_ be equivalent. Surely there's
> > > something in the optimiser that discards '=true' stuff, like 'a=a'
> should be
> > > discarded?
> >
> > I figure that's what he meant, but it isn't what was said.
On Thu, 21 Nov 2002, Stephan Szabo wrote:
>
> On Thu, 21 Nov 2002, Christopher Kings-Lynne wrote:
>
> > > > > "col" isn't of the general form "indexkey op constant" or "constant op
> > > > > indexkey" which I presume it's looking for given the comments in
> > > > > indxpath.c. I'm not sure what
On 21 Nov 2002, Rod Taylor wrote:
> On Thu, 2002-11-21 at 15:09, scott.marlowe wrote:
> > On 21 Nov 2002, Rod Taylor wrote:
> >
> > > On Thu, 2002-11-21 at 14:11, Bruce Momjian wrote:
> > > > Of course, those would be SQL purists who _don'
On 21 Nov 2002, Rod Taylor wrote:
> On Thu, 2002-11-21 at 14:11, Bruce Momjian wrote:
> > Of course, those would be SQL purists who _don't_ understand
> > concurrency issues. ;-)
>
> Or they're the kind that locks the entire table for any given insert.
Isn't that what Bruce just said? ;^)
--
Now, Solaris seems to be running all the tests but failing something like
29 out of 85 of them.
With a vanilla ./configure;make, I get this on a make check:
== running regression test queries==
parallel group (13 tests): char int8 oid int2 int4 varchar name boole
On Mon, 25 Nov 2002, Christopher Kings-Lynne wrote:
> Can you send in the regression.diffs file?
>
> Chris
>
> - Original Message -
> From: "scott.marlowe" <[EMAIL PROTECTED]>
> To: "Tom Lane" <[EMAIL PROTECTED]>
> Cc: &qu
On Mon, 25 Nov 2002, Christopher Kings-Lynne wrote:
> Can you send in the regression.diffs file?
>
OK, after a bit of hair pulling, and figuring out I was running out of
space because of quotas, I've gotten it to run with only one failure,
which was because of having too many files open, and t
On Mon, 25 Nov 2002, Bruce Momjian wrote:
>
> Please try RC2; this is fixed there.
U. That was with rc2
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Tue, 26 Nov 2002, Justin Clift wrote:
> Dear Clift,
>
> > As a side thought, would you please be able to correct the spelling of
> PostgreSQL on the same page. Presently it's spelt "PostGreSQL", which
> is
> incorrect.
>
> Better way, i'v remove postgresql name in the site, as i think you wa
On Tue, 26 Nov 2002, Al Sutton wrote:
> D'Arcy,
>
> In production the database servers are seperate multi-processor machines
> with mirrored disks linked via Gigabit ethernet to the app server.
>
> In development I have people extremely familiar with MS, but not very hot
> with Unix in any flavo
On 27 Nov 2002, Hannu Krosing wrote:
> Al Sutton kirjutas T, 26.11.2002 kell 20:37:
> > D'Arcy,
> >
> > In production the database servers are seperate multi-processor machines
> > with mirrored disks linked via Gigabit ethernet to the app server.
> >
> > In development I have people extremely f
On Tue, 26 Nov 2002, bpalmer wrote:
> > > D'Arcy,
> > >
> > > In production the database servers are seperate multi-processor machines
> > > with mirrored disks linked via Gigabit ethernet to the app server.
> > >
> > > In development I have people extremely familiar with MS, but not very hot
> >
On 27 Nov 2002, Hannu Krosing wrote:
> Merlin Moncure kirjutas T, 26.11.2002 kell 08:00:
> > I was playing with the Japanese win32 7.2.1 port and I noticed that "select
> > 0 / 0" caused the server to crash and restart. I understand that it is a
> > totally unsupported version, but it should be e
On 27 Nov 2002, Hannu Krosing wrote:
> scott.marlowe kirjutas K, 27.11.2002 kell 01:40:
> > On 27 Nov 2002, Hannu Krosing wrote:
> >
> > > You could try out VMWare and run a linux virtual machine under Windows,
> > > You could set it up once with all ne
In a similar vein, setting the way back machine to the mid 80s when I was
in the USAF and teaching the computer subsystem of the A-10 INS test
station, we had old reclaimed Sperry 1650 computers (the precursor to the
1750) that had come out of the 1960 era fire control systems on
battleships li
On Wed, 27 Nov 2002, Al Sutton wrote:
> Hannu,
>
> Using a Win32 platform will allow them to perform relative metrics. I'm not
> looking for a statement saying things are x per cent faster than production,
> I'm looking for reproducable evidence that an improvement offers y per cent
> faster perf
On Fri, 29 Nov 2002, Prasanna Phadke wrote:
>
> Can anybody explain me, how to compile postgres source code in VC++.
>
> Catch all the cricket action. Download Yahoo! Score tracker
Step 1: Get VC++ to run under unix...
Just kidding. :-) Right now you can't.
pgsql 7.4 should support native W
On 10 Dec 2002, Rod Taylor wrote:
> > > Not sure what you mean by that, but it sounds like the behaviour of my AVD
> > > (having it block until the vacuum command completes) is fine, and perhaps
> > > preferrable.
> >
> > I can easily imagine larger systems with multiple CPUs and multiple disk
On Mon, 16 Dec 2002, Tom Lane wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > How hard would it be to add a "WITH (VACUUM)" option to UPDATE and DELETE
> > queries? This option would cause the regular vacuum activity -- purging the
> > dead tuple and its index references -- to be done imme
On Mon, 16 Dec 2002, Marc G. Fournier wrote:
> On Mon, 16 Dec 2002, scott.marlowe wrote:
>
> > On Mon, 16 Dec 2002, Tom Lane wrote:
> >
> > > Josh Berkus <[EMAIL PROTECTED]> writes:
> > > > How hard would it be to add a "WITH (VACUUM)" opt
On Wed, 18 Dec 2002, Marc G. Fournier wrote:
> The problem is that there is nothing to announce ... "Hi, we fixed some
> bugs"? :) minor releases don't have any features added to them, so isn't
> really news worthy ... :(
I don't know, if you're a postgresql user and you don't read these lists,
On Wed, 18 Dec 2002, Marc G. Fournier wrote:
> On Wed, 18 Dec 2002, Bruce Momjian wrote:
>
> > OK, I see from your commit message:
> >
> > From the SSL_CTX_new man page:
> >
> > "SSLv23_method(void), SSLv23_server_method(void), SSLv23_client_method(void)
> >
> > A TLS/SSL connection establishe
On Wed, 18 Dec 2002, Bruce Momjian wrote:
> Marc G. Fournier wrote:
> > > My question is whether it is safe to be making this change in a minor
> > > release? Does it work with 7.3 to 7.3.1 combinations? My other
> > > question is, if SSLv2 isn't secure, couldn't a client say they only
> > > sup
On Thu, 19 Dec 2002, Philip Warner wrote:
> At 10:49 PM 18/12/2002 -0500, Bruce Momjian wrote:
> >I don't think we can bump that up in a minor.
>
> Why not? It's a relatively serious problem with the default config.
>
>
> >Should we?
>
> Yes.
I concur. The problems of a too-low fsm setting a
Yeah, it's called cygwin. Oh, you probably meant that miserable excuse
for a posix layer MS included when they shipped it. :-)
On Tue, 7 Jan 2003, Dave Page wrote:
> So does NT iirc ;-)
>
> > -Original Message-
> > From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> > Sent: 07 January 2
> No analyze for 7.1.3.
> Just ran vacuum a few minutes before the query. No boost at all. Even
> with SET enable_seqscan = 0 it still does a table scan.
Dann, I can attest to 7.2 having a much better planner and performance
than 7.1 did. Can you upgrade?
---(end of
On 23 Jan 2003, Hannu Krosing wrote:
> Curt Sampson kirjutas N, 23.01.2003 kell 17:42:
> > If the OS can handle the scheduling (which, last I checked, Linux couldn't,
>
> When did you do your checking ?
> (just curious, not to start a flame war ;)
>
> > at least not without patches), eight or
My other pet peeve is the default max connections setting. This should be
higher if possible, but of course, there's always the possibility of
running out of file descriptors.
Apache has a default max children of 150, and if using PHP or another
language that runs as an apache module, it is qu
On Tue, 11 Feb 2003, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Is setting the max connections to something like 200 reasonable, or likely
> > to cause too many problems?
>
> That would likely run into number-of-semaphores limitation
On 11 Feb 2003, Greg Copeland wrote:
> On Tue, 2003-02-11 at 12:55, Tom Lane wrote:
> > "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > > Is setting the max connections to something like 200 reasonable, or likely
> > > to cause too many problems?
&g
On Tue, 11 Feb 2003, Merlin Moncure wrote:
> Here's the comment I was referring to:
>
> /*
> * InitProcGlobal -
> * initializes the global process table. We put it here so that
> * the postmaster can do this initialization.
> *
> * We also create all the per-process semaphores
On Tue, 11 Feb 2003, Rick Gigger wrote:
> The type of person who can't configure it or doesnt' think to try is
> probably not doing a project that requires any serious performance. As long
> as you are running it on decent hardware postgres will run fantastic for
> anything but a very heavy load.
On Wed, 12 Feb 2003, Curt Sampson wrote:
> On Tue, 11 Feb 2003, Tom Lane wrote:
>
> > It's a lot too conservative. I've been thinking for awhile that we
> > should adjust the defaults.
>
> Some of these issues could be made to Just Go Away with some code
> changes. For example, using mmap rathe
On Wed, 12 Feb 2003, Tatsuo Ishii wrote:
> > My other pet peeve is the default max connections setting. This should be
> > higher if possible, but of course, there's always the possibility of
> > running out of file descriptors.
> >
> > Apache has a default max children of 150, and if using PH
On Wed, 12 Feb 2003, GB Clark wrote:
> On Thu, 23 Jan 2003 11:19:36 -0700 (MST)
> "scott.marlowe" <[EMAIL PROTECTED]> wrote:
>
> > On 23 Jan 2003, Hannu Krosing wrote:
> >
> > > Curt Sampson kirjutas N, 23.01.2003 kell 17:42:
> > > >
On Tue, 11 Feb 2003, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > ... If he starts running out of semaphores, that's a
> > problem he can address while his database is still up and running in most
> > operating systems, at least in
Oh, another setting that should be a "default" for most users is to initdb
automatically with locale of C. If they need a different locale, they
should have to pick it.
The performance of Postgresql with a locale other than C when doing like
and such is a serious ding. I'd much rather have th
On 13 Feb 2003, Martin Coxall wrote:
>
> > Well, to the extent that you're serious, you understand that
> > a lot of people feel that /usr/local should be reserved for
> > stuff that's installed by the local sysadmin, and your
> > vendor/distro isn't supposed to be messing with it.
> >
> > Wh
On Thu, 13 Feb 2003, mlw wrote:
>
>
> Christopher Browne wrote:
>
> >In the last exciting episode, [EMAIL PROTECTED] (Curt Sampson) wrote:
> >
> >>On Wed, 12 Feb 2003, Peter Bierman wrote:
> >>
> >>>What do you gain by having the postmaster config and the database
> >>>data live in different lo
On Thu, 13 Feb 2003, mlw wrote:
>
>
> scott.marlowe wrote:
>
> >>These are not issues at all. You could put the configuration file
> >>anywhere, just as you can for any UNIX service.
> >>
> >>postmaster --config=/home/myhome/mydb.conf
> >
On Fri, 14 Feb 2003, Curt Sampson wrote:
> On Thu, 13 Feb 2003, scott.marlowe wrote:
>
> > If I do a .tar.gz install of apache, I get /usr/local/apache/conf, which
> > is not the standard way you're listing.
>
> I'm going to stay out of this argument from now
On Sat, 15 Feb 2003, Curt Sampson wrote:
> On Fri, 14 Feb 2003, scott.marlowe wrote:
>
> > Asking for everything in a directory with the name local in it to be
> > shared is kind of counter intuitive to me.
>
> Not really. If you install a particular program that doesn
On Thu, 20 Feb 2003, Kevin Brown wrote:
> Tom Lane wrote:
> > UPDATE totals SET
> > xmax = ss.xmax, xmin = ss.xmin, ...
> > FROM
> > (SELECT groupid, max(x) AS xmax, ... FROM details GROUP BY groupid) ss
> > WHERE groupid = ss.groupid;
>
> As long as any individual item th
g/SC32/WG3/Progression_Documents/FCD/4FCD1-01-Framework-2002-01.pdf
>
> Dave
> On Thu, 2003-02-20 at 11:20, scott.marlowe wrote:
> > On Thu, 20 Feb 2003, Tom Lane wrote:
> >
> > > Hannu Krosing <[EMAIL PROTECTED]> writes:
> > > > Are you against it ju
e, I think the actual document is
>
> ftp://ftp.sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-01-Framework-2002-01.pdf
>
> and it is in section 14.12
>
>
> on or about page 839
>
> Dave
> On Thu, 2003-02-20 at 11:20, scott.marlowe wrote:
> > On
On Thu, 20 Feb 2003, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Are you against it just on grounds of cleanliness and ANSI compliance,
> > or do you see more serious problems in letting it in ?
>
> At this point it seems there are two different things being tossed
> about. I
On Sat, 22 Feb 2003, Peter Eisentraut wrote:
> AFAICT, ILIKE cannot use an index. So why does ILIKE even exist, when
> lower(expr) LIKE 'foo' provides a solution that can use an index and is
> more standard, too?
I would guess because for lower(expr) to work you need to make an index on
it. Si
On Mon, 3 Mar 2003, Tommi Maekitalo wrote:
> On the results page they list kernels like linux-2.4.18-1tier or
> linux-2.4.19-rc2 or redhat-stock-2.4.7-10cmp. This sounds really like
> linux-kernel-versions.
>
> Am Montag, 3. März 2003 13:41 schrieb [EMAIL PROTECTED]:
> > > OSDL has just come ou
On Wed, 5 Mar 2003, Dave Page wrote:
>
>
> > -Original Message-
> > From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]
> > Sent: 05 March 2003 02:23
> > To: [EMAIL PROTECTED]
> > Subject: [HACKERS] Win32 Powerfail testing
> >
> > So far we found interesting facts. Our Win32 port passes his
>
On 13 Mar 2003, Greg Stark wrote:
>
> Joe Conway <[EMAIL PROTECTED]> writes:
>
> > I'm leaning toward implode() and explode() now anyway because split() uses a
> > regex for the delimiter in PHP (and probably Perl), and I was not planning to
> > get that fancy.
>
> PHP isn't exactly an exemplar
On 14 Mar 2003, Greg Stark wrote:
>
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
>
> > You're quick to throw out a trollish barb against PHP without any
> > real discussion as to why it's such a horrible language.
>
> No need to be s
On Fri, 14 Mar 2003, Christopher Browne wrote:
> > Do you really think someone looking for a function to break up a
> > string into a list of strings would ever think of looking up "explode"
> > in an index if he hadn't already used PHP or (shudder) VBScript?
>
> It's also one of the classic exam
On Fri, 14 Mar 2003, Þórhallur Hálfdánarson wrote:
> -*- Greg Stark <[EMAIL PROTECTED]> [ 2003-03-14 17:43 ]:
> > Do you really think someone looking for a function to break up a string into a
> > list of strings would ever think of looking up "explode" in an index if he
> > hadn't already used PH
1 - 100 of 252 matches
Mail list logo
