Re: [HACKERS] Re: Call for platforms

2001-04-07 Thread Peter Eisentraut
e is expected to hold this information), and the program fails at run-time even though it linked without any error message. On such a platform it would hardly be possible to detect anything with any reliably. A linker that links a program "succesfully" while the program really needs mo

[HACKERS] A more useful way to split the distribution

2001-04-07 Thread Peter Eisentraut
$@ $(distdir)/src/interfaces $(distdir)/src/bin +$(distdir).opt.tar: distdir + $(TAR) cf $@ $(addprefix $(distdir)/, $(opt_files)) $(distdir).test.tar: distdir $(TAR) cf $@ $(distdir)/src/test ===snip -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e

Re: [HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-08 Thread Peter Eisentraut
a 7.1beta RPM already installed. Huh? I always thought that ASCII R was greater then b ... *confused* in the future, would it help to have 7.2Beta? Or am I missing something? :) How about 7.2rc1, which is greater than 7.2beta1. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org

Re: [HACKERS] A more useful way to split the distribution

2001-04-08 Thread Peter Eisentraut
ll tarball with everything, or at least I will not put my name to something that abolishes it. In fact, I didn't like the idea of the split tarballs in the first place, I'm merely changing the split to something more useful. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.o

[HACKERS] Re: A more useful way to split the distribution

