aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Fix for EINTR returns from Win9X socket operations:Bruce Momjian2002-04-15
| | | | | | | | | | | | | | In summary, if a software writer implements timer events or other events which generate a signal with a timing fast enough to occur while libpq is inside connect(), then connect returns -EINTR. The code following the connect call does not handle this and generates an error message. The sum result is that the pg_connect() fails. If the timer or other event is right on the window of the connect() completion time, the pg_connect() may appear to work sporadically. If the event is too slow, pg_connect() will appear to always work and if the event is too fast, pg_connect() will always fail. David Ford
* Adjust rules for search_path so that pg_catalog is never implicitlyTom Lane2002-04-15
| | | | | | selected as the creation target namespace; to make that happen, you must explicitly set search_path that way. This makes initdb a hair more complex but seems like a good safety feature.
* Fix text_substr bug intrduced in 7.3 developmentTatsuo Ishii2002-04-15
| | | | | using Joe Conway's patches (submitted at pgsql-patches on 2002/04/08) + small fix.
* Fix oversight in recent change of representation for JOIN aliasTom Lane2002-04-15
| | | | | variables: JOIN/ON should allow references to contained JOINs. Per bug report from Barry Lind.
* The contents of command.c, creatinh.c, define.c, remove.c and rename.cTom Lane2002-04-15
| | | | | | | | | | | | | | | have been divided according to the type of object manipulated - so ALTER TABLE code is in tablecmds.c, aggregate commands in aggregatecmds.c and so on. A few common support routines remain in define.c (prototypes in src/include/commands/defrem.h). No code has been changed except for includes to reflect the new files. The prototypes for aggregatecmds.c, functioncmds.c, operatorcmds.c, and typecmds.c remain in src/include/commands/defrem.h. From John Gray <jgray@azuli.co.uk>
* 1) Fix a bug about reporting varchar info thanks to Aceto.Hiroshi Inoue2002-04-15
| | | | | 2) Introcuced 3 drivers. 3) The version is now 7.02.0001.
* Allow detection of collateindex.pl in stylesheet directory or in path,Peter Eisentraut2002-04-14
| | | | | | | | | which covers some recent installation schemes. Add Mandrake installation layout to directories to check for stylesheets. Allow documentation build to proceed if stylesheets were not found, in case the stylesheets might be found through the SGML catalog mechanism.
* Fix comment dashes.Bruce Momjian2002-04-14
|
* - Synced preproc.y with gram.yMichael Meskes2002-04-14
| | | | - Fixed one bug in structure handling resulting in using sizeof indicator instead of variable.
* Rod's patch does what it is supposed to do, but it also includesBruce Momjian2002-04-13
| | | | | | | | | | | | | | | | | | | | some old code to add PK constraints to CREATE TABLE. That stuff had been removed as part of my original patch for pg_dump a little while ago. The attached patch fixes this by removing (again :-) ) the code in dumpTables() to perform PK creation during CREATE TABLE. I briefly tested it locally and it fixes both of Tom's test cases. Please apply. Cheers, Neil -- Neil Conway <neilconway@rogers.com>
* Patch against 7.2.1 sources. Uses Solaris Intimate Shared MemoryBruce Momjian2002-04-13
| | | | | | | | | | | | | | | for Solaris on SPARC. Scott Brunza (sbrunza@sonalysts.com) gets credit for identifying the issue, making the change, and doing the regression tests. Earlier testing on 7.2rc2 and 7.2 showed performance gains of 1% to 10% on pgbench, osdb-pg, and some locally developed apps. Solaris Intimate Shared Memory is described in "SOLARIS INTERNALS Core Kernel Components" by Jim Mauro and Richard McDougall, Copyright 2001 Sun Microsystem, Inc. ISBN 0-13-022496-0 P.J. "Josh" Rovero
* Checking to decide whether relations are system relations now dependsTom Lane2002-04-12
| | | | | on the namespace not the name; pg_ is not a reserved prefix for table names anymore. From Fernando Nasser.
* Tweak error message wording.Tom Lane2002-04-12
|
* Allow prompting of create/drop user to handle spaces.Bruce Momjian2002-04-12
|
* Allow dropdb and others to use identifiers with spaces; IFS cleanup forBruce Momjian2002-04-12
| | | | pg_dumpall.
* Update new Russian FAQ.Bruce Momjian2002-04-12
|
* 1) Fix a bug in declare/fetch mode.Hiroshi Inoue2002-04-12
| | | | 2) Suppress some error logs for the request to other drivers.
* Add mention of function CREATE INDEX usage.Bruce Momjian2002-04-11
|
* Cleanup in use of IFS.Bruce Momjian2002-04-11
|
* Update obsolete syntax in example of inheritance.Tom Lane2002-04-11
|
* Make sure leading/trailing/multiple consecutive space/tab in db/user/groupBruce Momjian2002-04-11
| | | | names are handled OK.
* Restructure representation of aggregate functions so that they have pg_procTom Lane2002-04-11
| | | | | | | | | | entries, per pghackers discussion. This fixes aggregates to live in namespaces, and also simplifies/speeds up lookup in parse_func.c. Also, add a 'proimplicit' flag to pg_proc that controls whether a type coercion function may be invoked implicitly, or only explicitly. The current settings of these flags are more permissive than I would like, but we will need to debate and refine the behavior; for now, I avoided breaking regression tests as much as I could.
* Fix pg_upgrade to handle dbnames, user/group names with spaces.Bruce Momjian2002-04-11
|
* Make sure that usesuper is always accessed through superuser(), so that thePeter Eisentraut2002-04-11
| | | | single-user escape path always works.
* Fix problem with invalid database name assignment in while loop.Bruce Momjian2002-04-11
| | | | Properly warn of invalid pg_dumpall options; minor quoting cleanups.
* Readline and Zlib now required by default. Add options --without-readlinePeter Eisentraut2002-04-10
| | | | and --without-zlib to turn them off.
* Add make install-strip target.Peter Eisentraut2002-04-10
|
* Prevent an infinite loop of error reporting.Hiroshi Inoue2002-04-10
|
* Functions live in namespaces. Qualified function names work, egTom Lane2002-04-09
| | | | | SELECT schema1.func2(...). Aggregate names can be qualified at the syntactic level, but the qualification is ignored for the moment.
* Let psqlodbc30 be compilable without /D DRIVER_CURSOR_IMPLEMENT.Hiroshi Inoue2002-04-09
|
* Update comment to clarify fetch limit and LIMIT.Bruce Momjian2002-04-08
|
* Document genbki.sh's ability to auto-assign OIDs for DESCR macros.Tom Lane2002-04-08
| | | | Some other minor wording improvements.
* Fix PQescapeBytea/PQunescapeBytea so that they handle bytes > 0x7f.Tatsuo Ishii2002-04-08
| | | | | | This is necessary for mulibyte character sequences. See "[HACKERS] PQescapeBytea is not multibyte aware" thread posted around 2002/04/05 for more details.
* Implement partial-key searching of syscaches, per recent suggestionTom Lane2002-04-06
| | | | | to pghackers. Use this to do searching for ambiguous functions --- it will get more uses soon.
* > > This patch corrects the use of rpath and export options when compilingBruce Momjian2002-04-05
| | | | | | | | > > on postgres on Unixware with GCC built with gnu-as and gnu-ld. Remove leading spaces in conditional tests in patch and Makefile.aix. Nicolas Bazin
* This patch adds a missing heap_freetuple() to renamerel(), documentsBruce Momjian2002-04-05
| | | | | | | | | the decision not to make renamerel() update the sequence name that is stored within sequences themselves (thanks to Tom Lane), and adds some rudimentary regression tests for ALTER TABLE ... RENAME on non-table relations. Neil Conway
* Add INSERT(..., DEFAULT, ).Bruce Momjian2002-04-05
| | | | Rod Taylor
* I was tinkering with creating rules on views (so, for instance, one couldBruce Momjian2002-04-05
| | | | | | | | | | | insert on a view), and noticed that psql wouldn't show the list of rules set up on a view, like it does for tables. The fix was extremely simple, so I figured I'd share it. Not sure what the standard is for communicating these things, so I've attached the diff file for /src/bin/psql/describe.c. Paul (?)
* Adds domain dumping support to pg_dump.Bruce Momjian2002-04-05
| | | | Rod Taylor
* When a macro is replaced by the preprocessor, pgc.l reaches a end ofBruce Momjian2002-04-05
| | | | | | | | | | | | | | | file, which is not the actual end of the file. One side effect of that is that if you are i n a ifdef block, you get a wrong error telling you that a endif is missing. This patch corrects pgc.l and also adds a test of this problem to test1.pgc. To convince you apply the patch to test1.pgc first then try to compile the test the n apply the patch to pgc.l. The patch moves the test of the scope of an ifdef block to the end of the file b eeing parsed, including all includes files, ... . Nicolas Bazin
* Looks like a small patch is needed as well to do the right thing on Linux.Bruce Momjian2002-04-05
| | | | | | | | | | | The patch enables the mips2 ISA for the ll/sc operations, and then restores it when done. The kernel/libc emulation code will take over on CPUs without ll/sc, and on CPUs with it, it'll use the operations provided by the CPU. Combined with the earlier fix (removing -mips2), postgresql builds again on mips and mipsel. The patch is against 7.2-7. Oliver Elphick
* Undo not-so-hot decision to postpone insertion of default values intoTom Lane2002-04-05
| | | | | | | | INSERT statements to the planner. Taking it out of the parser was right (so that defaults don't get into stored rules), but it has to happen before rewrite rule expansion, else references to NEW.field behave incorrectly. Accordingly, add a step to the rewriter to insert defaults just before rewrite-rule expansion.
* Divide functions into three volatility classes (immutable, stable, andTom Lane2002-04-05
| | | | | | | volatile), rather than the old cachable/noncachable distinction. This allows indexscan optimizations in many places where we formerly didn't. Also, add a pronamespace column to pg_proc (it doesn't do anything yet, however).
* Fix a bug in SQLError().Hiroshi Inoue2002-04-04
|
* This patch against 0.98.7 lib/tables.tcl will allow PGAccess to create newBruce Momjian2002-04-04
| | | | | | | | | | records containing apostrophes in text fields without altering the appearance of the entry in the GUI interface (by copying the fldval to fldvalfixed). This will alleviate the need for users to create a record and then go back to edit apostrophes into the text they entered. Ryan Grange
* Cleanup of level ordering and add missing LOG entry.Bruce Momjian2002-04-04
|
* Add missing mention of 'log' option for client_min_messages.Bruce Momjian2002-04-04
|
* Authentication improvements:Bruce Momjian2002-04-04
| | | | | | | | | | | | | | A new pg_hba.conf column, USER Allow specifiction of lists of users separated by commas Allow group names specified by + Allow include files containing lists of users specified by @ Allow lists of databases, and database files Allow samegroup in database column to match group name matching dbname Removal of secondary password files Remove pg_passwd utility Lots of code cleanup in user.c and hba.c New data/global/pg_pwd format New data/global/pg_group file
* Fix a bug in multibyte_strchr().Hiroshi Inoue2002-04-04
|
* Locale support is on by default. The choice of locale is done in initdbPeter Eisentraut2002-04-03
| | | | and/or with GUC variables.