summaryrefslogtreecommitdiff
path: root/src/bin
AgeCommit message (Collapse)Author
2009-01-13Throw an error when using -C and -1 at the same time in pg_restore.Magnus Hagander
It's not possible to do CREATE DATABASE inside a transaction, so previously we just got a server error instead. Backpatch to 8.2, which is where the -1 feature appeared.
2008-10-30Translation updatesPeter Eisentraut
2008-09-30Recent patches to pg_ctl broke "pg_ctl restart" for the case where noTom Lane
command-line options had been given to the postmaster; and just plain broke it altogether in 8.1 and 8.0. Per report from KaiGai Kohei.
2008-09-24Make sure pg_control is opened in binary mode, to dealMagnus Hagander
with situtations when the file contains an EOF maker (0x1A) on Windows. ITAGAKI Takahiro
2008-08-16Fix pg_dump/pg_restore's ExecuteSqlCommand() to behave suitably if PQexecTom Lane
returns NULL instead of a PGresult. The former coding would fail, which is OK, but it neglected to give you the PQerrorMessage that might tell you why. In the oldest branches, there was another problem: it'd sometimes report PQerrorMessage from the wrong connection.
2008-06-27Fix 'pg_ctl reload' to properly preserve postmaster commend-lineBruce Momjian
arguments on restart. Patch to releases 8.0 - 8.3.X.
2008-06-05Translation updates.Tom Lane
2008-03-14Translation updatesREL8_2_7Peter Eisentraut
2008-02-29Don't call AddUserToDacl on CygwinAndrew Dunstan
2008-02-29Fix handling of restricted processes for Windows Vista (mainly),Magnus Hagander
by explicitly adding back the user to the DACL of the new process. This fixes the failure case when executing as the Administrator user, which had no permissions left at all after we dropped the Administrators group. Dave Page with some modifications from me
2008-02-20Fix mistakes in pg_ctl's code for "start -w" that tries to cope withTom Lane
non-default settings for the postmaster's port number. The code to parse command line options and postgresql.conf entries wasn't quite right about whitespace or quotes, and it was coded in a not-very-readable way too. Per bug #3969 from Itagaki Takahiro, though this is more extensive than his proposed patch (which fixed only the whitespace problem). This code has been broken since it was put in in 8.0, so patch all the way back.
2007-10-28Fix a couple of issues with pg_dump's handling of inheritance child tablesTom Lane
that have default expressions different from their parent. First, if the parent table's default expression has to be split out as a separate ALTER TABLE command, we need a dependency constraint to ensure that the child's command is given second. This is because the ALTER TABLE on the parent will propagate to the child. (We can't prevent that by using ONLY on the parent's command, since it's possible that other children exist that should receive the inherited default.) Second, if the child has a NULL default where the parent does not, we have to explicitly say DEFAULT NULL on the child in order for this state to be preserved after reload. (The latter actually doesn't work right because of a backend bug, but that is a separate issue.) Backpatch as far as 8.0. 7.x pg_dump has enough issues with altered tables (due to lack of dependency analysis) that trying to fix this one doesn't seem very productive.
2007-09-13Translation updatesPeter Eisentraut
2007-08-29Fix aboriginal bug in _tarAddFile(): when complaining that the amount of dataTom Lane
read from the temp file didn't match the file length reported by ftello(), the wrong variable's value was printed, and so the message made no sense. Clean up a couple other coding infelicities while at it.
2007-08-10Fix unintended change of output format for createlang/droplang -l. MissedTom Lane
these uses of printQuery() in FETCH_COUNT patch a year ago :-(. Per report from Tomoaki Sato.
2007-08-06Fix pg_restore to guard against unexpected EOF while reading an archive file.Tom Lane
Per report and partial patch from Chad Wagner.
2007-07-02- Fix the -w (wait) option to work in Windows service mode, per bug #3382.Magnus Hagander
- Prevent the -w option being passed to the postmaster. - Read the postmaster options file when starting as a Windows service. Dave Page
2007-06-22In psql, when running a SELECT query using a cursor, flush the queryNeil Conway
output after each FETCH. This ensures that incremental results are available to clients that are executing long-running SELECT queries via the FETCH_COUNT feature.
2007-05-15Avoid emitting empty role names in the GRANTED BY clause of GRANT ROLEAlvaro Herrera
when the grantor has been dropped. This is a workaround for the fact that we don't track the grantor as a shared dependency.
2007-04-18Translation updatesPeter Eisentraut
2007-04-16Don't write timing output in quiet mode.Magnus Hagander
Merlin Moncure
2007-04-16Fix pg_dump to not crash if -t or a similar switch is used to select a serialTom Lane
sequence for dumping without also selecting its owning table. Make it not try to emit ALTER SEQUENCE OWNED BY in this situation. Per report from Michael Nolan.
2007-02-19Fix pg_dump on win32 to properly dump files larger than 2Gb when usingMagnus Hagander
binary dump formats.
2007-02-05Pass modern COPY syntax to backend, since copy (query) does not accept old ↵Andrew Dunstan
syntax. Per complaint from Michael Fuhr.
2007-01-31Translation updatesPeter Eisentraut
2007-01-11Allow Borland CC to compile libpq and psql.Bruce Momjian
Backpatch to 8.2.X. L Bayuk
2007-01-04Tweak pg_dumpall to add GRANT CONNECT ON DATABASE ... TO PUBLIC when dumpingTom Lane
database privileges from a pre-8.2 server. This ensures that the reloaded database will maintain the same behavior it had in the previous installation, ie, everybody has connect privilege. Per gripe from L Bayuk.
2006-12-27Print combining characters (those reported as having zero width byTom Lane
PQdsplen()) normally, instead of replacing them by \uXXXX sequences. Assume that they in fact occupy zero screen space for formatting purposes. Per gripe from Michael Fuhr and ensuing discussion.
2006-12-24Make HISTCONTROL=ignoredups work again (broken by misordering ofTom Lane
operations during recent code refactoring). Per bug #2840 from Ned Crigler.
2006-12-04Fix pg_dump linking on Win32 with MSVS win32.mak:Bruce Momjian
The module link is insufficient.:-( ---- Sorry, japanese message change to xxx --- link.exe @C:\DOCUME~1\hi-saito\LOCALS~1\Temp\nmk03360. common.obj : error LNK2001: xxxxxx "_pg_qsort" xxxxxx pg_dump_sort.obj : error LNK2001: xxxxx "_pg_qsort" xxxxx .\Release\pg_dump.exe : fatal error LNK1120: xxxxxxx NMAKE : fatal error U1077: 'link.exe' : xxxxx '0x460' Stop. Hiroshi Saito
2006-12-02Translation updatesPeter Eisentraut
2006-11-24Fix psql's \copy command to ensure that it cycles libpq back to the idle stateTom Lane
(in particular, causing the ReadyForQuery message to be eaten) before returning from do_copy. The only known consequence of failing to do so is that get_prompt might show a wrong result for the %x transaction status escape, as reported by Bernd Helmle; but it's possible there are other issues. Back-patch as far as 7.4, the oldest version supporting %x.
2006-11-24Translation updatesPeter Eisentraut
2006-11-21Get rid of retail definitions of HAVE_STRDUP and HAVE_VSNPRINTF inTom Lane
some of the Windows-only makefiles; the correct place to assert these things is pg_config.h.win32. Per bug #2677.
2006-11-21Suppress timezone (%Z) part of timestamp display when running on Windows,Tom Lane
because on that platform strftime produces localized zone names in varying encodings. Even though it's only in a comment, this can cause encoding errors when reloading the dump script. Per suggestion from Andreas Seltenreich. Also, suppress %Z on Windows in the %s escape of log_line_prefix ... not sure why this one is different from the other two, but it shouldn't be.
2006-11-08Fix a memory leak in psql: we'd leak a few PGresult handles ifNeil Conway
a connectivity error occurred while executing one of the queries for "\d <table>". Not serious, but still worth fixing. Patch from Brendan Jurd.
2006-11-01pg_restore failed on tar-format archives if they contained large objectsTom Lane
(blobs) with comments, per bug #2727 from Konstantin Pelepelin. Mea culpa for not having tested this case. Back-patch to 8.1; prior branches don't dump blob comments at all.
2006-10-21Translations updatePeter Eisentraut
2006-10-14Code review for --no-data-for-failed-tables patch. Instead of trashingTom Lane
one of the program's core data structures, make use of the existing ability to selectively exclude TOC items by ID. Slightly more code but much less likely to create future maintenance problems.
2006-10-12Remove somebody's ill-considered free() call, per report from Chander Ganesan.Tom Lane
No, I do not care whether Coverity considers this a memory leak. It's entirely not worth the code space to do it correctly.
2006-10-10MSVC/BCC Win32 compiler fixes.Bruce Momjian
Hiroshi Saito
2006-10-09Revise psql pattern-matching switches as per discussion. The rule is nowTom Lane
to process all inclusion switches then all exclusion switches, so that the behavior is independent of switch ordering. Use of -T does not cause non-table objects to be suppressed. And the patterns are now interpreted the same way psql's \d commands do it, rather than as pure regex commands; this allows for example -t schema.tab to do what it should have been doing all along. Re-enable the --blobs switch to do something useful, ie, add back blobs into a dump they were otherwise suppressed from.
2006-10-09Move processNamePattern into dumputils.c in preparation for using it inTom Lane
pg_dump as well as psql. Since psql already uses dumputils.c, while there's not any code sharing in the other direction, this seems the easiest way. Also, fix misinterpretation of patterns using regex | by adding parentheses (same bug found previously in similar_escape()). This should be backpatched.
2006-10-07Fix ancient oversight in psql's \d pattern processing code: when seeing twoTom Lane
quote chars inside quote marks, should emit one quote *and stay in inquotes mode*. No doubt the lack of reports of this have something to do with the poor documentation of the feature ...
2006-10-07The -X option in pg_dump was supposed to be a workaround for the lack ofPeter Eisentraut
portable long options. But we have had portable long options for a long time now, so this is obsolete. Now people have added options which *only* work with -X but not as regular long option, so I'm putting a stop to this: -X is deprecated; it still works, but it has been removed from the documentation, and please don't add more of them.
2006-10-06Message style improvementsPeter Eisentraut
2006-10-04Fix initdb's logic for picking shared_buffers/max_fsm_pages, which hadTom Lane
gotten rather thoroughly whacked out by careless recent changes: the intended ratio between the two was off by a lot, and the minimum number of shared buffers tried had increased by a lot. Problem exposed by failures on buildfarm members with smaller SHMMAX values.
2006-10-04pgindent run for 8.2.Bruce Momjian
2006-10-03pgevent fixes:Bruce Momjian
1) Make vcbuild actually build the pgevent dll. 2) Change the pgevent DLL file so it doens't specify ordinal for the functions. You're not supposed to do that. You're actually supposed to declare them as PRIVATE as well, but mingw doesn't support that. VC++ will throw a warning and not an error though, so we can live with it. Magnus Hagander
2006-10-03Fix yesno_prompt() memory leak in /script tools, reported by Converity.Bruce Momjian