PDA

View Full Version : Pgsql General

  1. pg_dump and cluster
  2. Stored Procedure performance / elegance question
  3. PostgreSQL books for beginner
  4. Re: Foxpro + PostgreSQL
  5. Differences lang with or without "u" example:pltcl and pltclu
  6. Re: Foxpro + PostgreSQL
  7. pgpool on Opteron server running FreeBSD 6.0
  8. uConnect Voip
  9. AYUDA POR FAVOR
  10. Help using user rights
  11. Problems with upgrade Postgre 8.1.2 to 8.1.4
  12. Re: Problems with sequences
  13. pglogger and utf-8
  14. Re: Majordomo drops multi-line Subject:
  15. Re: Problems with sequences
  16. Fwd: Help using user rights
  17. postgres and emacs on windows os
  18. Replace NULL values
  19. On DNS for postgresql.org
  20. Re: On DNS for postgresql.org
  21. Child program using parent program's transaction?
  22. Problems with sequences
  23. Re: On DNS for postgresql.org
  24. Asynchronous trigger
  25. inet/cidr type ?!
  26. WG: postgres and emacs on windows os
  27. Re: On DNS for postgresql.org
  28. Database design and triggers...
  29. Estimate on gborg rescue?
  30. Dead Lock problem with 8.1.3
  31. NT4 client problem
  32. Date using Int8
  33. constraint -- one or the other column not null
  34. Postgres 8.1.4 sanity_check failed on SuSE 8.2
  35. ERROR: Gin doesn't support full scan due to it's awful inefficiency
  36. Enabling Kerberos
  37. Re: [OT] sig sizes (was Re: Porting from ...)
  38. what fired a trigger
  39. Re: [OT] sig sizes (was Re: Porting from ...)
  40. how to add postgresql service by command on windows
  41. Re: Plperl functions with OUT parameters crashing each other when used in the same connection
  42. Upgrade Postgres 8.1.2 to 8.1.4
  43. Two billion records ok?
  44. deadlock detected errors
  45. Porting from ORACLE to PostgSQL
  46. tetst
  47. Re: Plperl functions with OUT parameters crashing each other when used in the same connection
  48. PostgreSQL XID exceeded crash.
  49. Plperl functions with OUT parameters crashing each other when used in the same connection
  50. Syntax for converting double to a timestamp
  51. Creating a date/time search function in Postgres.
  52. Serial Updating
  53. pgFoundry.org not working!
  54. Severe problems with PostgreSQL 7.4.7 installation, please help!
  55. database replication
  56. compressed protocol
  57. One step install, up and running?
  58. pg_column_size()
  59. Compiling libpqddll.lib win32 mingw msys
  60. how to integrate postgresql into my installer in Window system?
  61. Sharing News
  62. Array comparison - subset
  63. pg_statistic corruption and duplicated primary keys
  64. Duplicating rows in one table but with one column value different
  65. Database corruption
  66. Insert Rule
  67. Some strange plans choosed by postgres for one query:
  68. Create user or role from inside a function?
  69. Postrgesql and Mysql in the same server Linux (Fedora core 5)
  70. Re: [pgsql-advocacy] Thought provoking piece on
  71. argue
  72. GBorg down?
  73. Trigger (Transaction related)
  74. Re: SPI_execute (result of a select statement)
  75. CMS and java?
  76. postgres array quoting
  77. Re: Thought provoking piece on NetBSD
  78. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  79. Re: postgres array quoting
  80. Re: Thought provoking piece on NetBSD
  81. Re: postgres array quoting
  82. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  83. Re: postgres array quoting
  84. Installation of Postgres 7.1
  85. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  86. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  87. Query performance inconsistant.
  88. Re: Cutting the Gborg throat
  89. number of elements in a multidimensional array
  90. Strange error related to temporary tables
  91. stream data in bytea field + using SSL
  92. problem to restore pg_dump --data-only
  93. pg_config --includedir is null
  94. Dependency graph of all tuples relied upon in a query answer
  95. Installing on Redhat 7.2
  96. Listening on more than one port?
  97. Dblink and connections to MySQL?
  98. Re: Dblink and connections to MySQL?
  99. Re: Listening on more than one port?
  100. Re: Dblink and connections to MySQL?
  101. Re: Dblink and connections to MySQL?
  102. Tsearch2 & Hebrew
  103. Fwd: How to convert a string to bytea?
  104. SQL Tuning
  105. plz unsubscribe me
  106. Postgres
  107. PLPERL Function very Slow
  108. Encoding problem
  109. Re: Version 1 Calling convention
  110. Query for order of tables
  111. PostgreSQL on system with root as only user
  112. #include "executor/spi.h" throwing errors
  113. Re: Version 1 Calling convention
  114. reindexdb and "could not open relation" error message
  115. Santa Clara Pg Training Event (resent to -general)
  116. Re: database files are incompatible with server, after computer restart
  117. SQL Tuning
  118. counting days
  119. strange sum behaviour
  120. Anonymous stored procedures
  121. Confused on a some deadlocks occuring...
  122. Re: speeding up big query lookup
  123. transaction isolation level
  124. Fwd: Can't populate database using Copy
  125. Deathly slow performance on SMP red-hat system
  126. database files are incompatible with server, after computer restart
  127. Re: Precision of data types and functions
  128. Postgresql mentioned on Newsforge MySQL article
  129. Re: Precision of data types and functions
  130. Atomicity?
  131. Precision of data types and functions
  132. Re: Precision of data types and functions
  133. Can't see what's wrong with this function?
  134. Re: speeding up big query lookup
  135. =?us-ascii?Q?pg=5Frestore=20problems?=
  136. Convert time to millisec?
  137. Re: optimising UNION performance
  138. Re: optimising UNION performance
  139. Perl language creation failed
  140. Cutting the Gborg throat
  141. any need to run vacuumdb if autovacuum is running?
  142. xpath_string and group by
  143. Re: mising chunk
  144. implementing a read lock
  145. xpath_string and group by
  146. mising chunk
  147. copy command
  148. Can't populate database using Copy
  149. Content of pg_class.relacl
  150. alternative to using a sequence
  151. Errors from pgbench
  152. speeding up big query lookup
  153. Something blocking in libpq_gettext?
  154. Re: hint unique result fro union
  155. Re: FW: Serverlog 100GB
  156. Inserting Data
  157. getting on the system
  158. 7.4 - data recovery
  159. Re: [ADMIN] CMS - portal server Question
  160. Re: [ADMIN] CMS - portal server Question
  161. preload perl modules in plperl?
  162. HOW SELECT
  163. multimpe records output from a 'no-table' source
  164. FW: Serverlog 100GB
  165. lock table problem
  166. ruby driver postgresql
  167. SQL:2003 Window Functions for postgresql 8.3?
  168. Inserting Data
  169. Large database design advice
  170. PG8 Stalling/Not Exit/Not Performing Issue
  171. undefined reference to `PQprepare' with postgresql-dev 7.4.7-6sarge2
  172. getting around 'out of memory' errors
  173. Re: Can't open Postgres at all!!!
  174. Re: Can't open Postgres at all!!!
  175. Length limit for query
  176. Can't open Postgres at all!!!
  177. Saving a jpg into Postgresql table
  178. Re: Shared Objects (Dynamic loading)
  179. Re: CASCADING could not open relation with OID
  180. XPath and XML support
  181. Re: CASCADING could not open relation with OID
  182. Re: [SLE] Install source
  183. Re: CASCADING could not open relation with OID
  184. Re: CASCADING could not open relation with OID
  185. invalid byte sequence ?
  186. How to detect Postgres deadlocks?
  187. Can I read data load files without loading in db?
  188. CASCADING could not open relation with OID
  189. Row type select syntax - inconsistency or misunderstanding?
  190. help with postgresql and stats
  191. How to become Stats in postgresql?
  192. Slow insert/delete
  193. Majordomo drops multi-line Subject:
  194. Re: [8.1.4] Create index on timestamp fails
  195. Re: UUID as primary key
  196. Installation Help needed
  197. How do i store arbitrary questions and answers in SQL?
  198. Error picking articles on mail archive
  199. Please participate in a non-profit academic research
  200. PSQLException: An I/O error occured while sending to the backend
  201. Please participate in a non-profit academic research
  202. table partitioning
  203. pl/R problem
  204. [8.1.4] Create index on timestamp fails
  205. unique constraint when updating tables
  206. using deferred initially deferred to solve foreign keychecking issues
  207. Passing arguments to a trigger function
  208. share library version problems
  209. Re: Inserting Data
  210. Re: UUID as primary key
  211. trigger help
  212. Re: could not open relation - why?
  213. GNUmed release (uses PostgreSQL)
  214. varchar(n) vs. varchar
  215. Re: Queries joining views
  216. Re: Queries joining views
  217. Re: Queries joining views
  218. error msg when pg_restore
  219. External variable
  220. Determine Transactions Per Second
  221. Weird join result
  222. Troubles linking with libpqxx
  223. Re: Is it possible (postgresql/mysql)
  224. Segmentation Fault
  225. Massive slowdown when LIMIT applied
  226. Timezones -- what comes out does not go in?
  227. Restarting Slony crashes Postgresql?
  228. limitations of constraints, possible bugs
  229. Trigger (Calling a Procedure)
  230. how to use variable for select query in pl/pgsql
  231. Re: DB insert Error
  232. How to add days to date
  233. Re: plpgsql dynamic queries and optional arguments
  234. CONSTRAINT REFERENCE betwen array to single
  235. trigger speed
  236. Changing the data directory Ubuntu
  237. REFERENCE problem with parent_table
  238. plpgsql dynamic queries and optional arguments
  239. Re:
  240. Unable to Start PostgreSQL 8.1.4 on Windows XP
  241. Using SETOF functions in SQL
  242. Partial indexes Vs standard indexes : Insert performance
  243. Excluding a table from pg_dump
  244. Explain returns extremely high cost
  245. wal files on temporary tables
  246. select updates pg_stat_database
  247. text datum VARDATA and strings
  248. Leaving out a schema from the dump/restore
  249. prepared statement already exists
  250. Re: problem with a dropped database