Just as an FYI for those considering the shift ... I just upgraded all of
my databases over to v7.1 from v7.0.3 and it was smooth as silk. The only
problems were having to compile and load a few modules from contrib that
some of my clients were using ...
Took about an hour and a half to do >100
andrea gelmini writes:
> debian unstable, i386.
> upgrade libreadline 4.2
> postgres doesn't compile.
It seems there were some incompatible changes in readline 4.2. Use
version 4.1 until we have a fix.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
-
>>> >
>>> >A possible kluge answer is to make pg_dump's OID-ordering of views
>>> >depend on the OID of the view rule rather than the view relation.
>>> >I am not sure if that would break any cases that work now, however.
>>> >
>>>
>>> This seems good to me; it should be based on the 'oid of the
Philip Warner <[EMAIL PROTECTED]> writes:
> Having now looked at pg_dump more closely, I'm not at all sure I want to
> make the change directly in pg_dump. The reason is that I am trying to move
> version-specific stuff from pg_dump, and I currently get a view definition
> by doing 'select pg_getv
At 03:53 14/04/01 -0400, Tom Lane wrote:
>
>> Would people mind me adding a 'pg_getviewoid()' for pg_dump's use?
>
>While that would be a clean solution, it would mean that the problem
>will remain until 7.2, because you don't get to assume another initdb
>until 7.2. I don't think we want to wait
"Len Morgan" wrote:
>>> Lamar Owen writes:
>>>
>>> > One quick note -- since 'R' < 'b', the RC RPM's must be forced to
>>> > install with --oldpackage, as RPM does a simple strcmp of version
>>> > numbers -- 7.1RC3 < 7.1beta1, for instance. Just force it with
>>> > --oldpackage if you
Tom Lane writes:
> We've gotten several different reports lately of peculiar compilation
> errors and warnings involving readline in 7.1. They look like configure
> is actively doing the wrong thing --- for example, how could we see
> reports like this:
>
> tab-complete.c:734: `filename_completi
At 18:29 14/04/01 +1000, Philip Warner wrote:
>
>I don't suppose we can change the pg_views view without an initdb?
>
Having now looked at the source, I realize that initdb is where this view
is defined. However, is there any reason that we can not change this
definition when upgrading to 7.1.1?
At 04:10 14/04/01 +0200, Mathijs Brands wrote:
>
>Sorry about the false alarm. I was convinced restoring blobs
>didn't work correctly.
>
The tar problem is now fixed in CVS.
Philip Warner| __---_
Albatr
At 17:34 13/04/01 -0400, Tom Lane wrote:
>
>A possible kluge answer is to make pg_dump's OID-ordering of views
>depend on the OID of the view rule rather than the view relation.
>I am not sure if that would break any cases that work now, however.
>
Fixed in CVS.
-
> I haven't addressed that as yet. Is it safe to assume that -ffast-math
> should be Considered Harmful in the RPM_OPT_FLAGS? Is -ffast-math
> _ever_ a Good Thing for our routines? I can easily enough strip out
> -ffast-math from the flags for all cases (xarg -n 1 grep -v
> ffast-math|xargs is
Thomas Lockhart wrote:
> I believe that there is no room for -ffast-math in PostgreSQL. The
I have placed code in the spec to strip out ffast-math from the CFLAGS.
I have not as yet followed Peter's advice on exporting CFLAGS and
leaving COPT -- but that's not to say that I won't.
> > While I d
Lamar Owen <[EMAIL PROTECTED]> writes:
> > In the past I have found that kaffe did not handle enough java code for
> > my needs, but that was not for the JDBC driver. I am currently using
> > jikes for my projects, and it produces *nice* code in my experience.
>
> Jikes is open source, right? I
Do we need to start thinking about an RPM mailing list? Seems there is
lots of traffic.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your ba
Philip Warner <[EMAIL PROTECTED]> writes:
> I don't suppose we can change the pg_views view without an initdb?
No, not very readily.
Even assuming that we were willing to require dbadmins to run a script
during upgrade (which I wouldn't want to do unless forced to it), it's
not that easy to fix
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> (b) the readline dudes commented out (#if 0) the declaration of
> filename_completion_function in the header in favour of the new
> rl_filename_completion_function (but left the symbol in the library).
The "#if 0" silliness is not what's confusing co
If someone wants to come up with an idea for name, i think that the whole
Win camp could be seperated also ...
pgsql-windows and pgsql-rpm ?
as far as newsgroups are concerned, they would both fall under ports:
comp.databases.postgresql.ports.linux.rpm
comp.databases.postgresql.ports.windows
77 databases in data/base directory ... all number'd ...
select * from pg_database;
doesn't give me the reference to which directory is which database ... so
what table do we need to join on to get this information?
thanks ...
Marc G. Fournier ICQ#7615664 IRC N
The Hermit Hacker wrote:
> If someone wants to come up with an idea for name, i think that the whole
> Win camp could be seperated also ...
> pgsql-windows and pgsql-rpm ?
> as far as newsgroups are concerned, they would both fall under ports:
If that's what you want to do. Although, I'd rec
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> If someone wants to come up with an idea for name, i think that the whole
> Win camp could be seperated also ...
> pgsql-windows and pgsql-rpm ?
A windows list seems like a good idea. But I'm not sure that a separate
list for RPMs is a good idea.
On Sat, 14 Apr 2001, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > If someone wants to come up with an idea for name, i think that the whole
> > Win camp could be seperated also ...
>
> > pgsql-windows and pgsql-rpm ?
>
> A windows list seems like a good idea. But I'm not s
Bruce Momjian writes:
> Do we need to start thinking about an RPM mailing list? Seems there is
> lots of traffic.
The traffic naturally peaks around release time, and this time especially
because yours truly messed up the whole build system that the packagers
were so careful to work around. I
> Bruce Momjian writes:
>
> > Do we need to start thinking about an RPM mailing list? Seems there is
> > lots of traffic.
>
> The traffic naturally peaks around release time, and this time especially
> because yours truly messed up the whole build system that the packagers
> were so careful to
On Sat, 14 Apr 2001, Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Do we need to start thinking about an RPM mailing list? Seems there is
> > lots of traffic.
>
> The traffic naturally peaks around release time, and this time
> especially because yours truly messed up the whole build sys
Where are the 7.1 rpms downloadable from? (even the RC based ones)?
Chris Bowlby,
-
Web Developer @ Hub.org.
[EMAIL PROTECTED]
www.hub.org
1-902-542-3657
-
---
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> I like Lamar's suggestion of pgsql-cygwin though ... sound reasonable?
Yes, that's probably better than pgsql-windows ...
regards, tom lane
---(end of broadcast)---
TIP 3: if
>
> d'oh, should have extended my query ...
>
> select oid,* from pg_database;
>
> gives the directory name ...
>
Interesting to not that reffilenode is for tables, but oid is for
databases. I hadn't realized that distinction until you asked. You
can't rename databases, so the oid is OK fo
The Hermit Hacker writes:
> I like Lamar's suggestion of pgsql-cygwin though ... sound reasonable?
We have pgsql-ports, which isn't seeing too much traffic as it is. Seems
like the cygwin people hang out there anyway.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
>
> 77 databases in data/base directory ... all number'd ...
>
> select * from pg_database;
>
> doesn't give me the reference to which directory is which database ... so
> what table do we need to join on to get this information?
>
> thanks ...
Info is in pg_class.relfilenode. Now the big qu
d'oh, should have extended my query ...
select oid,* from pg_database;
gives the directory name ...
thanks :)
On Sat, 14 Apr 2001, Bruce Momjian wrote:
> >
> > 77 databases in data/base directory ... all number'd ...
> >
> > select * from pg_database;
> >
> > doesn't give me the reference
On Sat, 14 Apr 2001, The Hermit Hacker wrote:
> On Sat, 14 Apr 2001, Peter Eisentraut wrote:
>
> > Bruce Momjian writes:
> >
> > > Do we need to start thinking about an RPM mailing list? Seems there is
> > > lots of traffic.
> >
> > The traffic naturally peaks around release time, and this time
On Sat, 14 Apr 2001, Peter Eisentraut wrote:
> The Hermit Hacker writes:
>
> > I like Lamar's suggestion of pgsql-cygwin though ... sound reasonable?
>
> We have pgsql-ports, which isn't seeing too much traffic as it is. Seems
> like the cygwin people hang out there anyway.
Ya, well, there is a
On Sat, 14 Apr 2001, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > I like Lamar's suggestion of pgsql-cygwin though ... sound reasonable?
>
> Yes, that's probably better than pgsql-windows ...
Done ...
---(end of broadcast)
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> 77 databases in data/base directory ... all number'd ...
> select * from pg_database;
> doesn't give me the reference to which directory is which database ... so
> what table do we need to join on to get this information?
select oid, datname from
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > I like Lamar's suggestion of pgsql-cygwin though ... sound reasonable?
>
> Yes, that's probably better than pgsql-windows ...
But then again, the comment this is more properly done on ports makes
sense.
--
Bruce Momjian
first, congratulations to all for the 7.1 release, good work.
second, I've found (some years ago to be honest) that pgsql can ALTER
TABLE while the table is widely available for all users...
this strike me as pretty bad/dangerous/confusing/messy (even from the
POV of implementation)
should I su
Tom Lane <[EMAIL PROTECTED]> writes:
> > I think this is indisputably a bug in (some versions of) NetBSD.
>
> I forgot to mention a possible contributing factor: the files involved
> were NFS-mounted, in the case I was looking at. So this may be an NFS
> problem more than a NetBSD problem. Any
Tom Ivar Helbekkmo <[EMAIL PROTECTED]> writes:
> I can verify, that with NetBSD-current on sparc, your test code works
> the way you want it to on local disk, but fails (in the way you've
> observed), if the target file is on an NFS-mounted file system.
FWIW, the test program succeeds (no error)
The Hermit Hacker writes:
> If someone wants to come up with an idea for name, i think that the whole
> Win camp could be seperated also ...
>
> pgsql-windows and pgsql-rpm ?
There seem to be a lot of Linux users, too. How about a new mailing list?
--
Peter Eisentraut [EMAIL PROTECTED] ht
Peter Eisentraut wrote:
> The traffic naturally peaks around release time, and this time especially
> because yours truly messed up the whole build system that the packagers
> were so careful to work around.
Now, Peter. The build, IMHO, is much better than before -- if anything,
the fact that we
http://www.crn.com/Sections/Fast_Forward/fast_forward.asp?ArticleID=25670
Marc will be pleased to note that the PostgreSQL project came out of the
FreeBSD project, and is Great Bridge's database. Gotta love
journalistic license.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
---
On Sat, 14 Apr 2001, Lamar Owen wrote:
> http://www.crn.com/Sections/Fast_Forward/fast_forward.asp?ArticleID=25670
>
> Marc will be pleased to note that the PostgreSQL project came out of the
> FreeBSD project, and is Great Bridge's database. Gotta love
> journalistic license.
Oh, and 7.1's du
there is little, to nothing, factual about that whole article ...
"Great Bridge essentially gives away its open-source database application
at little cost..."
- thannk god I can get it completely for free, eh?
"Great Bridge executives say their licensing costs for the software..."
I've been messing around with a 7.0 compatible dump for 7.1, and it looks
good so far (at least I can dump & restore my local DBs and, to some
extent, the regression DB, including BLOBs).
It is a mixture of 7.1 and 7.0 features, in the sense that it is basically
the 7.1 pg_dump but with 7.0 SQL/
I rarely sign a note as the webmaster, I like to keep a low profile.
I just sent the witch a note and made it a point to let her know who
I am - and BCCd Marc. He can cross post it if he wishes. I also sent
it to the editor of that rag.
Vince.
On Sun, 15 Apr 2001, The Hermit Hacker wrote:
okay, I didn't get a copy of it ... :(
On Sun, 15 Apr 2001, Vince Vielhaber wrote:
>
> I rarely sign a note as the webmaster, I like to keep a low profile.
> I just sent the witch a note and made it a point to let her know who
> I am - and BCCd Marc. He can cross post it if he wishes. I also
Philip Warner <[EMAIL PROTECTED]> writes:
> At the moment it has no idea what do do with aggregates (is there
> anything?), and it assumes 'proisstrict' on functions.
I'll take the blame for the aggregate issue ;-).
SFUNC1/STYPE1/INITCOND1 in 7.0 equate to SFUNC/STYPE/INITCOND in 7.1.
There is n
Here's my response to the inaccurate article cmp produced. After
chatting with Marc I decided to post it myself.
Since I know Ned reads this list, I formally request that he also
insists PUBLICALLY that cmp correct their inaccuracies. I'm rather
disappointed (for lack of a more descriptive wor
> > In the past I have found that kaffe did not handle enough java code for
> > my needs, but that was not for the JDBC driver. I am currently using
> > jikes for my projects, and it produces *nice* code in my experience.
> Jikes is open source, right? I know it is available for Red Hat (ships
>
> Do we need to start thinking about an RPM mailing list? Seems there is
> lots of traffic.
The delete key is your friend. So is procmail, if you just can't stand
to see the letters "R", "P", and "M" too close together ;)
I'm not a big fan of the trend to fork off a mailing list anytime more
th
> Where are the 7.1 rpms downloadable from? (even the RC based ones)?
ftp://ftp.postgresql.org/pub/dev/...
or
ftp://ftp.postgresql.org/pub/binary/...
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriat
Tom and Peter,
After looking at and thinking about the direction of the PostgreSQL
project and the release of 7.1, I wanted to personally thank the both
of you for your hard work and contributions to the project which without
your efforts there might not only not be a 7.1, PostgreSQL might not b
Thomas Lockhart <[EMAIL PROTECTED]> writes:
> I'm not a big fan of the trend to fork off a mailing list anytime more
> than a few messages on a single topic come through. The synergy and
> cross-pollination that we get by having us all see various topics wrt
> development far outweigh the minor an
On Sun, 15 Apr 2001, Thomas Lockhart wrote:
> > Do we need to start thinking about an RPM mailing list? Seems there is
> > lots of traffic.
>
> The delete key is your friend. So is procmail, if you just can't stand
> to see the letters "R", "P", and "M" too close together ;)
>
> I'm not a big fa
On Sun, Apr 15, 2001 at 01:17:15AM -0400, Vince Vielhaber wrote:
>
> Here's my response to the inaccurate article cmp produced. After
> chatting with Marc I decided to post it myself.
> ...
> Where do you get your info? Do you just make it up? PostgreSQL is
> not a product of Great Bridge and
Hi pgsql-hackers,
Could anyone advise me how to do modular test in any partial
PostgreSQL's modules?
I am interested in the PostgreSQL development. I have begun study the
DBMS source code by developer documentation provided by postgresql.org
especially internal.ps that is the best explainat
56 matches
Mail list logo
