PDA

View Full Version : Pgsql General

  1. FInding "corrupt" values in UTF-8 tables (regexp question, I think)
  2. Where are the Server error logs
  3. Accessing pg_timezone_names system view
  4. SELECT question
  5. tsearch2 query question
  6. Repeat posts
  7. Enterprise Wide Deployment
  8. Help creating a function
  9. Emigrar SqlServer a Posgres
  10. 8.3 performance
  11. Help with this query (some join stuff I think)
  12. Finding my database
  13. Some frustrations with admin tasks on PGSQL database
  14. Transaction auto-abort causes grief with Spring Framework
  15. Help creating a function
  16. Non-superuser creating a flat file
  17. Windows XP installation problem
  18. Problem Designing Index
  19. serial grows on failed requests
  20. Postmaster does not shut down
  21. CREATE RULE.. RETURNING?
  22. Vacuum problem
  23. Re: [BUGS] some information
  24. [RESEND] Transaction auto-abort causes grief with Spring Framework
  25. Strange inconsistency with UPDATE
  26. How to use Integer array in where IN clause parameter
  27. automatic rollback?
  28. Re: Running a stored procedure via pgagent, need an example
  29. I get a error msg when i try to connect to the DB
  30. Function with Integer array parameter
  31. Re: [SQL] Embedded C++ with ecpg?
  32. Accessing tables in other databases, through functions
  33. Performance question
  34. how to get id of currently executed query?
  35. array for cstring type
  36. INSERT before UPDATE?
  37. UTF-8 encoding problem
  38. PostgreSQL clustering (shared disk)
  39. Fastest way to import only ONE column into a table? (COPY doesn't work)
  40. =?EUC-KR?B?cGxlYXNlISBTUElfZmluaXNoIGlzIHN0cmFuZ2Ug?=
  41. Re: pg_dump on local Windows, pg_restore on Linux?
  42. SELECT ... FOR UPDATE performance costs? alternatives?
  43. User-Friendly TimeZone List
  44. pg_dump on local Windows, pg_restore on Linux?
  45. Customizing psql console to show execution times
  46. Yet Another COUNT(*)...WHERE...question
  47. Writing most code in Stored Procedures
  48. How to trap exceptions inside PL/Perl functions?
  49. Best practice for: ERROR: invalid byte sequence for encoding "UTF8"
  50. is this trigger safe and efective? - locking (caching via triiggers)
  51. check if database is correctly created
  52. memory optimization
  53. Custom functions for default values for columns on insert
  54. Transactional DDL
  55. language interface in postgresql
  56. Blobs in Postgresql
  57. query help
  58. Re: Select time jump after adding filter; please help mefigure out what I'm doing wrong.
  59. Compound Indexes
  60. Creating a row during a select
  61. MVCC cons
  62. Select time jump after adding filter; please help me figure out what I'm doing wrong.
  63. Using PITR Backup and Recovery
  64. Moving to postgresql and some ignorant questions
  65. Downloading PostgreSQL source code version 7.1 through CVS
  66. Insert or Replace or \copy (bulkload)
  67. PgAdmin .sql default handler
  68. Enterprise Wide Deployment
  69. Copy command and duplicate items (Support Replace?)
  70. Postgresql INSERT speed (how to improve performance)?
  71. How can I avoid PGPool as a single point of failure?
  72. Index not being used
  73. is there a psql equivilent of fsck?
  74. Running a stored procedure via pgagent, need an example
  75. can i use an array as a table (in the from clause)
  76. non superuser creating flat files
  77. Selecting rows where timestamp between two timestamps
  78. Problem Designing Index
  79. "Out of memory" errors..
  80. UDFs
  81. Persistent connections in PHP
  82. TimestampTZ
  83. copy command - date
  84. Performance check of my database
  85. Automation Using Databases.
  86. winxp failed installation problem
  87. pg_dumpall to psql -f NOT working
  88. why it doesn't work? referential integrity
  89. Trigger Procedure Error: NEW used in query that is not in a rule
  90. LIKE conditions in PGSQL very, very slow!
  91. SQL question: checking all required items
  92. PITR for postgresql-7.3
  93. Deadlocks caused by a foreign key constraint
  94. Re: UPDATES hang every 5 minutes
  95. CREATE RULE on VIEW with INSERT after UPDATE does not work
  96. Configuration starting point...
  97. Cluster and MVCC
  98. Re: UPDATES hang every 5 minutes
  99. [PROPOSAL] DML value format
  100. Database Select Slow
  101. Re: Allowing LAN connections
  102. Multiple operations on single rule, revisited
  103. Re: UPDATES hang every 5 minutes
  104. Re: [PERFORM] Dell Hardware Recommendations
  105. How I can know a back up database is up to date
  106. Connecting from one computer to another over lan
  107. Unable to connect to PostgreSQL server via PHP
  108. UPDATES hang every 5 minutes
  109. Installing Postgresql 8.2 on Windows Vista
  110. clustering failover... ala Oracle Parallel server
  111. Are these two creation commands functionally identical?
  112. Re: failed to unlink, Permission denied
  113. Confusing performance of specific query
  114. Bytea question with \208
  115. Re: failed to unlink, Permission denied
  116. timestamp skew during 7.4 -> 8.2 upgrade
  117. Time for Vacuum vs. Vacuum Full
  118. Interesting abilities of substring
  119. Multiple operations when updating a view - works in Postgres, doesn't in the app
  120. failed to unlink, Permission denied
  121. [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall
  122. Sylph Searcher
  123. Allowing LAN connections
  124. Crosstab Question
  125. Solved: Getting the field names for a given table
  126. Trigger not working as expected, first row gets a null value
  127. Running a query from the OS CLI
  128. Re: PostgreSQL and cluster
  129. Automation using postgres
  130. Interpreting statistics collector output
  131. Modified FIFO queue and insert rule
  132. Data Mart with Postgres
  133. PostgreSQL and cluster
  134. Installation problem
  135. Comment for column in view - "legal" or just working?
  136. track row / field usage
  137. Internal Postgre SQL documentation
  138. Reordering columns, will this ever be simple?
  139. Unsubscribe
  140. clustering failover... ala Oracle Parallel server
  141. List tables in load order
  142. Using function like where clause
  143. create table liek view
  144. Having trouble building 64-bit pgsql 7.4.17 on HPUX ia64
  145. tsearch2: plainto_tsquery() with OR?
  146. how to detect the backup database every day
  147. Removing a schema
  148. Intelligent Database in postgreSQL
  149. finding reusable ids
  150. finding out vacuum completion %, and vacuum VS vacuum full
  151. dbi and indexes
  152. more select-for-update questions
  153. 8.1.2 select for update issue
  154. Backup & Restore
  155. new line in psotgres
  156. Procedural Code Profiling
  157. Template zero xid issue
  158. Re: Postgres service startup
  159. Re: [PERFORM] Planner making wrong decisions 8.2.4. Insane cost calculations.
  160. Asynchronous Query processing
  161. Postgres service startup
  162. import content of XLS file into PostgreSQL
  163. Checkpoint segments too small
  164. Dealing with tsvector in fuctions for data split
  165. Modeling bill/ship addresses
  166. indexing large "text" attributes ... ERROR: maximum size is 8191
  167. Re: HA, failover and load balancing / howto?
  168. Changing column types
  169. pg_dump of only the structure from a client such as ruby
  170. Modelling tags
  171. Tablespace
  172. truncate transaction log
  173. PGSQL internals
  174. WAL Queries
  175. Re: backend process terminates
  176. clustering failover... ala Oracle Parallel server
  177. clustering failover... ala Oracle Parallel server
  178. v8.2 ... command line interface on Windows
  179. List tables in reverse dependancy order
  180. pg_restore UTF8 problem
  181. Help to solve configure error
  182. timezone + DST handling
  183. date ranges
  184. could not [extend relation|write block N of temporary file|write to hash-join temporary file]
  185. Safe usage of tsearch2: to_tsquery('<user input>')
  186. Select question..... is there a way to do this?
  187. virtual database
  188. Table queue (locking)
  189. pg_shdepend big
  190. Latin1 to UTF-8 ?
  191. invalid page header
  192. Suse RPM's
  193. Re: pgpool2 vs sequoia
  194. PG for DataWarehouse type Queries
  195. PostgreSQL Documentation on PalmOS
  196. Re: == PostgreSQL Weekly News - July 29 2007 ==
  197. ORDER BY on multiple columns still requires multi-col index?
  198. reindexing pg_shdepend
  199. want to drop corrupt db
  200. tsearch2 upgrade problem and mediawiki
  201. SQL function and "UPDATE...RETURNING"
  202. GiST index implementation
  203. pgTray - win32 tray tool for monitoring PostgreSQL service
  204. Error installing postgresql-8.2.4 on windows 2003 server
  205. Restrict access
  206. Re: pgpool2 vs sequoia
  207. Survey on changing a Free/Open Source Software project
  208. parsed queries (cursors) cashing issues
  209. python api to backup/restore data
  210. PGCluster-II version 1.3 , implementation
  211. file-system snapshot under freebsd for backup
  212. What do people like to monitor (or in other words, what might be nice in pgsnmpd)?
  213. why is the LIMIT clause slowing down this SELECT?
  214. Move database from Solaris to Windows
  215. how do i get num of recs inserted/deleted/updated in plpgsql
  216. Re: Linux distro
  217. Triggers: Detecting if a column value is explicitly set in an UPDATE statement or not... ("IS NULL" not working?)
  218. How do I connect postgres table structures and view structures to an existing svn repository?
  219. Linux distro
  220. Possible to Attach/Detach Tablespaces?
  221. Problem With gunzip backup
  222. Re: Core reported from vaccum function.
  223. array_to_set functions
  224. client encoding mismatch
  225. Re: Polymorphic functions' weird behavior
  226. continue in plpgsql 7.4
  227. FOREIGN KEY migration of syntax, help needed
  228. Indexing Hostnames with tsearch2 and fti.c
  229. Need quick help with standalone mode
  230. PG Admin
  231. huge file in pg_xlog and base
  232. Re: tables not in list
  233. Error restarting postmaster
  234. Re: tables not in list
  235. psql 8.2 client vs pg 8.1 server problem
  236. Polymorphic functions' weird behavior
  237. Performance problem with large resultsets (byte array 2200)
  238. Re: alter table table add column
  239. Manual Vaccum very slow with Autovaccum enabled
  240. Re: [NOVICE] alter table table add column
  241. Good News Mr 142.179.22.210 flood pgsql.general
  242. Good News Mr 142.179.22.210 flood pgsql.general
  243. pg_dump
  244. Auto Starting +/or Shutdown on OS X
  245. Stored Proc Problem
  246. plperl syntax highlighting for vi
  247. tables not in list
  248. Optimising SELECT on a table with one million rows
  249. Re: [pgsql-advocacy] European users mailing list
  250. Possible new feature