PDA

View Full Version : Pgsql General

  1. HINT: Perhaps out of disk space?
  2. bit/integer operations in postgres
  3. problems with currval and rollback
  4. Why is create function bringing down the Backend server?
  5. reading EXPLAIN output
  6. Stored procedure
  7. Sorting array field
  8. About Maximum number of columns
  9. Re: Indexes on character type columns
  10. Is CREATE TYPE an alias for CREATE DOMAIN?
  11. Mem usage/leak - advice needed
  12. SAVEPOINT performance
  13. lo function changed in PostgreSQL 8.1.1 (ask again)
  14. two shared memory segments?
  15. Re: PostgreSQL crashing
  16. Memory Question
  17. contrib extenstions
  18. query for a time interval
  19. Funky template1 problem?
  20. Questions about server.
  21. No reaction to client_encoding!
  22. Newbie Question: FAQ for database optimization?
  23. Syntax Error Inserting From STDIN?
  24. recursive function
  25. tsearch2: index in different table?
  26. deduce sequence name from table and column
  27. Could not read - Permission denied
  28. About Blobs in postgresSQL
  29. ANN: PgBrowse 1.5
  30. Show all to a specific backed
  31. Performance of batch COMMIT
  32. Re: Question on indexes
  33. libpq++ installation error
  34. out of memory during query execution
  35. sequences w/o holes
  36. sequences in transaction blocks
  37. Select list of table names for particular DB
  38. sequence rollback?
  39. One DB not backed up by pg_dumpall
  40. synchronization of news.postgresql.org and news.fr.postgresql.org
  41. Access bool integer solution
  42. convert integer to bool implicitly
  43. installing tsearch 2 error no user "root"
  44. update count
  45. Converting seconds past midnight to a time
  46. Views
  47. Tsearch2 and aspell
  48. (NONE)
  49. DBlink documentation
  50. Versioning Schema/Stored Procedures
  51. FW: PL/pgSQL Function Help
  52. PL/pgSQL Function Help
  53. 8.1 build on Solaris has LATIN9?
  54. Transacciones Anidadas
  55. Getting a DB password to work without editing pg_hba.conf, possible?
  56. Fetch statements
  57. Re: Debug user lib for user define data type
  58. How to store the time zone with a timestamp
  59. Migration tool from MS SQL server 7.0
  60. Re: outdated (bad) information in pg_stat_activity
  61. Re: Installation trouble - Solved
  62. 7.4.5 vs 8.0 on Debian/sparc
  63. "gmake check" fails with 8.1.1
  64. Re: is this a bug or I am blind?
  65. Re: is this a bug or I am blind?
  66. is this a bug or I am blind?
  67. Compilation on Solaris problem
  68. enable SSL on server
  69. copying a database without dumping it
  70. Question on the use of bracket expressions in Postgres
  71. unsubscribe pgsql-genera
  72. New RPM sets are available for download
  73. Re: outdated (bad) information in pg_stat_activity
  74. Debug user lib for user define data type
  75. Recuperar Base de datos
  76. Release 8.1.1 for Fedora X 64bits
  77. Re: Improving Availability
  78. Re: Improving Availability
  79. outdated (bad) information in pg_stat_activity
  80. ANN: PgBrowse 1.4
  81. valgrind output
  82. stored procedure performance
  83. post
  84. Timestamp <-> ctime conversion question ...
  85. Installing the latest 8.1.1 rpms question.
  86. User entry of parameters in queries/views.
  87. Multi-row update w. plpgsql function
  88. php + postgresql pg_connect problem
  89. triggering on deletes, NEW row or OLD row?
  90. "incomplete startup packet" on SGI
  91. Toolkit for creating editable grid
  92. timestamp <-> ctime conversion question...
  93. to_char() Question
  94. UPDATE table .....
  95. pg money -> msaccess currency
  96. lo function changed in PostgreSQL 8.1.1
  97. Re: Performance large tables.
  98. non-blocking socket
  99. File access problem access(), stat()
  100. What's new in 8.1.1
  101. How to Save Arrays
  102. OpenOffice 2 and Postgresql 8.1 How to?
  103. ERROR: could not find function
  104. missing something obvious about intervals?
  105. View with an outer join - is there any way to optimise this?
  106. Re: TSearch2: Auto identify document language?
  107. Re: Silent installation of postgres
  108. client_encoding values
  109. Silent installation of postgres
  110. Two instances of postgresql, neither frees up log space
  111. Quick hack: permissions generator
  112. Issue With PQftable()
  113. Re: ODBC connection problems!
  114. Re: postgreSQL 8.0.4 - Windows driver
  115. Negative offsets
  116. PostGreSQL 8.1.0 : out of memory during vacuum full analyze
  117. Free Pascal and Postgresql Functions, Possible?
  118. postgresql rpms (8.1.1) for redhat 8.0
  119. using more then one CPU for queries
  120. Re: [SQL] Looking for information on PostgreSQL Stored Procedures
  121. PL/pgSQL : notion of deferred execution
  122. TSearch2: Auto identify document language?
  123. Re: Performance large tables.
  124. Maximum number of tables per database and slowness
  125. alter table schema in 8.0
  126. Performance woes
  127. Update and bytea problem...
  128. R: find last day of month
  129. Re: PgSQL 8.1.0 Solaris w/ Sun's cc
  130. swap relations to be able to execute a left join
  131. Solaris 10 Sun Studio 11 compile error configtest
  132. PgSQL 8.1.0 Solaris w/ Sun's cc
  133. random delays
  134. \d++
  135. tsearch2: How to use different configurations for two columns?
  136. pg_dump problems
  137. 1 question about psql table
  138. GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 8.1.0
  139. after vacuum, db is still "growing" :(
  140. bug or not? Trigger preventing delete causes circumvention of FK
  141. Re: copy with where query?
  142. copy with where query?
  143. How efficient is select currval?
  144. find last day of month
  145. Error in 7.4.9 Documentation
  146. Specify schema in jdbc connection string?
  147. Re: is it possible to delete the psql log while psql is running?
  148. date format
  149. Special message brought to you by Writer's Digest
  150. is it possible to delete the psql log while psql is running?
  151. is it possible to delete the psql log while psql is running?
  152. Multi-Master-Solution (PGCluster)?
  153. how to check if a database exists programatically
  154. deleting records is failing
  155. php from windowsXP box
  156. =?ISO-2022-JP?B?GyRCQGhHWiNPI0wkLDY1JCgkayEiTlkkTjF8TU1FcDsjR Wo5RiROGyhC?==?ISO-2022-JP?B?GyRCSlQbKEI=?=
  157. Help on collation and accent sensitivity
  158. Re: Memory Leakage Problem
  159. Log of CREATE USER statement
  160. Re: Map of Postgresql Users (OT)
  161. Re: [pgsql-de-allgemein] Query SELECT * sehr langsam
  162. Lost database
  163. Problem: libpq, network traffic, memory usage
  164. TSearch2 / Get all unique lexems
  165. FW: Advanced search form
  166. PostgreSQL 8.1.0 RHEL / Debian incompatible packages
  167. Error on PostgreSQL mailing list web pages?
  168. inheritance/foreignkeys
  169. pg_autovacuum
  170. =?iso-8859-1?Q?CURSOS_FORMACI=D3N_INFORMATICA_ONLINE?=
  171. Character encoding and string matches
  172. cannot find source of "add missing from" error
  173. tables with lots of columns - what alternative from performance point of view?
  174. Delete Question
  175. Letting a function return multiple columns instead of a single complex one
  176. Re: Graphical modelling tool
  177. Problem with constraints
  178. insert deadlock
  179. Graphical modelling tool
  180. ltree patch is available
  181. Should I fix something after disk full error
  182. Re: error in creating database
  183. error in creating database
  184. Re: Unicode Corruption and upgrading to 8.0.4. to 8.1
  185. Help needed for Table name resolution
  186. Re: Unicode Corruption and upgrading to 8.0.4. to 8.1
  187. Re: need help
  188. Temporary disable autovacuum in pgsql 8.1.0
  189. UNSUBSCRIBE
  190. is there any way of specifying "i want x GB of space to be avaialble for my database"
  191. mirroring tables to sqlite?
  192. Changing database owner (7.4)
  193. Hanging Transactions
  194. feature: dynamic DB cache resizing
  195. 8.1 removed functions
  196. ILIKE '%term%' and Performance
  197. EXPLAIN SELECT .. does not return
  198. Using a 250GB RAID10 server for postgres
  199. Preventing or controlling runaway queries
  200. troubleshooting hung postmasters
  201. how to use SAVEPOINT in stored function
  202. unsubscribe
  203. massive performance hit when using "Limit 1"
  204. Re: ODBC Layer and the now() function
  205. ODBC Layer and the now() function
  206. plperlu function
  207. fts, compond words?
  208. Re: [ANNOUNCE] == PostgreSQL Weekly News - December 05 2005 ==
  209. postmaster does not come up
  210. PG_exception_stack
  211. Inheritance Algebra
  212. Selecting Large Object and TOAST
  213. postgresql jdbc connect via hostname instead of just ip
  214. Fwd: Enhancement Request : Expressions for format string in PlPgsql RAISE statement
  215. function in index expression and unnecessary function calls in select
  216. keeping track of inserts (periodical) into a table
  217. Use of %ROWTYPE in plpgsql function declarations
  218. Re: Missing variable "role" in "pg_settings"?
  219. Re: int to inet conversion
  220. Re: beginne' - inserting a record
  221. pl_pgSQL array parameter and order of results returned
  222. Re: beginne' - inserting a record
  223. Re: beginne' - inserting a record
  224. Re: beginne' - inserting a record
  225. Re: beginne' - inserting a record
  226. hello
  227. 8.03 versus 8.04
  228. news.postgresql.org slow
  229. Regular Expression Question
  230. GENERAL] unsubscribe
  231. Re: memory leak under heavy load?
  232. was a initdb required from 8.1beta3 -> beta4?
  233. pg_dump from Java or SQL?
  234. New.* and old.* as function arguments within rules
  235. deadlock detected - when multiple threads try to update one table
  236. createuser ignores stdin in 8.1.0?
  237. Adding order bys to the view definitions (7.4)
  238. [Fwd: Re: deadlock on the same relation]
  239. Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
  240. accessing text of the query in a rule
  241. Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
  242. How: single db, multiple users
  243. Re: Table design
  244. Unicode Corruption and upgrading to 8.0.4. to 8.1
  245. Table design
  246. 'AS' column-alias beign ignored on outer select
  247. deadlock on the same relation
  248. user_write_lock_oid questions
  249. PostgresSQL Halting System Boot
  250. lo_import permissions problem