> -Original Message-
> From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 31, 2003 10:39 PM
> To: Dann Corbit
> Cc: Christopher Browne; Justin Clift; Jeff Davis; PostgresSQL
> Hackers Mailing List
> Subject: RE: [mail] Re: [HACKERS] Windows Build System
>
>
> On Fri,
On Fri, 31 Jan 2003, Andrew Sullivan wrote:
> But the pain of making them
> interoperate is part of the cause of resistance. The compatibility
> addresses are going to _have_ to work if people are really going to
> move...
There is no pain in this respect; you get your compatability by simply
ru
On Fri, Jan 31, 2003 at 22:30:45 -0800,
ow <[EMAIL PROTECTED]> wrote:
> IMHO, replication, performance improvements, cross-db queries, etc is
> much better use of time than Windows port.
Welcome to open source where individual people get to decide what is most
important to spend their time on.
> -Original Message-
> From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 31, 2003 10:18 PM
> To: Dann Corbit
> Cc: Christopher Browne; Justin Clift; Jeff Davis; PostgresSQL
> Hackers Mailing List
> Subject: RE: [mail] Re: [HACKERS] Windows Build System
>
>
> On Fri,
On Fri, 2003-01-31 at 19:22, Dann Corbit wrote:
> For MySQL:
> There is no Cygwin needed. Period.
Sorry to followup again, but I did want to point out something. I'm
assuming you actually installed it. Please take note that the cygwin
dll is normally installed into one of the window's directori
On Sat, Feb 01, 2003 at 12:27:31AM -0600, Greg Copeland wrote:
> On Fri, 2003-01-31 at 14:36, Dave Page wrote:
> >
> > I intend to run the tests on a Dual PIII 1GHz box, with 1Gb of Non-ECC
> > RAM and a 20Gb (iirc) IDE disk. I will run on Windows 2000 Server with
> > an NTFS filesystem, and again
On Fri, 2003-01-31 at 16:07, Christopher Browne wrote:
> I'm making the generous assumption that since /they/ claim that there is
> some distinction, that there perhaps is one.
I've used the cygwin environment enough to know that there isn't any.
If it's linked against the cygwin dll, the applic
On Fri, Jan 31, 2003 at 11:13:04 +0100,
Jaume Teixi <[EMAIL PROTECTED]> wrote:
> how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal user ?
If you are using psql, use the \copy command.
---(end of broadcast)---
TIP 2: you
IMHO, replication, performance improvements, cross-db queries, etc is
much better use of time than Windows port.
--- Dann Corbit <[EMAIL PROTECTED]> wrote:
> For MySQL:
> There is no Cygwin needed. Period.
>
__
Do you Yahoo!?
Yahoo! Mail Plus - P
On Fri, 2003-01-31 at 14:36, Dave Page wrote:
>
> I intend to run the tests on a Dual PIII 1GHz box, with 1Gb of Non-ECC
> RAM and a 20Gb (iirc) IDE disk. I will run on Windows 2000 Server with
> an NTFS filesystem, and again on Slackware Linux 8 with either ext3 or
> reiserfs (which is preferred?
On Fri, 2003-01-31 at 19:22, Dann Corbit wrote:
> For MySQL:
> There is no Cygwin needed. Period.
>
Any idea as to why we seem to be getting such a conflicting story here?
By several accounts, it does. Now, your saying it doesn't. What the
heck is going on here. Not that I'm doubting you. I
On Fri, 31 Jan 2003, mlw wrote:
> Like it or not, if PG releases a very good Win32 port, ALL the unixoids
> combined will be out numbered by the windoze users.
Now that's certainly something to look forward to.
Vince.
--
Fast, inexpensive internet service 56k and beyond! http://www.pop4.net/
> > Now, there are some obvious problems:
>
> You missed the real reason why this will never happen: it completely
> kills any prospect of concurrent updates. If transaction A has
> issued an update on some row, and gone and modified the relevant
> aggregate cache entries, what happens when trans
Bruce Momjian wrote:
So, as far as I am concerned, we will have a Win32 port in 7.4. It will
not be perfect, but it will be as good as we can do. We are also
getting point-in-time recovery in 7.4, so that may help us with Win32
port failures too.
If anyone's interested, the "PostgreSQL 7.3.1
Dann Corbit wrote:
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 8:24 PM
To: mlw
Cc: Lamar Owen; Dann Corbit; PostgresSQL Hackers Mailing List
Subject: Re: [mail] Re: [HACKERS] Windows Build System
mlw <[EMAIL PROTECTED]> writes:
Li
Tom Lane wrote:
mlw <[EMAIL PROTECTED]> writes:
Like it or not, if PG releases a very good Win32 port, ALL the unixoids
combined will be out numbered by the windoze users.
A lot of us are *not* looking forward to that prospect.
regards, tom lane
No doubt to that, but, depending
Sean Chittenden <[EMAIL PROTECTED]> writes:
> Now, there are some obvious problems:
You missed the real reason why this will never happen: it completely
kills any prospect of concurrent updates. If transaction A has issued
an update on some row, and gone and modified the relevant aggregate
cache
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 31, 2003 8:24 PM
> To: mlw
> Cc: Lamar Owen; Dann Corbit; PostgresSQL Hackers Mailing List
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> mlw <[EMAIL PROTECTED]> writes:
> > Like it
mlw <[EMAIL PROTECTED]> writes:
> Like it or not, if PG releases a very good Win32 port, ALL the unixoids
> combined will be out numbered by the windoze users.
A lot of us are *not* looking forward to that prospect.
regards, tom lane
---(end of br
> > I have a table which is very large (~65K rows). I have
> > a column in it which is indexed, and I wish to use for
> > a join. I'm finding that I'm using a sequential scan
> > for this when selecting a MIN.
>
> Due to Postgres' system of extensible aggregates (i.e. you can write
> your own aggr
Like it or not, if PG releases a very good Win32 port, ALL the unixoids
combined will be out numbered by the windoze users.
Lamar Owen wrote:
On Friday 31 January 2003 20:22, Dann Corbit wrote:
Now, as far as the Win32 animosity goes, I think that is a natural thing
too. There is a culture c
On Friday 31 January 2003 20:22, Dann Corbit wrote:
> Now, as far as the Win32 animosity goes, I think that is a natural thing
> too. There is a culture clash between the Linux camps and the Win32
> camps. Typically, it's the highly intelligent kids recently out of
> college that are in love with
wade <[EMAIL PROTECTED]> writes:
> We recently upgraded a project from 7.2 to 7.3.1 to make use of some of
> the cool new features in 7.3. The installed version is CVS stable from
> yesterday. However, we noticed a major performance hit in POSIX regular
> expression matches against columns usin
> As for build environment, we have two audiences --- those using
> binaries, and those compiling from source. Clearly we are going to have
> more binary users vs. source users on Win32 than on any other platform,
> so at this stage I think making thing easier for the majority of our
> Unix develo
For MySQL:
There is no Cygwin needed. Period.
I did a build last night. Using nothing but Visual Studio with the
Intel C++ compiler for Win32.
Here is what got built:
E:\mysql-3.23.55>dir /s *.dll, *.exe
Volume in drive E has no label.
Volume Serial Number is 7496-C335
Directory of E:\mysql-
Dave Page wrote:
Justin? We can write a techdocs styled search/results page quite easily
if you like that will use the same database, and filter to techdocs only
if that's preferred. It would be nice to get rid of Google.
Agreed. It would be better to have Dave improved search engine do it.
A
Curtis Faith writes:
>a) Running as a service is important as this the way NT/2000
> administrators manage server tasks. The fact that PostgreSQL's Cygwin
> emulation doesn't do this is very indicative of inferior Windows
> support.
No, it is indicative of the inability to read the documentat
On Friday 31 January 2003 03:21, Bruce Momjian wrote:
> Man, I go away for one day, and look what you guys get into. :-)
No duh. Whew.
> Lastly, SRA just released _today_ their first Win32 port of PostgreSQL,
> and it is _threaded_:
> http://osb.sra.co.jp/PowerGres/
Is there an English
On Fri, 31 Jan 2003, Shridhar Daithankar<[EMAIL PROTECTED]> wrote:
> Besides file locking is implemented using setgid bit on most unices. And
> everybody is free to do what he/she thinks right with it.
I don't believe it's implemented with the setgid bit on most Unices. As
I recall, it's certain
On Fri, Jan 31, 2003 at 08:21:21PM +0100, Kurt Roeckx wrote:
> What do you mean with "compatibility addresses"? I don't know of
> any such thing.
I'm thinking of these sorts of things (my faviourite description,
from RFC 2893):
IPv6/IPv4 nodes that perform automatic tunneling are assigned
IPv4-c
Dave Page kirjutas R, 31.01.2003 kell 22:36:
> Despite some people's thoughts that a powerfail test is of little use, I
> going to spend some time doing one anyway because I think Tom's
> arguments for it are valid. I have lashed together the attached test
> program (the important bits are the setu
Just a quick question... are you guys using the C runtime or the win32
API to do things like file i/o and memory allocation. If you are using
the win32 api, are you using asynchronous I/O? Generally, how much raw
win32 code do you expect to write (assumption: as little as possible).
As for memor
Hello,
We recently upgraded a project from 7.2 to 7.3.1 to make use of some of
the cool new features in 7.3. The installed version is CVS stable from
yesterday. However, we noticed a major performance hit in POSIX regular
expression matches against columns using the ~* operator.
http://arch.w
> On Fri, 2003-01-31 at 07:22, Christopher Browne wrote:
> > But it's not /nearly/ that straightforward.
>> If you look at the downloads that MySQL AB provides, they point you
>> to a link that says "Windows binaries use the Cygwin library."
>> Which apparently means that this "feature" is not ac
On Mon, Jan 13, 2003 at 07:31:08PM +1100, Giles Lean wrote:
>
> Is the "Single Unix Standard, version 2" (aka UNIX98) any better?
> It says for fsync():
>
> "The fsync() function forces all currently queued I/O operations
> associated with the file indicated by file descriptor fildes to
>
> -Original Message-
> From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2003 19:45
> To: Dave Page
> Cc: PostgresSQL Hackers Mailing List
> Subject: RE: [HACKERS] Odd website behavior...
>
>
> > Or do you mean the old Google one?
> >
> > Regards, Dave.
>
>
> I'm goi
Original Message
Subject: Re: [mail] Re: [HACKERS] Windows Build System
Date: Fri, 31 Jan 2003 15:46:20 -0500
From: mlw <[EMAIL PROTECTED]>
To: Tom Lane <[EMAIL PROTECTED]>
CC: Curtis Faith <[EMAIL PROTECTED]>, 'Al Sutton'
<[EMAIL PROTECTED]>, 'Bruce Momjian' <[EMAIL PROTECTED]
Tom Lane wrote:
"Curtis Faith" <[EMAIL PROTECTED]> writes:
If a developer can simply download the source, click on the Visual C++
project in the win32 directory and then build PostgreSQL, and they can
see that Windows is not the "poor stepchild" because the VC project is
well laid out, they
Despite some people's thoughts that a powerfail test is of little use, I
going to spend some time doing one anyway because I think Tom's
arguments for it are valid. I have lashed together the attached test
program (the important bits are the setup, run and check functions) for
review before I actu
On Fri, 2003-01-31 at 13:04, Kurt Roeckx wrote:
> On Thu, Jan 30, 2003 at 08:21:09PM -0600, Greg Copeland wrote:
> > It doesn't help the
> > confusion that many OS's try to confuse programmers by exposing a single
> > socket interface, etc. Simple fact remains, IPv6 is not IPv4.
>
> It's a good t
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 31, 2003 12:21 AM
> To: Lamar Owen
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] Windows Build System - My final thoughts
>
>
> Man, I go away for one day, and look what you guys get int
On Fri, 2003-01-31 at 13:28, Dave Page wrote:
> > -Original Message-
> > From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> > Sent: 31 January 2003 16:12
> > To: PostgresSQL Hackers Mailing List
> > Subject: [HACKERS] Odd website behavior...
> >
> >
> > When searching techdocs.postgresql.o
- Original Message -
From: "Greg Copeland" <[EMAIL PROTECTED]>
> I'm confused as to whether you are being sarcastic or truly seem to
> think there is a distinction here. Simple question, does MySQL require
> the cygwin dll's (or statically linked to) to run?
>
> If the answer is yes, then
> -Original Message-
> From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2003 16:12
> To: PostgresSQL Hackers Mailing List
> Subject: [HACKERS] Odd website behavior...
>
>
> When searching techdocs.postgresql.org, if you type in
> "transaction", it says, "Your original
Christopher Browne wrote:
>
> >> From the MySQL site's page about MySQL vs PostgreSQL:
> >>http://www.mysql.com/doc/en/MySQL-PostgreSQL_features.html
> >>
> >>"MySQL Server works better on Windows than PostgreSQL does. MySQL
> >>Server runs as a native Windows application (a service on
> >>NT/2
On Thu, Jan 30, 2003 at 08:13:30PM -0500, Tom Lane wrote:
> Kurt Roeckx <[EMAIL PROTECTED]> writes:
> > On Thu, Jan 30, 2003 at 11:28:41AM -0500, Tom Lane wrote:
> >> We have to work out what the semantics should be. I don't know anything
> >> about v6, but I'd imagine v4 addresses form a defined
On Thu, Jan 30, 2003 at 08:21:09PM -0600, Greg Copeland wrote:
>
> IPv6 has some provisions to help people migrate toward it (from IPv4),
> however, IPv6 is a distinctly different protocol.
The ipv4 mapped ipv6 addresses are to help migrate, but it
actually makes things worse. If this wouldn't b
Hi,
I have three tables, two of which are missing a column:
CREATE TABLE table1 (t1 TEXT);
CREATE TABLE table2 (t2 TEXT);
CREATE TABLE table3 (t3 TEXT, i3 INTEGER);
I am trying to create a view over these tables that defaults values for
non-existant columns to NULL.
On Fri, Jan 31, 2003 at 09:13:18AM -0500, Andrew Sullivan wrote:
>
> Soon, the NAT + CIDR bag-on-the-side will run out of room, and people
> will have no choice but to use IPv6. But the pain of making them
> interoperate is part of the cause of resistance. The compatibility
> addresses are going
So ignore it, eh?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On Fri, 2003-01-31 at 07:22, Christopher Browne wrote:
> But it's not /nearly/ that straightforward.
>
> If you look at the downloads that MySQL AB provides, they point you to a link
> that says "Windows binaries use the Cygwin library."
>
> Which apparently means that this "feature" is not actu
On Friday 31 January 2003 05:08, Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
>
> > And what about MySQL?
>
> What about it? Someone claimed in this thread that MySQL's Windows port
> requires Cygwin. Is that true or not?
For reference, from the INSTALL-SOURCE file included in
the My
On Fri, 31 Jan 2003, Caffeinate The World wrote:
>
> > But, we need help to create good documentation for tsearch !
> > This is main stopper for releasing of tsearch.
>
> I am currently using tsearch. I'd be happy to help with documentation.
Nice ! We'll send you archive with new tsearch and shor
how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal user ?
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Christopher Browne wrote:
From the MySQL site's page about MySQL vs PostgreSQL:
http://www.mysql.com/doc/en/MySQL-PostgreSQL_features.html
"MySQL Server works better on Windows than PostgreSQL does. MySQL Server
runs as a native Windows application (a service on NT/2000/XP), while
PostgreSQL i
On Thu, 2003-01-30 at 21:30, Kevin Brown wrote:
>
> That said, if the parser's gram.y file is anything to go by, the fixes
> to make it work with bison 1.75 are trivial, so if you change your
> mind I'll be happy to do the work.
>
If your gung ho about doing the work, I see no reason not to do i
> -Original Message-
> From: Jeff Davis [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2003 06:27
> To: [EMAIL PROTECTED]
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
>
> > What about it? Someone claimed in this thread that MySQL's Windows
> > port requires Cygwin. Is t
> -Original Message-
> From: Dave Page
> Sent: 30 January 2003 19:57
> To: Vince Vielhaber; Lamar Owen
> Cc: [EMAIL PROTECTED]
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
> I ought to plonk you for a comment like that. Especially
> coming from the person who's crap I've
Hi there,
we've discussed with Teodor about adding ranking feature to tsearch and
seems we've found a way to do that. New version of tsearch will have
ranking supports, friendly configurability, linguistic options
and removing some internal limits. Expect alpha-version in 1-2 weeks.
But, we need
On Thursday 30 January 2003 14:02, mlw wrote:
> Forgive my stupidity, are you running PostgreSQL with the data on an NFS
> share?
Yes, sorry. PostgreSQL is running from the local disk but the data is on the
mounted drive.
--
D'Arcy J.M. Cain| Democracy is three wolves
http://www.druid.net
Antti Haapala <[EMAIL PROTECTED]> writes:
> And from SunOS 5.8 flock
> Locks are on files, not file descriptors. That is, file
> descriptors duplicated through dup(2) or fork(2) do not
> result in multiple instances of a lock, but rather multiple
> references to a sin
On Thursday 30 January 2003 14:27, Greg Copeland wrote:
> That was going to be my question too.
>
> I thought NFS didn't have some of the requisite file system behaviors
> (locking, flushing, etc. IIRC) for PostgreSQL to function correctly or
> reliably.
>
> Please correct as needed.
Yes, doubly s
When searching techdocs.postgresql.org, if you type in "transaction", it
says, "Your original search: transation returned zero results. The
alternate spelling: transaction returned the results below." For some
reason it is changing the spelling and then reverting back to the
original.
Just a hea
On Thursday 30 January 2003 12:07, Tom Lane wrote:
> "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes:
> > I have posted before about this but I am now posting to both NetBSD and
> > PostgreSQL since it seems to be some sort of interaction between the two.
> > I have a NetAPP filer on which I am putt
> But this only wins if a child process inheriting an open file also
> inherits copies of any locks held by the parent. If not, then the
> issue is moot. Anybody have any idea if file locks work that way?
> Is it portable??
>From RedHat 8.0 manages fork(2):
SYNOPSIS
#include
#in
D'Arcy J.M. Cain wrote:
On Thursday 30 January 2003 14:02, mlw wrote:
Forgive my stupidity, are you running PostgreSQL with the data on an NFS
share?
Yes, sorry. PostgreSQL is running from the local disk but the data is on the
mounted drive.
I'm not sure, I guess it could work, but N
On Fri, 31 Jan 2003, D'Arcy J.M. Cain wrote:
> On Thursday 30 January 2003 12:07, Tom Lane wrote:
> > Perhaps the next thing to do is to strace (ktrace, trace, truss,
> > whatever system-call tracing utility you got) the postmaster and
> > child processes. If we could determine what system call i
On Thu, 2003-01-30 at 15:56, Tom Lane wrote:
> The reason the TIP is
> still there is that there are platforms on which that stuff doesn't work
> very nicely. It's better to let the postmaster exit cleanly so that
> that state gets cleaned up. I have no idea what the comparable issues
> are for a
On Fri, Jan 31, 2003 at 10:57:17AM +0900, Curt Sampson wrote:
> Hm? DNS completely separates IPv4 and IPv6 addresses; they're different
> record types ("A" versus "") in the DNS "database".
>
> And the "interoperation" if IPv4 and IPv6 is pretty much not happening,
> if you're talking about th
On Fri, 31 Jan 2003, Caffeinate The World wrote:
>
> --- Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> > On Fri, 31 Jan 2003, Caffeinate The World wrote:
> >
> > >
> > > > But, we need help to create good documentation for tsearch !
> > > > This is main stopper for releasing of tsearch.
> > >
> > > I
Jan Wieck wrote:
> Looking at the arguments so far, nearly everyone who questions the Win32
> port must be vehemently against the Cygwin stuff anyway. So that camp
> should be happy to see it flushed down the toilet. And the pro-Win32
> people want the native version because they are unhappy with t
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > Assuming all your assumptions are right, why the hell is Oracle's and MS
> > SQL-Server's reputation that bloody good?
>
> They have marketing departments.
... As well as sizable systems integration departments devoted to the
platforms in question. Po
On Thursday 30 January 2003 18:32, Simon J. Gerraty wrote:
> Is postgreSQL trying to lock a file perhaps? Would seem a sensible thing
> for it to be doing...
Is that a problem? FWIW I am running statd and lockd on the NetBSD box.
--
D'Arcy J.M. Cain| Democracy is three wolves
http://www.d
Jeff Davis wrote:
> > What about it? Someone claimed in this thread that MySQL's Windows port
> > requires Cygwin. Is that true or not?
>
> It's been a while, but I know I've installed MySQL on windows without any
> separate step of installing Cygwin (I can't say 100% for sure that it didn't
>
> Jeff Davis wrote:
> >>What about it? Someone claimed in this thread that MySQL's Windows port
> >>requires Cygwin. Is that true or not?
> >
> > It's been a while, but I know I've installed MySQL on windows without any
> > separate step of installing Cygwin (I can't say 100% for sure that it d
On Thu, 2003-01-30 at 20:29, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > While I understand (and agree with) your (and Vince's) reasoning on why
> > Windows should be considered less reliable, neither of you have provided a
> > sound technical basis for why we should not hold the
On Thu, 2003-01-30 at 16:01, Vince Vielhaber wrote:
>
> Dave, Lamar and Katie can cheer now 'cuze this is the last comment
> I'm going to make on this. All others will be ignored, probably.
>
> The one thing I haven't seen from Dave, Lamar or Katie on this is
> reputation. You're all for the Po
> -Original Message-
> From: Greg Copeland [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2003 22:47
> To: Dave Page
> Cc: Tom Lane; PostgresSQL Hackers Mailing List
> Subject: Re: [mail] Re: [HACKERS] Windows Build System
>
> I have lost entire directory trees (and all associated data)
Man, I go away for one day, and look what you guys get into. :-)
Let me shoot out some comments on this.
First, clearly the Win32 port is going to have more port-specific code
paths than any other port, so it is going to require extra testing even
if it wasn't our first non-Unix port. You can e
Tom Lane wrote:
> But this only wins if a child process inheriting an open file also
> inherits copies of any locks held by the parent. If not, then the
> issue is moot. Anybody have any idea if file locks work that way?
> Is it portable??
An alternate way might be to use semaphores, but I can't
Jeff Davis wrote:
What about it? Someone claimed in this thread that MySQL's Windows port
requires Cygwin. Is that true or not?
It's been a while, but I know I've installed MySQL on windows without any
separate step of installing Cygwin (I can't say 100% for sure that it didn't
install some
81 matches
Mail list logo
