Christopher Browne writes:
bash-2.05a$ uname -a
AIX ibm-db 1 5 000CD13A4C00
We already have a report for AIX. Were you trying to indicate that this
is a different variant thereof?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
doc/man.tar.gz.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
will be added shortly.)
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Marc G. Fournier writes:
Why does it scare you? *raised eyebrow*
Because release-making should be a predictable process. But if every
other release brings a new surprise in the naming scheme, it's not.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
I wrote:
For a change, here is one that does not work:
HP-UX hpunix5 B.11.00 U 9000/803 2002765023
This one is OK now.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once
/bin/pg_ctl/pg_ctl.sh
src/interfaces/jdbc/example/corba/stock.idl
src/pl/tcl/modules/pltcl_delmod.in
src/pl/tcl/modules/pltcl_listmod.in
src/pl/tcl/modules/pltcl_loadmod.in
src/port/dirmod.c
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
applications and libraries develop around it. That has worked
out pretty well lately, I think.
--
Peter Eisentraut [EMAIL PROTECTED]
Master-of-the-Makefiles http://www.postgresql.org
---(end of broadcast)---
TIP 7: don't forget to increase your free space
Andrew Overholt writes:
[EMAIL PROTECTED] postgresql]$ time make all make.nonsmp
mkdir man7
some minor bison and ant warnings
Should the man directory creation be echoed like that?
Yes, that appears to be normal.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end
that there may be a need to issue an error if an invalid octal
or hex character is found following a \ or \x. No errors are currently flagged by
the octal (or this hex) import.
I think this belongs into the string literal parser (at least in addition
to COPY).
--
Peter Eisentraut [EMAIL
The SuSE PPC guru said that the PPC spinlock code we currently use may
behave erroneously on multiprocessor systems. Attached is the proposed
patch, suggested for inclusion in 7.4. Comments?
--
Peter Eisentraut [EMAIL PROTECTED]
--- src/include/storage/s_lock.h
+++ src/include/storage
of manual work this time, so
any further reference page changes need to be integrated by hand.
* Did we really decide not to rename the check_function_bodies parameter
to something more general? Maybe I've missed it.
* PPC spinlock patch from SuSE.
--
Peter Eisentraut [EMAIL PROTECTED
is Don't get me wrong, press contacts and advocacy team deserve
recognition as well, but not on a page that is indirectly labelled What
is PostgreSQL. It makes it look like the project is run by marketing
dudes.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end
anywhere, because the main site
understands itself as a portal, and there is no obvious way that other
groups can integrate.
Check out www.debian.org or www.freebsd.org to see what I mean.
Everything is there at one glance, everything looks the same, everyone is
invited everywhere.
--
Peter Eisentraut
a
recognised contributor?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
we really need a method to guarantee unique names. It would
already help a lot if we just added the table name, or something that was
until a short time before the action believed to be the table name, or
even only the table OID, before (or after) the $1.
--
Peter Eisentraut [EMAIL PROTECTED
is the right place to discuss who gets to be a recognized contributor of
that same development group.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
Josh Berkus writes:
I was discussing specifically the Recognized Corporate Contributors which
is, AFAIK, strictly a PHB thing, no?
No.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
that is relatively fully
IPv6 enabled.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
that list is a pretty dumb idea in the first place. We have a
list of developers with company names next to them. Let readers make
their own recognition evaluation.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get
-in-IPv4
NOARP MTU:1480 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
--
Peter Eisentraut [EMAIL PROTECTED
Andrew Sullivan writes:
I'm not sure that's all it's for. Every time we talk about using
Postgres, people want to know who else uses it.
True, but for that you're looking at the wrong list. This is the list of
contributors, not of users.
--
Peter Eisentraut [EMAIL PROTECTED
just requested to be on it.
Well, if there must be a list, then why not be on it? :-)
It is there for IT department managers, PHBs, people considering
PostgreSQL, and people looking for high-end paid support.
Great, that's exactly what I wanted to hear.
--
Peter Eisentraut [EMAIL PROTECTED
to
guarantee any kind of longevity of the project. I think that will be hard
to do (because there is, in fact, absolutely no relation). But hopefully,
by the time we've arrived there, this silly web site fragmentation will be
over and this question will be moot.
--
Peter Eisentraut [EMAIL PROTECTED
?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Robert Treat writes:
I disagree... the tech and the content are separate issues, let's keep
them that way or we'll never make progress on either of them.
Just because one solution is technically more simple, it doesn't mean that
it is the overall best solution.
--
Peter Eisentraut [EMAIL
their private notes
lists in public, add comments on why things are difficult, if the
perspective changes, etc. I have the feeling that key developers for the
most part ignore the TODO list and keep their private set of notes.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end
?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
that are wishlist items and those that are old project
lore and would have been duplicates of existing recorded bugs. So even if
you count in bugs coming in through other channels, this should be
manageable.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
which is right and left.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Patrick Welche writes:
PostgreSQL 7.5devel on arm-unknown-netbsdelf1.6ZE, compiled by GCC gcc (GCC)
3.3.2-nb1
Can you test 7.4?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
strk writes:
I can't build postgresql from CVS. Any help ?
Search the fine archives.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
developers of
database-backed applications are dying to have people like that at their
disposal.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
and egroupware
but haven't got around it..
When I said I've been doing a bit of that, I meant the developers of
eGroupWare call me once a week with questions. So maybe you can take
over dbmail. :-)
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
PostgreSQL
yet, get a good sense for what the feeling of the project maintainers
toward database abstraction layers is, then throw out a design plan. But
the key is to show results, not intentions. That is how open-source
development works.
--
Peter Eisentraut [EMAIL PROTECTED
Tom Lane writes:
Actually, I think that that may be expected behavior depending on the
vintage of the kernel. Note the following comment in
StreamServerPort():
Can we make the warning less misleading if IPV6_V6ONLY does not exist?
--
Peter Eisentraut [EMAIL PROTECTED
Do we have any data on how many people download the partial tarballs
(-base, -opt, etc.)? I have a feeling that more people are confused by
them than use them.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you
install the documentation??? How is that a good idea?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Patrick Welche writes:
All 93 tests passed.
with 7.4rc2 on NetBSD-1.6ZE/acorn32.
Added, thanks. I put it under CPU arm32, because that's the actual CPU,
which PostgreSQL depends on, and acorn32 is just the system type. Let me
know if this is grossly incorrect.
--
Peter Eisentraut
is just Itanium/Linux AFAICT.
What is the URL for reporting successful ports? --Bob
mailto:[EMAIL PROTECTED]
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
compatibility headers of ECPG. But we need some more information from
Informix users about that. It will have to wait for 7.4.1.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives
to test NetBSD on -general a week or so
ago. So I think we'd have heard something by now. But feel free to
solicit more people. Maybe writing to a NetBSD project mailing list would
work.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
Karel Zak writes:
XML advantage:
All very true.
XML disadvantage:
- no arbitrary parameter entities
If someone can solve this for me, I'm ready to switch.
Follow-up to [EMAIL PROTECTED] please.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
Greg Stark writes:
Wouldn't at least 0750 be safe? That way putting a user in the postgres group
would grant him access to be able to browse around and read the files in
pg_data.
That assumes that there is a restricted postgres group, which is not
guaranteed.
--
Peter Eisentraut [EMAIL
-coding
does not count.)
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
option --docdir,
but it's too late to philosophize about that now.)
Comments?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
you want to do the old col = col + 1 in the
presence of a unique index.
(c) Do I need to consider inheritance?
Inheritance is based on column names, so initially no, but if there is a
command to alter the column order, then it should have an ONLY option.
--
Peter Eisentraut [EMAIL PROTECTED
number
changes in the past weren't because the features were cool, but because
the project has moved to a new phase. I don't see any such move
happening.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our
for a 6 month cycle, consisting of approximately 4 months of development
and 2 months of cleanup. So the start of the next beta could be the 1st
of March. What do you think?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9
. Something went *really* wrong there.
Part of that may have been that few people were actually aware of that
schedule.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
That was a Bruce Momjian estimate mentioned in passing, not an affirmed
plan. Also, I think Bruce's estimates are notoriously off by years. ;-)
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
Neil Conway writes:
Peter Eisentraut [EMAIL PROTECTED] writes:
The time from release 7.3 to release 7.4 was 355 days, an all-time
high. We really need to shorten that.
Why is that?
First, if you develop something today, the first time users would
realistically get a hand at it would
-- instead of 6.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
, they
need to do another. That seems fair.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
part of this year., but dates for steps such as feature freeze then,
proposals for open issues fielded then, string freeze then,
release candiate then.
5. If need be, have a release management team that manages 0-4.
--
Peter Eisentraut [EMAIL PROTECTED
the obvious: Cygwin is your friend in exactly this
case.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
by this License; they are outside its scope. The act of
running the Program is not restricted, ...
So commercial use is clearly allowed.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
television viewers?
33% -- better entertainment
That does not say that better entertainment will attract new viewers, just
that the existing viewers think that. Most nonviewers might in fact be
perfectly content with their way of living.
--
Peter Eisentraut [EMAIL PROTECTED
that the build farm
becomes useful. IMO, that would mean *more* machines than are currently
lines in the supported-platforms table.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
all the above, with great effort. But by throwing out the code and
have real people test them on real systems with real applications, you can
do much better.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched
Lamar Owen writes:
And he is getting paid to do it, unlike me.
That's news to me. :-)
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
might find that adopting the source code
of the Samba suite to PostgreSQL is harder than writing a new one.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
LWP and talking to a
CGI script.
That will be the difficult part to organize, if it's supposed to be
distributed and autonomous.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
and logical numbers in the backend in some
places. So one option is to replace some uses of attnum by attlognum.
The other optionis to replace *all* uses of attnum by attphysnum and then
replace some uses of attphysnum by attnum. To me, this looks like an
equal risk as far as the backend goes.
--
Peter
.
In particular, it provides redundancy, load balancing, caching, and even
database independence.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs
(currently 1024 bytes) in
every pg_proc row. In this case, a regular name[] would be more suitable.
Just be sure to put it after all the fixed-length fields.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner
Here is what I get:
peter ~$ pg-install/bin/initdb pg-install/var/data
...
creating directory pg-install/var/data ... initdb: failed
No points for details in the error message here either.
If I create pg-install/var first, then it work.
--
Peter Eisentraut [EMAIL PROTECTED
While people add more executable files to CVS (cf. initdb.c), can we do
something about it?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
in the group pgsql and
that group having write permission.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
about these
later.)
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
.
This could easily take a long time, but I feel that even if we have to
stop after 2., 3., or 4. at feature freeze, we'd be a lot farther.
Comments? Anything else that needs fixing?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
of. We might be chasing warnings forever.
I'm not sure what the point is anyway. Shadowing is perfectly
well-defined and I've never heard of a real problem because of it.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can
Bruce Momjian writes:
FYI, the HP testdrive farm, http://www.testdrive.hp.com, has shared
directories for most of the machines, meaning you can CVS update once
and telnet in to compile for each platform.
Except that you can't open connections to the outside from these machines.
--
Peter
implement one
using memcmp() or whatever you like.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
(or
something else). If it's not up to what we need, than fix that library
instead.
I wasn't aware that glib had this. I'll look.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
(together.at).
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
, but that is much too
bloated.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
, please post details.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
FYI, I've successfully tested on NetBSD Sparc and added it to the
supported list for 7.4.1.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
that make each statement print out the
parse tree. I think it's show_parse_tree or something like that.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
-hanging fruit in there, for instance
Finishing ECPG's dynamic SQL support
Column privileges
Updatable views
Distinct data types
Basic array support
BLOB and CLOB types
Chained transactions
Basic roles
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Neil Conway writes:
Building PostgreSQL outside the source tree is slightly broken:
I've installed a patch that should fix this.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
E.Rodichev writes:
I just noticed some incorrect behaviour for postgresql-7.4 related
to locale.
Maybe you should first read the documentation to understand how it
actually works.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
other suggestions on how to deal with this?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Karel Zak writes:
in our TODO is the item: Add PL/PgSQL packages.
I think the interesting part are the package-global variables. The
name hierarchy seems completely redundant with schemas.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
it.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
. filenameconfigure/ will check
for the required header files and libraries to make sure that
your Kerberos installation is sufficient before proceeding.
/para
/listitem
/varlistentry
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
--with-krb5=/usr/kerberos
checking build system type... i586-pc-linux-gnu
...
checking whether to build with Kerberos 5 support... configure: error: no
argument expected for --with-krb5 option
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast
they all have to be recompiled.
Considering that mostly everyone else uses -fPIC across the board (because
it is libtool's behavior and also the policy of several distributions),
either no one has used PostgreSQL on those platforms or there is no
problem.
--
Peter Eisentraut [EMAIL PROTECTED
characteristics between the two data types?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
E.Rodichev writes:
It is incorrect, because database test is, really, in KOI8, NOT in SQL_ASCII
in this example, as I explained in my mail.
The encoding is only a declaration of your intentions. What you actually
put into the database is your responsibility.
--
Peter Eisentraut [EMAIL
Marc G. Fournier writes:
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first ... we know of nothing outstanding
right now ...
A bug in the information schema concerning
Marc G. Fournier wrote:
A bug in the information schema concerning the bit types must be
fixed.
Does anyone have a patch for this?
I suppose not, but it's being worked on.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
What is COUNT('x') supposed to return? 1? Is that legal SQL?
Why not?
Because there is nothing to count.
In general,
SELECT count(expr) FROM table1;
counts the number of rows in table1 where expr evaluates to not null.
If table1
:
programlisting
DROP SCHEMA information_schema CASCADE;
\i /usr/local/pgsql/share/information_schema.sql
/programlisting
Substitute your installation path in the second command.
/para
--On Sunday, December 07, 2003 06:18:50 -0400 Peter Eisentraut -
PostgreSQL
[EMAIL PROTECTED] wrote:
CVSROOT
Tom Lane wrote:
libpq++ got heaved overboard largely
because the autoconf burden for it was too high,
That's news to me. Certainly the overhead doesn't grow smaller by
splitting stuff up in smaller pieces.
---(end of broadcast)---
TIP 4: Don't
Thomas Hallgren wrote:
What are your thoughts and ideas?
Instead of making up your own stuff, there's a whole SQL standard that
tells you how Java embedded in an SQL server should work. Of course
that doesn't tell you about implementation details.
---(end of
Andrew Dunstan wrote:
Peter Eisentraut wrote:
Thomas Hallgren wrote:
What are your thoughts and ideas?
Instead of making up your own stuff, there's a whole SQL standard
that tells you how Java embedded in an SQL server should work. Of
course that doesn't tell you about implementation
David Fetter wrote:
I'm looking to the SQL WITH clause as a way to get better regex
support in PostgreSQL. I've been chatting a little bit about this,
and here's an idea for a behavior. Implementation details TBD.
WITH res = match (x.foo, '([0-9]+)x([0-9]+)')
SELECT *
FROM x
WHERE y =
1 - 100 of 8763 matches
Mail list logo
