summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2006-02-18Add support for Windows codepages 1253, 1254, 1255, and 1257 and cleanPeter Eisentraut
up a bunch of the support utilities. In src/backend/utils/mb/Unicode remove nearly duplicate copies of the UCS_to_XXX perl script and replace with one version to handle all generic files. Update the Makefile so that it knows about all the map files. This produces a slight difference in some of the map files, using a uniform naming convention and not mapping the null character. In src/backend/utils/mb/conversion_procs create a master utf8<->win codepage function like the ISO 8859 versions instead of having a separate handler for each conversion. There is an externally visible change in the name of the win1258 to utf8 conversion. According to the documentation notes, it was named incorrectly and this changes it to a standard name. Running the Unicode mapping perl scripts has shown some additional mapping changes in koi8r and iso8859-7.
2006-02-18Mark unescape_single_char() "static": as far as I can see this functionNeil Conway
is only used by scan.l/scan.c
2006-02-17Fix typo in comment.Neil Conway
2006-02-16Change MemSet to use long instead of int32, for better performance onPeter Eisentraut
64-bit platforms. by ITAGAKI Takahiro
2006-02-14Repair --single-transaction patch so it handles blobs correctly.Tom Lane
Simon Riggs
2006-02-14Move btbulkdelete's vacuum_delay_point() call to a place in the loop whereTom Lane
we are not holding a buffer content lock; where it was, InterruptHoldoffCount is positive and so we'd not respond to cancel signals as intended. Also add missing vacuum_delay_point() call in btvacuumcleanup. This should fix complaint from Evgeny Gridasov about failure to respond to SIGINT/SIGTERM in a timely fashion (bug #2257).
2006-02-14Add some missing vacuum_delay_point calls in GIST vacuuming.Tom Lane
2006-02-14AllocSetStats should probably be using unsigned format to show space totals.Tom Lane
2006-02-13Add positive defense against trying to connect when the connectionTom Lane
option state hasn't been fully set up. This is possible via PQreset() and might occur in other code paths too, so a state flag seems the most robust solution. Per report from Arturs Zoldners.
2006-02-13IMHO, --single-transaction should wrap *all* the commands in BEGIN/COMMIT,Tom Lane
not just some of them.
2006-02-13Place function names in first column for consistency.Bruce Momjian
2006-02-13Fix qual_is_pushdown_safe to not try to push down quals involving a whole-rowTom Lane
Var referencing the subselect output. While this case could possibly be made to work, it seems not worth expending effort on. Per report from Magnus Naeslund(f).
2006-02-13Fix build failure when not USE_READLINE. Sergey E. KoposovTom Lane
2006-02-12Revert because C locale uses "" for thousands_sep, meaning "n/a", whileBruce Momjian
French uses "" for "don't want". Seems we have to keep the existing behavior.
2006-02-12Fix bug that allowed any logged-in user to SET ROLE to any other database userTom Lane
id (CVE-2006-0553). Also fix related bug in SET SESSION AUTHORIZATION that allows unprivileged users to crash the server, if it has been compiled with Asserts enabled. The escalation-of-privilege risk exists only in 8.1.0-8.1.2. However, the Assert-crash risk exists in all releases back to 7.3. Thanks to Akio Ishida for reporting this problem.
2006-02-12Throw a warning rather than an error on invalid character from UTF8 toBruce Momjian
Latin1, like we do for other Latin encodings.
2006-02-12Back out patch pending review.Bruce Momjian
--------------------------------------------------------------------------- > I've now tested this patch at home w/ 8.2HEAD and it seems to fix the > bug. I plan on testing it under 8.1.2 at work tommorow with > mod_auth_krb5, etc, and expect it'll work there. Assuming all goes > well and unless someone objects I'll forward the patch to -patches. > It'd be great to have this fixed as it'll allow us to use Kerberos to > authenticate to phppgadmin and other web-based tools which use > Postgres. While playing with this patch under 8.1.2 at home I discovered a mistake in how I manually applied one of the hunks to fe-auth.c. Basically, the base code had changed and so the patch needed to be modified slightly. This is because the code no longer either has a freeable pointer under 'name' or has 'name' as NULL. The attached patch correctly frees the string from pg_krb5_authname (where it had been strdup'd) if and only if pg_krb5_authname returned a string (as opposed to falling through and having name be set using name = pw->name;). Also added a comment to this effect. Please review. Stephen Frost (sfrost@snowman.net) wrote:
2006-02-12> I've now tested this patch at home w/ 8.2HEAD and it seems to fix theBruce Momjian
> bug. I plan on testing it under 8.1.2 at work tommorow with > mod_auth_krb5, etc, and expect it'll work there. Assuming all goes > well and unless someone objects I'll forward the patch to -patches. > It'd be great to have this fixed as it'll allow us to use Kerberos to > authenticate to phppgadmin and other web-based tools which use > Postgres. While playing with this patch under 8.1.2 at home I discovered a mistake in how I manually applied one of the hunks to fe-auth.c. Basically, the base code had changed and so the patch needed to be modified slightly. This is because the code no longer either has a freeable pointer under 'name' or has 'name' as NULL. The attached patch correctly frees the string from pg_krb5_authname (where it had been strdup'd) if and only if pg_krb5_authname returned a string (as opposed to falling through and having name be set using name = pw->name;). Also added a comment to this effect. Please review. Stephen Frost (sfrost@snowman.net) wrote:
2006-02-12Support "" for thousands separator and plus sign in to_char(), perBruce Momjian
report from French Debian user. psql already handles "" fine.
2006-02-12Remove LEFT part of JOIN to pg_roles because of optimizer limitation:Bruce Momjian
> True, but they're not being used where you'd expect. This seems to be > something to do with the fact that it's not pg_authid which is being > accessed, but rather the view pg_roles. I looked into this and it seems the problem is that the view doesn't get flattened into the main query because of the has_nullable_targetlist limitation in prepjointree.c. That's triggered because pg_roles has '********'::text AS rolpassword which isn't nullable, meaning it would produce wrong behavior if referenced above the outer join. Ultimately, the reason this is a problem is that the planner deals only in simple Vars while processing joins; it doesn't want to think about expressions. I'm starting to think that it may be time to fix this, because I've run into several related restrictions lately, but it seems like a nontrivial project. In the meantime, reducing the LEFT JOIN to pg_roles to a JOIN as per Peter's suggestion seems like the best short-term workaround.
2006-02-12Revert patch becaues of locking concerns:Bruce Momjian
Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME Joachim Wieland
2006-02-12Update release checlist.Bruce Momjian
2006-02-12Improve tab completion macro for default keywords.Bruce Momjian
2006-02-12When performing a parallel build (make -j N) with ./configureBruce Momjian
--enable-depend it often tries to create the .deps directory twice and bails out when it already exists due to a race condition of if doesn't exist, then create. This patch prevents mkdir from returning an error. Kris Jurka
2006-02-12List psql tab completion for various default keywords.Bruce Momjian
Joachim Wieland
2006-02-12Apply code-reviewed version of for-scalar-list patch: mostly, fixingTom Lane
it to report reasonable errors in error cases.
2006-02-12Add MSVC support for utility commands and pg_dump.Bruce Momjian
Hiroshi Saito
2006-02-12Allow PL/pgSQL FOR statement to return values to scalars as well asBruce Momjian
records and row types. Pavel Stehule
2006-02-12Use 0x01 for newlines in saved history. It was determined to be notBruce Momjian
used by multi-byte sequences, but futher invesetigation might prove this to be false.
2006-02-12Clean up plpgsql grammar to make sure that check_assignable() is appliedTom Lane
consistently. This is mostly cosmetic right at the moment because check_assignable() does nothing for ROW or RECORD datums, but that might not always be so. This also syncs several different places that read INTO target lists. They're just enough different that it seems impractical to factor them into a single routine, but they surely should be the same as much as possible.
2006-02-12Allow to_char() to print localized month and day names.Bruce Momjian
Euler Taveira de Oliveira
2006-02-12As part of previous commit, add pg_restore option:Bruce Momjian
-1 or --single-transaction Simon Riggs
2006-02-12Add psql option:Bruce Momjian
-1 or --single-transaction Simon Riggs
2006-02-12Add contrib/pg_freespacemap to display free space map information.Bruce Momjian
Mark Kirkwood
2006-02-12Fix more fallout from line-wrap patch, to wit, arbitrarily changingTom Lane
the API of PQdsplen without bothering to fix its callers. Although ReportSyntaxErrorPosition could probably do with more smarts about handling control characters, for the moment I'll just get it back to handling tabs consistently.
2006-02-12I've created a new shared catalog table pg_shdescription to storeBruce Momjian
comments on cluster global objects like databases, tablespaces, and roles. It touches a lot of places, but not much in the way of big changes. The only design decision I made was to duplicate the query and manipulation functions rather than to try and have them handle both shared and local comments. I believe this is simpler for the code and not an issue for callers because they know what type of object they are dealing with. This has resulted in a shobj_description function analagous to obj_description and backend functions [Create/Delete]SharedComments mirroring the existing [Create/Delete]Comments functions. pg_shdescription.h goes into src/include/catalog/ Kris Jurka
2006-02-12Undo changes of trailing space in recently-committed expected files.Tom Lane
This is mostly just over-compulsiveness on my part, but the exercise did reveal one real bug: errors.out has a space difference now where it should not.
2006-02-12Restore previous psql behavior of not printing useless trailing spacesTom Lane
after the data in the last column on a line.
2006-02-12Please find enclosed a patch that lets you use \c to connectBruce Momjian
(optionally) to a new host and port without exiting psql. This eliminates, IMHO, a surprise in that you can now connect to PostgreSQL on a differnt machine from the one where you started your session. This should help people who use psql as an administrative tool. David Fetter
2006-02-12Actually there's a better way to do this, which is to count tuplesTom Lane
during the vacuumcleanup scan that we're going to do anyway. Should save a few cycles (one calculation per page, not per tuple) as well as not having to depend on assumptions about heap and index being in step. I think this could probably be made to work for GIST too, but that code looks messy enough that I'm disinclined to try right now.
2006-02-11Skip ambulkdelete scan if there's nothing to delete and the index is notTom Lane
partial. None of the existing AMs do anything useful except counting tuples when there's nothing to delete, and we can get a tuple count from the heap as long as it's not a partial index. (hash actually can skip anyway because it maintains a tuple count in the index metapage.) GIST is not currently able to exploit this optimization because, due to failure to index NULLs, GIST is always effectively partial. Possibly we should fix that sometime. Simon Riggs w/ some review by Tom Lane.
2006-02-11Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAMEBruce Momjian
Joachim Wieland
2006-02-11o Improve psql's handling of multi-line statementsBruce Momjian
Currently, while \e saves a single statement as one entry, interactive statements are saved one line at a time. Ideally all statements would be saved like \e does. Sergey E. Koposov
2006-02-11Fix incorrect addition, subtraction, and overflow checking in newTom Lane
inet operators.
2006-02-11Revert based on Tom's recommendation:Bruce Momjian
> Allow VACUUM to complete faster by avoiding scanning the indexes when no > rows were removed from the heap by the VACUUM.
2006-02-11Allow VACUUM to complete faster by avoiding scanning the indexes when noBruce Momjian
rows were removed from the heap by the VACUUM. Simon Riggs
2006-02-11Update catalog version for INET additions.Bruce Momjian
2006-02-11Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inetBruce Momjian
minus inet. Stephen R. van den Berg
2006-02-10Clean up signedness warnings and 64-bit bugs in recent psql printingTom Lane
patch. Martijn van Oosterhout and Tom Lane
2006-02-10Make it possible to run initdb from an admin account on Windows,Tom Lane
by giving up admin privileges (only works if newer than NT4). Magnus