- 21 8月, 2002 2 次提交
- 20 8月, 2002 9 次提交
-
-
由 Bruce Momjian 提交于
FOUND is set whenever a SELECT INTO returns > 0 rows, *or* when an INSERT, UPDATE, or DELETE affects > 0 rows. We implemented the first part of this behavior, but not the second. I also improved the documentation on the various situations in which FOUND can be set (excluding inside FOR loops, which I still need to think about), and added some regression tests for this behavior. Neil Conway
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
- don't fail type-sanity checks if a domain exists Rod Taylor
-
由 Bruce Momjian 提交于
Christopher Kings-Lynne
-
由 Bruce Momjian 提交于
Add current_database(). > Quick system function to pull out the current database. > > I've used this a number of times to allow stored procedures to find out > where they are. Especially useful for those that do logging or hit a > remote server. > > It's called current_database() to match with current_user(). It's also a necessity for an informational schema. The catalog (database) name is required in a number of places. Rod Taylor
-
由 Barry Lind 提交于
for the last two releases. Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/PG_Stream.java Removed Files: jdbc/org/postgresql/core/BytePoolDim1.java jdbc/org/postgresql/core/BytePoolDim2.java jdbc/org/postgresql/core/MemoryPool.java jdbc/org/postgresql/core/ObjectPool.java jdbc/org/postgresql/core/SimpleObjectPool.java
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * -Make other constraints clearer in dump file
-
由 Tom Lane 提交于
cause SERIAL column declaration not to imply UNIQUE, so that this can be done without creating an extra index.
-
- 19 8月, 2002 9 次提交
-
-
由 Tom Lane 提交于
latent wrong-struct-type bugs and makes the coding style more uniform, since the majority of places working with lists of column names were already using Strings not Idents. While at it, remove vestigial support for Stream node type, and otherwise-unreferenced nodes.h entries for T_TupleCount and T_BaseNode. NB: full recompile is recommended due to changes of Node type numbers. This shouldn't force an initdb though.
-
由 Tatsuo Ishii 提交于
It pfree() wrong pointer.
-
由 Tatsuo Ishii 提交于
-
由 Tom Lane 提交于
required changes to copyfuncs/equalfuncs.
-
由 Tom Lane 提交于
been missing forever; surprising it wasn't noticed before. The other additions are, um, sloppiness in certain recent feature additions.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
Bruno Wolff.
-
由 Tom Lane 提交于
when two equal() targetlist items were to be added to an ORDER BY or DISTINCT list. Although indeed this would make sorting fractionally faster by sometimes saving a comparison, it confuses the heck out of later stages of processing, because it makes it look like the user wrote DISTINCT ON rather than DISTINCT. Bug reported by joe@piscitella.com.
-
- 18 8月, 2002 12 次提交
-
-
由 Peter Eisentraut 提交于
master and slave tables.
-
由 Peter Eisentraut 提交于
The -n and -N options were removed. Quoting is now smart enough to supply quotes if and only if necessary. Numerical types are now printed without quotes, except in cases of special values such as NaN. Boolean values printed as true and false. Most string literals now do not escape whitespace characters (newlines, etc.) for portability. SET SESSION AUTHORIZATION argument is a string literal, to follow SQL. Made commands output by pg_dump use consistent spacing and indentation.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
a token scanned by multiple lex rules.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
about %c
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Everytime if I do PQconsumeInput (when the backend channel gets readable) I check for the return value. (0 == error) and generate a notification manually, e.g. fixed string connection_closed) and pass it to the
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
-
- 17 8月, 2002 8 次提交
-
-
由 Bruce Momjian 提交于
Original patch from Thomas.
-
由 Bruce Momjian 提交于
> * Use dependency information to dump data in proper order
-
由 Bruce Momjian 提交于
> o -Add command to display locks
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
offending token more efficiently (per your suggestion of using scanbuf). The new patch does the same as before: template1=# select * frum pg_class; ERROR: parser: parse error at or near "frum" at character 10 It also implement's Tom's suggestion: template1=# select * from pg_class where\g ERROR: parse: parse error at end of input Gavin Sherry
-
由 Bruce Momjian 提交于
This patch is an updated version of the lock listing patch. I've made the following changes: - write documentation - wrap the SRF in a view called 'pg_locks': all user-level access should be done through this view - re-diff against latest CVS One thing I chose not to do is adapt the SRF to use the anonymous composite type code from Joe Conway. I'll probably do that eventually, but I'm not really convinced it's a significantly cleaner way to bootstrap SRF builtins than the method this patch uses (of course, it has other uses...) Neil Conway
-
由 Bruce Momjian 提交于
Denis A Ustimenko
-
由 Bruce Momjian 提交于
Everytime if I do PQconsumeInput (when the backend channel gets readable) I check for the return value. (0 == error) and generate a notification manually, e.g. fixed string connection_closed) and pass it to the TCL event queue. The only other thing I had to do is to comment out removing all pending events in PgStopNotifyEventSource whenever the connection was unexpectedly closed (so the manually generated event will not be deleted). A broken backend connection triggers a notify event to the client (fixed notification string "connection_closed") so proper action can be taken to switch to another database server etc. Remember that this is event driven. If you have applications, that have idle database connections most of the time, you'll get immediate feedback of a dying server. Upon connection to the server issue a pg_notify for notify event "connection_closed" and whenever the backend crashes (which it does do in very very rare cases) you get an event driven recovery. (of course the Tcl-Event loop has to be processed). Issuing a notification "connection_closed" on a still working database could be used for switching to another db-server (which I've actually impelemented right now). Gerhard Hintermayer
-