2001-04-08 Thread Peter Eisentraut
1.9 MB * postgresql-XXX.test.tar.gz 1.0 MB Since we're going to make a change, I'd like to change the names to postgresql-base-XXX.tar.gz etc. to align them with existing practice (cf. RPMs, GCC download). Dots should be used for format-identifying extensions. -- Peter Eisentraut [EMAIL

Re: [HACKERS] Re: RC3 ...

2001-04-08 Thread Peter Eisentraut
again when a branch is made so the paths are set correctly, but in principle it is trivial to arrange. Not that the documentation ever changes for minor releases. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast

Re: [HACKERS] RPMS for RC3

2001-04-08 Thread Peter Eisentraut
some work. You probably want to run gzip on the files after installation. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [HACKERS] --tuning compile and runtime option (?)

2001-04-09 Thread Peter Eisentraut
what heading because everyone is in a different situation. The solution is to provide user guidance to the existing configuration variables that goes beyond what they do by adding why the user should care. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---

Re: [HACKERS] RPMS for RC3

2001-04-09 Thread Peter Eisentraut
; YMMV). The man pages are still in a separate tarball, or not? They're in a tarball, but they're not separate. You probably want to run gzip on the files after installation. Done automagically by the buildrootpolicy of the rpm build system, Amazing... ;-) -- Peter Eisentraut [EMAIL

Re: AW: [HACKERS] RPM upgrade caveats going from a beta version toRC

2001-04-09 Thread Peter Eisentraut
not kid ourselves. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[HACKERS] Truncation of char, varchar types

2001-04-09 Thread Peter Eisentraut
this to raise an error in this situation? Does anybody rely on silent truncation? Should this be user-settable, or can those people resort to using triggers? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast

Re: AW: [HACKERS] Truncation of char, varchar types

2001-04-10 Thread Peter Eisentraut
exception-string data, right truncation. """ Similarly in SQL 1999 and for other data types. How do people feel about changing this to raise an error in this situation? Can't do. Why not? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [HACKERS] libpq PQexec call of COPY

2001-04-10 Thread Peter Eisentraut
ry, I want the executable to do it and still enjoy the performance of the COPY command. Read the libpq chapter in the Programmer's Guide and look into src/bin/psql/copy.c for information and examples of using COPY through libpq. Yes, it's possible, but you need to use special API calls. -- Peter

Re: [HACKERS] Truncation of char, varchar types

2001-04-10 Thread Peter Eisentraut
to this, although a number of people seem to like it. Sounds like a configuration option to me. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] Re: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can'timport to v7.1?

2001-04-10 Thread Peter Eisentraut
't see any of this. Btw., it would really seem like a neat feature if a given pg_dump suite would also handle the respective previous version. Otherwise we're in a situation like now where we've got a shiny new pg_dump but people that want to upgrade are still stuck with the broken 7.0 incarnation.

Re: [HACKERS] Re: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can'timport to v7.1?

2001-04-11 Thread Peter Eisentraut
Philip Warner writes: At 01:09 11/04/01 +0200, Peter Eisentraut wrote: Btw., it would really seem like a neat feature if a given pg_dump suite would also handle the respective previous version. This has been in the back of my mind for some time, and is why I initially backported my

Re: [HACKERS] age() function documentation

2001-04-11 Thread Peter Eisentraut
confusing? I do not recall any discussion on the topic, and I'll restore the documentation until someone can refresh my memory on why these are a problem. grumble http://www.postgresql.org/mhonarc/pgsql-hackers/2001-02/msg00550.html -- Peter Eisentraut [EMAIL PROTECTED] http://yi.o

Re: [HACKERS] age() function documentation

2001-04-11 Thread Peter Eisentraut
does that mean anyway? Simple subtraction also preserves years and months, as I see it. Would we like some additional clarification in the docs perhaps? Seems to be preferable to dropping all mention, especially since it is a useful function. By all means. -- Peter Eisentraut [EMAIL

Re: [HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-11 Thread Peter Eisentraut
of the 'serial' tag to override the version guessing mechanism? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: AW: AW: [HACKERS] Truncation of char, varchar types

2001-04-11 Thread Peter Eisentraut
copy that behavior if they are not conformant. See above question. Someone said Oracle raises an error. Informix seems to be the only other db that truncates silently. I think Oracle wins here... -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [HACKERS] RPM upgrade caveats going from a beta version to RC

2001-04-11 Thread Peter Eisentraut
-0.1beta6.2' through '7.1-0.2RC1.1' to '7.1-1'. Just name them 7.1betax 7.1rcx 7.1.0 7.1.1 etc. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [HACKERS] age() function documentation

2001-04-12 Thread Peter Eisentraut
not implemented per spec (spec == SQL). Lots of fun projects here... ;-) -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] age() function documentation

2001-04-12 Thread Peter Eisentraut
onths; int32 years; } } } This would make it mostly compatible to its current behaviour. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] age() function documentation

2001-04-12 Thread Peter Eisentraut
, such as the above. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: AW: AW: AW: [HACKERS] Truncation of char, varchar types

2001-04-12 Thread Peter Eisentraut
on the existing behaviour, but I doubt that. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Yacc / Bison difficulties

2001-04-12 Thread Peter Eisentraut
Mark Butler writes: I was trying to make a minor change today to the gram.y file to make PostgreSQL recognize "DOUBLE" as a data type the way DB2 does. I ran into reduce / reduce conflicts using both of the methods I tried. See attached patch. -- Peter Eisentraut [EMAIL

Re: [HACKERS] RE: Estimating Size of Database

2001-04-12 Thread Peter Eisentraut
it. ;-) -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[HACKERS] Dump/restore of views containing select distinct fails

2001-04-13 Thread Peter Eisentraut
rs instead of spelling out the select list again would work? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [HACKERS] Re: 7.1 RPMs

2001-04-13 Thread Peter Eisentraut
Lamar Owen writes: In the postgresql-docs subpackage, along with the SGML source. Why would you want to ship the source? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 5: Have you checked

Re: [HACKERS] cvs postgres doesn't compile with libreadline 4.2

2001-04-14 Thread Peter Eisentraut
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

[HACKERS] Re: Possible explanation for readline configuration problems

2001-04-14 Thread Peter Eisentraut
for doing this in a minor release. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [HACKERS] Re: 7.1 RPMs

2001-04-14 Thread Peter Eisentraut
trust that in a few weeks we'll enter a new quiet period. My vote is that technical packaging discussions should go on -hackers just like a makefile discussion. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast

Re: [HACKERS] Re: 7.1 RPMs

2001-04-14 Thread Peter Eisentraut
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

Re: [HACKERS] Re: 7.1 RPMs

2001-04-14 Thread Peter Eisentraut
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] http

[HACKERS] Real/effective user

2001-04-17 Thread Peter Eisentraut
orization stack" at the start of a transaction. But I'm not sure whether this would be a desirable feature to have in the first place. Most schema commands are rollbackable now, so maybe this won't be a large restriction for pg_dump's purposes. Comments? -- Peter Eisentraut [EMA

Re: [HACKERS] Re: No printable 7.1 docs?

2001-04-17 Thread Peter Eisentraut
not mistaken I got a readable PDF file part of the time. If anyone's interested in helping with the tool chain, look there first. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off

[HACKERS] Re: [PATCHES] Fix for psql core dumping on bad user

2001-04-18 Thread Peter Eisentraut
return 1 when it is passed an invalid encoding. In any case it should do better than dump core. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] Real/effective user

2001-04-18 Thread Peter Eisentraut
E, shouldn't the created object be owned by the setuid user? I'm not sure that I *want* to accept the SQL spec on this point. Me neither. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if pos

Re: [HACKERS] Re: No printable 7.1 docs?

2001-04-18 Thread Peter Eisentraut
to tweak appearance through style sheets. No need to make new tags either (although it sometimes doesn't hurt). -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] Re: No printable 7.1 docs?

2001-04-19 Thread Peter Eisentraut
processing and less about dsssl programming (since that won't help you). -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

[HACKERS] CVS server ailing?

2001-04-19 Thread Peter Eisentraut
What did you do to the CVS server? It takes hours to update a single file, half a day to run cvs diff. This has been like that for about 48 hours. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

[HACKERS] System catalog representation of access privileges

2001-04-19 Thread Peter Eisentraut
table creation. These indexes are not unique (more than one grantor can grant the same privilege), but AFAICS the syscache interface should work okay with this, since in normal operation we don't care who granted the privilege, only whether you have at least one. How does that look? -- Peter Eisentr

Re: [HACKERS] System catalog representation of access privileges

2001-04-19 Thread Peter Eisentraut
ar pritarget, -- 't' = any table, 'v' = any view, ... char priselect, char priupdate, /* etc */ ) But this would mean that a check like "can I select from this table" would possibly require lookups in two tables. Not sure how much of a tradeoff that is, but the "shoehor

Re: [HACKERS] Re: [BUGS] three VERY minor things with 7.1 final

2001-04-19 Thread Peter Eisentraut
it obviously had a net negative benefit. Those who want to use it can still add '-lstdio -lsfio' to LIBS. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] RFC: planner statistics in 7.2

2001-04-20 Thread Peter Eisentraut
the table is left as a challenge. ;-) This brings up a question I have: Are statistics calculated for every column? Should they be? Is there a possibility to speed up ANALYZE by controlling this? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [HACKERS] System catalog representation of access privileges

2001-04-20 Thread Peter Eisentraut
Tom Lane writes: Peter Eisentraut [EMAIL PROTECTED] writes: pg_privilege ( priobj oid, -- oid of table, column, function, etc. prigrantor oid, -- user who granted the privilege prigrantee oid, -- user who owns the privilege What about

[HACKERS] setuid(geteuid());?

2001-04-21 Thread Peter Eisentraut
This call setuid(geteuid()); is found in backend/utils/init/postinit.c. AFAICT, this does nothing. Anyone got an idea? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] setuid(geteuid());?

2001-04-21 Thread Peter Eisentraut
would have to use seteuid() to do what setuid() does here. One more reason to avoid this area when possible. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] Re: How to determine if a user exists..

2001-04-23 Thread Peter Eisentraut
existence in the context of a new authentication method is to not do that at all. None of the other methods do it, the existence of a user is checked when authentication has completed and the backend starts. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [HACKERS] row name length

2001-04-23 Thread Peter Eisentraut
row headers? Yes. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: SET SESSION AUTHORIZATION (was Re: [HACKERS] Real/effectiveuser)

2001-04-23 Thread Peter Eisentraut
management we will probably have the ability to revert user identity changes like you probably imagine. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [HACKERS] refusing connections based on load ...

2001-04-24 Thread Peter Eisentraut
and FreeBSD 4.3. Rumour[*] also has it that there is a way to do this on Solaris and HP-UX 9. So I think that covers enough users to be worthwhile. [*] - Autoconf AC_FUNC_GETLOADAVG -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end

Re: [HACKERS] refusing connections based on load ...

2001-04-24 Thread Peter Eisentraut
used as an administrative tool. The rule is, if you don't like it, don't use it. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] refusing connections based on load ...

2001-04-25 Thread Peter Eisentraut
setups exist, but not everywhere. To me, both of these approaches are in the if you don't like it, don't use it category. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked

[HACKERS] zpbit_in does not receive correct atttypmod

2001-04-26 Thread Peter Eisentraut
When I create a table create table test (a bit(4)); and insert a value insert into test values (b'11'); the zpbit_in() function gets an atttypmod (arg 2 (of 2)) of -1. Is there somewhere the system needs to be told that this type uses the atttypmod field? -- Peter Eisentraut

Re: [HACKERS] `make depend' broken in CVS sources

2001-04-27 Thread Peter Eisentraut
Ian Lance Taylor writes: `make depend' is broken in the CVS sources. 'make depend' doesn't exist anymore. Use configure --enable-depend. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP

[HACKERS] Re: v7.1.1 branched and released on Tuesday ...

2001-04-30 Thread Peter Eisentraut
. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Unix sockets connection authentication - patch

2001-05-03 Thread Peter Eisentraut
Oliver Elphick writes: Since it is not universally supported, I have included a configure test. autoconf needs to be run after installing the patch. You don't need Autoconf tests for cpp symbols. You can just write #ifdef WEIRD_SYMBOL in the code. Btw., never ever use AC_EGREP_*. -- Peter

Re: [HACKERS] \c connects as another user instead I want in psql

2001-05-03 Thread Peter Eisentraut
Kovacs Zoltan writes: By the way, could you please define a unique constraint on column 'usesysid' in future in PostgreSQL? The usesysid column will be removed and the oid column will be used instead. That one tends to be unique, but an index will still be added. -- Peter Eisentraut

Re: [HACKERS] \c connects as another user instead I want in psql

2001-05-03 Thread Peter Eisentraut
Bruce Momjian writes: Really? We are removing usesysid? Seems the admin will no longer be able to choose the users id, right? Not that this was ever useful. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [HACKERS] Final stamp for 7.1.1

2001-05-03 Thread Peter Eisentraut
can now take string argument (Thomas) Python fixes (Darcy) Is this OK? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [HACKERS] Packaging 7.1.1

2001-05-04 Thread Peter Eisentraut
Lamar Owen writes: contrib/rpm-dist? A separate CVS module sounds like a better idea to me. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [HACKERS] Re: Metaphone function attachment

2001-05-04 Thread Peter Eisentraut
be moved into the core. contrib is a nice place for things that we don't really know how/whether they work, but once we're confident about the quality we might as well offer it by default. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end

Re: [HACKERS] Packaging 7.1.1

2001-05-04 Thread Peter Eisentraut
can be developed and released at their own pace. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[HACKERS] elog(LOG), elog(DEBUG)

2001-05-05 Thread Peter Eisentraut
should be converted to INFO conditional on a configuration setting (like log_pid, for example). The stricter distinction between DEBUG and INFO would also yield the possibility of optionally sending DEBUG output to the frontend, as has been requested a few times. -- Peter Eisentraut [EMAIL

Re: [HACKERS] elog(LOG), elog(DEBUG)

2001-05-05 Thread Peter Eisentraut
Tom Lane writes: Peter Eisentraut [EMAIL PROTECTED] writes: There's a TODO item to make elog(LOG) a separate level. I propose the name INFO. It would be identical to DEBUG in effect, only with a different label. This conveys nothing to my mind. How should I determine whether a given

Re: [HACKERS] Lisp as procedural language

2001-05-05 Thread Peter Eisentraut
|/usr/ucb/liszt [...] This must have been an artifact from the time when part of the Postgres system was written in Lisp. A Lisp procedural language never actually existed in PostgreSQL. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end

Re: [HACKERS] Problem with authentication in psql.

2001-07-06 Thread Peter Eisentraut
' Official PostgreSQL sources don't have peer authentication. You should contact the provider of your package (Debian?). -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our

Re: [HACKERS] FE/BE protocol oddity

2001-07-06 Thread Peter Eisentraut
-blocking mode was using some of the intermediate states. I'll change it momentarily. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

[HACKERS] Happy Anniversary

2001-07-08 Thread Peter Eisentraut
I suppose few people have remembered that today is what could be considered the 5th anniversary of the PostgreSQL project. Cheers for another five years! http://www.ca.postgresql.org/mhonarc/pgsql-hackers/1999-10/msg00552.html -- Peter Eisentraut [EMAIL PROTECTED] http

Re: AW: [HACKERS] New SQL Datatype RECURRINGCHAR

2001-07-09 Thread Peter Eisentraut
the same thing (different join syntax), whereas a leaf generally underlying table is guaranteed to be a real base table. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading

Re: AW: [HACKERS] pg_index.indislossy

2001-07-10 Thread Peter Eisentraut
more tuples than the ones that match the given qual. Okay, this is not surprising. I agree that storing this in the index might be suboptimal. But why is this called lossy? Shouldn't it be called exceedy? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

[HACKERS] FE/BE protocol oddity

2001-07-10 Thread Peter Eisentraut
an appropriate way to check for a closed connection without reading anything? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

[HACKERS] Time to read pg_hba.conf (Re: [PATCHES] [PATCH] Patch to make...)

2001-07-10 Thread Peter Eisentraut
| 0.071679 | 0.00629838985852663 -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] grant and SQL92

2001-07-10 Thread Peter Eisentraut
Bruce Momjian writes: On Sat, 9 Jun 2001, Peter Eisentraut wrote: Vince Vielhaber writes: I can grant a series of privileges (comma separated) on a series of objects (comma separated) to either a user, group or public NOT a comma separated list of users or groups. I

Re: [HACKERS] grant and SQL92

2001-07-13 Thread Peter Eisentraut
Bruce Momjian writes: On Sat, 9 Jun 2001, Peter Eisentraut wrote: Vince Vielhaber writes: I can grant a series of privileges (comma separated) on a series of objects (comma separated) to either a user, group or public NOT a comma separated list of users or groups. I

Re: [HACKERS] Re: SOMAXCONN (was Re: Solaris source code)

2001-07-13 Thread Peter Eisentraut
it? Because the new connection might be a cancel request. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [HACKERS] grant and SQL92

2001-07-13 Thread Peter Eisentraut
Bruce Momjian writes: Can't I keep it on the TODO until it is done? And wasn't yesterday tomorrow? :-) No, tomorrow was the day after June 9th. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [HACKERS] Re: SOMAXCONN (was Re: Solaris source code)

2001-07-11 Thread Peter Eisentraut
that barfed on large listen() parameters. We'll never find that out if we don't try it. If you're concerned about cooperating with other listen()ing processes, set it to MaxBackends * 2, if you're not, set it to INT_MAX and watch. -- Peter Eisentraut [EMAIL PROTECTED] http

Re: [PATCHES] Re: [HACKERS] [PATCH] Re: Setuid functions

2001-07-11 Thread Peter Eisentraut
whether we'd eventually like to have grantable privileges, and if so, how this would fit in. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PATCHES] Re: [HACKERS] [PATCH] Re: Setuid functions

2001-07-12 Thread Peter Eisentraut
, because any setuid function would have to run with super powers. - Allowing it only in trigger functions? (That way a user has to actually own one of the tables) Your premise is no longer correct in 7.2devel. Mark Peter Eisentraut wrote: Bruce Momjian writes: Peter might

Re: [HACKERS] pg_depend

2001-07-17 Thread Peter Eisentraut
still be possible.) But how then do you find the system table that uses the given oid? It's implied by the column you're looking at. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1

Re: [HACKERS] pg_depend

2001-07-17 Thread Peter Eisentraut
.) -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [HACKERS] pg_depend

2001-07-17 Thread Peter Eisentraut
. There might be others I forgot but a finite list can be defined. When a table is dropped, you scan all of these objects (their system catalogs) for matches against the table and either do a cascade or restrict. This is not new, we already do this for indexes and descriptions, for instance. -- Peter

Re: [HACKERS] pg_depend

2001-07-17 Thread Peter Eisentraut
. The former is what I'm advocating. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] NetBSD 1.5.1(HP300)

2001-07-16 Thread Peter Eisentraut
conftest -O2 -g conftest.c -lreadline -ltermcap 15 [success] Can you take this to the OS developers? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands

Re: [HACKERS] pg_depend

2001-07-16 Thread Peter Eisentraut
| CASCADE] to make use of dependency info. That was me. The point, however, was, given object id 145928, how the heck to you know what table this comes from? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

[HACKERS] iconv?

2001-07-11 Thread Peter Eisentraut
a few systems, too. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [HACKERS] LOG PgSql ..

2001-07-11 Thread Peter Eisentraut
gabriel writes: Is there a way to config the postmaster to log in a file all connections and querys to each database? http://www.de.postgresql.org/users-lounge/docs/7.1/postgres/runtime-config.html#LOGGING -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [HACKERS] pg_depend

2001-07-16 Thread Peter Eisentraut
in the dependency case. (E.g., make sure none of them require whereToSendOutput or parser state as an argument.) -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] ALTER TABLE ADD COLUMN column SERIAL -- unexpectedresults

2001-07-17 Thread Peter Eisentraut
wanted'; A subtle difference, but it's perfectly consistent. -- And it works already. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [HACKERS] NetBSD 1.5.1(HP300)

2001-07-16 Thread Peter Eisentraut
to succeed without -lcurses. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Possible feature?

2001-07-11 Thread Peter Eisentraut
would receive: 'An employee with a matching Social Security number already exists' I think what you're after is TRY BEGIN INSERT ... END CATCH SQLCODE 12345 -- made up BEGIN RAISE 'your message here' END I'm positive people would kill for that kind of feature. -- Peter

Re: [HACKERS] iconv?

2001-07-13 Thread Peter Eisentraut
in ports openbsd in ports osf yes qnx4 sco yes solaris yes sunos4 unixwareyes win In addition there's a free portable libiconv library available. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter

Re: [HACKERS] libpq autoconf scripts?

2001-07-11 Thread Peter Eisentraut
Timothy H. Keitt writes: Anyone maintaining generic autoconf scripts for linking against libpq, i.e., returns path to libpq-fe.h and proper link options? pg_config since 7.1 -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end

Re: [HACKERS] Re: SOMAXCONN (was Re: Solaris source code)

2001-07-11 Thread Peter Eisentraut
make sense? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] FW: [JDBC] BIGINT vs Java's long

2001-08-07 Thread Peter Eisentraut
(ERROR, Bad int8 external representation \%s\, str); - result = (sign 0) ? -tmp : tmp; + result = (sign 0) ? -tmp : tmp; PG_RETURN_INT64(result); } ===end -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast

Re: [HACKERS] Possible solution for LIKE optimization

2001-08-05 Thread Peter Eisentraut
Tom Lane writes: Peter Eisentraut [EMAIL PROTECTED] writes: I have had an idea how the LIKE optimization problem could be solved. Hmm ... so in a non-ASCII locale, we'd have to look for an index on strxfrm(A) rather than directly on A. And the index would need to use a nonstandard

Re: [HACKERS] failed: make install prefix=/foo/bar

2001-08-07 Thread Peter Eisentraut
Karel Zak writes: Yes, you are right. But make install prefix=... can be used for package building if you want install all to some temp directory and compress it. In that case it's much better to use make install DESTDIR= -- Peter Eisentraut [EMAIL PROTECTED] http

[HACKERS] config.guess updated in CVS

2001-08-07 Thread Peter Eisentraut
config.guess now supports OpenUNIX 8, AIX 5, HPUX on IA64, and Linux on PPC64. Enjoy. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

<    3   4   5   6   7   8   9   10   11   12   >