| Commit message (Collapse) | Author | Age |
|
|
|
|
| |
UNIQUE-PRIMARY KEY notice message. This is what Christopher wanted from
his patch.
|
|
|
|
|
| |
same code is called for both creation and alter. Not worth worrying
about.
|
|
|
|
|
|
| |
analysis. This keeps stored rules from prematurely absorbing default
information, which is necessary for ALTER TABLE SET DEFAULT to work
unsurprisingly with rules. See pgsql-bugs discussion 24-Oct-01.
|
|
|
|
|
|
|
| |
postmaster children before client auth step. Postmaster now rereads
pg_pwd on receipt of SIGHUP, the same way that pg_hba.conf is handled.
No cycles need be expended to validate password cache validity during
connection startup.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
recreated since the start of our transaction, our first reference to it
errored out because we'd try to reuse our old relcache entry for it.
Do this by accepting SI inval messages just before relcache search in
heap_openr, so that dead relcache entries will be flushed before we
search. Also, break heap_open/openr into two pairs of routines,
relation_open(r) and heap_open(r). The relation_open routines make
no tests on relkind and so can be used to open anything that has a
pg_class entry. The heap_open routines are wrappers that add a relkind
test to preserve their established behavior. Use the relation_open
routines in several places that had various kluge solutions for opening
rels that might be either heap or index rels.
Also, remove the old 'heap stats' code that's been superseded by Jan's
stats collector, and clean up some inconsistencies in error reporting
between the different types of ALTER TABLE.
|
| |
|
|
|
|
|
|
| |
stored in pg_pwd, to guard against failures of the sort observed by
Tom Yackel. Note: in the case of encrypted passwords this is no
restriction, since the string we are interested in is the MD5 hash.
|
| |
|
| |
|
| |
|
|
|
|
| |
message spacing.
|
|
|
|
|
|
|
|
| |
which incorporates recent changes by Bruce to
readability of some messages and few more translations.
--
Serguei A. Mokhov
|
|
|
|
|
|
| |
Add space between slash for ALTER TABLE / ADD ....
Regression and *.po updates to follow.
|
|
|
|
|
|
| |
from Philip Warner. Side effect of change is that GROUP BY expressions
will not be re-evaluated at multiple plan levels anymore, whereas this
sometimes happened with old code.
|
| |
|
| |
|
| |
|
|
|
|
| |
spacing. Also adds space for one-line comments.
|
|
|
|
|
| |
causes pgindent to make weird formatting decisions. Easiest fix
seems to be to put in the extra parens...
|
|
|
|
|
| |
breaking existing pg_dump scripts, which try to assign the result of
count(*) to an int2 variable. catversion bumped.
|
| |
|
|
|
|
| |
tests pass.
|
| |
|
|
|
|
| |
forth@pagic.net
|
| |
|
| |
|
| |
|
|
|
|
| |
user columns. Needed for foreign keys on OID, but useful in general.
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
never overwrite adjacent pages with copied data, even if page header
and/or item pointers are already corrupt. Change inspired by trouble
report from Alvaro Herrera.
|
|
|
|
| |
for indexes on system columns. Per complaint from Peter.
|
| |
|
|
|
|
|
|
|
|
| |
environment strings need to be moved around, do so when called from
initial startup (main.c), not in init_ps_status. This eliminates the
former risk of invalidating saved environment-string pointers, since
no code has yet had a chance to grab any such pointers when main.c
is running.
|
|
|
|
|
| |
arguments (where the parser doesn't check them already). Minor code
cleanups too.
|
|
|
|
| |
in .:/home/postgres/testversion/bin:/opt/perl5.6.1/bin:/home/postgres/bin:/usr/local/bin:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/upgrade/bin:/opt/CC/bin:/opt/langtools/bin:/opt/graphics/phigs/bin:/opt/java/bin:/bin:/opt/imake/bin:/opt/hparray/bin:/opt/aCC/bin:/opt/lrom/bin:/usr/local/nmh/bin:. (I suppose the only common case for this is '.').
|
|
|
|
|
|
| |
per suggestion from Peter. Simplify several APIs by transmitting the
original argv location directly from main.c to ps_status.c, instead of
passing it down through several levels of subroutines.
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Mask both typmod subfields for INTERVAL to avoid setting the high bit,
per dire warning from Tom Lane.
Clear tmask for DTK_ISO_TIME case to avoid time zone troubles.
Symptom reported by Tom Lane.
Clean up checking for valid time zone info in output routine.
This should now work for both SQL99 and Unix-style time zones.
Put in explicit check for INTERVAL() typmod rounding to avoid accumulating
cruft in the lower bits. Not sure that this helps, but we'll need to do
something. The symptom is visible with a query like
select interval(2) '10000 days 01:02:03.040506';
Regression tests are patched to repair the Tom Lane symptom, and all pass.
|
|
|
|
| |
before.
|
|
|
|
|
|
| |
subprocesses; perhaps this will fix portability problem just noted by
Lockhart. Also, move test for bad permissions of DataDir to a more
logical place.
|
|
|
|
|
|
|
| |
bootstrap) check for a valid PG_VERSION file before looking at anything
else in the data directory. This fixes confusing error report when
trying to start current sources in a pre-7.1 data directory.
Per trouble report from Rich Shepard 10/18/01.
|
|
|
|
|
|
|
|
|
|
|
| |
just after receipt of the startup packet. Now, postmaster children
that are waiting for client authentication response will show as
'postgres: user database host authentication'. Also, do an
init_ps_display for startup/shutdown/checkpoint subprocesses,
so that they are readily identifiable as well. Fix an obscure race
condition that could lead to Assert failure in the postmaster ---
attempting to start a checkpoint process before any connections have
been received led to calling PostmasterRandom before setting random_seed.
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
| |
authentication failed' and a 'send() failed: Broken pipe' message
on every connection from psql in password auth mode. Problem is
that psql doesn't ask user for a password until it sees a password
challenge failure, and libpq just closes the connection unceremoniously
if it's challenged for a password when it hasn't got one to send.
Accordingly, EOF from the client after asking for a password is
normal behavior and should not result in postmaster log entries.
|
| |
|
| |
|