PDA

View Full Version : Pgsql General

  1. Sql problem
  2. Install fails on Debian sid
  3. PostgreSQL Storage: Sorted by Primary Key?
  4. Embedding code in Postgres source code
  5. ERROR: could not open file "pg_subtrans...
  6. Should I install PostgreSQL 8.2.5?
  7. This Watch is remarkable
  8. Very asynchrnous replication system
  9. valid query runs forever?
  10. Foreign Key for PHP serialized data - possible?
  11. "timer" script from SAMS book or equivalent?
  12. Re: [PERFORM] Slow TSearch2 performance for table with 1million documents.
  13. Re: Slow TSearch2 performance for table with 1 milliondocuments.
  14. Privileges on information_schema
  15. Q: migrating from serverA(gentoo) to serverB(centos) 8.2.4
  16. How to convert rows into HTML columns?
  17. Error while database creation
  18. Windows vista
  19. Large Result and Memory Limit
  20. time penalties on triggers?
  21. Problem with connectivity
  22. Re: good sql tutorial
  23. good sql tutorial
  24. ERROR: variable not found in subplan target lists
  25. multiple row insertion
  26. Postgres8: subselect and optimizer/planner
  27. About selected data dump
  28. Partitioned tables, rules, triggers
  29. Design Question (Time Series Data)
  30. Unexpected behavior with CASE statement
  31. Unexpected behavior with CASE statement
  32. Importing MySQL dump into PostgreSQL 8.2
  33. Backup single database roles and ACLs
  34. Generating TRUNCATE orders
  35. Easier string concat in PL funcs?
  36. SLOW Remote Connection to PostgreSQL Database
  37. Tsearch2 Dutch snowball stemmer in PG8.1
  38. This Watch is out-of-this-world
  39. pg_cancel_backend() does not work with buzz queries
  40. PITR Recovery and out-of-sync indexes
  41. pg_dump
  42. Can't access Cluster
  43. PITR and Compressed WALS
  44. Finding number of rows deleted in a stored procedure
  45. create visual query in web applications
  46. pgcrypto digest_exists replacement?
  47. Strange behavior of TRIGGER
  48. Feature Request - Defining default table space for Indexes in Conf file
  49. Find min year and min value
  50. Execution plan caching
  51. Strange discrepancy in query performance...
  52. Porting Schema from MySQL
  53. Re: PostgreSQL Conference Fall 2007, final schedule
  54. Re: PostgreSQL Conference Fall 2007, final schedule
  55. Select too many ids..
  56. Upgrading PG
  57. Find clusters containing a schema?
  58. Find out encoding of data
  59. Inheritance problem when restoring db
  60. Dump of table structure is not consistent
  61. sha1 function
  62. Query problem
  63. ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window
  64. Partitioned table limitation
  65. COPY for .CSV files problem
  66. =?ISO-8859-1?Q?using_COPY,_.CSV_and_=BFcatalog=3F?=
  67. Inheritance fixing timeline? (Was "Inherited FK Indexing")
  68. windows and pg 8.2 (change database to another server)
  69. It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username
  70. Vacuum/Analyze (suddenly) too slow
  71. 3 tables join update
  72. OK, when 8.3 is coming?
  73. Please change default characterset for database cluster
  74. Triggers & inheritance
  75. more problems with count(*) on large table
  76. row->ARRAY or row->table casting?
  77. problemas zona horaria
  78. Preventing selection of data during transaction
  79. How to avoid: 9.50184e+06
  80. =?iso-2022-jp?B?GyRCP006SiVRJWklQCUkJTkbKEI=?=
  81. Re: Debian problem...
  82. importing large files
  83. usage of indexes for inner joins
  84. question about pg_dump -a
  85. Getting the search_path value for a query listed in pg_stat_activityoutput (feature request?)
  86. Re: Find "smallest common year"
  87. access privileges: grant select on (all current and future tables)?
  88. TSearch - Bulgarian
  89. How unsubscrib this list ?
  90. Find "smallest common year"
  91. how to ignore invalid byte sequence for encoding without using sql_ascii?
  92. df output change (in psql) after 8.2 version
  93. pg_dump (8.1.9) does not output copy statements
  94. RETURN NEXT on result set
  95. Arabic Language
  96. creating schema in oracle with sas datasets
  97. datestyle question
  98. Memory usage of COPY command
  99. decode access privileges
  100. Data cube in PostgreSQL
  101. More on migragting the server.
  102. CLUSTER = slower vacuum?
  103. =?UTF-8?Q?UNIQUE=5FVIOLATION=2C=20Finding=20out=20which= 20index=20would?==?UTF-8?Q?=20have=20been=20violated?=
  104. Help tuning a large table off disk and into RAM
  105. Duplicate public schema and user tables
  106. Dumping from older version
  107. regds bulk of records
  108. Compare Content in Multidimensional Array [PHP/SQL]
  109. =?ISO-8859-2?Q?libpg.dll problem while changing from version 8.2.4no-installer to 8.2.5 n=
  110. Filesystem crash - corupted database
  111. pgpoolAdmin:No such file or directory in /var/www/html/pgpoolAdmin-1.0.0/libs/Smarty.class.php on line 1258
  112. 8.3devel, csvlog, missing info?
  113. This Watch is outrageous
  114. Autostart PostgreSQL in Ubuntu
  115. NZDT Question
  116. DAGs and recursive queries
  117. subquery/alias question
  118. pg_restore - invalid file problem
  119. cascade and restrict options to alter domain drop constraint
  120. A few basic troubleshooting questions
  121. rules and command status question
  122. Fw: PgpoolAdmin installation
  123. Re: Version 8.2.4 ecpg - function not found
  124. lowering impact of checkpoints
  125. Hey Frankie
  126. PgpoolAdmin installation
  127. =?UTF-8?Q?UNIQUE=5FVIOLATION=20exception=2C=20finding=20 out=20which=20ind?==?UTF-8?Q?ex=20would=20have=20been=20violated?=
  128. [Urgent] Regexp_replace question
  129. Poor performance with ON DELETE CASCADE
  130. table column reordering
  131. AUXILIO!!!! CONSULTA SOBRE CURSORES HELP!!! ABOUT CURSORS
  132. trying to migrate to a new server.
  133. Re: Is this good spec for a PostgreSQL server?
  134. set returning functions.
  135. Restricting user access to an absolute minimum?
  136. pg_dumping large objects
  137. delta copies of pg_dump files
  138. DELETE FROM pg_class
  139. pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
  140. ERROR: must be superuser to alter superusers
  141. Get ur Jobs by sms
  142. Send greetings to any mobile in India
  143. Convert ur Mobile to earn money
  144. Get paid for reading ads on Mobile in India
  145. Transaction Steps!!
  146. Extra messages on my console.
  147. Best practice for specifying an interval
  148. Dynamic Sorting in Functions
  149. Dynamic Sorting in Functions
  150. how to get the total statistics info and query time for many queries
  151. Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
  152. SRF called with optional NULL input runs 7x slower
  153. configuration question
  154. zero value in statistics collector's result
  155. Unique is non unique; no nulls
  156. Can't connect (2 dbs) or login (2 others)
  157. Postgres Tamil Team
  158. Re: Unable to start PostgresSQL Server
  159. Re: Uninstall mess Postgresql 7.3.4, 8.1.4 on Redhat 9
  160. Re: Restore 8.1.4 backup in 8.2.5
  161. Unable to start PostgresSQL Server
  162. SPI shared memory ?
  163. Return t/f on existence of a join
  164. Migrating from 32 bit to 64 bit binaries
  165. 5 minutes to pg_dump nothing
  166. Re: Windows Auto-Vacuum in 8.2.4 or 8.2.5
  167. Re: Windows Auto-Vacuum in 8.2.4 or 8.2.5
  168. foreign key on views
  169. "not in" clause too slow?
  170. queston about locking
  171. How to display geometry data using java and PostGIS
  172. about the PostgreSql loading?
  173. Using RETURNING with INTO inside pgsql
  174. Adding domain type with CHECK constraints slow on large table
  175. PG levels vs. syslog levels
  176. Manually clearing "database "foo" is being accessed by other users"
  177. Re: Building Windows fat clients
  178. Migration from PervasiveSQL
  179. Query planner unaware of possibly best plan
  180. autovacuum
  181. Re: Building Windows fat clients
  182. Re: Tsearch2 - spanish
  183. Re: Is this good spec for a PostgreSQL server?
  184. any with the output of coalesce
  185. Stuck on Foreign Keys
  186. Postgresql and SSL
  187. Planning a Postgresql based Database
  188. Re: Building Windows fat clients
  189. about pgpool question
  190. Restore 8.1.4 backup in 8.2.5
  191. Re: Building Windows fat clients
  192. Configuration starting point...
  193. Plpgsql function to join array elements with a string
  194. PG_DUMP not working
  195. ON INSERT => execute AWK/SH/EXE?
  196. help w/ SRF function
  197. Alter sequence restart with selected value...
  198. Inline Function documentation
  199. New PostgreSQL RPM sets are available for Fedora / RHEL
  200. statements of an unfinished transaction
  201. This Watch is super
  202. FW: August Monthly techdata split file p
  203. Recall: August Monthly techdata split fi
  204. stability issues
  205. RFC : best way to distrubute IO from queries (low end server)
  206. pgcrypto: is an IV needed with pgp_sym_encrypt()?
  207. keeping 3 tables in sync w/ each other
  208. CPU spike when doing PARSE (what is this?)
  209. For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
  210. Q:Aggregrating Weekly Production Data. How do you do it?
  211. Tsearch2 - spanish
  212. Re: processing urls with tsearch2
  213. postgres catalog files problem
  214. Re: Time Zone design issues
  215. update command question?
  216. Re: help w/ SRF function
  217. New/Custom DataType - Altering definition / seeing definition inpgAdmin3
  218. Re: Database reverse engineering
  219. Re: pg_standby observation
  220. Re: pg_standby observation
  221. Re: PostgreSQL Glossary?
  222. Re: Database reverse engineering
  223. Re: PostgreSQL Glossary?
  224. Function to determine next payment date
  225. Re: use COPY TO on normalized database
  226. read-only queries on PITRslaves, any progress?
  227. text_pattern_ops index *not* used in field = value condition?
  228. "like" vs "substring" again
  229. Re: Locking entire database
  230. strange TIME behaviour
  231. Re: Locking entire database
  232. getting min/max of two values
  233. %tsearch2-affix parse error dictionary spanish
  234. Re: Pgsql roles, SQL injection, and utility statements
  235. New ETL tool !
  236. Re: plpgsql trigger original query
  237. Inserting a timestamp in a "timestamp" column.
  238. Re: constrains on two tables
  239. GRANT on group does not give access to group members
  240. database still hanging
  241. tsearch2 and parsing host strings
  242. Re: GRANT on group does not give access to group members
  243. NOT NULL Issue
  244. su: adduser: command not found mac osx
  245. Re: importing pgsql schema into visio (for diagramming)
  246. Re: Tablespaces on tertiary media
  247. Alias "all fields"?
  248. Alias "all fields"?
  249. Rankinf of Results?
  250. Need suggestion on how best to update 3 million rows