summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2011-02-07Fix error messages for FreeFile in COPY command.Itagaki Takahiro
They are extracted from COPY API patch. suggested by Noah Misch
2011-02-06Force strings passed to and from plperl to be in UTF8 encoding.Andrew Dunstan
String are converted to UTF8 on the way into perl and to the database encoding on the way back. This avoids a number of observed anomalies, and ensures Perl a consistent view of the world. Some minor code cleanups are also accomplished. Alex Hunsaker, reviewed by Andy Colson.
2011-02-06Rename macro DECIMAL to DECIMAL_T to help pgindent; this is alreadyBruce Momjian
done for a few other macros in that file, for other reasons. I also remove pgindent/README mention of the file.
2011-02-06IDENTIFY_SYSTEM now returns 3 fields, not 2Magnus Hagander
2011-02-06Tighten ALTER FOREIGN TABLE .. SET DATA TYPE checks.Robert Haas
If the foreign table's rowtype is being used as the type of a column in another table, we can't just up and change its data type. This was already checked for composite types and ordinary tables, but we previously failed to enforce it for foreign tables.
2011-02-04Add C comment about why older compilers complain about basebackup.c'sBruce Momjian
longjump.
2011-02-04Attempt to unbreak MSVC builds after pipe.c move.Andrew Dunstan
2011-02-04Clarify comment in ATRewriteTable().Robert Haas
Make sure it's clear that the prohibition on adding a column with a default when the rowtype is used elsewhere is intentional, and be a bit more explicit about the other cases where we perform this check.
2011-02-04Move pipe.c into the backend.Robert Haas
It's full of backend-specific error reporting, so it's neither possible nor necessary for this to be used from frontend code.
2011-02-04Avoid including postgres.h in frontend compiles of src/port.Robert Haas
This isn't kosher, and doesn't play nicely with my recent changes to the Makefile in this directory.
2011-02-04Use $(MAKE) rather than make.Robert Haas
Per buildfarm.
2011-02-04Make handling of errcodes.h more consistent with other generated headers.Robert Haas
This fixes make distprep, and seems more robust in other ways as well. Some special handling is required because errcodes.txt is needed by some stuff in src/port, but just by src/backend as is the case for the other generated headers. While I'm at it, fix a few other things that were overlooked in the original patch.
2011-02-04Unbreak 'configure' followed immediately by 'make install'.Robert Haas
More fallout from ddfe26f6441c24660595c5efe5fd0bd3974cdc5c. Report by Fujii Masao.
2011-02-04Use single quotes when there are backslashes in the filenameMagnus Hagander
In the hope of unbreaking the buildfarm
2011-02-04Unbreak the VPATH build.Robert Haas
My commit ddfe26f6441c24660595c5efe5fd0bd3974cdc5c of 2010-02-03 broke it. Per buildfarm.
2011-02-03Preserve copyright notice from old errcodes.h file.Robert Haas
2011-02-03Avoid maintaining three separate copies of the error codes list.Robert Haas
src/pl/plpgsql/src/plerrcodes.h, src/include/utils/errcodes.h, and a big chunk of errcodes.sgml are now automatically generated from a single file, src/backend/utils/errcodes.txt. Jan Urbański, reviewed by Tom Lane.
2011-02-03Simplify code used in is_absolute_path() macro; also add comment aboutBruce Momjian
'E:abc' Win32 path handling.
2011-02-03Include more status information in walsender resultsMagnus Hagander
Add the current xlog insert location to the response of IDENTIFY_SYSTEM, and adds result sets containing start and stop location of backups to BASE_BACKUP responses.
2011-02-02Rename function to first_path_var_separator() to clarify it works withBruce Momjian
path variables, not directory paths.
2011-02-02Clearify macro IS_PATH_VAR_SEP in path.c so it is clear this is a pathBruce Momjian
variable, not a directory path.
2011-02-02Log restartpoints in the same fashion as checkpoints.Robert Haas
Prior to 9.0, restartpoints never created, deleted, or recycled WAL files, but now they can. This code makes log_checkpoints treat checkpoints and restartpoints symmetrically. It also adjusts up the documentation of the parameter to mention restartpoints. Fujii Masao. Docs by me, as suggested by Itagaki Takahiro.
2011-02-02Clean up missed change to plpython expected files.Tom Lane
2011-02-02Wrap PL/Python SPI calls into subtransactionsPeter Eisentraut
This allows the language-specific try/catch construct to catch and handle exceptions arising from SPI calls, matching the behavior of other PLs. As an additional bonus you no longer get all the ugly "unrecognized error in PLy_spi_execute_query" errors. Jan Urbański, reviewed by Steve Singer
2011-02-02Add comment on why we're passing a useless 'false' to the plperl function ↵Andrew Dunstan
compiler. It's for compatibility with modules like PostgreSQL::PLPerl::NYTProf.
2011-02-01Add validator to PL/PythonPeter Eisentraut
Jan Urbański, reviewed by Hitoshi Harada
2011-02-01Set up PLPerl trigger data using C code instead of Perl code.Andrew Dunstan
This is an efficiency change, and means we now no longer have to run "out $_TD; local $_TD = shift;", which was especially pointless in the case of non-trigger functions where the passed value was always undef anyway. A tiny open issue is whether we should get rid of the $prolog argument of mkfunc, and the corresponding pushed value, which is now just a constant "false". Tim Bunce, reviewed by Alex Hunsaker.
2011-02-01Undefine setlocale() macro on Win32Magnus Hagander
New versions of libintl redefine setlocale() to a macro which causes problems when the backend and libintl are linked against different versions of the runtime, which is often the case in msvc builds. Hiroshi Inoue, slightly updated comment by me
2011-02-01Re-classify ERRCODE_DATABASE_DROPPED to 57P04Simon Riggs
2011-02-01Fix wrong error reports in 'number of array dimensions exceeds theItagaki Takahiro
maximum allowed' messages, that have reported one-less dimensions. Alexey Klyukin
2011-02-01Create new errcode for recovery conflict caused by db drop on master.Simon Riggs
Previously reported as ERRCODE_ADMIN_SHUTDOWN, this case is now reported as ERRCODE_T_R_DATABASE_DROPPED. No message text change. Unlikely to happen on most servers, so low impact change to allow session poolers to correctly handle this situation. Tatsuo Ishii, edits by me, review by Robert Haas
2011-01-31Fix error code for canceling statement due to conflict with recovery.Simon Riggs
All retryable conflict errors now have an error code that indicates that a retry is possible, correcting my incomplete fix of 2010/05/12 Tatsuo Ishii and Simon Riggs, input from Robert Haas and Florian Pflug
2011-01-31Fix typoHeikki Linnakangas
2011-01-31Support multiple concurrent pg_basebackup backups.Heikki Linnakangas
With this patch, pg_basebackup doesn't write a backup_label file in the data directory, so it doesn't interfere with a pg_start/stop_backup() based backup anymore. backup_label is still included in the backup, but it is injected directly into the tar stream. Heikki Linnakangas, reviewed by Fujii Masao and Magnus Hagander.
2011-01-30Fix typoAndrew Dunstan
2011-01-30Enable building with the Mingw64 compiler.Andrew Dunstan
This can be used to build 64 bit Windows binaries, not only on 64 bit Windows but on supported cross-compiling hosts including 32 bit Windows, Cygwin, Darwin and Linux.
2011-01-30Make reduce_outer_joins() smarter about semijoins.Tom Lane
reduce_outer_joins() mistakenly treated a semijoin like a left join for purposes of deciding whether not-null constraints created by the join's quals could be passed down into the join's left-hand side (possibly resulting in outer-join simplification there). Actually, semijoin works like inner join for this purpose, ie, we do not need to see any rows that can't possibly satisfy the quals. Hence, two-line fix to treat semi and inner joins alike. Per observation by Andres Freund about a performance gripe from Yazan Suleiman. Back-patch to 8.4, since this oversight has been there since the current handling of semijoins was implemented.
2011-01-30Add option to include WAL in base backupMagnus Hagander
When included, this makes the base backup a complete working "clone" of the initial database, ready to have a postmaster started against it without the need to set up any log archiving or similar. Magnus Hagander, reviewed by Fujii Masao and Heikki Linnakangas
2011-01-29Use GSSAPI library for SSPI auth, when native SSPI is not availableMagnus Hagander
This allows non-Windows clients to connect to a Windows server with SSPI authentication. Christian Ullrich, largely modified by me
2011-01-29Try to avoid running with a full fsync request queue.Robert Haas
When we need to insert a new entry and the queue is full, compact the entire queue in the hopes of making room for the new entry. Doing this on every insertion might worsen contention on BgWriterCommLock, but when the queue it's full, it's far better than allowing the backend to perform its own fsync, per testing by Greg Smith as reported in http://archives.postgresql.org/pgsql-hackers/2011-01/msg02665.php Original idea from Greg Smith. Patch by me. Review by Chris Browne and Greg Smith
2011-01-27Don't include <asm/ia64regs.h> unnecessarily.Tom Lane
We only need that header when compiling with icc, since the gcc variant of ia64_get_bsp() uses in-line assembly code. Per report from Frank Brendel, the header doesn't exist on all IA64 platforms; so don't include it unless we need it.
2011-01-27Update psql's \copyright to match the text we have in the COPYRIGHT file.Heikki Linnakangas
2011-01-27Restore ALTER TABLE .. ADD COLUMN w/DEFAULT restriction.Robert Haas
This reverts commit a06e41deebdf74b8b5109329dc75b2e9d9057962 of 2011-01-26. Per discussion, this behavior is not wanted, as it would need to change if we ever made composite types support DEFAULT.
2011-01-26Change inv_truncate() to not repeat its systable_getnext_ordered() scan.Tom Lane
In the case where the initial call of systable_getnext_ordered() returned NULL, this function would nonetheless call it again. That's undefined behavior that only by chance failed to not give visibly incorrect results. Put an if-test around the final loop to prevent that, and in passing improve some comments. No back-patch since there's no actual failure. Per report from YAMAMOTO Takashi.
2011-01-27autoreconfPeter Eisentraut
Synchronize pg_config.h.in with configure.in (someone must have forgotten to run autoheader or autoreconf), and clean up some spurious change in configure introduced by the last commit there.
2011-01-27Do not prefix error messages with the string "PL/Python: "Peter Eisentraut
It is redundant, given the error context. Jan Urbański
2011-01-27Improve exception usage in PL/PythonPeter Eisentraut
Use the built-in TypeError, not SPIError, for errors having to do with argument counts or types. Use SPIError, not simply plpy.Error, for errors in PLy_spi_execute_plan. Finally, do not set a Python exception if PyArg_ParseTuple failed, as it already sets the correct exception. Jan Urbański
2011-01-27Also save the error detail in SPIErrorPeter Eisentraut
The temporarily broken plpython_unicode test shows a case where this is used. Do remaining fix-ups on the expected files at the same time.
2011-01-27Fix compiler warningsPeter Eisentraut
Older versions of GCC appear to report these with the current standard option set, newer versions need -Wformat-security.
2011-01-26Add a comment explaining why we force physical removal of OIDs.Robert Haas
Noah Misch, slightly revised.