Quoting Dennis Gearon <[EMAIL PROTECTED]>:
> I've been using PG very lightly for quite awhile, (although I"ve read
> through all but the programmer's manual once or twice). I loved when I
> got to PG and it had Oracle like features, "A real database!". This is
> after using MySQL, which I first
On Sat, Oct 11, 2003 at 05:48:23PM -0700, Dennis Gearon wrote:
> projects.) I want to use as my main argument, the fact (at this time,
> only from my previous usage), that MySQL really doesn't have foreign
> keys or record locking, and Postgres does.
Define "really". Certainly, for some cases,
On Sat, Oct 11, 2003 at 10:11:49PM +0100, NK wrote:
> Trying to install Postgresql 7.3.4 using the Cygwin(the last
> version), I followed all the instructions.
Why don't you use the pre-built Postgresql package that is part of the
standard Cygwin distribution?
> After typing the "" ./configure
I've been using PG very lightly for quite awhile, (although I"ve read
through all but the programmer's manual once or twice). I loved when I
got to PG and it had Oracle like features, "A real database!". This is
after using MySQL, which I first though, "I'm programming a website off
a simple, e
On Fri, Oct 10, 2003 at 11:17:53PM +0100, Oliver Elphick wrote:
> I haven't got any further than this, but I wonder if this is something
> that would be useful to the whole project and not just to the
> distributions. Any comments?
None except that this is more or less how we manage multiple
inst
Trying to install Postgresql 7.3.4 using the Cygwin(the last version) , I followed all the instructions.
After typing the "" ./configure "" command, I typed "" make "" (i have installed the GNU make 8 ) but after the build-process the result was not "All of Postgresql is successfully made,Ready
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > What's really strange is that some other
> > queries perform fine but this one and a few others reliably takes this long
> > and behaves this way under explain analyze. It's as if there's something
> > specific abou
[EMAIL PROTECTED] ("Marc G. Fournier") writes:
> my personal question is how well any of this would even stand up in
> a court of law, or how would you enforce it?
If you get a threatening letter in the mail with all sorts of legal
verbiage such that you have to pay for a lawyer to interpret it,
t
[EMAIL PROTECTED] (Jonathan Bartlett) writes:
> However, the reason the industry switched to relational databases
> was that they cared more that they had consistent data that worked
> with multiple applications that was able to guarantee data integrity
> (i.e. - support for views, constraints, and
I need to add a column to a table. This table holds several thousand
records, has several indexes, and serves as the parent table to a few
child tables.
When I've done this in the past, it has taken quite a long time for
the ALTER TABLE command to complete.
So, what is the correct procedure for
Greg Stark <[EMAIL PROTECTED]> writes:
> What's really strange is that some other
> queries perform fine but this one and a few others reliably takes this long
> and behaves this way under explain analyze. It's as if there's something
> specific about this query that triggers the delay.
You haven'
On Thu, 2003-10-09 at 11:05, David Shadovitz wrote:
> I need to add a column to a table. This table holds several thousand
> records, has several indexes, and serves as the parent table to a few
> child tables.
>
> When I've done this in the past, it has taken quite a long time for
> the ALTER TA
On Sat, Oct 11, 2003 at 11:22:36AM -0400, Bruce Momjian wrote:
> Martijn van Oosterhout wrote:
> -- Start of PGP signed section.
> > Planning time?
>
> Uh, I thought the actual number reported by EXPLAIN ANALYZE includes
> parse/plan times, but now that you mention it, if it is timing things
> ins
[EMAIL PROTECTED] ("Dann Corbit") writes:
>> That's true of just about any software license.
>
> Where is the risk with a Berkeley style license?
... That AT&T might sue you for infringing on their UNIX code.
That this actually happened (albeit a long, long time ago) proves that
it is a risk th
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> That's very strange.
Not really. In the dummy example, the two indexes are exactly the same
size and so there is no reason for the planner to prefer one over the
other. (Note that the two plans have exactly the same estimated cost.)
In a real
15 matches
Mail list logo
