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
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
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
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 the
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 the
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 sys/types.h
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 single
Christopher Browne wrote:
snip
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
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 actually a
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, 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 to
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 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 be
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 subset of
Christopher Browne wrote:
snip
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
- 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 there
-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 into. :-)
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 things
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],
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 actually a
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
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
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 certainly
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.55dir /s *.dll, *.exe
Volume in drive E has no label.
Volume Serial Number is 7496-C335
Directory of
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 developers
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 using the
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
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
-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 or not, if
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
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:
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/
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'm
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 -
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
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.
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
-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,
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
-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)
on
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 other
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 darcy@{druid|vex}.net | Democracy is three
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. PostgreSQL
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 am currently using
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, 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 is
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
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 putting a
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 so here
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 darcy@{druid|vex}.net | Democracy is three wolves
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
-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 been
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 short
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 MySQL
-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 search:
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
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 will
-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 going to guess and
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
the
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 setup,
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
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
Dave Page wrote:
snip
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
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 aggregates),
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
Bruce Momjian wrote:
snip
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
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 transaction
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
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 can
69 matches
Mail list logo