View Full Version : Pgsql General



  1. Is it possible to have multiple names for a column?
  2. Client Connections
  3. PostgreSQL slammed by PHP creator
  4. Optimising a query requiring seqscans=0
  5. When to reload and when to restart?
  6. Question about timestamp with time zone
  7. Re: remote duplicate rows
  8. Inherited tables vs UNION ALL views
  9. Running PostgreSQL in a Xen DomU?
  10. oracle listener intercept
  11. remote duplicate rows
  12. Kill specific connection
  13. Load "myLib.so" error cannot load obj file...
  14. Problems with date configuration
  15. Re: [NOVICE] Question About Aggregate Functions
  16. Re: [NOVICE] INSERT does not finish except if it is carried out a
  17. Template1 oops
  18. Initializing Datums for use with SPI_execute_plan
  19. berkley sockets
  20. program for graphical/schematical representation of relations between tables
  21. serial, sequence, and COPY FROM
  22. Bytea to Text problems
  23. Issue with order by for type varchar
  24. Multiple entries of same table in pg_class
  25. select unique items in db
  26. initdb: invalid locale name "sv_SE.ISO-8859-1"
  27. Re: Superuser lost access to particular database
  28. Superuser lost access to particular database
  29. off topic - web shop
  30. Need Help w/ Timestamps
  31. Database migration and redesign
  32. Groups, permissions and visibility
  33. Before Delete Problem - don't delet first time ?
  34. Re: [ANNOUNCE] == PostgreSQL Weekly News - September 10 2006 ==
  35. references/tutorial/tricks on dynamic generation of sql (& plpgsqlfunctions) editing/coding
  36. Re: Plan for outer joins
  37. Re: Certificate, login & php question ?
  38. Re: Reinstall problem of PostgreSQL in Windows XP
  39. Rules / Triggers and Return Row Count
  40. execute in pl/pgsql
  41. Data Warehouse
  42. How to use SPI_saveplan
  43. Is this logical?
  44. Idle in transaction state.
  45. find a free database design software
  46. Logging queries that are part of a stored procedure
  47. Reinstall problem of PostgreSQL in Windows XP
  48. Re: [NOVICE] Insert Only Postgresql
  49. Determining right size for max_fsm_pages on large setup?
  50. pg_dump and cluster
  51. Stored Procedure performance / elegance question
  52. PostgreSQL books for beginner
  53. Re: Foxpro + PostgreSQL
  54. Differences lang with or without "u" example:pltcl and pltclu
  55. Re: Foxpro + PostgreSQL
  56. pgpool on Opteron server running FreeBSD 6.0
  57. uConnect Voip
  58. AYUDA POR FAVOR
  59. Help using user rights
  60. Problems with upgrade Postgre 8.1.2 to 8.1.4
  61. Re: Problems with sequences
  62. pglogger and utf-8
  63. Re: Majordomo drops multi-line Subject:
  64. Re: Problems with sequences
  65. Fwd: Help using user rights
  66. postgres and emacs on windows os
  67. Replace NULL values
  68. On DNS for postgresql.org
  69. Re: On DNS for postgresql.org
  70. Child program using parent program's transaction?
  71. Problems with sequences
  72. Re: On DNS for postgresql.org
  73. Asynchronous trigger
  74. inet/cidr type ?!
  75. WG: postgres and emacs on windows os
  76. Re: On DNS for postgresql.org
  77. Database design and triggers...
  78. Estimate on gborg rescue?
  79. Dead Lock problem with 8.1.3
  80. NT4 client problem
  81. Date using Int8
  82. constraint -- one or the other column not null
  83. Postgres 8.1.4 sanity_check failed on SuSE 8.2
  84. ERROR: Gin doesn't support full scan due to it's awful inefficiency
  85. Enabling Kerberos
  86. Re: [OT] sig sizes (was Re: Porting from ...)
  87. what fired a trigger
  88. Re: [OT] sig sizes (was Re: Porting from ...)
  89. how to add postgresql service by command on windows
  90. Re: Plperl functions with OUT parameters crashing each other when used in the same connection
  91. Upgrade Postgres 8.1.2 to 8.1.4
  92. Two billion records ok?
  93. deadlock detected errors
  94. Porting from ORACLE to PostgSQL
  95. tetst
  96. Re: Plperl functions with OUT parameters crashing each other when used in the same connection
  97. PostgreSQL XID exceeded crash.
  98. Plperl functions with OUT parameters crashing each other when used in the same connection
  99. Syntax for converting double to a timestamp
  100. Creating a date/time search function in Postgres.
  101. Serial Updating
  102. pgFoundry.org not working!
  103. Severe problems with PostgreSQL 7.4.7 installation, please help!
  104. database replication
  105. compressed protocol
  106. One step install, up and running?
  107. pg_column_size()
  108. Compiling libpqddll.lib win32 mingw msys
  109. how to integrate postgresql into my installer in Window system?
  110. Sharing News
  111. Array comparison - subset
  112. pg_statistic corruption and duplicated primary keys
  113. Duplicating rows in one table but with one column value different
  114. Database corruption
  115. Insert Rule
  116. Some strange plans choosed by postgres for one query:
  117. Create user or role from inside a function?
  118. Postrgesql and Mysql in the same server Linux (Fedora core 5)
  119. Re: [pgsql-advocacy] Thought provoking piece on
  120. argue
  121. GBorg down?
  122. Trigger (Transaction related)
  123. Re: SPI_execute (result of a select statement)
  124. CMS and java?
  125. postgres array quoting
  126. Re: Thought provoking piece on NetBSD
  127. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  128. Re: postgres array quoting
  129. Re: Thought provoking piece on NetBSD
  130. Re: postgres array quoting
  131. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  132. Re: postgres array quoting
  133. Installation of Postgres 7.1
  134. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  135. Re: [pgsql-advocacy] Thought provoking piece on NetBSD
  136. Query performance inconsistant.
  137. Re: Cutting the Gborg throat
  138. number of elements in a multidimensional array
  139. Strange error related to temporary tables
  140. stream data in bytea field + using SSL
  141. problem to restore pg_dump --data-only
  142. pg_config --includedir is null
  143. Dependency graph of all tuples relied upon in a query answer
  144. Installing on Redhat 7.2
  145. Listening on more than one port?
  146. Dblink and connections to MySQL?
  147. Re: Dblink and connections to MySQL?
  148. Re: Listening on more than one port?
  149. Re: Dblink and connections to MySQL?
  150. Re: Dblink and connections to MySQL?
  151. Tsearch2 & Hebrew
  152. Fwd: How to convert a string to bytea?
  153. SQL Tuning
  154. plz unsubscribe me
  155. Postgres
  156. PLPERL Function very Slow
  157. Encoding problem
  158. Re: Version 1 Calling convention
  159. Query for order of tables
  160. PostgreSQL on system with root as only user
  161. #include "executor/spi.h" throwing errors
  162. Re: Version 1 Calling convention
  163. reindexdb and "could not open relation" error message
  164. Santa Clara Pg Training Event (resent to -general)
  165. Re: database files are incompatible with server, after computer restart
  166. SQL Tuning
  167. counting days
  168. strange sum behaviour
  169. Anonymous stored procedures
  170. Confused on a some deadlocks occuring...
  171. Re: speeding up big query lookup
  172. transaction isolation level
  173. Fwd: Can't populate database using Copy
  174. Deathly slow performance on SMP red-hat system
  175. database files are incompatible with server, after computer restart
  176. Re: Precision of data types and functions
  177. Postgresql mentioned on Newsforge MySQL article
  178. Re: Precision of data types and functions
  179. Atomicity?
  180. Precision of data types and functions
  181. Re: Precision of data types and functions
  182. Can't see what's wrong with this function?
  183. Re: speeding up big query lookup
  184. =?us-ascii?Q?pg=5Frestore=20problems?=
  185. Convert time to millisec?
  186. Re: optimising UNION performance
  187. Re: optimising UNION performance
  188. Perl language creation failed
  189. Cutting the Gborg throat
  190. any need to run vacuumdb if autovacuum is running?
  191. xpath_string and group by
  192. Re: mising chunk
  193. implementing a read lock
  194. xpath_string and group by
  195. mising chunk
  196. copy command
  197. Can't populate database using Copy
  198. Content of pg_class.relacl
  199. alternative to using a sequence
  200. Errors from pgbench
  201. speeding up big query lookup
  202. Something blocking in libpq_gettext?
  203. Re: hint unique result fro union
  204. Re: FW: Serverlog 100GB
  205. Inserting Data
  206. getting on the system
  207. 7.4 - data recovery
  208. Re: [ADMIN] CMS - portal server Question
  209. Re: [ADMIN] CMS - portal server Question
  210. preload perl modules in plperl?
  211. HOW SELECT
  212. multimpe records output from a 'no-table' source
  213. FW: Serverlog 100GB
  214. lock table problem
  215. ruby driver postgresql
  216. SQL:2003 Window Functions for postgresql 8.3?
  217. Inserting Data
  218. Large database design advice
  219. PG8 Stalling/Not Exit/Not Performing Issue
  220. undefined reference to `PQprepare' with postgresql-dev 7.4.7-6sarge2
  221. getting around 'out of memory' errors
  222. Re: Can't open Postgres at all!!!
  223. Re: Can't open Postgres at all!!!
  224. Length limit for query
  225. Can't open Postgres at all!!!
  226. Saving a jpg into Postgresql table
  227. Re: Shared Objects (Dynamic loading)
  228. Re: CASCADING could not open relation with OID
  229. XPath and XML support
  230. Re: CASCADING could not open relation with OID
  231. Re: [SLE] Install source
  232. Re: CASCADING could not open relation with OID
  233. Re: CASCADING could not open relation with OID
  234. invalid byte sequence ?
  235. How to detect Postgres deadlocks?
  236. Can I read data load files without loading in db?
  237. CASCADING could not open relation with OID
  238. Row type select syntax - inconsistency or misunderstanding?
  239. help with postgresql and stats
  240. How to become Stats in postgresql?
  241. Slow insert/delete
  242. Majordomo drops multi-line Subject:
  243. Re: [8.1.4] Create index on timestamp fails
  244. Re: UUID as primary key
  245. Installation Help needed
  246. How do i store arbitrary questions and answers in SQL?
  247. Error picking articles on mail archive
  248. Please participate in a non-profit academic research
  249. PSQLException: An I/O error occured while sending to the backend
  250. Please participate in a non-profit academic research