PDA

View Full Version : Pgsql General

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