On Tue, Sep 24, 2002 at 03:59:33AM -0400, Vince Vielhaber wrote:
On Tue, 24 Sep 2002, Gavin Sherry wrote:
Hi all,
It occurs to me that opening web page on www.postgresql.org, asking the
user to select the mirror, is rather unprofessional. I am sure this has
been discussed before but
On Tue, Sep 24, 2002 at 11:26:55AM -0400, Vince Vielhaber wrote:
On Tue, 24 Sep 2002, Ross J. Reedstrom wrote:
I'd suggest setting a cookie, so I only see the 'pick a mirror' the
first time. And provide a link to 'pick a different mirror' that resets
or ignores the cookie.
Or choose
Ah, so Ben finally got around to posting here. Ben's a CS Grad student
here at Rice. His (current) project involves taking some interesting
results from constraint satisfaction and implementing them on a database:
one of the CS faculty has demonstrated that one class of highly joined
DB queries
On Mon, Nov 04, 2002 at 08:10:29PM -0500, Mike Mascari wrote:
Actually, I was thinking along the lines of a true CREATE
DATABASE LINK implementation, where multiple databases could
participate in a distributed transaction. That would require the
backend in which the main query is
On Wed, Oct 30, 2002 at 10:59:39PM -0500, Tom Lane wrote:
What's the basis for your assertion that it's planning things that
don't need it? Given a JOIN-constrained query I do not believe the
planner will look at any cases other than the intended join order.
Well, that was a loose choice of
On Tue, Nov 05, 2002 at 08:54:46PM +0900, Satoshi Nagayasu wrote:
Hannu Krosing [EMAIL PROTECTED] wrote:
In protocol-layer 2PC, no new SQL command is required.
A precommit-vote-commit phase will be called implicitly. It means an
user application can be used without any
On Wed, Nov 06, 2002 at 05:02:14PM +0900, Satoshi Nagayasu wrote:
Hannu Krosing [EMAIL PROTECTED] wrote:
Exactly. When user send the COMMIT command to the master server, the
master.talks to the slaves to process precommit-vote-commit using the
2PC. The 2PC cycle is hidden from user
Hey Hackers -
I was testing beta5 and found a performance regression involving
application of constraints into a VIEW - I've got a view that is fairly
expensive, involving a subselet and an aggregate. When the query is
rewritten in 7.2.3, the toplevel constraint is used to filter before
the
On Wed, Nov 13, 2002 at 02:40:40AM -0500, Mike Mascari wrote:
Ross J. Reedstrom wrote:
For this query, the difference is 160 ms vs. 2 sec. Any reason for this
change?
I could be way off base, but here's a shot in the dark:
http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8threadm
it.
Ross
On Wed, Nov 13, 2002 at 09:28:38AM +0100, Tommi Maekitalo wrote:
Am Mittwoch, 13. November 2002 07:22 schrieb Ross J. Reedstrom:
Hey Hackers -
...
CREATE VIEW current_modules AS
SELECT * FROM modules m
WHERE module_ident =
(SELECT
On Wed, Nov 13, 2002 at 08:58:04AM -0500, Tom Lane wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
Bingo, that solved it. I'm back to 160 ms. What does Tom feel about
removing this? Is there some way the planner could have known which
was the smarter/faster order of application?
As I
I've tested this under 7.3, and it works beautifully for the cases I've
built over the last 2 days. I can no longer bugger a plan up mearly
by reordering the WHERE clauses. Note that 2 of the five parts won't
patch in (involving constantqual). Looks to be code refactoring between
here and
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
Found SQL/MED, Section 21 of ISO 9075-9.
That's the old version, though. The new draft is at (digs out article)
http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
Found SQL/MED, Section 21 of ISO 9075-9.
That's the old version, though. The new draft is at (digs out article)
http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf
On Thu, Jan 02, 2003 at 07:26:06PM -0500, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
replies I will rather quickly redirect to /dev/null, as it isn't Red Hat's
fault we can't do a sane upgrade.
I think you're wasting your time trying to hold us to a higher standard
of
On Thu, Jan 09, 2003 at 10:49:33PM +0100, Peter Eisentraut wrote:
Christopher Kings-Lynne writes:
Is there any way of making the 'up' arrow retrieve all of the last multiline
query, instead of just the last line?
There is nothing technical that should prevent you from implementing it.
On Fri, Jan 10, 2003 at 07:15:34AM +, Peter Mount wrote:
On Thu, 9 Jan 2003, Peter Eisentraut wrote:
Tom Lane writes:
The case I find interesting is where you're using plain \e to
re-edit a query interactively. If this query never gets into the
history buffer then you're
On Fri, Jan 10, 2003 at 11:02:55PM +0100, Peter Eisentraut wrote:
Ross J. Reedstrom writes:
I already posted a one-line patch to implement this, but it doesn't
seem to hve come through to the list. Here it is inline, instead of as
an attachment:
We need this to work without readline
On Mon, Jan 13, 2003 at 11:59:33AM +0800, Christopher Kings-Lynne wrote:
Tom Lane writes:
Feel free to contribute some code.
I will, but unfortunately the damage has already been done...since I have to
support 7.3 anyway, fixing the above problem will actually make my life
harder, not
On Mon, Jan 13, 2003 at 10:01:38AM -0500, Vince Vielhaber wrote:
On Mon, 13 Jan 2003, Dan Langille wrote:
On 13 Jan 2003 at 9:45, Vince Vielhaber wrote:
On Mon, 13 Jan 2003 [EMAIL PROTECTED] wrote:
FTP is just over 800MB, plan for growth.
WEB is just over 90MB, can't tell
On Tue, Jan 14, 2003 at 12:23:59PM +0800, Christopher Kings-Lynne wrote:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
No, I mean that we don't drop the user. You go:
ALTER USER chriskl COPY PERMISSIONS FROM blah;
That seems cleaner to me than the DROP thingy.
You could only
On Thu, Jan 16, 2003 at 11:17:42AM -0500, Jeff wrote:
On Wed, 15 Jan 2003, mlw wrote:
So with all that, you gotta appreciate both sides - hte fact pg just
works and the tunability of bigger db's (Oh yeah - and we've actually had
informix on the horn about the problem - their solution was
On Fri, Jan 17, 2003 at 11:38:24AM -0500, Bruce Momjian wrote:
Tom Lane wrote:
A small difficulty is that explicitly-specified sysids could conflict
with sysids generated later by the sequence. We could perhaps fix this
by forcing up the sequence setting to be at least as large as an
On Thu, Jan 23, 2003 at 10:03:28AM -0500, Tom Lane wrote:
Curt Sampson [EMAIL PROTECTED] writes:
I object. I personally think we should be moving towards not using OIDs
as the default behaviour, inasmuch as we can, for several reasons:
All these objections are global in nature, not
On Sun, Feb 16, 2003 at 01:34:34AM +0100, Ian Barwick wrote:
On Sunday 16 February 2003 01:10, Rod Taylor wrote:
I've been debating a mechanism which could build tab completion tables
based on the documentation for a while now -- and was going to give it a
try next week. If it works, that
On Sat, Feb 15, 2003 at 03:10:19PM -0600, Ross J. Reedstrom wrote:
On Fri, Feb 14, 2003 at 11:32:02AM -0500, Tom Lane wrote:
Patrick Welche [EMAIL PROTECTED] writes:
On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote:
Well, is that a bug in your wrapper? Or must we add a configure
On Mon, Feb 17, 2003 at 12:05:20AM +0100, Peter Eisentraut wrote:
Ross J. Reedstrom writes:
I don't think this is what we were out for. We've certainly been running
with libedit for a long time without anyone ever mentioning
/usr/include/editline. I suggest this part is taken out.
Well, I
On Wed, Feb 19, 2003 at 10:35:58PM -0500, Tom Lane wrote:
snip Tom discussion backend internal tracking of timezone
Any objections?
Not to your suggestion per se, but looking at the bug report raises a
question about pgsql's time zone parsers. It appears there's at least
two, since SET TIME
On Thu, Feb 20, 2003 at 03:21:09PM -0500, Tom Lane wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
question about pgsql's time zone parsers. It appears there's at least
two, since SET TIME ZONE accepts strings like 'US/Eastern', while general
timestamp parsing doesn't:
The TIME ZONE
On Thu, Feb 20, 2003 at 04:19:21PM -0500, Tom Lane wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
On Thu, Feb 20, 2003 at 03:21:09PM -0500, Tom Lane wrote:
Provide a portable way of getting libc to tell us whether it likes TZ,
and I'll be glad to fix this.
Dang that lovely word
On Fri, Feb 21, 2003 at 05:45:53PM -0600, Ross J. Reedstrom wrote:
On Fri, Feb 21, 2003 at 06:15:31PM -0500, Tom Lane wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
snip
I'm worried about cases like Africa/Benin for places that just happen
to be on the prime meridian, but don't call
On Fri, Feb 21, 2003 at 06:15:31PM -0500, Tom Lane wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
snip
I'm worried about cases like Africa/Benin for places that just happen
to be on the prime meridian, but don't call their time GMT or UTC.
Looking at a globe, it also seems possible
of application of tzset()
vs. table lookup?
Ross
On Mon, Feb 24, 2003 at 03:34:56PM -0600, Ross J. Reedstrom wrote:
On Fri, Feb 21, 2003 at 08:39:12PM -0600, Ross J. Reedstrom wrote:
Every other validly formatted TZ variable that returns GMT should be
caught be the datetktbl check
On Fri, Feb 21, 2003 at 08:39:12PM -0600, Ross J. Reedstrom wrote:
Every other validly formatted TZ variable that returns GMT should be
caught be the datetktbl check.
I'll play with it this weekend, see how hard it is to make it work.
O.K., the weekend's over, And I've created two
On Tue, Mar 04, 2003 at 11:04:03PM -0500, Tom Lane wrote:
There is still barely enough time to do the long-threatened protocol
revision for 7.4, if we suck it up and get started on that now. I've
been avoiding the issue myself, because it seems generally boring and
thankless work, but maybe
On Sun, Apr 21, 2002 at 07:28:32PM +1000, Martijn van Oosterhout wrote:
http://svana.org/kleptog/pgsql/page.sgml.txt
I don't know whatever SGML format this is using, so the layout is not great,
but the information should be accurate. I used it to create a program to
dump the datafiles
On Wed, May 01, 2002 at 10:05:23AM +0800, Christopher Kings-Lynne wrote:
phpPgAdmin (WebDB) will be broken as well. I think myself and at least a
few other committers lurk here tho.
Other things that will break:
TOra
Various KDE interfaces
GNUe will break, as well.
Ross
On Wed, May 01, 2002 at 12:03:00AM -0400, Tom Lane wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
GNUe will break, as well.
Do I hear a volunteer to fix it?
I'm willing to implement whatever clever solution we all come up with.
I'll have to coordinate w/ the GNUe IRC folks to get
On Wed, May 01, 2002 at 12:56:00AM -0400, Tom Lane wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
GNUe will break, as well.
I'm willing to implement whatever clever solution we all come up with.
If you need help in inventing a solution, it'd be a good idea to explain
the problem
On Thu, May 09, 2002 at 06:33:58PM +0100, Nigel J. Andrews wrote:
On Thu, 9 May 2002, Thomas Lockhart wrote:
gborg is another way to organize, and of course www.pgaccess.org is a
way too. It partly depends on how you see the future of pgaccess. If it
stays tightly coupled to pgsql, then
On Thu, May 09, 2002 at 10:24:00PM +0200, Iavor Raytchev wrote:
nice summary of how we got here
PROPOSAL
What pgaccess needs is some fresh air - it needs a small and fresh team. It
needs own web site, own cvs, own mailing list. So that the people who love
it, write for it and really need
On Fri, May 10, 2002 at 09:13:20PM +0200, Peter Eisentraut wrote:
Nigel J. Andrews writes:
BTW, I had been wondering what to call the Schema tab now that that label is
required for schemas rather than design.
Design?
Thought about it, but it seems to 'active' for what's behind the tab:
On Fri, May 10, 2002 at 11:24:40PM +0200, Peter Eisentraut wrote:
Iavor Raytchev writes:
3] Still - the only thing that is not clear to me is - who is going to
collect all patches and make one whole form them. As long as each of us
works on a different thing - this should not be a big
On Tue, Jun 11, 2002 at 11:08:11AM -0700, Josh Berkus wrote:
Thomas,
I've just committed changes which implement three SQL99 functions and
operators. OVERLAY() allows substituting a string into another string,
SIMILAR TO is an operator for pattern matching, and a new variant of
On Tue, Jun 18, 2002 at 03:24:57PM +0200, Michael Meskes wrote:
On Mon, Jun 17, 2002 at 11:27:45AM -0700, Dann Corbit wrote:
Here is the complete NIST regression test:
ftp://cap.connx.com/pub/chess-engines/new-approach/nist.ZIP
You have to use passive ftp to get files from my site
On Wed, Jul 17, 2002 at 11:19:40PM +0800, Christopher Kings-Lynne wrote:
i spoke w/jan some time ago (in a hurry now -- have to call salvation army
to have them pick up my couch!).
i need to jump in an discuss/get an assignment off the todo list. i am a cs
doctoral student at gmu in va.
On Wed, Aug 14, 2002 at 09:39:06AM -0500, Greg Copeland wrote:
On Tue, 2002-08-13 at 23:43, Curt Sampson wrote:
Just my opinion of course, but I think it would be best to have a
detailed description of how everything in inheritance is supposed to
work, write a set of tests from that, and
On Thu, Aug 15, 2002 at 11:59:20AM +0300, Oleg Bartunov wrote:
tsearch has compiled-in stop-list, it's currently just not flexible
as OpenFTS does. We plan to move most functionality to tsearch but
currently have no time. Feel free to join us to speedup tsearch
development.
Oleg -
I think
On Thu, Aug 15, 2002 at 11:05:07AM -0400, Bruce Momjian wrote:
I think we are going to see more company-funded developers working on
PostgreSQL. There are a handful now, but I can see lots more coming.
I am going to work on getting those funding companies more visibility.
We originally were
On Fri, Aug 16, 2002 at 10:21:12AM -0400, Vince Vielhaber wrote:
RPMs aren't a good enough reason to put it in. All features aren't
installed in an RPM, why would this need to? Besides, anything that
is runtime configurable can end up getting its default changed on a
whim. Then again as
On Tue, Aug 20, 2002 at 11:28:32AM -0400, Tom Lane wrote:
Nigel J. Andrews [EMAIL PROTECTED] writes:
But going back to the idea that it seems that the only problem being
publicised in the 'outside world' is the cash_out(2) version can we
not do the restriction on acceptable input type in
On Tue, Aug 27, 2002 at 06:08:40PM -0400, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
But we should have some default to print some of the query,
Why? So far you've been told by two different people (make that three
now) that such a behavior is useless, and no one's weighed in
On Fri, Aug 30, 2002 at 02:43:38PM -0400, Matthew T. OConnor wrote:
As someone else mentioned (I think), even using a separate schema is not
always an acceptable option. If you are using a packaged application
(whether commercial or open source), you usually don't want *any*
changes to
On Thu, Sep 05, 2002 at 10:23:02AM -0400, Tom Lane wrote:
I really like Hannu's idea of storing an entire (single-inheritance)
hierarchy in a single file.
Wouldn't this require solving the ALTER TABLE ADD COLUMN (to parent)
column ordering problem?
I guess the question we need to ask
On Mon, Sep 09, 2002 at 11:30:52AM -0700, Dann Corbit wrote:
I suspect it'll be several more major releases before we
begin to consider it approaching completely functional.
I believe that the surprise is at the focus, when it comes to a release.
With commercial products (anyway) if
On Thu, Sep 12, 2002 at 01:56:19PM +0800, Christopher Kings-Lynne wrote:
*sigh*
Well, at least they have an easy and fast upgrade process ;)
Right, fewer pesky features to get in the way of the upgrade ;-
Ross
---(end of broadcast)---
TIP
On Wed, Sep 18, 2002 at 08:01:42PM -0400, Bruce Momjian wrote:
Second, when you unlink() a file on Win32, do applications continue
accessing the old file contents if they had the file open before the
unlink?
I'm pretty sure it errors with 'file in use'. Pretty ugly, huh?
Ross
On Thu, Sep 19, 2002 at 04:57:30PM +0200, Zeugswetter Andreas SB SD wrote:
Have you seen my example ? If calculated in float4 the result of
1.01*1000.0-1000.0 would be 0.0, no ?
So? If you are storing one input as float4, then you cannot rationally
say that you
On Thu, Sep 19, 2002 at 10:30:51AM -0500, Ross J. Reedstrom wrote:
Ah, sorry to drag this on, then. But this is one of those clear cases
were we must fo the right thing, not follow the crowd. PostgreSQL gets
do
used by a lot of scientific projects (Have you noticed all the big
On Thu, Sep 19, 2002 at 06:00:37PM +0200, Zeugswetter Andreas SB SD wrote:
What if he must display 9 digits and says the result is approximately 2.45678932
would that be worse than 2.4600 ?
Yup. Trailing zeros are not significant. That's why scientific notation is nice:
you don't fill
On Wed, Mar 21, 2001 at 09:41:44AM +1200, Christopher Sawtell wrote:
On Tue, 20 Mar 2001 10:56, you wrote:
Just that it might be a good idea to incorporate the version / release
details in some way so that when somebody on the list is squeaking about
an error message it is obvious to the
On Tue, Mar 20, 2001 at 08:03:16PM -0500, Joel Burton wrote:
Yikes. It gets weirder.
I have
Zope 2.3.1b2 (most recent version of Zope)
running on a Linux-Mandrake 7.2 box (server #1)
What kind of filesystem is the pgsql data tree living on? If you do a fsck,
does anything turn up
On Wed, Mar 21, 2001 at 10:51:03AM -0500, Bruce Momjian wrote:
Added to TODO:
* Add BETWEEN [ASYMMETRIC|SYMMETRIC]
Ross did a patch for this but some wanted it implemented differently so
I just added it to the TODO list.
Hmm, have I been coding in my sleep? I think I perhaps
On Tue, Apr 03, 2001 at 03:34:51PM -0400, Tom Lane wrote:
Philip Warner [EMAIL PROTECTED] writes:
We really need ALTER TABLE ADD CONSTRAINT for PK.
That would be a cleaner way to do it, all right ... but for now, you can
just reach in and set the indisprimary flag in pg_index after
Gabor -
Tri-valued logic strikes again. Remember, NULL represents don't know,
which means could be anything. So, when you ask the system to return
values that are guaranteed not to be in a list, and that list contains
a NULL, the system returns nothing, since the NULL _could_ be equal to
the
On Mon, Jun 11, 2001 at 12:21:56PM -0400, Robert E. Bruccoleri wrote:
Dear Tom,
[EMAIL PROTECTED] (Robert E. Bruccoleri) writes:
BTW, given the high level of support that you provide to the PostgreSQL
community, it's very accurate to state that support for PostgreSQL
is far
On Wed, Jun 13, 2001 at 06:24:10PM -0300, The Hermit Hacker wrote:
Now that you've narrowed it down to a specific table, at least you can
specifically vacuum just that table and ignore the rest of the database
...might help a bit?
Even better: since he's loading a script anyway, the script
On Wed, Jun 20, 2001 at 09:13:13AM +0200, Pedro Abelleira Seco wrote:
To say it briefly if an average IT manager asks you to
show him PostgreSQL and you open pgsql or pgaccess
you are done. Sad but true.
Well, then open Access. What do you do when the same manager wants to
see your web
Hmm, your using ColdFusion, so that goes through the ODBC driver, which
picks up the 'primary key' by looking for an index named 'foo_pkey',
I think. Ah, here it is:
in interfaces/odbc/info.c:
sprintf(tables_query, select ta.attname, ia.attnum
from pg_attribute ta, pg_attribute ia,
On Thu, Jun 21, 2001 at 09:44:43AM +0800, Christopher Kings-Lynne wrote:
Okay, what I'm thinking is to have a pair of commands added to
PL/pgSQL. For
the sake of example we'll call them:
ENABLE PRIVLEDGE -- Sets user ID to that of the function's owner
DISABLE PRIVLEDGE -- Restores
On Thu, Jun 21, 2001 at 02:32:59PM +1000, Joe Shevland wrote:
I'd certainly be keen on helping out with a Java/Swing approach. It would be
an excellent test of the meta-data stuff in the JDBC driver and to catch any
ommissions. I'm willing to provide a homepage etc if wanted (and for some
On Tue, Jul 10, 2001 at 09:46:07AM -0700, Stephan Szabo wrote:
On Tue, 10 Jul 2001, Sergio Bruder wrote:
If you have time, take a quick look at
http://acidlab.sourceforge.net/perf/acid_perf.html
PostgreSQL has serious scalability problems with snort + acid. Any
advices?
(Now
On Wed, Jul 18, 2001 at 01:08:15PM +1000, Philip Warner wrote:
At 11:25 18/07/01 +0900, Hiroshi Inoue wrote:
Oops I made a mistake.
Reference name is needed not an object name,
i.e
object relid
object oid
relerence relid
reference oid
reference name
I
On Fri, Jul 20, 2001 at 08:45:05AM +0900, Hiroshi Inoue wrote:
It doesn't seem preferable that the default(unadorned) DROP
allows reattachement after the DROP. The default(unadorned) DROP
should be the same as DROP RESTRICT(or CASCADE because the current
behabior is halfway CASCADE?). How
On Wed, Jul 18, 2001 at 04:06:28PM -0400, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Is the idea to make oid's optional, with them disabled by default on
user tables?
My thought is to make OID generation optional on a per-table basis, and
disable it on system tables that
On Wed, Jul 11, 2001 at 09:56:27AM -0400, Jan Wieck wrote:
Rachit Siamwalla wrote:
Is there any good reason to use VARCHAR over TEXT for a string field? ie.
performance hits, etc.
Other than running into the row size limit problem, are there any large
storage / performance penalties
On Sun, Jul 29, 2001 at 12:19:48PM -0400, mlw wrote:
employee
nameBill/name
positionProgrammer/position
address
number1290/number
street
nameCanton Ave/name
/street
town
nameMilton/name
/town
/address
/emplyee
The
On Sun, Aug 12, 2001 at 10:21:55PM -0400, Vince Vielhaber wrote:
If you think that people are going to flock to PostgreSQL from Oracle
simply because it's a drop in replacement, I want some of whatever it
is you're drinking!
An Oracle compatibility mode wouldn't be a bad idea, but at what
On Thu, Aug 16, 2001 at 10:36:49PM -0400, Tom Lane wrote:
I said:
Suppose that we invent a new datatype regclass, similar to regproc:
it's actually an OID, but it has the additional implication that it is
the OID of a pg_class row, and the I/O operations for the type try to
accept or
On Tue, Aug 21, 2001 at 09:51:29AM -0400, Bruce Momjian wrote:
It's up to the group to decide. If we have a database of bugs, I think
it has to be complete. I think a partial list is worse than no list at
all.
I disagree. Unless you are omniscient, we will only ever have a
Uh, guys? The last thing I can find that Massimo says about the license
is this, from Sunday:
On Sun, Aug 19, 2001 at 11:15:54PM +0200, Massimo Dal Zotto wrote:
Regarding the licencing of the code, I always release my code under GPL,
which is the licence I prefer, but my code in the backend
On Sat, Oct 20, 2001 at 05:24:39PM +0200, Ron de Jong wrote:
Not even close!
Oh? What's it missing? the \dt display in psql has all the information
in your mythical table versionbelow, just organized a little differently,
doesn't it?
Particularly on the hackers list, if there's a feature you
On Tue, Oct 23, 2001 at 08:43:32AM -0700, Bill Studenmund wrote:
And there's the fact that schemas were wanted for 7.2, and didn't happen.
Withouth external adgitation, will they happen for 7.3? Given the size of
the job, I understand why they didn't happen (the package changes so far
On Fri, Sep 28, 2001 at 03:50:12PM -0400, Bruce Momjian wrote:
I'm using the current CVS (4.0.8-dev)- It's spectacular. Lower memory
usage, more descriptive debug, better control over it. Tons more options,
smaller code, much much faster.
snip
Note: if you are not having the problem
On Mon, Mar 18, 2002 at 09:35:51PM -0500, Neil Conway wrote:
It is an application issue
This is completely wrong. Caching can not be done against a database without
knowledge of the database, i.e. when the data changes.
But can't this be achieved by using a LISTEN/NOTIFY model, with
On Tue, Mar 19, 2002 at 08:28:19PM -0500, Neil Conway wrote:
On Tue, 2002-03-19 at 19:20, F Harvell wrote:
I feel that the caching should be SQL transparent. If it is
implemented reasonably well, the performance gain should be pretty
much universal.
Well, the simple query cache scheme
On Fri, Mar 22, 2002 at 02:34:57PM +0800, Christopher Kings-Lynne wrote:
Do we want the above syntax, or this syntax:
ALTER TABLE blah ALTER COLUMN col SET NOT NULL;
ALTER TABLE blah ALTER COLUMN col SET NULL;
My only objection to the second command is that it's plain wrong. You
On Fri, Mar 22, 2002 at 01:12:09PM -0500, Tom Lane wrote:
Also I agree with Fernando that trying to make the word COLUMN optional
is likely to lead to conflicts.
According to the docs, COLUMN is _already_ optional at that point.
Are the changes past that point going to cause different
On Fri, Apr 05, 2002 at 11:19:04AM -0500, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
Could we get out of this by defining that timeout is
automatically reset at next statement end?
I was hoping to avoid that, because it seems like a wart. OTOH,
it'd be less of a
On Sun, Aug 08, 2004 at 01:18:02AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Maybe a better SCM could help with this, but I doubt it.
I haven't seen any particular reason why we should adopt another SCM.
Perhaps BitKeeper or SubVersion would be better for our
On Wed, Aug 18, 2004 at 10:12:53PM -0400, Bruce Momjian wrote:
Magnus Hagander wrote:
Another discussion was about binary files in the tree (not being source
files - the source is a binary .AI file (AFAIK that's Adobe
Illustrator)). The question was raised wether ImageMagick could do
On Sat, Sep 25, 2004 at 11:14:53AM +0100, Simon Riggs wrote:
Jim C. Nasby
Fair questions. MVCC has been tightly locked into Postgres/SQL for the whole
of its history. There is much written on this and you should search some
more - references are in the manual.
Well, not quite it's whole
to
reveal the content.
Well, there's my nickel. Do with it what you will.
Ross
Ross J. Reedstrom, [EMAIL PROTECTED] NSBRI Research Scientist/Programmer
Computer and Information Technology Institute Rice University, 6100
S. Main St., Houston, TX 77005
--
Open source code is like a natural resource
On Wed, Oct 11, 2000 at 02:40:47PM -0400, Bruce Momjian wrote:
On Wed, 11 Oct 2000, Bruce Momjian wrote:
Considering no one has used it in 4 years that I remember, my guess is
that it is an abandonded Berkeley project.
If it does not break anything in our build process, please let
On Fri, Oct 13, 2000 at 04:10:48PM -0400, Bruce Momjian wrote:
We were talking about this today down here at Great Bridge, and I
mentioned that there is very little that happens in the core group. Up
until Great Bridge arrived, and we had to secretly communicate with
them, there really
On Mon, Oct 16, 2000 at 12:22:23PM -0400, Bruce Momjian wrote:
OK, the bad news is that this does not apply to the current development
tree. Ross, can you make a more corrent one? Sorry.
I think it won't apply because it's already in there. There were also
subsequent fixes to how pg_dump
On Mon, Oct 16, 2000 at 03:31:08PM -0500, Ross J. Reedstrom wrote:
On Mon, Oct 16, 2000 at 12:22:23PM -0400, Bruce Momjian wrote:
OK, the bad news is that this does not apply to the current development
tree. Ross, can you make a more corrent one? Sorry.
I think it won't apply because
On Fri, Oct 20, 2000 at 01:30:25PM -0400, Bruce Momjian wrote:
I compute the code count with:
find . -name \*.[chyl] | xargs cat| wc -l
Right, that solves the problem others might be seeing, with the command
line getting expanded and silently chopped off. For example, no one
seems to
On Fri, Oct 20, 2000 at 04:15:11PM -0700, Kevin O'Gorman wrote:
I've just built 7.1 from a slightly old point in the tree:
October 9. Regression tests pass, but postmaster won't
start.
I'm getting a complaint from pg_ctl that it cannot find
postmaster.opts.default.
What am I missing?
On Sun, Oct 22, 2000 at 01:26:07AM -0400, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Next question: why is RelationInitLockInfo using
RelationGetPhysicalRelationName to get the input data for
IsSharedSystemRelationName --- shouldn't that be a test on logical
relation name?
1 - 100 of 183 matches
Mail list logo
