summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-08-04This patch fixes a probably harmless write of uninitialized memory inBruce Momjian
the statistics collector and makes a number of corrections to the documentation for SET, SHOW, and COPY. Neil Conway
2002-08-04Change messages like this:Bruce Momjian
ERROR: ExecInsert: rejected due to CHECK constraint insert_con To be like this: ERROR: ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_tbl" Updated regression tests to match. I got sick of seeing 'rejected due to CHECK constraint "$1" in my log and not being able to find the bug in our website code... Christopher Kings-Lynne
2002-08-04This trivial patch fixes a small memory leak in pg_dump.Bruce Momjian
Neil Conway
2002-08-04This patch fixes a "multi-line string literal" warning encounteredBruce Momjian
when compiling psql with GCC 3.1. Neil Conway
2002-08-04The attached patch implements START TRANSACTION, per SQL99. TheBruce Momjian
functionality of the command is basically identical to that of BEGIN; it just accepts a few extra options (only one of which PostgreSQL currently implements), and is standards-compliant. The patch includes a simple regression test and documentation. [ Regression tests removed, per Peter.] Neil Conway
2002-08-04This patch fixes in intermittent failure in the regression tests:Bruce Momjian
there was a race condition between the "alter_table" and "rules" regression tests. Depending on scheduling, sometimes an ALTER TABLE command would operate on a relation created by the "rules" tests, leading to unexpected results. Neil Conway
2002-08-04Back out pl/pgsql quotation fix. Has problems.Bruce Momjian
2002-08-04 I send a simple patch for PL/pgSQL parser which allow now to useBruce Momjian
whitespaces in identifers of any kind(table names,attribute names,variables ...) in Pl/pgSQL procedural language.Explicit definition of bug can be found in Re: [HACKERS] Bug of PL/pgSQL parser TODO item completed: o -Fix PL/PgSQL to handle quoted mixed-case identifiers eutm
2002-08-02When compiling with --enable-cassert, check for reference count leaksTom Lane
in the relcache. It's rather silly that we have reference count leak checks in bufmgr and in catcache, but not in relcache which will normally have many fewer entries. Chris K-L would have caught at least one bug in his recent DROP patch if he'd had this.
2002-08-02RemoveAttrDefaultById() neglected to obtain exclusive lock on theTom Lane
relation being modified. In most paths of control we'd already have such a lock, but if we were dropping the default due to a cascaded delete of some function it depended on, maybe not.
2002-08-02ALTER TABLE DROP COLUMN works. Patch by Christopher Kings-Lynne,Tom Lane
code review by Tom Lane. Remaining issues: functions that take or return tuple types are likely to break if one drops (or adds!) a column in the table defining the type. Need to think about what to do here. Along the way: some code review for recent COPY changes; mark system columns attnotnull = true where appropriate, per discussion a month ago.
2002-08-01* -Remove LockMethodTable.prio field, not used (Bruce)Bruce Momjian
2002-08-011) Improve the handling of the queries like (select ..) union (select ..)Hiroshi Inoue
whose first non-space character is '('. 2) Handle Insert .. () VALUES ().
2002-07-31Instead of having a configure-time DEFAULT_ATTSTATTARGET, store -1 inTom Lane
attstattarget to indicate 'use the default'. The default is now a GUC variable default_statistics_target, and so may be changed on the fly. Along the way we gain the ability to have pg_dump dump the per-column statistics target when it's not the default. Patch by Neil Conway, with some kibitzing from Tom Lane.
2002-07-31Rename pid function to backend_pid().Bruce Momjian
2002-07-31Add function to access backend pid, pg_stat_get_backend_mypid.Bruce Momjian
2002-07-30Teach pg_dump to dump user-defined operator classes. For the moment,Tom Lane
this only works against 7.3 or later databases; the pushups required to do it without regprocedure/regtype/etc seem more trouble than they're worth, considering that existing users aren't expecting pg_dump support for this.
2002-07-30If we're cleaning out _deadcode, might as well zap this one too.Tom Lane
2002-07-30Remove last recipe file.Bruce Momjian
2002-07-30Ensure that src/tutorial gets cleaned by top-level make clean.Tom Lane
2002-07-30The attached patch removes the last remnants of support forBruce Momjian
'tioga recipes', whatever those are -- Peter E. killed most of it a couple days ago, but this patch removes the rest. Most of it was #ifdef'ed out anyway. Neil Conway
2002-07-30IMPROVED VERSION APPLIED:Bruce Momjian
The attached patch completes the following TODO item: * Generate failure on short COPY lines rather than pad NULLs I also restructed a lot of the existing COPY code, did some code review on the column list patch sent in by Brent Verner a little while ago, and added some regression tests. I also added an explicit check (and resultant error) for extra data before the end-of-line. Neil Conway
2002-07-30Added support for schemas and quotes in tab-complete.c, as well asBruce Momjian
a few other things: * Made all references to the pg_* tables absolute, by specifying the pg_catalog schema. * Added SCHEMA as a create/delete completion option. * Added SCHEMA completion as: SELECT nspname FROM pg_catalog.pg_namespace WHERE substr(nspname,1,%d)='%s' * Added completion of "INSERT INTO <table> (" with attribute names. * Added completion of "INSERT INTO <table> (attribs)" with VALUES or SELECT * Added limited locking completion: only for one table: "LOCK" and "LOCK TABLE" now both get a completion list of tables Complete with "IN" for LOCK [TABLE] <table> Complete LOCK [TABLE] <table> IN with a lock mode * Added a very simple WHERE finisher that uses the previous word as a table lookup for attributes. * Added quote support when parsing "previous words". In other words, hitting tab after INSERT INTO "foo bar baby" now does the right thing and recognizes "foo bar baby" as one word. Letting tab-complete quote things that should be quoted seems to be temporarily ifdef'ed out due to readline compatibility problems. Can anyone elaborate on this? Greg Sabino Mullane
2002-07-30 This should fix a bug where a row that was updated orBruce Momjian
deleted that had another row inserted/updated to its old value during the same statement or other statements before the integrity check for noaction would incorrectly error. This could happen in deferred constraints or due to triggers or functions. It's effectively a reworking of the previous patch that did a not exists to instead do a separate check. Stephan Szabo
2002-07-30Since we're depending on %option noyywrap in the main scanner now,Tom Lane
we may as well use it in all our flex files. Make all the flex files have a consistent set of options.
2002-07-30Here are two patches. The guc_and_tablefunc patch addresses the twoBruce Momjian
changes mentioned above, and also adds a new function to the tablefunc API. The tablefunc API change adds the following function: * Oid foidGetTypeId(Oid foid) - Get a function's typeid given the * function Oid. Use this together with TypeGetTupleDesc() to get a * TupleDesc which is derived from the function's declared return type. In the next post I'll send the contrib/tablefunc patch, which illustrates the usage of this new function. Also attached is a doc patch for this change. The doc patch also adds a function that I failed to document previously. Joe Conway
2002-07-30This patch fixes one serious bug (runaway INSERT) and a few rare (andBruce Momjian
hard to reproduce) error conditions. Manfred Koizar
2002-07-30added tests for crossReferencesDave Cramer
2002-07-30changed test user back to testDave Cramer
2002-07-30Added DataSource code and tests submitted by Aaron MulderDave Cramer
2002-07-30changes for new DatasourceDave Cramer
2002-07-30Move alarm timers to proper location.Bruce Momjian
2002-07-30Rewrite xindex.sgml for CREATE OPERATOR CLASS. catalogs.sgml finallyTom Lane
contains descriptions of every single system table. Update 'complex' tutorial example too.
2002-07-30Make statement_timeout apply to entire query string, not per statement.Bruce Momjian
2002-07-30--enable-syslog no longer required to use syslog.Bruce Momjian
2002-07-30Fix a bug about automatic client_encoding setting.Hiroshi Inoue
2002-07-29Centralize code for interpreting schema references, which had gottenTom Lane
copied more places than I first thought it would. This fixes a bug: a couple of these places were neglecting to enforce USAGE access on explicitly-referenced schemas.
2002-07-29Use aclcheck_error() in place of ad-hoc permissions complaints.Tom Lane
2002-07-29Implement CREATE/DROP OPERATOR CLASS. Work still remains: need moreTom Lane
documentation (xindex.sgml should be rewritten), need to teach pg_dump about it, need to update contrib modules that currently build pg_opclass entries by hand. Original patch by Bill Studenmund, grammar adjustments and general update for 7.3 by Tom Lane.
2002-07-29Fix minor coding error: don't ReleaseSysCache until after last use ofTom Lane
cache entry.
2002-07-29Fix typo. Remove #ifdef MULTIBYTETatsuo Ishii
2002-07-27Assemble portability modules into libpgport library.Peter Eisentraut
Some makefile simplifications.
2002-07-26Fix a bug about the handling of CX parameter of the connection stringHiroshi Inoue
reported by Sergey Smirnov.
2002-07-26Fouth (and final) phase of restructuring to add jdbc3 support.Barry Lind
Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java Added Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2DatabaseMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSetMetaData.java Removed Files: jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/ResultSetMetaData.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/ResultSetMetaData.java
2002-07-25Third phase of restructuring to add jdbc3 support.Barry Lind
Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java Added Files: jdbc/org/postgresql/jdbc1/Jdbc1CallableStatement.java jdbc/org/postgresql/jdbc2/Jdbc2CallableStatement.java Removed Files: jdbc/org/postgresql/jdbc1/CallableStatement.java jdbc/org/postgresql/jdbc2/CallableStatement.java jdbc/org/postgresql/jdbc2/UpdateableResultSet.java
2002-07-25Remove extra comma.Peter Eisentraut
2002-07-25Implement DROP CONVERSIONTatsuo Ishii
Add regression test
2002-07-24Second phase of restructuring to add jdbc3 support.Barry Lind
2002-07-24Remove _deadcode.Peter Eisentraut
2002-07-24Remove unused system table columns:Peter Eisentraut
pg_language.lancompiler pg_operator.oprprec pg_operator.oprisleft pg_proc.proimplicit pg_proc.probyte_pct pg_proc.properbyte_cpu pg_proc.propercall_cpu pg_proc.prooutin_ratio pg_shadow.usetrace pg_type.typprtlen pg_type.typreceive pg_type.typsend Attempts to use the obsoleted attributes of pg_operator or pg_proc in the CREATE commands will be greeted by a warning. For pg_type, there is no warning (yet) because pg_dump scripts still contain these attributes. Also remove new but already obsolete spellings isVolatile, isStable, isImmutable in WITH clause. (Use new syntax instead.)
generated by cgit v1.2.3 (git 2.46.0) at 2025-09-04 08:39:40 +0000