summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
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.)
2002-07-24Add mention of copyright year update.Bruce Momjian
2002-07-24Add Japanese README explaining how to add new conversion.Tatsuo Ishii
English README will come soon...
2002-07-23Initial restructuring to add jdbc3 support. There was a significant amountBarry Lind
of duplicated code between the jdbc1 and jdbc2. This checkin restructures the code so that the duplication is removed so that the jdbc3 support can be added without adding yet another copy of everything. Also many classes were renamed to avoid confusion with multiple different objects having the same name. The timestamp tests were also updated to add support for testing timestamp without time zone in addition to timestamp with time zone Modified Files: jdbc/Makefile jdbc/build.xml jdbc/example/ImageViewer.java jdbc/example/basic.java jdbc/example/blobtest.java jdbc/example/threadsafe.java jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/Field.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/fastpath/Fastpath.java jdbc/org/postgresql/jdbc1/CallableStatement.java jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/PreparedStatement.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc2/CallableStatement.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/PreparedStatement.java jdbc/org/postgresql/jdbc2/UpdateableResultSet.java jdbc/org/postgresql/largeobject/LargeObjectManager.java jdbc/org/postgresql/largeobject/PGblob.java jdbc/org/postgresql/largeobject/PGclob.java jdbc/org/postgresql/test/jdbc2/BlobTest.java jdbc/org/postgresql/test/jdbc2/ConnectionTest.java jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java jdbc/org/postgresql/test/jdbc2/TimestampTest.java jdbc/org/postgresql/test/jdbc2/UpdateableResultTest.java jdbc/org/postgresql/util/Serialize.java Added Files: jdbc/org/postgresql/PGConnection.java jdbc/org/postgresql/PGStatement.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc1/Jdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Connection.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2Statement.java Removed Files: jdbc/org/postgresql/Connection.java jdbc/org/postgresql/ResultSet.java jdbc/org/postgresql/Statement.java jdbc/org/postgresql/jdbc1/Connection.java jdbc/org/postgresql/jdbc1/ResultSet.java jdbc/org/postgresql/jdbc1/Statement.java jdbc/org/postgresql/jdbc2/Connection.java jdbc/org/postgresql/jdbc2/ResultSet.java jdbc/org/postgresql/jdbc2/Statement.java
2002-07-22Add unique index on pg_cast.oid, and document pg_cast table.Peter Eisentraut
2002-07-21Fixed some minor typos.Michael Meskes
2002-07-21Re-Committed old file.Michael Meskes
2002-07-20Tweak CreateTrigger() so that the OID used in the name of anTom Lane
RI_ConstraintTrigger is the same OID assigned to the pg_trigger row. This reduces consumption of OIDs and may ease debugging.
2002-07-20Code review for SHOW output changes; fix horology expected files forTom Lane
new SHOW output format.
2002-07-20Synced parser yet again.Michael Meskes
Michael
2002-07-20Fix regression tests for new SHOW output.Bruce Momjian
2002-07-20Fix problems caused by code drift of API for without-oids.Bruce Momjian
2002-07-20The attached patch fixes 2 trivial warnings generated by bison 1.35,Bruce Momjian
as a result of Peter's recent CREATE CAST changes. Neil Conway
2002-07-20I can't remember who said they were working on schema related psqlBruce Momjian
changes, but I kept finding myself wishing I could see what schema a table or view exists in when I use \dt, \dv, etc. So, here is a patch which does just that. It sorts on "Schema" first, and "Name" second. It also changes the test for system objects to key off the namespace name starting with 'pg_' instead of the object name. Sample output: test=# create schema testschema; CREATE SCHEMA test=# create view testschema.ts_view as select 1; CREATE VIEW test=# \dv List of relations Name | Schema | Type | Owner --------------------+------------+------+---------- __testpassbyval | public | view | postgres fooview | public | view | postgres master_pg_proc | public | view | postgres rmt_pg_proc | public | view | postgres vw_dblink_get_pkey | public | view | postgres vw_dblink_replace | public | view | postgres ts_view | testschema | view | postgres (7 rows) Joe Conway
2002-07-20> 2. This patch includes the same Table Function API fixes that IBruce Momjian
> submitted on July 9: > > http://archives.postgresql.org/pgsql-patches/2002-07/msg00056.php > > Please disregard that one *if* this one is applied. If this one is > rejected please go ahead with the July 9th patch. The July 9th Table Function API patch mentioned above is now in CVS, so here is an updated version of the guc patch which should apply cleanly against CVS tip. Joe Conway
2002-07-20Hello, i noticed that win32 native stopped working/compiling after the SSL mergeBruce Momjian
. So i took the opportunity to fix some stuff: 1. Made the thing compile (typos & needed definitions) with the new pqsecure_* s tuff, and added fe-secure.c to the win32.mak makefile. 2. Fixed some MULTIBYTE compile errors (when building without MB support). 3. Made it do that you can build with debug info: "nmake -f win32.mak DEBUG=1". 4. Misc small compiler speedup changes. The resulting .dll has been tested in production, and everything seems ok. I CC:ed -hackers because i'm not sure about two things: 1. In libpq-int.h I typedef ssize_t as an int because Visual C (v6.0) doesn't de fine ssize_t. Is that ok, or is there any standard about what type should be use d for ssize_t? 2. To keep the .dll api consistent regarding MULTIBYTE I just return -1 in fe-connect.c:PQsetClientEncoding() instead of taking away the whole function. I wonder if i should do any compares with the conn->client_encoding and return 0 if not hing would have changed (if so how do i check that?). Regards Magnus Naeslund
2002-07-20Add new configure files for missing-oid patch.Bruce Momjian
2002-07-20Patch problems caused by code drift since OID patch creation.Bruce Momjian
2002-07-20Manually apply part of oid patch that didn't apply cleanly.Bruce Momjian
2002-07-20oid is needed, it is added at the end of the struct (after the nullBruce Momjian
bitmap, if present). Per Tom Lane's suggestion the information whether a tuple has an oid or not is carried in the tuple descriptor. For debugging reasons tdhasoid is of type char, not bool. There are predefined values for WITHOID, WITHOUTOID and UNDEFOID. This patch has been generated against a cvs snapshot from last week and I don't expect it to apply cleanly to current sources. While I post it here for public review, I'm working on a new version against a current snapshot. (There's been heavy activity recently; hope to catch up some day ...) This is a long patch; if it is too hard to swallow, I can provide it in smaller pieces: Part 1: Accessor macros Part 2: tdhasoid in TupDesc Part 3: Regression test Part 4: Parameter withoid to heap_addheader Part 5: Eliminate t_oid from HeapTupleHeader Part 2 is the most hairy part because of changes in the executor and even in the parser; the other parts are straightforward. Up to part 4 the patched postmaster stays binary compatible to databases created with an unpatched version. Part 5 is small (100 lines) and finally breaks compatibility. Manfred Koizar
2002-07-20The attached patch fixes a build problem with GEQO when using theBruce Momjian
PX recombination operator, changes some elog() messages from LOG to DEBUG1, puts some debugging functions inside the appropriate #ifdef (not enabled by default), and makes a few other minor cleanups. BTW, the elog() change is motivated by at least one user who has sent a concerned email to -general asking exactly what the "ERX recombination operator" is, and what it is doing to their DBMS. Neil Conway
generated by cgit v1.2.3 (git 2.46.0) at 2025-09-02 19:35:44 +0000