View Full Version : Pgsql General



  1. Re: HP/Pgsql/DBD::Pg issue
  2. Re: [ADMIN] pg_buffercache view
  3. Number of Queries
  4. Re: [pgadmin-support] questions about cursors
  5. tsearch2 punctuation question
  6. Business days
  7. Feature request - have postgresql log warning when new sub-releasecomes out.
  8. Re: PosegreSQL support
  9. Re: PosegreSQL support
  10. PosegreSQL support
  11. Re: Vacuum-full very slow
  12. reg:bitmap index
  13. Re: Regarding WAL
  14. FOREIGN KEY CONSTRAINT AND INHERITANCE
  15. reg: bitmap index implementation
  16. Re: [DOCS] Incrementally Updated Backups: Docs Clarification
  17. Kill a Long Running Query
  18. Stored Procedure Speed
  19. pg_connect sometimes works sometimes not
  20. a math question
  21. Bitmap Scan Pages
  22. copy or create table for data logging?
  23. Additional debugging of idle sessions?
  24. query from a list of ids
  25. ERROR: variable not found in subplan target lists
  26. reasonable limit to number of schemas in a database?
  27. postgres on Windows: PAE and max memory
  28. conditional joins and views
  29. Re: [ADMIN] Regarding WAL
  30. FIN_WAIT_2
  31. WAL files, warm spares and minor versions
  32. Generic triggers ?
  33. Re: Problem Backing Up a DB
  34. Audit-trail engine: getting the application's layer user_id
  35. Re: How does server handle clients that disconnect ungracefully?
  36. Re: How does server handle clients that disconnect ungracefully?
  37. Re: [pgadmin-support] questions about cursors
  38. Problem Backing Up a DB
  39. pgsql-general@postgresql.org
  40. Major differences between 7.1.1 and 7.4.x
  41. [pgsql] inherits and foreign key problem
  42. PG service restart failure (start getting ahead of stop?)
  43. where clause help
  44. Slow query using simple equality operators
  45. Re: ERROR: Failed to build any 5-way joins]
  46. change format of logging statements?
  47. using Postgres with Sequoia
  48. Setting table ids in slony
  49. The directory of the postgresql source
  50. Help debugging a hung postgresql client connection
  51. PQerrorMessage: suppress trailing new line?
  52. Mass Update
  53. Postgresql Help
  54. Missing magic block
  55. Help with pgFoundry
  56. Lock contention, docs vs. reality
  57. Creating Index
  58. contributing patches
  59. understanding output from Explain
  60. Indirect access to data, given table name as a string
  61. ERROR: Failed to build any 5-way joins
  62. permissions
  63. PostgreSQL configuration
  64. Regular Expression Data Type
  65. Re: [HACKERS] functions to obtain query plan
  66. Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?
  67. Modify existing index
  68. can't start tsearch2 in 8.2.4
  69. Passing arrays to stored procedures
  70. unique constraint on 2 columns
  71. tsearch2 dictionary that indexes substrings?
  72. error:varchar too long - how to get details?
  73. large table problem
  74. Upgrading a 32-bit build to a 64-bit build
  75. Re: binding 64-bit integer
  76. returning setof varchar
  77. Schema relationship diagram
  78. nedd help bytea encode
  79. Re: Need help with db script, and daily routines
  80. tsearch2 dictionary that indexes substrings?
  81. Technical Documentation and Community Login
  82. cant get pg_dump/pg_restore to behave
  83. binding 64-bit integer
  84. Bug o not bug in subqueries
  85. dollar-quoting trouble
  86. Incrementally Updated Backups: Docs Clarification
  87. Is it possible to move a database to another tablespace?
  88. Building PG 8.2.3 for x86_64 on Mac OS X 10.4.9
  89. tsearch2 benchmarks, Oleg gets prize
  90. Can Postgresql be ported to a device with no OS and simple file I/O and memory management?
  91. Auditing a database
  92. Need help with db script, and daily routines
  93. Auditing a database
  94. Postgres data/form entry tool
  95. WAL
  96. selective export for subsequent import (COPY)
  97. Login to Postgres 8.2 via Cygwin hangs
  98. How to get a place not only for secrits but also for communication.
  99. Download source
  100. Postgres and geographically diverse replication
  101. Disadvantages on having too many page slots?
  102. Re: [ADMIN] Increasing the shared memory
  103. making a pg store of 'multiple checkboxes' efficient
  104. Re: Status of Postgres 8.2.4 and pg_standby
  105. Status of Postgres 8.2.4 and pg_standby
  106. bug in schema export?
  107. rename constraints ?
  108. Incremental backups
  109. unique ID across all columns
  110. Re: pg_restore "out of memory" - big problem :(
  111. seeking PITR archive_command advice
  112. query optimizer
  113. pg_standby + test_warm_standby: A Community Report
  114. string fields helps
  115. Advanced query rewrite
  116. delete with self join
  117. Dynamic DDL
  118. concatenating setof functions
  119. Procurando Freelancer PostgreSQL -- Rio de Janeiro
  120. PITR - "Rewind to snapshot" scheme
  121. Dump & restore required for x86 -> EM64T?
  122. Q re installing Pg on OS X?
  123. autovacuum vacuums entire database...is this right?
  124. issue when export/import table including pictures
  125. one more performance question I cannot test yet :(
  126. Display Cursor Content - Help!
  127. display cursor contents
  128. Help setting up warm standby replication
  129. phppgadmin and dump
  130. pg_dump seg fault on sequences
  131. postgresql 8.1.4 to 8.2.3
  132. recommendations for reducing mem usage on local dev machine
  133. Trigger on transaction?
  134. indexing array columns
  135. Re: question
  136. Temporary table in pl/pgsql
  137. meaning of Total runtime
  138. Update a Value From TEdit
  139. Re: Update a Value From TEdit
  140. OT: schema-sketching software
  141. Cursor Contents display in pgAdmin - Help.
  142. error creating/setting sequence, pg_dump / pg_restore 8.1.5
  143. median query causes disk to fill up
  144. Regard to PANIC: unexpected hash relation size
  145. Import data from 8.2.3 into 8.0.8
  146. ERROR: XLogFlush: request
  147. Arrays with Rails?
  148. DTrace and PostgreSQL
  149. Re: pg_standby
  150. corr() in 8.1
  151. Start postgresql failed
  152. deadlock
  153. local selectivity estimation - computing frequency of predicates
  154. pg_dump when database contains multiple tablespaces
  155. Performance of using tablespaces to seperate indexes and tables todifferent disks
  156. Re: Bugs not appearing in list archives
  157. Autovac _scale_ settings not changed by SIGHUP?
  158. digest data types?
  159. Re: role passwords and md5()
  160. Oracle mailing lists
  161. Re : Dumping part (not all) of the data in a database...methods?
  162. Providing user based previleges to Postgres DB
  163. INSERT..RETURNING on a partitioned table
  164. INSERT..RETURNING on a partitioned table
  165. seeking: advice on reordering table
  166. digest data types?
  167. hashtext () and collisions
  168. Unable to get a database connection while deleting rows
  169. table partitioning and plpgsql functions in 8.2.3
  170. hashtext & collisions
  171. hashtext () and collisions
  172. hashtext () and collisions
  173. INSERT..RETURNING on partitioned table
  174. is there a way to determine the attributes of anyelement
  175. pg_standby: Unremovable Trigger File
  176. SQL - finding next date
  177. Dumping part (not all) of the data in a database...methods?
  178. indexes, and tables within tables
  179. Transactions through JDBC
  180. Select taking excessively long; Request help streamlining.
  181. What about SkyTools?
  182. Evaluate only one CASE WHEN in a select
  183. Acces via applets
  184. COPY FROM file with zero-delimited fields
  185. The rule question before, request official documentation on the problem
  186. Is this a bug? Sequences and rules
  187. ORDER BY with UNION
  188. storing checksums in a database
  189. Do I need serializable for this query?
  190. Tomcat question/problem
  191. passing arrays to shared object functions
  192. Versioning
  193. Do I need serializable for this query?
  194. EXECUTE in a funtion to return a VIEW object ID
  195. Kill session in PostgreSQL
  196. Debian upgrade and PGSQL pid file
  197. Bad plan using join on VALUES
  198. Errors during recovery of a postgres. Need some help understanding them...
  199. programmatic way to fetch latest release for a given major.minor version
  200. Re: Postgres Crash Running PLPGSQL Function on 8.2.3
  201. Index "misbehavior" in PostgreSQL 8.2.2?
  202. Problem with copying data
  203. Problem with copying data
  204. backend reset of database
  205. NEWBIE: How do I get the oldest date contained in 3 tables
  206. Tom Kiel/UGW/DE ist =?iso-8859-1?Q?au=DFer_Haus=2E?=
  207. Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News -April 08 2007 ==
  208. plperl "set-valued function" problem
  209. Can you combine text variable together to referenece a VIEW name ?
  210. Re: table partitioning and plpgsql functions in 8.2.3
  211. join by char(16) or by bytea?
  212. How to disable duplicate columns
  213. Documenting PGSQL database.
  214. Security: Please verify your PayPal Account!
  215. PlPg/SQL mulit-array as a parameter?
  216. New to concurrency
  217. perl DBI: problems searching text strings with ' symbol (es d'ambrose)
  218. performance; disk bad or something?
  219. reindexing keys in postgres
  220. Re: reindexing keys in postgres
  221. No of triggers of one single table
  222. YTA Time Zone Question
  223. One database serveral schemas and group roles
  224. 8.2.3 AutoVacuum not running
  225. SQL WHERE: many sql or large IN()
  226. Database replication.
  227. problem selecting from function
  228. Re: Migrate postgres DB to oracle
  229. Migrate postgres DB to oracle
  230. turn off cache option
  231. Seg fault in pg_dump?
  232. Print database name
  233. inet_client_addr() implementation
  234. Cron'd dumpall failing?
  235. Trigger on CREATE ROLE
  236. Migrating data from mssql to postgresql
  237. All objects of a Particular USER
  238. Adding multiple column in alter statement?
  239. Granting permissions
  240. Re: Storing blobs in PG DB
  241. Problem with oids for table names getting out of sync?
  242. PG 8.2.3, FSM warning & VACUUM
  243. How to suppress NOTICE messages
  244. dropping role w/dependent objects
  245. Re: Postgres 7.4: how to disconnect users without restarting postmaster
  246. Need your help on using "partion"
  247. Postgres 7.4: how to disconnect users without restarting postmaster
  248. Problem with a transaction on dump
  249. OS X Kernel settings
  250. newid() in postgres