PDA

View Full Version : Pgsql General

  1. Slow COUNT
  2. postmaster / resolv.conf / dns problem
  3. pg_restore error
  4. Encoding problem
  5. information_schema._pg_keypositions() in 8.1???
  6. Switchover : WAL archiving and shutdown...
  7. interval behaviour
  8. Function returning SETOF
  9. Re: fatal error in pg.log
  10. Disk Keeper
  11. number of dimensions of a multi-dimensional array
  12. Switchover : WAL archiving and shutdown...
  13. 8.1, OID's and plpgsql
  14. Re: fatal error in pg.log
  15. encoding problem
  16. fatal error in pg.log
  17. Re: help with utf8
  18. alter table schema on 8.0.X
  19. Re: postgres log file
  20. date/time function
  21. PGSQL 7.4.8 PHP 4.3.4 & Apache 2.0.49 Segmentation Fault with Client Certs
  22. default_index_tablespace?
  23. Re: postgres log file
  24. How to run a stored PL/pgSQL function?
  25. SELECT Generating Row Exclusive Locks?
  26. Re: undefined behaviour for sub-transactions?
  27. How to check options PostgreSQL was started with
  28. How to change database owner in 7.4
  29. Question
  30. What is the deal with mailing lists?
  31. Limits
  32. Re: Tablespaces with Windows 2000
  33. Re: [SQL] Archives site down?
  34. regarding Solaris 10
  35. Re: memory leak under heavy load?
  36. Finding uniques across a big join
  37. Writing output to a file
  38. Re: errors with 8.1 make on Solari
  39. errors with 8.1 make on Solaris
  40. sequence problem - many rows
  41. memory leak under heavy load?
  42. Re: sequence problem - many rows
  43. I can't build the 8.1.0 source rpm from postgresql.org
  44. Question
  45. Error in IPV6 client authenciation
  46. [indexing] 2d spatial + 1d value in one index?
  47. postgres log file
  48. Getting "cannot remove lock from HTAB" during VACUUM FULL
  49. Re: Errors upgrading from 7.3 to 8.1
  50. Errors upgrading from 7.3 to 8.1
  51. Table size
  52. Re: Strange VACUUM behaviour
  53. sub select as a data column
  54. problem with psql?
  55. intarray index
  56. ANN: PgBrowse-1.3 is available.
  57. Re: PostgreSQL and SAN/NAS technologies
  58. how to get size of array in function
  59. Help with COPY Error: invalid UTF-8 byte ....
  60. strange behaviour in plpgsql:null arguments
  61. "nice" query possible?
  62. Re: regarding the apostrophe character
  63. Re: postmaster does not come up
  64. PostgreSQL and SAN/NAS technologies
  65. Queue Implementation for/with PostgreSQL
  66. need help in designing a database.
  67. Usability Question
  68. Tcl Support in the FC4 rpms at posgresql.org?
  69. Default and PQexecParams
  70. Login limitation?
  71. FW: GRANT question
  72. GRANT question
  73. howto create dynamic table name in plpgsql function.
  74. Can this pl/pgsql be simplified?
  75. Resend: Question about PostgreSQL, pgpool, and Postfix
  76. Regular expressions w localization problem
  77. Syntax Error in COPY
  78. crosstab doesn't work
  79. I need a teacher in Huelva, Spain...
  80. Re: regarding the apostrophe character
  81. postmaster does not come up
  82. regarding postmaster.pid file
  83. regarding the apostrophe character
  84. New user questions
  85. pg_connect troubles on localhost
  86. tool for DB design
  87. pg_dump --data-only: is dump ordered to keep foreign-key-relations loadable?
  88. different queries and their efficiencies
  89. Postgres as embedded db for GUI
  90. Function name variable within a non-trigger function
  91. Re: How to commuciate between two server in postgress
  92. selecting a attribute from a function
  93. Errors with temporary tables
  94. Set a blank password for a db user
  95. declare function with IN and OUT parameter as well as refcursor
  96. Re: Private email requests
  97. dumping data to version control using pg_dump?
  98. Delete statement does not work with PostgreSQL 8.0.1
  99. How to commuciate between two server in postgress
  100. Re: Group By?
  101. PL/pgSQL: how to round a number up?
  102. "invalid page header in block 597621 of relation..." error
  103. Re: Questions on 8.1 install
  104. Re: Silent start of Postgres in XP
  105. Questions on 8.1 install
  106. Silent start of Postgres in XP
  107. Re: pg_ctl start leaves dos window open
  108. pg_ctl start leaves dos window open
  109. TSearch2 / German compound words / UTF-8
  110. Logging prepared statements in 8.1?
  111. Logging prepared statements in 8.1?
  112. Strugging with NEW and OLD records.
  113. tsearch2: more than one index per table?
  114. Slow pgdump
  115. Index Administration: pg_index vs. pg_get_indexdef()
  116. Set Returning Function (Pipelining)
  117. How to trim Bytea fields
  118. problem with GRANT postgres 8.0.4
  119. settings for multi-language unicode DB
  120. Re: not null error in trigger on unrelated column
  121. Java, postgres and jasper help
  122. not null error in trigger on unrelated column
  123. Best way to represent values.
  124. Re: Group By?
  125. Group By?
  126. Re: Conditional delete
  127. Difference in indexes
  128. Timestamp with Timezone
  129. Rule appears not to fire on insert w/ "except"
  130. Re: Any good HOWTOs on LDAP with PostgreSQL 8.1?
  131. Re: Trouble downloading Postgres
  132. Re: Anomalies with the now() function
  133. Any good HOWTOs on LDAP with PostgreSQL 8.1?
  134. Trouble downloading Postgres
  135. About not to see insertion result "INSERT 0 1"
  136. Rule appears not to fire on insert w/ "except"
  137. Re: Multi-parameter aggregates.
  138. Re: Multi-parameter aggregates.
  139. Re: Multi-parameter aggregates.
  140. Re: Multi-parameter aggregates.
  141. SQL Help: Multiple LEFT OUTER JOINs
  142. Testing again, ignore ...
  143. TSearch2 Questions
  144. Test, ignore ...
  145. Weird results when using schemas
  146. to create a database...
  147. Why pgAdmin III guru suggests VACUUM in 8.1
  148. Create role question
  149. Mambo (CMS) & PostgreSQL
  150. Implementing rounding rule in plpgsql
  151. Custom GIST getting ERROR: too many LWLocks taken
  152. permission issue
  153. Re: DISTINCT ON
  154. Re: Why CALL/PERFORM not part of core SQL?
  155. Createlang plpgsql
  156. Postgres Disconnection problems
  157. DISTINCT ON
  158. implicit index created, do I need to also create an explicit index?
  159. Upgrading from 8.0 to 8.1 on Debian
  160. shorter way to get new value of serial?
  161. plperlu Question
  162. Anomalies with the now() function
  163. to Jerry LeVan
  164. trigger
  165. How to debug a locked backend ?
  166. Re: Sun supporting PostgreSQL
  167. Why CALL/PERFORM not part of core SQL?
  168. Mambo/Joomla (CMS) on PostgreSQL ?
  169. Strange slow database
  170. [Fwd: Sun backs open-source database PostgreSQL | Topic: "everything"| ZDNet News Alerts]
  171. unsubscribe
  172. Partial foreign keys, check constraints and inheritance
  173. unsubscribe pgsql-general
  174. Moving from MySQL to PostgreSQL with Ruby on Rails.
  175. Very slow queries on 8.1
  176. strange behavior on 8.1
  177. Re: Rebranding PostgreSQL
  178. Re: Rebranding PostgreSQL
  179. Re: PG 8.1 on Dual XEON with FreeBSD 6.0
  180. Re: Does PG Support Unicode on Windows?
  181. Does PG Support Unicode on Windows?
  182. Re: PREPARE TRANSACTION and webapps
  183. Incomplete Startup Packet
  184. absolute or relative updates
  185. Re: PREPARE TRANSACTION and webapps
  186. Re: PostgreSQL compatible with Real Time Linux ?
  187. Call for trace_sort output/details
  188. PostgreSQL compatible with Real Time Linux ?
  189. PostgreSQL compatible with Real Time Linux ?
  190. Re: Rebranding PostgreSQL
  191. PHP PDO functions
  192. locked backend
  193. PG 8.1 on Dual XEON with FreeBSD 6.0
  194. Rebranding PostgreSQL
  195. shouldn't postgres know the numer of rows in a (sorted) result-set before returning the first row?
  196. Tsearch2: casting text to tsquery
  197. Re: invalid UTF-8 byte sequence detected
  198. Wrong rows selected with view
  199. installation(pg_depend) problem
  200. Trouble with recursive trigger
  201. Re: ablilty to test record for foreign key before deleting the record? - Found word(s) list error in the Text body
  202. Re: Permissions required for service user account _after_ installation
  203. Permissions required for service user account _after_ installation
  204. ablilty to test record for foreign key before deleting the record?
  205. subscribe
  206. Re: Customizing the Windows installer
  207. Customizing the Windows installer
  208. Cursors or Offset, Limit?
  209. Re: recovering windows database after crash
  210. Re: Number of items in a cursor...
  211. Most significant digit number formatting
  212. Is it databases in general, SQL or Postgresql?
  213. Restore a PG database in Windows
  214. lo_import()
  215. recovering windows database after crash
  216. Performance of a view
  217. Re: Updated: partitioning functions
  218. Re: Queries causing highest I/O load since pg_stat_reset?
  219. 3 x PostgreSQL in cluster/redunant
  220. IF EXISTS
  221. 8.1 beta3 initdb required?
  222. Re: Updated: partitioning functions
  223. Queries causing highest I/O load since pg_stat_reset?
  224. Bug with index-usage?
  225. Re: Choosing PostgreSQL as the database for our next project
  226. Fuzzy text search
  227. odbc and psql 8.1.0
  228. Outer join with where conditions
  229. Connection Oracle database from Postgres function
  230. Does PG support updateable view?
  231. Tablespaces with Windows 2000
  232. Re: psycopg2 problem with libpq.dll , Postgres 8.1.0 Win XP
  233. psycopg2 problem with libpq.dll , Postgres 8.1.0 Win XP
  234. postgres: unknown hard error
  235. Duplicate rows
  236. Re: Wikipedia help requested, especially non-English speakers
  237. Reports and postgres
  238. strings
  239. postgres 8.1 compile error in the pg_attribute.h file
  240. Choosing PostgreSQL as the database for our next project
  241. Re: I'm getting "ERROR: unsupported type: 17296"
  242. replicator
  243. [8.1] "drop table" in plpgsql function
  244. return next
  245. A good postgresql book
  246. Restoring from filesystem backup
  247. Two slightly different queries produce same results, one takes 1/4the time.. bug in planner?
  248. Congratulations on 8.1
  249. pg_restore errors
  250. table copy