PDA

View Full Version : Pgsql General

  1. index being ignored for "limit n" queries
  2. Solicitud de informacion de psql con php
  3. Reference new.* or old.* in dynamic statement?
  4. best way to reference tables
  5. Database syncronization
  6. Cross database queries
  7. PostgreSQL and ClearQuest?
  8. pg_dump for table with bytea takes a long time
  9. Query stucked in pg_stat_activity
  10. Referencing "less-unique" foreign keys
  11. Re: The cost of SET search_path TO
  12. The cost of SET search_path TO
  13. Adjacency List & total item counts
  14. plpythonu and return void
  15. Testing of MVCC
  16. escape string type for upcoming 8.1
  17. Updating timestamps
  18. PL/pgSQL in 8.0
  19. Re: Getting actual number of rows updated
  20. Getting actual number of rows updated
  21. Re: linking access using ODBC driver with geometric data
  22. tsearch2: very slow queries
  23. Re: Remopte connection to POstgreSQL via ODBC
  24. postgresql Secure Mode
  25. Re: Querry and SMP mechine
  26. Querry and SMP mechine
  27. Poll on your LAPP Preferences
  28. ACM Sigmod interview with Bruce Lindsay
  29. $B@hF|%a!<%k$7$?7o$G$9(B
  30. Re: tables in public
  31. Re: tables in public
  32. tables in public
  33. Case sensitivity
  34. timestamp default values
  35. changing default lockfile location
  36. Clog/Transaction problems
  37. slow update query
  38. How to join function with a table?
  39. Re: What causes lock??
  40. Optimizing large data loads
  41. Does preparing statements other than selects help performance?
  42. Weird lock or bug maybe?
  43. Inheritance vs. LIKE - need advice
  44. Why pgsql function is working on vers 8.0/windows and not on ver 7.3.2/rad hat?
  45. Re: New MySQL to PostgreSQL Migration Guide
  46. Going beyond sql
  47. How to explode an array into multiple rows
  48. wanting to use postgres with python - WHAT am I doing wrong??????AGGGHHHH
  49. FATAL: cache lookup failed for access method 6881280
  50. How to write jobs in postgresql
  51. Postgresql Hosting
  52. What causes lock?
  53. Re: DNS vs /etc/hosts
  54. psqsl -> remote db
  55. connection string - DNS
  56. Default size limit for 'character varying' in Postgres 8?
  57. DNS vs /etc/hosts
  58. Trigger Variables
  59. pgsql-odbc list problem
  60. Restore PLAIN file
  61. dbf to pgsql
  62. Tsearch2 doesn't work
  63. What happens when wal fails?
  64. Re: SELECT count(*) Generating Lots of Write Activity
  65. untrusted languages and non-global superusers?
  66. Internal catalogs error in log file
  67. Re: Instalation batch file
  68. initskript after db start; locks on transactions
  69. Instalation batch file
  70. Re: oids and pg_class_oid_index constraint
  71. Re: Windows file path for copy
  72. oids and pg_class_oid_index constraint violations
  73. pg_dump - dump specific functions and other items?
  74. ssl problem with postgres 8.0
  75. postgresql.conf value need advice
  76. Cost problem
  77. Note on scalar subquery syntax
  78. Hello
  79. views to behave differently according to user and schema
  80. Re: Need some help creating a database sandbox...
  81. Re: Windows file path for copy
  82. Re: Insert ImageFile in PostgreSQL
  83. Need some help creating a database sandbox...
  84. Windows file path for copy
  85. Re: indexes are farked
  86. Re: Failure to use indexes (fwd)
  87. user's groups
  88. Questions about anonymous procedure/function.
  89. Re: [BUGS] BUG #1552 followup
  90. indexes are fucked
  91. Re: Unable to Update a Record
  92. Problems to install pg 8.0.3
  93. Re: unicode error on win32 Was: Re: pgmonitor
  94. CLUSTER equivalent
  95. System catalog diagram
  96. Indexes
  97. Re: unicode error on win32 Was: Re: pgmonitor
  98. Re: pgmonitor
  99. Insert ImageFile in PostgreSQL
  100. Inheritance vs. LIKE - need advice
  101. tsearch2 and colons or urls
  102. SELECT count(*) Generating Lots of Write Activity
  103. could not bind IPv6 socket
  104. Check postgres compile-time options
  105. pgmonitor
  106. Problem with dropping a tablespace
  107. Re: Unable to Update a Record
  108. PostgreSQL vs. MySQL
  109. Re: Unable to Update a Record
  110. Alter privileges for all tables
  111. Strange delete behaviour
  112. Disconnect sessions and session timeouts
  113. 10$B;~4V8e2r=|$H$J$j$^$9!#(B
  114. Questions about Views, Rules and DBLink
  115. postmaster
  116. renaming a table, and its primary key constraint
  117. Tool for database design documentation?
  118. Postgres array types
  119. Design question
  120. Re: Unable to Update a Record
  121. Unable to Update a Record
  122. Re: fix pg_autovacuum
  123. Looking for version 7.4.7 for windows
  124. how to select
  125. Failure to use indexes
  126. tool for analysing the postgres log-file
  127. templates, encoding
  128. Fwd: PostgreSQL 7.1.3 installation problem on FC3
  129. Is there something like Mssql GUID in PostgreSql database
  130. vacuum freeze
  131. ecpg and C++
  132. Re: Megabytes of stats saved after every connection
  133. Re: Megabytes of stats saved after every connection
  134. Korry Douglas's PostgreSQL 2ed out yet?
  135. Can't connect to posgresql server by using pgadmin
  136. UNSUBSCRIBE
  137. Re: Perl DBI and postgres
  138. How to optimize select count(*)..group by?
  139. Pg_autovaccum.
  140. Megabytes of stats saved after every connection
  141. Raise Notice question
  142. Perl DBI and postgres
  143. Trigger ad mutli database
  144. Real vs Float & 32bit vs 64bit CPU Performance Question
  145. problem inserting with sequence
  146. Re: Welcome to the pgsql-general list!
  147. Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type
  148. Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type
  149. pg_get_serial_sequence and inheritance
  150. PostgreSQL DBA
  151. Re: GUID for postgreSQL
  152. Re: GUID for postgreSQL
  153. Re: GUID for postgreSQL
  154. link errors building extensions for Postgres on Windows usingMinGW
  155. DELETE with JOIN syntax
  156. pgsql mention on zdnet
  157. Upgrading from 7.1
  158. Re: error when using SELECT
  159. About Tools at the DB design phase.
  160. Backup and restore from 7.4.1 to latest, crossing platforms... issues?
  161. postgres 7.2.4 - errors after vacuuming/reindexing in single user mode
  162. Daily digest?
  163. duplicate messages?
  164. Re: dropping non-existent tables
  165. Re: dropping non-existent tables
  166. Re: back-end triggers front-end to update
  167. Re: Trigger disactivation and SELECT WAITING
  168. GUID for postgreSQL
  169. Postgresql with max_connections=4096
  170. Rules vs Triggers
  171. Re: back-end triggers front-end to update
  172. Re: back-end triggers front-end to update
  173. Cursor Issue??
  174. Re: [Bizgres-general] Hardware suggestions for a new data
  175. Problem with text_pattern_ops
  176. Select Stament Issue??
  177. (NONE)
  178. Re: transaction timeout
  179. Re: transaction timeout
  180. Re: transaction timeout
  181. error when using SELECT
  182. Budget battery-backed ramdisk (Gigabyte i-RAM)
  183. dropping non-existent tables
  184. Please help: Running Win2k with CP1252 codepage
  185. Re: [Bizgres-general] Hardware suggestions for a new data
  186. transaction timeout
  187. Re: Trigger disactivation and SELECT WAITING
  188. Re:
  189. Bad plan when null is in an "in" list
  190. Access FE - This operation is not supported within transaction
  191. Hardware suggestions for a new data warehouse Postgresql/Bizgres server? (£6000)
  192. Error when entering template1
  193. Trigger disactivation and SELECT WAITING
  194. constraint problem
  195. speeding up a query on a large table
  196. pgsql client/server compatibility matrix?
  197. db slowness + upgrade prospects
  198. mass grant on sequences script
  199. Re: Connection error
  200. transaction timeout
  201. PGSQL programmer needed!!!
  202. Creating a record in a database encoded 'WIN1250'/'WIN'
  203. PostgreSQL, Lazarus and zeos ?
  204. Need help with data validation..
  205. Re: PostgreSQL + windows xp + ipv6
  206. Re: Can't connect after restart
  207. get sequence from remote server
  208. Could not convert UTF-8 character to ISO8859-1?
  209. \dt gives ERROR: did not find '}' at end of input node
  210. Tsearch2 and frequent updates
  211. Privileges needed by pg_autovacuum?
  212. tsearch2 frequent updates
  213. unsubscribe
  214. setting up
  215. Solaris 10 SMF for Postgres?
  216. Re: DST and potential changes thereto
  217. testing castability of VARCHAR data to INET/CIDR
  218. Re: [pgsql-es-ayuda] transportar base de datos
  219. DST and potential changes thereto
  220. Re: Problems compiling Postgresql 8.0.3 on 10.4
  221. query don't optimize
  222. PostgreSQL + windows xp + ipv6
  223. When is Like different to =
  224. Copying bytea data out via pgsql
  225. problem casting varchar to inet
  226. Re: Insert into ... Select ... From ... too intelligent transaction
  227. Re: Connection error
  228. Bad locking with MS-Access
  229. Re: Insert into ... Select ... From ... too intelligent transaction
  230. Dumb question about count()
  231. Connection error
  232. unsubscribe
  233. ROW SHARE vs. ACCESS EXCLUSIVE; UPDATE vs. SELECT ... FOR UPDATE
  234. Strange input/cast semantics for inet
  235. dynamic loading of c-functions
  236. Insert into ... Select ... From ... too intelligent transaction
  237. Query planner refuses to use index
  238. ANN: Access2PostrgreSQL Pro v1.0.0 release
  239. function execution problem - plpgsql
  240. Postgres terminates on first connecton
  241. Re: Cannot start DB system
  242. Cannot start DB system
  243. No user being created in os X
  244. IN subquery not using a hash
  245. help: production db stuck in startup mode
  246. Trigger problem
  247. Slow Inserts on 1 table?
  248. on delete rules on a view problem
  249. Custom DateStyle
  250. Vacuumdb question