> > I wasn't really comparing to MySQL here. I meant, in relationship
> > to MS Access. Start it up and it just works.
>
> Yeah, a point-and-drool installation wizard for postgres under windows
> would be great. I think, from looking at PGAdminII, that we've already
> got great admin tools; it see
> What other development options do we have for soemthing that is GUI and
> portable to all platforms that postgresql runs on? Java? wxWindows? Qt?
> Gtk? I would think that Gtk is probably the most portable, and it has
> bindings to many languages, but we would probalby want to use C.
TOra u
> OK, I want to know, does anyone see MySQL gaining in market share in
> comparison to PostgreSQL, or is MySQL gaining against other databases?
> Is MySQL gaining sites faster than we are gaining sites?
>
> Every indication I can see is that PostgreSQL is gaining on MySQL.
>
> The Linux/FreeBSD co
I have noticed that unlike indexes/check constrains, "ALTER TABLE ADD
CONSTRAINT FOREIGN KEY ..." statement does NOT prevent a user from
re-creating an existing constraint more than once. Following this, a pg_dump
on the table showed multiple entries of the foreign key constraint/trigger
definiti
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Do people want an advocacy article written, like "How to choose a
> database?" I could do that.
That would be good, as would an updated "postgres vs mysql" article
to point people towards. Or a "postgres myths debunked" page.
> Basically, I am
I'd have to say that personally, given a choice between expending effort
to fix current know bugs and add known needed features, and expending
effort to port to Windows, I'd pick the former, not the latter.
I could personally care less if postgresql ever runs as a native window
application, si
I don't normally post to this list, but have a crazy suggestion that is a
little farfetched.
Suggestion:
Fix the portability problems so that there is a Windows native version of
PostgreSQL. Then offer the Open Office organization PostgreSQL as the
project's database. This would increase the
On Tue, Jun 25, 2002 at 04:25:24PM +0200, Tycho Fruru wrote:
> Everyone should use and support the tools that fit the bill.
I've mentioned before, however, that "the tools that fit the bill" is
partly a function of network effects. The *BSD guys have the same
problem when facing the Linux jugge
...
> Adding a new expression node tree type is not too difficult these days;
> see for example Joe Conway's recent NullTest and BooleanTest additions.
> I believe the existing expansions of row comparison operators
> (makeRowExpr) should be replaced by specialized nodes, too. That would
> give u
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> IIRC, a function is only considered to be a cast function if it matches
>> by name *and schema* with the target type. So if you, for example,
>> make a function public.int4(something), it'll never be considered a
>> cast function for pg_catalog.int4.
IMO One of the big reasons that MySQL is viewed as being better is it's
percieved simplicity. It has a large following because of this, and many
of them are not experienced database users, in fact just the opposite.
This large user base is perhaps the best marketing that an open source
project ca
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Can we mmap WAL without problems? Not sure if there is any gain to it
> > because we just write it and rarely read from it.
>
> Perhaps, but I don't see any point to it.
Agreed. I have been poking around google looking for an arti
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Can we mmap WAL without problems? Not sure if there is any gain to it
> because we just write it and rarely read from it.
Perhaps, but I don't see any point to it.
regards, tom lane
---(end of broadca
> Another possibility is that you got burnt by some schema-related issue;
> cf the updated conversion docs at
> http://developer.postgresql.org/docs/postgres/typeconv-func.html
I'll bet that is it, though possible differences in CAST() behaviors are
not explained. I'll see if I can reproduce them
Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > On Tue, 25 Jun 2002, Tom Lane wrote:
> >> The other discussion seemed to be considering how to mmap individual
> >> data files right into backends' address space. I do not believe this
> >> can possibly work, because of loss of contro
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > This will also work well when we have non-SysV semaphore support, like
> > Posix semaphores, so we would be able to run with no SysV stuff.
>
> You do realize that we can use Posix semaphores today? The Darwin (OS X)
> port uses 'em
"Mario Weilguni" <[EMAIL PROTECTED]> writes:
> Isn't that what msync() is for? Or is this not portable?
msync can force not-yet-written changes down to disk. It does not
prevent the OS from choosing to write changes *before* you invoke msync.
For example, the HPUX man page for msync says:
Isn't that what msync() is for? Or is this not portable?
-Ursprüngliche Nachricht-
Von: Tom Lane [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 25. Juni 2002 16:30
An: Curt Sampson
Cc: J. R. Nield; Bruce Momjian; PostgreSQL Hacker
Betreff: Re: [HACKERS] Buffer Management
Curt Sampson <
Curt Sampson <[EMAIL PROTECTED]> writes:
> On Tue, 25 Jun 2002, Tom Lane wrote:
>> The other discussion seemed to be considering how to mmap individual
>> data files right into backends' address space. I do not believe this
>> can possibly work, because of loss of control over visibility of data
On Tue, 2002-06-25 at 07:21, Tom Lane wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > Frankly, my feeling is, as a "geek-to-geek" product, PostgreSQL is already
> > adequately marketed through our huge network of DBA users and code
> > contributors.
>
> Well, mumble ... it seems to me that
Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > So, while we're at it, what's the current state of people's thinking
> > on using mmap rather than shared memory for data file buffers?
>
> There seem to be a couple of different threads in doc/TODO.detail/mmap.
>
> One envisions mma
On Tue, 25 Jun 2002, Tom Lane wrote:
> The only thing you'd really have to think about is how to replace the
> current behavior that uses shmem attach counts to discover whether any
> old backends are left over from a previous crashed postmaster. I dunno
> if mmap offers any comparable facility.
On Tue, 2002-06-25 at 09:09, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > So, while we're at it, what's the current state of people's thinking
> > on using mmap rather than shared memory for data file buffers?
>
[snip]
>
> (Hey Marc, can one do mmap in a BSD jail?)
I believe th
Curt Sampson <[EMAIL PROTECTED]> writes:
> So, while we're at it, what's the current state of people's thinking
> on using mmap rather than shared memory for data file buffers?
There seem to be a couple of different threads in doc/TODO.detail/mmap.
One envisions mmap as a one-for-one replacement
So, while we're at it, what's the current state of people's thinking
on using mmap rather than shared memory for data file buffers? I
see some pretty powerful advantages to this approach, and I'm not
(yet :-)) convinced that the disadvantages are as bad as people think.
I think I can address most
Curt Sampson wrote:
> On Mon, 24 Jun 2002, Tom Lane wrote:
>
> > There are a lot of other things we desperately need to spend time
> > on that would not amount to re-engineering large quantities of OS-level
> > code. Given that most Unixen have perfectly respectable disk management
> > subsystem
hi
i want to alter the ALTER TABLE xxx ADD statement to allow
the following syntax:
ALTER TABLE [ ONLY ] table
ADD [ COLUMN ] ( column type [ column_constraint ] [, column type [
column_constraint ]] )
just to add one or more columns to a table with one alter table statement.
i know .. i
Hi,
I corrected a few minor problems with the patch I sent Friday allowing
IDENT authification to recognize encrypted responses.
Thanks,
David
ident-des.pgsql.tar.gz
Description: GNU Zip compressed data
---(end of broadcast)---
TIP 2: you ca
Hiroshi Inoue <[EMAIL PROTECTED]> wrote:
> Julian Mehnle <[EMAIL PROTECTED]> wrote:
> > Recently I tried to use the new 7.02.0001 Win32 ODBC driver in the new
> > (beta) Unicode mode in conjunction with MS Access 2000 and a "UNICODE"
> > encoded database stored in a PostgreSQL 7.2.1 database runnin
On Tue, 25 Jun 2002, Tom Lane wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > Frankly, my feeling is, as a "geek-to-geek" product, PostgreSQL is already
> > adequately marketed through our huge network of DBA users and code
> > contributors.
>
> Well, mumble ... it seems to me that we are de
> The second seems more user-friendly but also seems to violate the
> principle of least surprise. Anyone have an opinion about what to do?
Sounds like a logical argument, given normal OO behaviour.
Hope it inspires someone to implement DROP COLUMN :)
Chris
---(end
If you define a database field like this with the "without time zone"
clause.
created timestamp(6) without time zone DEFAULT 'now' NOT NULL,
Then the current postgresql jdbc driver falls over in a heap when trying
to select and retrieve this field.
---(end of
32 matches
Mail list logo
