[EMAIL PROTECTED] wrote on 01/05/2006 01:59:52 PM:
snip
so the problem is that MySQL _forces_ a consistent state but in the
process it violates the integrity of the data
That is a contradiction in terms. Data integrity is a requirement of
database consistency.
[EMAIL PROTECTED] wrote on 01/05/2006 04:00:37 PM:
On Thu, 5 Jan 2006 15:11:49 -0500
Jaime Casanova [EMAIL PROTECTED] wrote:
On 1/5/06, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 01/05/2006 01:59:52 PM:
snip
so the problem is that MySQL _forces_
[EMAIL PROTECTED] wrote on 11/17/2005 12:33:11 PM:
On Wed, Nov 16, 2005 at 02:19:28PM -0500, Vivek Khera wrote:
On Nov 16, 2005, at 1:09 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
There are a few obstinate anti-open source customers though, that
prevent my plan from moving
I beg to differ. Read this link. New today. Also announced to all
members of the OTN today. --Rick
http://www.oracle.com/technology/products/database/xe/index.html
[EMAIL PROTECTED] wrote on 11/03/2005 11:36:35 AM:
Again, the previously provide link is NOT the version that is licensed
I agree it is the same old software. The point is that they are changing
the license. Note the text from the download window:
Note: The current license is for Beta testing purposes only. It does not
include terms, such as free redistribution and embedding (read the FAQ),
that will be available
Highlights from the license: My thoughts. This is not free, not even as
in beer. Only good for a year. No production use (which is more
restrictive than no commercial use. IANAL) You have to pay when they
release it.
Quotes (with my bolding)
grants to you a no-charge trial license to use
[EMAIL PROTECTED] wrote on 10/31/2005 12:02:07 PM:
Perhaps I'm the only one to actually have read the article?
Okay, yeah. I went straight for the license. I have now read the article
and agree with you.
---(end of broadcast)---
TIP 5: don't
[EMAIL PROTECTED] wrote on 10/31/2005 01:14:57 PM:
snip
And I daresay that this _can_ be an attractive thing to businesses,
supposing they offer a production release, gratis.
snip
True, as long as there is no license clause for future revocation of the
free license at the vendor's whim.
I will happily reiterate that I am the troll who started this mess by
whining about how *Oracle* handles this. Tom's explanation that CHAR is
has a PAD collation and VARCHAR has a NO PAD collation have restored my
faith that there is goodness in the world. My whining was out of
ignorance. I
Tom Lane [EMAIL PROTECTED] wrote on 10/20/2005 03:11:23 PM:
snip
The hard part would be in figuring out how
the output routine could know how many spaces to add back.
The length is in the metadata for the column, or am I being dense?
regards, tom lane
[EMAIL PROTECTED] wrote on 10/19/2005 12:35:25 AM:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Strangely a pgsql to oracle exporter is a good thing. It'd be a great
feature of PostgreSQL. Imagine how many people would start on
PostgreSQL if they KNEW that one day they could
Marc G. Fournier [EMAIL PROTECTED] wrote on 10/19/2005 01:02:15
PM:
On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 10/19/2005 12:35:25 AM:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Strangely a pgsql to oracle exporter is a good thing. It'd be a
Dann Corbit [EMAIL PROTECTED] wrote on 10/19/2005 04:33:23 PM:
Doesn't NO PAD connect to the collating sequence (CS) rather than the
data type?
Yep. Back to the mental drawing board.
BTW, the ordering of posts when they come to my mailbox is really weird.
ISO/IEC 9075-2:1999 (E)
Okay, since the standard explicitly says that whether 'a' = 'a ' is a
well-defined characteristic of a character datatype (NO PAD) I'm happy with
both Oracle and PostgreSQL. If you want a certain behavior, choose your
datatypes wisely. Cool. I didn't in a recent port. Uncool. I went from
[EMAIL PROTECTED] wrote on 10/17/2005 01:44:24 PM:
snip
(BTW, has anyone looked lately to see how far away Postgres is from
being able to run SAP?)
Uh, Tom? Are you in the habit of waiving red capes in front of bulls? :)
I assume the question was rhetorical, due to MySQL's capability gap
[EMAIL PROTECTED] wrote on 10/11/2005 09:59:16 PM:
Jan Wieck [EMAIL PROTECTED] writes:
And look at it, all Oracle would have to do is to be so open source
friendly that they make InnoDB GPL only. Can you imagine the confusion
in the MySQL fan club if Oracle releases the next GPL version
[EMAIL PROTECTED] wrote on 10/09/2005 08:16:22 AM:
This is the first time I can think of where software being GPL'd might
actually hurt the open-source community.
The MySQL license has been modified so that it is, IMHO, not compatible
with the GPL. The basic tenet of the GPL is that I
You could look at what SELinux extensions now available in at least the Red
Hat (and Fedora) distro offer. I have never done anything with SELinux,
and a quick review of the archives indicates it is not a slam dunk to use.
It is designed to create the kind of restrictive environment you describe.
Check it out.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Aaron,
If you are new to free software, it is best to familiarize yourself with
the different types of licenses, and especially with the concept of
copyleft:
http://www.fsf.org/fsf/licensing
BSD, LGPL, and GPL are all very different animals, and representative of
many of the licenses used in
Firebird is a nice, small, ACID compliant database that embeds well.
firebird.sourceforge.net
Hi John,
Unix sockets are a presentation layer interface to TCP/IP. You're not
avoiding it by using them.
Rick
John Zubac
[EMAIL PROTECTED]
Firebird has MVCC also (they call it multi-generational record architecture
--- MGRA), and may have at least a good test plan, though it may not cover
effects of rules, triggers, functions, and constraints. Those are the
killer test cases. I don't have time to look.
I'd start by comparing the /etc/nsswitch.conf files on the various
machines. If the second column contains files for passwd and hosts on
the fast machines, and dns on the slow machine, then change the slow
machine to files and see if it speeds up. That's an easy way to rule out
or condemn DNS.
Sorry to re-reply, but I had a much simpler idea. From the client machine
that is slow to connect, type the command nslookup hostname1. If it
takes 15 seconds. If it does, DNS is the problem.
Rick
[EMAIL PROTECTED] wrote on 08/04/2005 03:01:31 PM:
I'd start by comparing the
[EMAIL PROTECTED] wrote on 07/15/2005 02:49:09 PM:
On Fri, Jul 15, 2005 at 20:08:32 +0300,
Andrus [EMAIL PROTECTED] wrote:
So I'll think still continuing to use null as unrestricted department
access.
Is it reasonable to create unique constraint using
CREATE UNIQUE INDEX
[EMAIL PROTECTED] wrote on 07/14/2005 10:38:43 AM:
On Thu, 2005-07-14 at 14:32 +1000, Neil Conway wrote:
Alvaro Herrera wrote:
I don't think you can use just plpgsql's parser. ... it
relies on the main backend parser
If you're content to treat expressions and SQL queries as
[EMAIL PROTECTED] wrote on 07/13/2005 02:59:02 PM:
On Wed, Jul 13, 2005 at 12:53:15PM -0400, Alvaro Herrera wrote:
we are developing GNUmed, a medical practice management
application running on PostgreSQL (you want your medical
data to be hosted by something reliable, don't you ;-)
Out of curiosity, what other backends do you consider and what is their
syntax for such problems.
Most folks that use Oracle's PL/SQL like it. I have a sneaking suspicion
Oracle used the GNAT parser for Ada as a starting point, but that is pure
conjecture. Oracle does document that PL/SQL is
I post to this list occasionally, and yet get maybe one spam email a month.
YMMV. Don't tell anyone, but I got a line on a great deal in Nigeria.
Rick
[EMAIL PROTECTED] wrote on 06/07/2005 09:56:16 PM:
Wes wrote:
It seems that for some time this list has been mirrored to Usenet
without
Some comments:
I've just been sent this link by our DBA (pro MySQL but even more
Anti-Postgres):
I can see skript kiddies preferring MySQL, but a DBA? Time for a
credentials review.
Firebird is a good small database (small resource footprint) that handles
small databases with many users
I'm cross posting this because it is an excellent opportunity for students.
I was a paid intern (studying pterodactyls), and my company employs paid
interns to perform well bounded summer projects. The intern gains
invaluable industry experience and a semester's worth of tuition (or beer).
One
[EMAIL PROTECTED] wrote on 05/19/2005 11:35:07 AM:
...We are proposing that Postgres be used for the application
database.
Not too surprisingly we are being asked for additional
information because
Postgres is open source.
So is the implication that they think open source is a bad
Isn't there some way to trick PostgreSQL with a RAM disk, like for the WAL?
Rick
[EMAIL PROTECTED] wrote on 05/11/2005 02:31:55 PM:
Why? Any specific reason that you are aware of ?
Are there any writes done to the database when read only SQL
statements are issued?
-Original
Tom Lane suggested a vacuum freeze (? or something like that) for archival
read only data. I got the impression the template databases are freeze
dried for freshness (good to the last bit?) That feature might help as
well in the transition from read-write to read-only.
Rick
For portability's sake commit successful transactions and rollback those
that fail.
Rick
[EMAIL PROTECTED] wrote on 04/25/2005 05:53:11 PM:
Dann Corbit [EMAIL PROTECTED] writes:
Probably, turning fsync off would be helpful, since you know it is
read-only.
Wouldn't make any difference: a
Mike Mascari mascarm@mascari.com wrote on 04/25/2005 09:21:02 PM:
[EMAIL PROTECTED] wrote:
In my *utter* lack of enthusiasm over this option, I was gathering
ammunition for better hardware. I went to spec.org for speed
comparisons,
and sun.com for price comparisons. Sun's *entry* level
[EMAIL PROTECTED] wrote on 04/25/2005 09:19:57 PM:
On Sat, 23 Apr 2005, Uwe C. Schroeder wrote:
Well, you overlook one thing there. SUN has always has a really good
I/O
performance - something far from negligible for a database application.
A lot of the PC systems lack that kind of
Sun's stock was at $65.00 in late 2000 and has rocketed to $3.50. I think
somebody else besides us noticed too.
[EMAIL PROTECTED] wrote on 04/26/2005 01:12:49 PM:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brent Wood
Sent: Monday, April 25,
I am looking at options for a customer with an installed base of ~5000 Sun
workstations running 400-500MHz UltraSPARCs. They're not getting the
performance they need. They shipped me two Tadpole Bullfrog machines, a
Bullfrog I and a Bullfrog II for evaluation.
http://www.tadpole.com
1.28GHz
[EMAIL PROTECTED] wrote on 04/22/2005 10:08:46 AM:
On Fri, 2005-04-22 at 09:48, [EMAIL PROTECTED] wrote:
I just got done comparing SPECMarks (on spec.org) between Sun's AMD
entry
level servers versus similarly configured UltraSPARCs versus desktop
AMD
based machines. Sun's AMD machines
I just got done comparing SPECMarks (on spec.org) between Sun's AMD entry
level servers versus similarly configured UltraSPARCs versus desktop AMD
based machines. Sun's AMD machines are twice as fast as their UItraSPARCs,
for approximately the same price. What a hoot.
Rick
As an academic exercise it would be interesting to try and create the
*next* RDBMS query language. In a production environment I do think the
idea is crazy.
I've got a little experience with this. Interbase used to support a more
procedural query language called GDML (along with SQL). I used
FYI,
MITRE, a nonprofit think tank catering to the US Department of Defense
(DoD), wrote an interesting study about the use of FOSS in the US Military.
PostgreSQL is not mentioned, but MySQL is. Seems to be an interesting
relaxation trend in the DoD, for those of us who do this kind of work.
...and very interesting.
The Date book should be required reading in computer science 101, but very
interesting implies that your only other hobby is watching grass grow.
Rick
An idea I like, because I have entrenched windows clients also, is to run
things that run best under Linux on VMWare (vmware.com) and to run good
Windows things (like desktop apps) under Windows. Linux can be either the
host or guest OS under VMWare, so the options of which OS is truly in
control
Thanks Magnus,
Just the information I need. Is this the case if Linux is the host (and
running PostgreSQL) and Windows is the guest running under VMWare? I care
about the data in the Linux realm. I could give a rip if a PowerPoint
presentation gets hosed. On the other hand, if it lost one of
But no Windows support yet. Needs future hardware: new Intel hardware for
better support of virtualization. VMWare is drooling over the upcoming
Intel support also.
Rick
...it will be the first time they have seen your name... ...with your first
email have criticised the project...
Check the archives. This poster has been active on the list for awhile.
Cheers,
Rick
Okay, I'll split them with you. I remember the Groton Database Corp. of
Groton Connecticut, whose marketing people didn't like the sound of
*Groton*, and renamed the company Interbase and the product InterBase (note
caps). Ashton Tate came along years later and bought the company to
increase
I don't think so, if you consider a troll to be someone who doesn't care
about the topic, but rather wishes to stir up newbies and flamers. A
search of the archives shows the sender has a history of asking valid
questions and offering advice on-topic.
That said, the result is the same.
Cheers,
For scalability the new tablespaces are a major improvement, in that they
allow enhanced allocation of portions of the database to different disks.
This can massively improve speed in RAID environments, or even just
multi-disk environments. PITR isn't a big deal for me, but might be for
you.
Additional Trigger Syntax (ie Oracle):
I'm not seeing anything there more than syntactic sugar that PostgreSQL
doesn't support, but no, it doesn't take that syntax.
Milla's syntax doesn't show that Oracle allows column level triggers.
That's the only difference I've noted. Column triggers are
Running the app and dbms in the same process
space will not guarantee that bugs in app will not mess up the database.
By embedded I thought we were saying *invisible to the user*. I agree that
having the database back end linked into user processes is dangerous. I
don't know if you can still
Do you need something from PostgreSQL that Firebird doesn't have? My
experience has been that Firebird/Interbase is a fairly complete, ACID
compliant, low/no maintenance back end for single workstation applications.
On the other hand, you can make any RDBMS into an embedded database with
enough
The trick is making database administration invisible to the user. Since
Firebird requires no administration, it's easy. The single file database
architecture in Firebird is also easy since you generally have only one
drive.
The only administration item presented to the user should be a dialog
If you explicitly name your schemas (including public) in all of your SQL
it will port easily to Oracle.
Chris
I don't think there are any Amish PostgreSQL users.
Geoffrey
What does that mean?
Lonni J Friedman
Do you not recommend autovacuum?
Rick
Dann Corbit
The problem may be in your /etc/syslog.conf file. It directs different
classes of messages different places, and can direct them to another
machine.
Rick
Did you add the path to where the libpq lives to your LD_LIBRARY_PATH? I
haven't tried this, but that may be the problem. Alternatively you can add
the path to the link command using -L (I think.)
e.g. on my machine
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib
or
gcc
PFC wrote: I'd really like to have a sql command, say MOVE, or SELECT AND
DELETE, whatever, which acts like a SELECT, returning the rows, but
deleting them as well.
Oracle implements this with the syntax DELETE FROM ... RETURNING ...;
There is also UPDATE ... RETURNING ...;
Where the deleted
I installed pgadminIII and really enjoy their built in documentation reader
for PostgreSQL. The documentation that came with pgadminIII had been
updated for the new version 8 features.
Rick
I understand your pain, because PL/SQL is so close to plpgsql the functions
should just drop into quotes with renamed parameters, but they don't.
Using another language makes the port more difficult.
Have you considered functions that store the variable value in the database
and read it back from
The FSF site explicitly says that free software is not free, it's about
freedom. I don't think the idea is to let your kids starve. --Rick
I blew the parenthesis around the conditional expression also. Hence the
*old* comment.
(Embedded image moved to file: pic14771.jpg)
I prefer the FORTRAN66 construct
IF condition label1 label2 label3
where it jumps to label1 if condition is negative, label2 if zero, and
label3 if positive. No else ifs about it.
I hope you realize I'm as kidding as I am obviously too old.
Don't get used to Ada. It's almost as dead as COBOL, though I liked it too
for some things. Oracle plsql is s Ada-like I've literally cut and
pasted whole Ada routines into Oracle plsql and they work without
modification. PostgreSQL doesn't do parameters and packages, so it is
slightly more
Oracle and PostgreSQL schemas seem to have fairly equivalent functionality
from what I've read, except that PostgreSQL schemas aren't as tied to a
particular user as are Oracle's.
I've not seen a post in days on many of the lists to which I subscribe.
--Rick
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Jim,
How about having the trigger write the pk of the table to a new table. The
backend processing could then just join the new table on the pk to the
existing table to give you a proper result set. In the same transaction
delete the contents of the new pk table. Not as efficient as setting a
Jeff,
Your Googler must be busted
http://www.ncstech.com/weblogic/www/what/index.jsp?page=sixcs=landwarrior
http://www.dpi.inpe.br/geopro/referencias/shekar_spatial_databases.pdf
http://www.waterwatch.com/process/plan-datamanage.htm
Rick
Hi Chris and Karim,
I haven't been following this thread, so excuse me if I suggest something
that has already been tossed out.
Solaris allows multiple IP addresses to be assigned to a single NIC. I
just looked at the man page for Linux ifconfig but didn't see quickly how
to do this. If Linux
Thanks Joshua,
I just played with it and it is more flexible that Solaris. Linux allows
alias to be four characters, but Solaris only allows low numbers. I like
this:
ifconfig eth0:dbms 192.1.1.100 up
Tino's right about the ARP tables. Gotta watch that one, especially with
lower grade
Mark,
There is a net.kkkOOk trying to disrupt our list with scatology. A good
time is not being had by any. The kkkOOk is spoofing email headers to look
like valid users. We can do little but ignore the juvenile.
Rick
I'm getting more spam also, though not an inordinate amount. A couple a
week.
The guy from UAE who wants to send me millions, and the v drug.
Didn't happen when I signed on months ago.
Kari,
Why not select count(*) from the table and multiply it by a true 0.0 - 1.0
pseudo random number generator? Then adjust the outcome for the range of
uids. If the uids (or some other column) are contiguous starting at 0,
this would be a snap.
Rick
Interesting about the meta DDL. I wrote a very small language called QDL
for Query Description Language that uses the same idea. You feed QDL and
the SQL schema into the compiler and it writes C modules with embedded SQL.
Makes porting my application from one database to another a snap from the
I've worked with Oracle, Interbase, and Informix. PostgreSQL is the most
SQL spec compliant of any of them, whether the spec is 89, 92, or 03. I
have not worked with MySQL.
Rick
Don,
If the data is can be mapped as 2D or 3D Cartesian coordinates, you could
use spatial operators from PostGIS.
Rick
Don
Bill, Madonna, and I are going out for beers after work. I'll mention it.
Richard Huxton
82 matches
Mail list logo