PDA

View Full Version : pgsql Bugs

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15
  1. BUG #4151: Can't connect/start database after restart
  2. statement_timeout and crosstab
  3. BUG #4150: ecpg: update/insert of array data does not work anymore since Version 8.2
  4. Re: reproducible database crash with simple sql command
  5. Re: BUG #4053: libpq documentation should express clearly,that integers are passed in network octet order
  6. Re: BUG #4053: libpq documentation should express clearly, that integers are passed in network octet order
  7. Re: BUG #4040: psql should provide option to notprompt for password
  8. Re: BUG #4040: psql should provide option to notprompt for password
  9. ORDER BY...LIMIT optimization does not work with inherited tables
  10. BUG #4148: tsearch related issue
  11. BUG: aliases does not work ((
  12. BUG #4147: pg_constraint table data retrieval error
  13. BUG #4145: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
  14. Feature request
  15. BUG #4141: Aliases in rules vanished, but they work
  16. BUG #4142: pg_dump will not work
  17. BUG #4137: Postgres drives pg_standby %r param to delete WAL file before processing
  18. BUG #4135: postmaster crashes if matching on VALUES is used on a column with index
  19. BUG #4133: Installation error
  20. PB with postgresql 7.4
  21. BUG #4132: REASSIGN OWNED fails on procedural languages
  22. postmaster segfault when using SELECT on a table
  23. Re: BUG #4126: KRB5/GSSAPI authenication fails for multipart kerberos principals
  24. BUG #4128: The postmaster.opts.default file is begin ignored
  25. BUG #4127: pg_dumpall -c unable to be restored without error
  26. problem
  27. BUG #4126: KRB5/GSSAPI authenication fails for multipart kerberos principals
  28. HELP pls
  29. Re:
  30. Re:
  31. BUG #4125: Strange ALTER TABLE behavior
  32. BUG #4124: Error message: "You local administrators group contains 'Service users' this is a common configurat
  33. Patch for LISTEN/NOTIFY race condition?
  34. Re: DISTINCT MAX() results mismatch on 8.2 and 8.3
  35. BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
  36. BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver
  37. Re: ERROR: failed to re-find parent key in "sl_seqlog_idx"for deletion target
  38. BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument
  39. BUG #4113: server closed the connection unexpectedly
  40. pg_dump error when dumping mixed-case name tables
  41. BUG #4120: ERROR: cache lookup failed for function 0
  42. 'Too many LWLocks held' with GIN pg_trgm_ops index [RE-SENT]
  43. BUG #4119: Add foreign key fails for non-presence of a record that does exist.
  44. BUG #4116: Cannot create tablespace: could not set permissions on directory
  45. BUG #4115: PostgreSQL ISO format is not really ISO
  46. Inconsistent shift operator
  47. BUG #4114: Inconsistent shift operator
  48. Re: Request
  49. BUG #4112: Error on access table's data
  50. BUG #4110: Error on select doing (date +1)
  51. BUG: Protocol 3.0: that's just odd, needing to add the number of bytes the length field occupies
  52. BUG #4109: Typo in documentation
  53. BUG: Protocol 3.0 ErrorResponse: Last 'null' character seems odd
  54. BUG #4108: PgInstaller Update modify install paths in Registry
  55. domains missing some default castings
  56. tracking down a crash bug
  57. Re: BUG #3953: No PostGIS option in installer
  58. Re: BUG #3953: No PostGIS option in installer
  59. BUG #4106: WHERE - clause in view works only sometimes
  60. operator does not exist: timestamp w/out timezone (similar to bug3807)
  61. error php - postgresql
  62. BUG #4103: DELETE Syntax Error
  63. BUG #4104: Uninstall/remove not working correctly
  64. BUG #4105: Service already started but no choice to stop in pgAdmin3 gui
  65. BUG #4101: Fails to start when transaction log on another drive
  66. Error in module
  67. Error in module
  68. BUG #4091: ECPG $select incompability with Informix
  69. BUG #4100: GMT offsets are wrong
  70. BUG #4098: Encoding problems
  71. BUG #4099: backup error
  72. CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others
  73. BUG #4097: can join + where query be optimized?
  74. BUG #4096: PG 8.3.1. confused about remaining disk space
  75. BUG #4092: initdb fails if the xlog directory is the same as [pg_data]/pg_xlog
  76. BUG #4095: Out of memory when restore db
  77. BUG #4090: ECPG Selecting table with NULL values
  78. BUG #4088: Server doesn't listen
  79. BUG #4089: When available disk space is low pg_stop_backup() fails, as do subsequent recovery attempts.
  80. BUG #4087: table creation problem using python
  81. 335 http://bloqueadorgsm.vilabol.uol.com.br - Bloqueador gps gsm -localizador gps gsm - sem mensalidade - alarme automotivo , alarme paracarros 3357682152366685811713028
  82. Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column isTEXT
  83. BUG #4085: No implicit cast after coalesce
  84. BUG #4084: Some DST timezones switche to summer time (one week) later
  85. BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
  86. Postgre cant start
  87. BUG #4081: Running Postgres as Windows service vs regular applications
  88. BUG #4082: Fatal error, close server
  89. BUG #4079: libpq.dll very slow (unusable)
  90. Re: BUG #4074: Using SESSION_USERor CURRENT_USER in a view definition is unsafe
  91. BUG #4075: PostgreSQL Database Server 8.2 failed to start
  92. BUG #4077: Error 42704
  93. BUG #4078: ERROR: operator does not exist: numeric = character varying
  94. BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
  95. BUG #4073: ERROR: invalid input syntax for type timestamp: "Sat Mar 29 04:47:06 WEST 2008"
  96. BUG #4074: Using SESSION_USER or CURRENT_USER in a view definition is unsafe
  97. BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data
  98. The problem with FULL JOIN
  99. Recommended approach for upgrading DBs with nonmatching encodings
  100. University of Bridgeport Graduate Programs and Research Opportunities
  101. Workaround to get arrays for plperl
  102. BUG #4069: Wrong tip
  103. Re: [PATCHES] Incomplete docs for restore_command forhotstandby
  104. ERROR: RETURN NEXT must specify a record or row variable in function returning tuple
  105. BUG: wrong doc or wrong connectby?
  106. Documentation commenting does not work
  107. Redundant explicit field name/types description while select from function with return type of record
  108. FOR-IN-EXECUTE: FOR does not replanned on each entry to the FOR loop
  109. Re: DISTINCT MAX() results mismatch on 8.2 and 8.3
  110. BUG #4068: Failed to compile 8.3.1
  111. Extra empty lines PGv8.3.1
  112. BUG #4066: error
  113. postgres geometry column data visibility
  114. Re: DISTINCT MAX() results mismatch on 8.2 and 8.3
  115. BUG #4064: the 'PostgreSQL Database Server 8.3' service auto shutdown
  116. BUG #4065: Error on psql windows client
  117. BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.
  118. BUG #4057: SUM returns NULL when given no rows
  119. BUG #4060: libpq - large stack causes TCP/IP error
  120. BUG #4059: Vacuum full not always cleaning empty tables
  121. Possible problem with EXTRACT(EPOCH FROM TIMESTAMP)
  122. BUG #4058: xml_table() segfaults on null
  123. can't delete record from second table in rules of view with join select
  124. BUG: PG do not use index
  125. BUG #4056: problem creating function with domain argument
  126. BUG #4052: GCC update -fwrapv and new -Wstrict-overflow
  127. BUG #4054: Text containing ';' upsets db restores
  128. BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1
  129. BUG #4053: libpq documentation should express clearly, that integers are passed in network octet order
  130. BUG #4050: pg_dump data contains COMMIT statement (8.3, 8.4)
  131. BUG #4051: ERROR: relation with OID xxxx does not exist
  132. BUG #4048: Can't install pltcl
  133. BUG #4049: ecpg library causes signal 11 when --enable-thread-safety is turned on
  134. lc_messages to_char('2007/01/01'::date,'TMMonth') does not work.
  135. BUG #4047: case preserve for columns
  136. win installer 8.3 doesn't recognice ActiveTCL8.5
  137. 8.3 can't convert cyrillic text from 'iso-8859-5' to other cyrillic 8-bit encoding
  138. BUG #4039: server closed the connection when use function "makeline_garray"
  139. BUG #4040: psql should provide option to not prompt for password
  140. BUG #4038: Problem with locale changing by initdb
  141. BUG #4029: Failed to get System metrics for terminal services:87
  142. BUG #4030: Inconsistency: ORDER BY clauses involving column aliases
  143. Further problems
  144. BUG #4036: Nested xpath() calls lose namespace support
  145. BUG #4035: sql table aliases do not work
  146. BUG #4037: Manual bug: 2.5. Querying a Table
  147. BUG #4028: installator failure
  148. Re: LISTEN/NOTIFY race condition?
  149. BUG #4025: wsock32.dll not found
  150. lseg ?# (intersects) incorrect for lsegs whose intersection is anotherlseg
  151. BUG #4026: Displaying Wrong dates
  152. BUG #4027: backslash escaping not disabled in plpgsql
  153. 8.3.0 backend segfaults
  154. BUG #4024: xpath() results lose namespace mappings
  155. BUG #4023: The transaction control does not work for sequences
  156. Rulese Bug: Instead of reporting incorrect insert count.
  157. Re: [PATCH] Don't bail with legitimate -N/-B options
  158. BUG #4021: UUID NULL and not equal query failed
  159. Help needed in Solving the problem in pg_restore
  160. Re: [PATCH] Don't bail with legitimate -N/-B options
  161. BUG #4020: RFE: have way to log autovacuum activity
  162. BUG #4022: DST Time Zone Bug related to: select now() at time zone 'EST'
  163. Re: BUG #3829: Wrong index reporting from pgAdmin III(v1.8.0 rev 6766-6767)
  164. Loading pljava: specified module could not be found
  165. BUG #4018: Installation failure
  166. Error during hash index scans can cause postgres halt!
  167. BUG #4019: Comparison of user defined domain doesn't work
  168. Tom Belich
  169. BUG #4012: bug in pg_query
  170. BUG #4015: uninitialized value passed as an argument to tm2timetz
  171. Re: BUG #3909: src\tools\msvc\clean.bat clears parse.hfile
  172. BUG #4016: Build fails in ecpglib on file extern.h
  173. BUG #4010: psql does not honour -c after database name
  174. BUG #4011: spelling mistake in comments
  175. Re:
  176. LISTEN/NOTIFY race condition?
  177. Re: [PATCHES] Incomplete docs for restore_command forhot standby
  178. Re: Incomplete docs for restore_command for hotstandby
  179. pg_ctl problem
  180. problem with silent installation
  181. BUG #4007: chr(0) doesn't work anymore
  182. BUG #4008: accepts invalid input with domaintypes and outer joins
  183. BUG #4005: installation error
  184. BUG #4006: pg_ctl assumes that all config files lie in data_directory
  185. Re: [GENERAL] ecpg problem
  186. patch: fix up compiling of libpq on the 8.3 stable branch
  187. BUG #4004: out of memory
  188. ecpg produces code that won't compile
  189. BUG #3999: Panic with "invalid string enlargement request size" after a strange request from JDBC
  190. BUG #4001: ecpg produces code that won't compile
  191. BUG #4002: Error when I attemp to make a query by prompt
  192. bug or not bug, xmlvalidate(xml, text) can read and show one line from file
  193. BUG #3997: Venezuela TIMEZONE
  194. FW: Bug Report - PGAdmin Version 1.6.3 - Restore
  195. BUG #3996: Reinstalling after uninstall
  196. BUG #3995: pqSocketCheck doesn't return
  197. BUG: ILIKE with single-byte encoding
  198. Internal Error on 'vacuum full'
  199. BUG #3993: RULE UPDATE : GET DIAGNOSTICS ROW_COUNT = 0
  200. Re: BUG #3968: ssh tunnel instructions could use improvement
  201. panic? return of the btree-bug
  202. BUG #3991: pgsql function sum()
  203. help me plz with 2 postgres users
  204. BUG #3988: problem with installation
  205. BUG #3990: PostgreSQL does not work
  206. BUG #3989: Error when Installing
  207. BUG #3987: Not checking the password
  208. BUG #3985: select command not working
  209. BUG #3986: Error ts_vector with UTF8 WS2003
  210. BUG #3980: Can not Install PostgreSQL - error at the end of installation
  211. BUG #3983: pgxs files missing from binary installation
  212. BUG #3981: Can not Install PostgreSQL - error at the end of installation
  213. BUG #3979: SELECT DISTINCT slow even on indexed column
  214. Bug Attached Table Ms Access97 with Boolean
  215. Initdb error without much more details PostgreSQL 7.4.19
  216. BUG #3978: plperl configure / build process behavior wrt Universal Binaries
  217. Re: BUG #3951: SELECT ... WHERE Param = ? does not work ifParam is of type bytea
  218. 8.3 problems with sspi authentication
  219. Re: BUG #3969: pg_ctl cannot detect server startup
  220. BUG #3976: Inteface direction issue
  221. BUG #3975: tsearch2 index should not bomb out of 1Mb limit
  222. BUG #3973: pg_dump using inherited tables do not always restore
  223. Incomplete docs for restore_command for hot standby
  224. GetNewOidWithIndex can cause infinite loop on user tables(not catalog).
  225. Re: BUG #3965: UNIQUE constraint fails on long column values
  226. BUG #3972: ERROR: function 59015 returned NULL
  227. BUG #3925: You can delete enum elements from pg_enum, but it is used in a table
  228. BUG #3926: Typo in documentation
  229. BUG #3927: configure --with-gssapi fails
  230. BUG #3920: sequence not generated for postgres using toplink jpa
  231. Re: BUG #3894: JDBC DatabaseMetaData.getTables is inconsistentlycase-sensitive with schema name
  232. BUG #3921: CREATE TABLE / INCLUDING INDEXES fails with permission denied
  233. BUG #3922: Problems migrating databases.
  234. BUG #3924: Create Database with another encoding as the encoding from postgres
  235. BUG #3919: Service Privileges Bug
  236. Re: Supported platforms for PostgreSQL
  237. BUG #3916: type of "xxxx" does not match that when preparing the plan
  238. BUG #3917: Compilation error on VC8.0
  239. Windows setup Error RC2
  240. Statement Timeout Message Incorrect
  241. BUG #3897: plJava dll still doesn't load
  242. BUG #3898: Postgres autovacuum not respecting pg_autovacuum.enabled = false
  243. BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name
  244. BUG #3895: Access denied
  245. 8.2 and 8.3 postgresql.conf oddity
  246. Gentoo shared_buffers setting (was: BUG #3888: postmaster...)
  247. bad message or bad privilege check in foreign key constraint
  248. why provide cross type arithmetic operators
  249. Default password
  250. Re: Gentoo shared_buffers setting (was: BUG #3888: postmaster...)