[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:
> > >
> > > > so the problem
[EMAIL PROTECTED] wrote on 01/05/2006 01:59:52 PM:
> 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.
---(end
[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 fr
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
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
fre
FYI, since there has been so much discussion. Have not reviewed license.
Also too busy to download. --Rick
http://www.oracle.com/technology/software/products/database/xe/index.html
[EMAIL PROTECTED] wrote on 11/02/2005 09:34:50 AM:
> On 11/1/05, Andrew Rawnsley <[EMAIL PROTECTED]>
wrote:
> >
>
[EMAIL PROTECTED] wrote on 10/31/2005 01:14:57 PM:
>
> And I daresay that this _can_ be an attractive thing to businesses,
> supposing they offer a "production release," gratis.
>
True, as long as there is no license clause for future revocation of the
free license at the vendor's whim. Kinda
[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
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 the
Tom Lane <[EMAIL PROTECTED]> wrote on 10/20/2005 03:11:23 PM:
> 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
--
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 woul
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
CHAR(
"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)
This is the salient sentence from the standard (that I've never personnally
thought much about before now).
"If CS has the NO PAD characteristic, then the pad character is an
implementation-dependent character different from any character in the
character set of X and Y that collates less than any
"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 go
[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 cou
[EMAIL PROTECTED] wrote on 10/17/2005 01:44:24 PM:
>
> (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 wi
[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
[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 tha
In this thread, no one has mentioned their dual license, which I think of
as more duplicitous than dual. Neither free as in freedom nor free as in
beer, really.
[EMAIL PROTECTED] wrote on 10/07/2005 12:45:39 PM:
> On Thu, 2005-10-06 at 23:00 -0400, Tom Lane wrote:
>
> > So, yeah, the above claim
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
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.
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 FOS
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.
http://firebird.sourceforge.n
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 /etc/nsswitch.
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 D
[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 U
[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 queri
[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
> 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 wel
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 mor
[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
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
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 Messa
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, A
[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 k
Mike Mascari 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 servers are
mo
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 diff
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 sin
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
[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 mac
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 it
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.
htt
"...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
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
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 m
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
...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
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,
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 thei
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.
Rick
>> 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 a
> 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
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 t
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 b
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
Do you not recommend autovacuum?
Rick
"Dann Corbit"
What does that mean?
Lonni J Friedman
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 -L/usr/lo
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 rows
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)
Bru
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
I prefer the FORTRAN66 construct
IF
where it jumps to label1 if 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.
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]
Jeff,
Your Googler must be busted
http://www.ncstech.com/weblogic/www/what/index.jsp?page=six&&cs=landwarrior
http://www.dpi.inpe.br/geopro/referencias/shekar_spatial_databases.pdf
http://www.waterwatch.com/process/plan-datamanage.htm
Rick
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
f
Thanks Joshua,
I just played with it and it is more flexible that Solaris. Linux allows
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 switches.
R
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 d
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
Bill, Madonna, and I are going out for beers after work. I'll mention it.
Richard Huxton
Don,
If the data is can be mapped as 2D or 3D Cartesian coordinates, you could
use spatial operators from PostGIS.
Rick
Don Isgit
85 matches
Mail list logo
