PDA

View Full Version : Pgsql General

  1. PostgreSQL Beta4 released
  2. Can i Force to postgrsql to use a certain index?
  3. Create function errors
  4. Re: Vacuum output redirect
  5. Vacuum output redirect
  6. Older version of PGSQL help
  7. Transaction isolation and constraints
  8. postgres freezes up on a query from slony
  9. Re: WAL shipping question
  10. bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<
  11. Can i Force to postgrsql to use a certain index?
  12. Re: WAL shipping question
  13. Tuning configuration
  14. Avoid huge perfomance loss on string concatenation
  15. Recovering data via raw table and field separators
  16. difficulty extracting variable-sized field on triggered row
  17. WAL shipping question
  18. CPU
  19. 8.3beta4 needs a dump/restore?
  20. "Suspending" indexes and constraint updates
  21. libpq messages language
  22. limits
  23. 8.3 release notes
  24. Moving pgstat.stat and pgstat.tmp
  25. Disconnects hanging server
  26. Re-partitioning huge schema
  27. postmaster logfile
  28. rpm's for 8.3 beta 4
  29. Transaction problem
  30. stored procedures and dynamic queries
  31. initdb - encoding question
  32. Including pg_dump in .NET Application
  33. uninstall postgres 8.2
  34. Insert/Update to multiple tables with relations
  35. 8.3, a few questions
  36. PostgreSQL on the internet
  37. Deadlock when updating table partitions (and presumed solution)
  38. slow UPDATE speed
  39. Re: Dump/Restore Large Object OID
  40. Re: pgcrypto functions fail for asymmetric encryption/decryption
  41. Archiving problem on Windows
  42. postgresql in ramdisk
  43. Dewins has Tagged you! :)
  44. One or more tables?
  45. Stored procedure issue
  46. "relation deleted while in use" encountered with Postgresql 8.0.8
  47. libeay32.dll and libpq.dll
  48. power failure....
  49. full_page_writes = off?
  50. Postgres shutting down by itself...why?
  51. Fault Tolerance & Master-master-Replication Solution needed
  52. HA and Replication - how to choose among all the available solutions
  53. PL/pgSQL and SETOF
  54. scrollable cursor in functions
  55. postgresql table inheritance
  56. FK index q'n
  57. Re: Linux v.s. Mac OS-X Performance
  58. Moving lock file (/tmp/.s.PGSQL.<port>)
  59. psql lo_export documentation
  60. Re: Linux v.s. Mac OS-X Performance
  61. Record variable not behaving as expected (bug?)
  62. Recommendations for a datasync scenario ?
  63. Simple math statement - problem
  64. Postgres High Availablity Solution needed for hot-standby and load balancing
  65. PostgresSQL vs Ingress
  66. Linux v.s. Mac OS-X Performance (now Solaris)
  67. Threads limit for postmaster
  68. Postgres WarmStandby using ZFS or Snapshot to create Web DB?
  69. certificate based authorization
  70. pgcrypto functions fail for asymmetric encryption/decryption
  71. ERROR: failed to find conversion function from unknown to integer[]
  72. free ETL using Postgresql 8.2.x
  73. Re: hibernate + postgresql ?
  74. problems with email...
  75. Help needed optimizing query
  76. Porting from FrontBase
  77. Dump/Restore Large Object OID
  78. Problems Dumping DB
  79. Discrpency in the GRANT docs
  80. Will PG use composite index to enforce foreign keys?
  81. Re: HD is flooded by Error Log info
  82. HD is flooded by Error Log info
  83. notify/listen disappearing data
  84. Making a query from 2 tables at same time
  85. log_line_prefix='%t %u %d %h %p %i %l %x ' causes error
  86. 1 cluster on several servers
  87. test message
  88. Killing a session on windows
  89. Declaring multidimensional arrays in pl/pgsql
  90. viewing definition of "CREATE TYPE name AS ENUM..."
  91. hibernate + postgresql ?
  92. 60 Seconds to connected to Postgresql using ODBC or PGAdmin
  93. Re: 60 Seconds to connected to Postgresql using ODBC or PGAdmin
  94. Why upgrade?
  95. Create index syntax error
  96. Cluster using tablespaces?
  97. Recheck condition
  98. Re: [HACKERS] plperl and regexps with accented characters- incompatible?
  99. Cascading Trigger Prevention
  100. Re: Recheck condition
  101. How to automate password requests?
  102. Select all fields except one
  103. Press contacts
  104. Crosstab limitation...
  105. Streaming LIBPQ? Sliding Window in LIBPQ?
  106. [Re] Re: [Re] Re: Unknown winsock error 10061while dumpinga big database
  107. Error compiling Slony I
  108. PostgresSQL vs. Informix
  109. can't createdb with my new user
  110. PostgreSQL DB split
  111. is the default of lowercase enforced on all OS platforms?
  112. I have a select statement on the issue.
  113. client_encoding error
  114. WAL Recovery
  115. Re: Connection idle broken
  116. Res: Connection idle broken
  117. spatial composition operators for PG
  118. Unknown winsock error 10061while dumping a big database
  119. Config settings for large restore
  120. Another question about partitioning
  121. Help Needed
  122. Re: Linux v.s. Mac OS-X Performance
  123. indexing tables using my owns functions
  124. Help Needed
  125. Re: postgres 8.3 beta 2 storage question
  126. select from an index
  127. select using an index
  128. "Invalid Pointer Operation" while reading tuples
  129. Connection idle broken
  130. postgres 8.3 beta 2 storage question
  131. System Load analyze
  132. Trigger problem
  133. Rules slower than Dynamic SQL ?
  134. cp: cannot stat `/mnt/server/archivedir/00000001.history': No such file or directory
  135. Stored Procedures vs Dynamic SQL generated by ORM ?
  136. speed up insert query
  137. Re: replication in Postgres
  138. Re: Primary Key
  139. ALTER syntax question and usernames with hyphens
  140. Re: replication in Postgres
  141. Re: Migrating from 32 to 64 bit
  142. Non-unique values problem after 'add column'
  143. replication in Postgres
  144. Empty arrays with ARRAY[]
  145. Re: Error while compiling PostgreSQL with Java
  146. Error while compiling PostgreSQL with Java
  147. \copy ... with null as '' csv doesn't get nulls
  148. Why LIMIT and OFFSET are commutative
  149. LIBPQ: Can we have buffered PGresult (i.e. a retreival by chuncks?)
  150. cursors
  151. Re: Migrating from 32 to 64 bit
  152. System Load analyze
  153. Problems with PostGreSQL and Windows 2003
  154. ODBC, access, and joins
  155. Re: Primary Key
  156. manipulating HeapTuples in a libpq client
  157. Disk arrangement in a cheap server
  158. Invalid input syntax for type bytea.
  159. Requesting for a pgadmin3-1.8.0 RPM for SL4
  160. Re: autovacuum process blocks without reporting adeadlock
  161. Forming the UK User Group
  162. autovacuum process blocks without reporting a deadlock
  163. which psqlodbc driver to use for PostgreSQL 8.2.5
  164. Re: POLL: Women-sized t-shirts for PostgreSQL
  165. Date Timezone
  166. LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)
  167. Casting hexadecimal IPs to readable content
  168. Re: backup of postgres scheduled with cron
  169. Re: BEGIN strange behaviour
  170. BEGIN strange behaviour
  171. EAV or not to EAV?
  172. Re: Fragments in tsearch2 headline
  173. Re: POLL: Women-sized t-shirts for PostgreSQL
  174. Query re disk usage
  175. best way to handle enum type
  176. Re: Postgres table size
  177. Coordinating database user accounts with active directory
  178. Re: Postgres table size
  179. Read-only availability of a standby server?
  180. select with recursive support
  181. maximum size of plpgsql function parameter
  182. Re: Postgres table size
  183. Re: Postgres table size
  184. loading a funtion script from a file
  185. logging of transaction related events
  186. Table filter
  187. Dynamic expressions set in "order by" clause
  188. Unused item pointers - can someone explain?
  189. MAybe a FAQ
  190. Restart a sequence regularly
  191. PostgreSQL is not behaving consistently across platforms
  192. Static linking of libpq with a windows application.
  193. Re: Postgres file structure doubt
  194. VB ADODB .Open failing
  195. Payment details
  196. plpythonu under OS X 10.4 -- a brief HOWTO
  197. Re: PostgreSQL Conference 08 East!
  198. Timestamp without timezone
  199. Foreign keys and inheritance
  200. plpython and error catching
  201. plpython array support
  202. Timestamp comparison with string in some special cases
  203. Re:
  204. postgresql performance and storage questions
  205. Postgres file structure doubt
  206. Postgresql storage question
  207. postgresql storage and performance questions
  208. unable to createuser in postgres 8.2.5 opensolaris
  209. Function Problems
  210. Random Drug Testing
  211. Re: [ADMIN] Error while starting postgreSQL service
  212. convert custom datatype to array
  213. Postgre and XML
  214. IP addresses
  215. possible to create multivalued index from xpath() results in 8.3?
  216. MI5 Persecution: Faxes Sent to Media1 (6308)
  217. MI5 Persecution: Faxes Sent to Media2 (8483)
  218. Sharing static data among several databases
  219. 8.3b2 XPath-based function index server crash
  220. MI5 Persecution: Faxes Sent to Diplomatic/Legal (4133)
  221. MI5 Persecution: Bernard Levin - The Times (32408)
  222. MI5 Persecution: Come back, Norma! (34583)
  223. MI5 Persecution: Victor Lewis-Smith (36758)
  224. MI5 Persecution: Introduction to Sent Faxes (1958)
  225. tsearch2 best practices
  226. MI5 Persecution: Post Office 14/11/02 (25883)
  227. MI5 Persecution: Eclipse pub 20/12/02 (28058)
  228. Re: how should I do to disable the foreign key in postgres?
  229. MI5 Persecution: Barbican Library 6/2/2003 (30233)
  230. Re: pg_dump problem
  231. Clustered/covering indexes (or lack thereof :-)
  232. MI5 Persecution: Jon Holmes (4-5/Jan/2002) (23708)
  233. Re: how should I do to disable the foreign key in postgres?
  234. regexp_replace() function in new version
  235. GIN: any ordering guarantees for the hits returned?
  236. ERROR: invalid restriction selectivity: 224359728.000000
  237. MI5 Persecution: Balham Bus 8/7/99 (12833)
  238. MI5 Persecution: Clapham South 17/2/00 (15008)
  239. MI5 Persecution: Clapham Junction 6/5/00 (17183)
  240. MI5 Persecution: he's an idiot you know 3/11/00 (19358)
  241. MI5 Persecution: tinker tailor wanker thief 2/12/00 (21533)
  242. HINT: Please REINDEX it.
  243. "and then" / "or else"
  244. MI5 Persecution: Ravenscourt Park 20/3/99 (6308)
  245. MI5 Persecution: Battersea Library 29/3/99 (8483)
  246. MI5 Persecution: Royal Festival Hall 15/4/99 (10658)
  247. max_fsm_relations
  248. MI5 Persecution: BA984 LHR->TXL 13/6/98 (1958)
  249. MI5 Persecution: BHS Croydon 18/12/98 (4133)
  250. pg_dump not including custom CAST?