PDA

View Full Version : Pgsql General

  1. bad function lets postgres crash
  2. Mugs 'n stuff
  3. how to covert a column?
  4. Insert speed
  5. Stored Procedure: COPY table FROM (where path is a text variable)
  6. How do I aggregate data from multiple rows into a delimited list?
  7. Best possible way of exporting data to a generic file format
  8. Design Tool
  9. Re: Stored Procedure: Copy table from; path = textvariable
  10. Stored Procedure: Copy table from; path = text variable
  11. Date for a week day of a month
  12. Trigger Priority
  13. Reasonable way to backup cluster Windows
  14. Check whether two strs have at least one shared character.
  15. how to: psql -U user --password password ?
  16. Re: how to: psql -U user --password password ?
  17. Re: how to: psql -U user --password password ?
  18. Re: how to: psql -U user --password password ?
  19. Re: [NOVICE] Recursive relationship - preventing cross-index entries.
  20. Delete Performance question
  21. General search problem - challenge
  22. Invalid page header
  23. Insert speed new post
  24. How-To: Aggregate data from multiple rows into a delimited list.
  25. tables are not listable by \dt
  26. HAVING clause working in postgres 8.0, but not in 8.2
  27. importing limited set of rows/tuples
  28. ERROR: unexpected hash relation size:
  29. Tables not created in proper schema
  30. assigning password from script
  31. recovery_target_time ignored or recovery always recovers to end of WAL
  32. 'Session local' variables
  33. shmctl EIDRM preventing startup
  34. Can't change working directory to C:/Documents and Settings in Windows
  35. [pgsql.general] Problem connecting PostgreSQL 8.2 to Rails 1.2
  36. Is this a bug?
  37. [pgsql-general] In memory tables/databases
  38. [ASK] create data ware house in postgre
  39. Re: postgressqlnot support inwindows 2000
  40. Bitmap index?
  41. Need Scheduling Support for Your Databases?
  42. Do Postgres exceptions rise up the stack?
  43. Trapping errors from pl/perl (trigger) functions
  44. Re: greatest/least semantics different between oracle and postgres
  45. Re: postgressqlnot support inwindows 2000
  46. stem & tsearch2, want different stemmed words
  47. Sun Cluster and PGSQL
  48. greatest/least semantics different between oracle and postgres
  49. How does one impolement lists, or arrays, pin pl/pgsql ?
  50. Execution variability
  51. Re: Why does postgres take time to shut down sometimes?
  52. Looking for help regarding getting the latest inserted sequence value.
  53. (NONE)
  54. Interval overflow?
  55. Re: pg_catalog.pg_get_serial_sequence() returns NULL
  56. CREATE FUNCTION ... performance boost?
  57. xpath_string namespace issue...
  58. Query optimization (select single record and join)
  59. db replication
  60. Create user
  61. [pgsql] Simple backup utility like mysqldump?
  62. what's wrong with this conf file?
  63. date time function
  64. SQL problem..
  65. i need a rad/ide open source for work with postgresql
  66. table disk space usage query?
  67. installing pljava on windows xp
  68. Strange duplicate key violation error
  69. OFFSET and LIMIT - performance
  70. Re: autovacumm not working ?
  71. Re: autovacumm not working ?
  72. Re: Possible bug (or I don't understand how foreign keys should work with partitions)
  73. using PREPAREd statements in CURSOR
  74. Pg7.4.x plpgsql trigger execution order bug
  75. Better way to handle functions doing inserts into dynamically named tables?
  76. Image Archiving with postgres
  77. Column Default Clause and User Defined Functions
  78. Re: autovacumm not working ?
  79. Re: autovacumm not working ?
  80. Execution variability
  81. Re: autovacumm not working ?
  82. Status of pgaccess
  83. Re: How do you handle shared memory corruption issues? (contrib/xml2)
  84. timestamp wiht time zone
  85. Re: How do you handle shared memory corruption issues? (contrib/xml2)
  86. Re: Checking for a number
  87. Checking for a number
  88. How do you handle shared memory corruption issues? (contrib/xml2)
  89. autovacumm not working ?
  90. COPY to/from non-local file
  91. Using ADO.NET entity framework with PostgreSQL
  92. [GENERAL] passing long array of integers to dblink remote call
  93. "Quota"
  94. postgres and webmin
  95. Auto Vaccume- Time based
  96. upgrade 8.1.4 -> latest, sort order subquery
  97. Ordering in SELECT statement
  98. growing disk usage problem: alternative solution?
  99. Re: problem importing data with psql
  100. View Triggers
  101. escaped rolenames in pg_has_role
  102. a JOIN on same table, but 'slided over'
  103. varchar(n) VS text
  104. data partitions across different nodes
  105. Throwing exceptions
  106. LC_CTYPE and matching accented chars
  107. Error or bug?
  108. problem importing data with psql
  109. postgresql varchar[] data type equivalent in Oracle
  110. dynamic table/col names in plpgsql
  111. pg_dump to include multiple tables
  112. Rule vs Trigger
  113. I want to apologize
  114. Standby servers and incrementally updated backups
  115. yet another simple SQL question
  116. was is the normal number of postgres.exe?
  117. Re: [SQL] another simple SQL question
  118. Automatic install on windows
  119. Re: acampada
  120. Re: another simple SQL question
  121. Move a database from one server to other
  122. simple SQL question
  123. alter table type from double precision to real
  124. low transaction ID wrap limit
  125. =?iso-2022-jp?B?GyRCJSolSiVLJTklSCQsOGwkayEqGyhC?=
  126. how to implement unusual constraint
  127. Duplicate Key Violates Unique Contraint when Updating a table
  128. dynamic table/col names in plpgsql
  129. Table Names
  130. minimum function
  131. Duplicate records returned
  132. MI5 Persecution: Stasi 21/4/96 (16303)
  133. MI5 Persecution: Leant On 7/4/96 (14789)
  134. MI5 Persecution: Shoot to Kill 4/4/96 (13275)
  135. MI5 Persecution: Email Cruelty 11/3/96 (11761)
  136. MI5 Persecution: Jeff Rooker MP 5/3/96 (10247)
  137. MI5 Persecution: Flight or fight 7/1/96 (8733)
  138. MI5 Persecution: A new Kafka? 3/10/95 (5705)
  139. MI5 Persecution: Do they fear truth? 3/10/95 (4191)
  140. MI5 Persecution: Grievous Bodily Harm 2/10/95 (2677)
  141. MI5 Persecution: Goldfish and Piranha 29/9/95 (1163)
  142. creating temporary table PostgreSql 8.1 and iBatis 2.3
  143. Possible bug (or I don't understand how foreign keys should work with partitions)
  144. permission denied for schema
  145. B-tree fan-out
  146. B-tree fan-out
  147. Establishing a primary key
  148. writing debug output in perl
  149. SPI using perl
  150. FUNCTION DEFINITION
  151. How determine a Views dependents
  152. Optimizer problem in 8.1.6
  153. Function call costs for SQL and PLPgSQL
  154. Re: How to install Postgresql on MS Vista?
  155. Proposed Feature
  156. Regular express question
  157. Can I backup/restore a database in a sql script?
  158. Re: ORDER BY with exception
  159. Re: ORDER BY with exception
  160. How to install Postgresql on MS Vista?
  161. Throwing exceptions
  162. finding items with 0 rels for a 0 to many relationship
  163. PostgreSQL question re select for update (locking??)
  164. Aggregates
  165. 8.2.3 PANIC with "corrupted item pointer"
  166. [PGSQL 8.2.x] INSERT+INSERT
  167. Accent insensitive search
  168. Recovery/Restore and Roll Forward Question.
  169. AutoVacuum Behaviour Question
  170. "Failed to create process: 2!" during installation in windows 2000
  171. Experiences of PostgreSQL on-disk bitmap index patch
  172. Running OS-level programs from Postgres?
  173. A problem in inheritance
  174. Surrogate VS natural keys
  175. copying indexes and f.keys from a template table
  176. Need help with generic query
  177. commit failed when calling postgresql procedure
  178. CHECK
  179. commit transaction failed
  180. Re: [NOVICE] Recursive relationship - preventing cross-index entries.
  181. PostgreSQL Installer for Windows x64
  182. regexp searching in arrays not working?
  183. Iterate over an array in stored procedure
  184. Excell
  185. Problem compiling on CentOS
  186. problems selecting from altered table
  187. Re: Subquery problems
  188. How to prevent modifications in a tree of rows, based on a condition?
  189. Re: Server and Client configuration.
  190. Regression - Query requires full scan, GIN doesn't support it
  191. fsync error when restoring from archived xlogs
  192. Dynamic Log tigger (plpgsql)
  193. Core reported from vaccum function.
  194. help with libpq program
  195. Setting variable
  196. Trigger function that works with both updates and deletes?
  197. statistics monitoring performance improvment -- 8.1 as well as 8.2 ?
  198. postgresql and solaris 10: pitch to sysadmins
  199. time without time zone
  200. unexpected shutdown
  201. pg_resetxlog command not found
  202. Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle
  203. Pg_standby and shutting down the warm standby
  204. Atomicity in DB transactions (Rollback related)
  205. Using the query INTERSECTion
  206. Loop through all views with PHP
  207. standard LOB support
  208. statistics on CRUD operations
  209. Re: Ubuntu, Postgresql-8.2 and remote access thrupg_hba.conf
  210. Ubuntu, Postgresql-8.2 and remote access thru pg_hba.conf
  211. Normal distribution et al.?
  212. VACUUM ANALYZE extremely slow
  213. initdb
  214. pgadmin3 1.6.3 problem with geom fields
  215. about cursors
  216. What O/S or hardware feature would be useful for databases?
  217. Which meta table contain the functions
  218. help with function
  219. Re: Dynamically generating DDL for postgresql object
  220. is it possible to recover more than one recordset or cursor from a function?
  221. Why does this work?
  222. Dynamically generating DDL for postgresql object
  223. Re: Postmaster processes taking all the CPU
  224. vacuum and postgresql.conf settings
  225. Re: Postmaster processes taking all the CPU
  226. pg_restore can't restore using list to select?
  227. Another conversion from ASA to PostGres how to
  228. persistent db connections in PHP
  229. "Constant" fields in a table
  230. Q: Tree traversal with SQL query?
  231. ANN: Linq provider for PostgreSQL
  232. pg_restore out of memory
  233. Hash Aggregate plan picked for very large table == out of memory
  234. UNION ALL with the same ORDER BY on the parts and the result
  235. Function with COPY command?
  236. COPY Command and a non superuser user?
  237. Historical Data Question
  238. explain analyze on a function
  239. allocate chunk of sequence
  240. Disable duplicate index creation
  241. DeadLocks...
  242. precision of epoch
  243. Re: [SQL] function to find difference between in days between two dates
  244. strange change (and error) in 8.3 ?
  245. Re: inner join problem with temporary tables
  246. Re: inner join problem with temporary tables
  247. recursive function
  248. changing the /tmp/ lock file?
  249. Re: psql : Error: Cannot stat /pgdata/8.2/main
  250. Regular expressions in procs