The Open Group publishes the Single Unix Standard (SUS); the IEEE publishes the POSIX standard. The latest version of POSIX is a subset of the latest version of the SUS, but only after a long coordination effort.
also montreal drivers know that we're in the jay-walking capital of the world.
Actually, the jay-walking capital of the world is Stockholm. In Sweden, a red light for pedestrians just means you're not insured if you get hit while on the street. It doesn't say anything about whether you're supposed to go or not.
We don't have a metric pound, why is there a metric tonne?
There is a metric pound, equivalent to 500 grams. When you go to a butcher you order meat in pounds rather than grams or kilograms. Not sure why, but everyone does it. There is also a Hundredweight (Zentner in German) equivalent to 50 kg (= 100 metric pounds) that you use to order coals for your oven. Again, a traditional thing.
Why are the Postgres people porting to Netware before Windows? I don't know -- I'm not on their team, but it seems a rather strange choice to me.
The port was done by someone not otherwise associated with PostgreSQL development (possibly from Novell, but he did not identify himself as such). Also, this port is not "official" in the sense that it is not integrated into the PostgreSQL source tree and won't be part of the upcoming 7.3 release.
The last I saw of the port was that a lot of Unix-specific stuff (shell scripts, build infrastructure, various C code) was completely rewritten using Netware-specific tools, so I'm kinda wondering how Novell (or whoever) plans to maintain this...
One feature I find really useful (I do lots of web programming) in MySQL that I couldn't find an equivalent of in Postgres is FULLTEXT indexes... The only thing I could find was a hack in the contrib repository...
Please explain why you think the solution in the contrib repository is a "hack".
And alternative solution, which is thought of by many as more sophisticated, is OpenFTS.
Fair enough. But note that the dash in the TODO list marks changes that will appear in the next release, not changes that might appear, should appear, or are hoped to appear.
If you want to know what's cooking, browse the mailing list archives of the developers' lists.
Anyway's let me tell you, pgsql's user permissions still make my head swim, it's a nightmare. I mean, ok there's like how many different ways to authenticate a user, plain text password, crypted password, now md5, ident, local ident, kerberos, etc etc.
Options are somtimes considered to be a good thing.
Seriously, what's the "preferred" way to add a normal, non super user, only has select, insert, update, and delete access to a given database that can connect from the local machine, and remotely. Is this even possible?
Add something like this to your pg_hba.conf:
local sameuser trust
host sameuser 127.0.0.1 255.255.255.255 trust
I guess another kind of oddity about the pgsql is that out of the box, it only does ident type local socket authetication, no tcp/ip.
We like the default setup to be reasonably secure.
I've looked forever, but I've yet to find a "mysql to postgresql" quick start guide.
Actually, the truth is that Red Hat has been planning this database thing for a long time and they have made sure that by the time they announced it their version number would match up with PostgreSQL's.
smaller base software/dependencies; BSD libc is much smaller than glibc;/bin/sh points to ash, so all shell and system scripts are ash processes (and not bloated bash processes)
FreeBSD's/bin/sh is one of the buggiest and brain-dead Bourne shells in existence. No thanks.
And please don't bring up MySQL or postgreSQL (you haven't so far, and I am grateful). If you want cheap web transactions fine, but I am talking
about true DB apps where you need row-level locking, rollback, transactions, etc.. all the things That the above mentioned RDBMS's have.
You're kidding, right? I can't imagine going through a day without the command line in Linux, even if I tried.
It's possible, surely...
You want examples? Well, with most Linux programs, you need to use the command line to build and install them. In some cases (ok, a lot of cases) you might be lucky enough to find an RPM. Well, so what? You install the RPM, and then what? How do you start the program?
You select it from the KDE/Gnome menu. Your distro doesn't do that? Too bad. Alternatively, you can also click on it in the file manager.
Another example -- drivers. How do you install new drivers in Linux?
You don't. Hardware is detected and configured automatically these days. New drivers come as packages or package updates.
I have been using Linux for two and a half years, BTW. It has been my primary OS for most of that time. I am running on a custom-compiled 2.4.2 kernel under Debian/unstable right now -- I know how Linux works. But the simple fact is that Linux is not (yet) as easy to use as Windows. I eagerly await the day when it is, but there is just so much work that needs to be done before that happens. I'm sorry, but it's the truth.
Maybe try a more recent distro. You could be surprised.
I think the whole "envelope" analogy is mostly phony. The real reason that most people use envelopes is for physical protection (wear and tear, dirt) and for packaging convenience (folded letters, more than one sheet). If I had to send something secret I sure would try harder than an envelope.
A more appropriate analogy are the specially shielded and sealed envelopes that banks occasionally use to send you new PIN codes. But when was the last time you used one of those?
The SQL standard allows (multiple) NULLs in unique indexes. The relevant portion reads: (8.9 GR 2)
If there are no two rows in T such that the value of each column
in one row is non-null and is equal to the value of the corresponding column in the other row according to Subclause 8.2,
"<comparison predicate>", then the result of the <unique predicate> is true; otherwise, the result of the <unique predicate>
is false.
The PostgreSQL HOWTO at the LDP was written by a moron and is in no relation to the PostgreSQL project. Just a couple of days ago the LDP webmaster finally yanked it.
Slashdot Mirror
How does this compare to Skolelinux, an existing Debian-derived distribution used in schools? Or is it just NIH?
Well, the name is not "Postgre" in the first place, just as much as the name of that other product is not "My".
The Open Group publishes the Single Unix Standard (SUS); the IEEE publishes the POSIX standard. The latest version of POSIX is a subset of the latest version of the SUS, but only after a long coordination effort.
Actually, the jay-walking capital of the world is Stockholm. In Sweden, a red light for pedestrians just means you're not insured if you get hit while on the street. It doesn't say anything about whether you're supposed to go or not.
According to the list of supported platforms, it doesn't.
I'm Peter Eisentraut, I'm quoted in this article, but I never knew I was doing an "interview".
There is a metric pound, equivalent to 500 grams. When you go to a butcher you order meat in pounds rather than grams or kilograms. Not sure why, but everyone does it. There is also a Hundredweight (Zentner in German) equivalent to 50 kg (= 100 metric pounds) that you use to order coals for your oven. Again, a traditional thing.
Correction, the limit is 1 GB per column. Rows can be longer than you really care to know.
The port was done by someone not otherwise associated with PostgreSQL development (possibly from Novell, but he did not identify himself as such). Also, this port is not "official" in the sense that it is not integrated into the PostgreSQL source tree and won't be part of the upcoming 7.3 release.
The last I saw of the port was that a lot of Unix-specific stuff (shell scripts, build infrastructure, various C code) was completely rewritten using Netware-specific tools, so I'm kinda wondering how Novell (or whoever) plans to maintain this...
No, the limit is 1 GB on all systems.
Please explain why you think the solution in the contrib repository is a "hack".
And alternative solution, which is thought of by many as more sophisticated, is OpenFTS.
If you want to know what's cooking, browse the mailing list archives of the developers' lists.
Well, we've just released 7.2 so you can't expect that anything is already done for 7.3.
Options are somtimes considered to be a good thing.
Seriously, what's the "preferred" way to add a normal, non super user, only has select, insert, update, and delete access to a given database that can connect from the local machine, and remotely. Is this even possible?
Add something like this to your pg_hba.conf:
I guess another kind of oddity about the pgsql is that out of the box, it only does ident type local socket authetication, no tcp/ip.
We like the default setup to be reasonably secure.
I've looked forever, but I've yet to find a "mysql to postgresql" quick start guide.
try here
Also, would it be darn nice to include a start/stop script that reads only config files and can be linked from
It's in contrib/start-scripts. Or you might as well download the RPMs.
Actually, the truth is that Red Hat has been planning this database thing for a long time and they have made sure that by the time they announced it their version number would match up with PostgreSQL's.
INGRES and POSTGRES were two separate projects at Berkeley that shared no code. PostgreSQL is based on the latter.
See also the POSTGRES FAQ.
FreeBSD's
The interesting thing here is that they changed the original "two" to "a few" after the third one got hired.
If you looked carefully you would find several PostgreSQL replication solutions being developed. Some of them are known to hobble along.
Time to upgrade.
PostgreSQL has all these things.
It's possible, surely...
You want examples? Well, with most Linux programs, you need to use the command line to build and install them. In some cases (ok, a lot of cases) you might be lucky enough to find an RPM. Well, so what? You install the RPM, and then what? How do you start the program?
You select it from the KDE/Gnome menu. Your distro doesn't do that? Too bad. Alternatively, you can also click on it in the file manager.
Another example -- drivers. How do you install new drivers in Linux?
You don't. Hardware is detected and configured automatically these days. New drivers come as packages or package updates.
I have been using Linux for two and a half years, BTW. It has been my primary OS for most of that time. I am running on a custom-compiled 2.4.2 kernel under Debian/unstable right now -- I know how Linux works. But the simple fact is that Linux is not (yet) as easy to use as Windows. I eagerly await the day when it is, but there is just so much work that needs to be done before that happens. I'm sorry, but it's the truth.Maybe try a more recent distro. You could be surprised.
A more appropriate analogy are the specially shielded and sealed envelopes that banks occasionally use to send you new PIN codes. But when was the last time you used one of those?
The PostgreSQL HOWTO at the LDP was written by a moron and is in no relation to the PostgreSQL project. Just a couple of days ago the LDP webmaster finally yanked it.