View Full Version : Pgsql General



  1. Re: kerberos authentication error with Windows 2003 SP1 AD
  2. functions: stable/volatile
  3. Re: phpPgAdmin, cannot connect to server
  4. =?iso-2022-jp?B?GyRCPXUkMSRGJC8kQCQ1JCQbKEI=?=
  5. problem in joins
  6. pg_hba.conf
  7. Druid for postgreSQL - can I export my ERD to MS Access?
  8. Can't Create Tablespace On Windows 2003
  9. Running a query as a specific, different user
  10. tsearch trigger: function public.tsearch2(tsvector, text) does not exist
  11. phpPgAdmin, cannot connect to server
  12. composite type insert
  13. User-defined-type in C crashing PostgreSQL server: What am I doingwrong?
  14. After Update Triggers
  15. Allowing SYSDATE to Work
  16. Is there a PostgreSQL utility that is similiar to Oracles sql loader?
  17. Copy command to load data into a PostgreSQL DB
  18. Shutting down a warm standby database in 8.2beta3
  19. Select slow over network
  20. tracking errors in psql
  21. user defined C-lang pg function bug
  22. function visibility
  23. Client SSL validation using root.crt
  24. Re: dependency on 32 bit libpq.so on 64 bit Postgres server.
  25. pg_dump : option --exclude-schema not recognized
  26. explain analyze taking longer than executing the query?
  27. Eliminating bad characters from a database for upgrading from 7.4 to 8.1
  28. Extract between year *and* month
  29. Linux hard drive/device nodes for a Postgres RAID array
  30. Accessing postgres in perl app using ssl authentication
  31. PostgreSQL: Question about rules
  32. SPI
  33. statement_timeout
  34. Partial index
  35. Strange Postgresql crash
  36. odd result set
  37. Why the data changes it's value by itself!
  38. problem in to_char() function
  39. PostGreSql cannot start after windows update
  40. Re: dependency on 32 bit libpq.so on 64 bit Postgres server.
  41. Postgres misses readline
  42. Re: ORDER BY
  43. calculated default
  44. Re: ORDER BY
  45. dependency on 32 bit libpq.so on 64 bit Postgres server.
  46. Transaction id wraparound problem
  47. How to crash postgres using savepoints
  48. Data conversion tools?
  49. Not your father's question about deadlocks
  50. sync linux and postgresql users and groups
  51. Discover temporary INDEX/TABLE name
  52. Re: Data corruption
  53. Re: Question about query optimization
  54. Re: PG_MODULE_MAGIC check in 8.2
  55. Question about query optimization
  56. SQL subquery question
  57. copy template X -> Y
  58. Recovering deleted or updated rows
  59. autovac state persistence
  60. RE : Re: RE : Re: database design ...
  61. RE : Re: RE : Re: database design ...
  62. RE : Re: database design ...
  63. Re: PG_MODULE_MAGIC check in 8.2
  64. RE : Re: database design ...
  65. Not your father's question about deadlocks
  66. PG_MODULE_MAGIC check in 8.2
  67. connectby usage question
  68. Using SAN Splits to instantly copy a DB
  69. ERROR: type "i" does not exist
  70. The old Insert and retrieving your Serial problem in VB
  71. ORDER BY
  72. LAN
  73. Re: database dump then restore on another system?
  74. Re: PostgreSQL Mhash functions
  75. schema rename - is analyze necessary?
  76. Data corruption
  77. FW: [NOVICE] Creating a new server
  78. Locale configuration with Win XP PostgreSQL 8.1.4
  79. autovac hung/blocked
  80. kerberos authentication error with Windows 2003 SP1 AD
  81. database design ...
  82. Re: can't start postgresql
  83. libpq.so full name?
  84. Trouble migrating from PostgreSQL --> Oracle
  85. Large Object to Bytea Conversion
  86. specified cluster does not exist error
  87. gcj requirement for jdbc driver
  88. Out of memory (Failed on request size 24)
  89. empty folder for downlaoding PostgreSQL 8.1.5 for FC 4
  90. can't start postgresql
  91. PgSQL not recognized
  92. Using PL/pgSQL
  93. Re: Inserting data in composite types
  94. chop off non-meaningful digits
  95. system tables...
  96. Re: SQL - update table problem...
  97. SQL - update table problem...
  98. schema synchronization
  99. Inserting data in composite types
  100. kubuntu & pgadmin
  101. Re: encoding advice requested
  102. Re: DELETE performance issues
  103. RE : Trying to Install PhP-4 Module for PostgreSQL from Ports
  104. Trying to Install PhP-4 Module for PostgreSQL from Ports
  105. specify whitch index to use
  106. Enable monitoring on the health of postgres db
  107. Why isn't it allowed to create an index in a schema other than public?
  108. Pushing the Limits
  109. join condition against where with coalesce
  110. Re: DB Designer??
  111. Re: Speed of postgres compared to ms sql, is this
  112. SQL Join for a Calculation
  113. Speed of postgres compared to ms sql, is this article/comment off?
  114. encoding advice requested
  115. SQL syntax additions for 8.2
  116. Utility to Convert MS SQL Server to Postgres
  117. Automatically Creating INSERT/UPDATE/DELETE Rules on Views
  118. apparent wraparound
  119. wildcard alias
  120. Request for replication advice
  121. FK pointing to a VIEW
  122. Cached dataset
  123. Which DatumGet ?
  124. Using GIN indexes on 8.2
  125. Re: "stopping" a single database in a cluster
  126. tsearch2() with data from other table
  127. SSL Certificate Check
  128. Re: ECPG and multiple threads
  129. Database Mirroring Solution
  130. "stopping" a single database in a cluster
  131. Logging in postgresql.conf - no SQL statements are logged
  132. ECPG and multiple threads
  133. Re: postgres at startup
  134. how & from where to start & admin pgsql on red hat ES 3
  135. LIKE OPERATOR cardinality estimation
  136. Linux vs. FreeBSD
  137. postgres at startup
  138. Multiple currencies in a application
  139. blocking function in PL/Python
  140. Remote tables infrastructure.
  141. AutoVacuum on demand?
  142. zero values in statistic views
  143. Can non-superuser install c functions ?
  144. Installation Instruction For Window
  145. Problem with pg_dump
  146. Mac OS X
  147. Datum problem
  148. ROWTYPE initialization question
  149. [PL/pgSQL] Commit every N rows. Is it possible ?
  150. posgres headers
  151. cannot connect anymore from a remote host
  152. Re: Why overlaps is not working
  153. Why overlaps is not working
  154. Re: autovacuum blues
  155. Re: Table design - unknown number of column
  156. Re: autovacuum blues
  157. Re: [PL/pgSQL] How should I use FOUND special variable.
  158. [PL/pgSQL] How should I use FOUND special variable. Documentation is little unclear for me
  159. Too many open cursors
  160. Changing the number and type of columns in a view
  161. Re: autovacuum blues
  162. Re: RULE - special variables?
  163. Table design - unknown number of column
  164. reproducing this issue on PG 8.0.0 ERROR: index "patient_pkey" is not a btree
  165. authentication question
  166. planer picks a bad plan (seq-scan instead of index) when adding an additional join
  167. Re: [SQL] [ADMIN] Is there anyway to...
  168. dblink / plpgsql - definition list cheats for record returning functions?
  169. Can PostgreSQL notify a client that a trigger has fired?
  170. PostgreSQL RPMs
  171. Survey...Please do help and Respond!!
  172. Performance monitoring
  173. TRIGGERS - access sql query_string that called it?
  174. RULE - special variables?
  175. dblink / plpgsql - definition list cheats for record returning functions?
  176. Does PostgreSQL support multi-instancing?
  177. How much memory is required?
  178. 8.1.2 locking issues
  179. Table and Field namestyle best practices?
  180. 8.1.2 postmaster died
  181. PostgreSQL tutorials
  182. "Broken" Plan? Nested Loop IN Join vs. Nested Loop/Hash Aggregate
  183. killing autovac
  184. Salir de la lista
  185. delete performance is extremely slow
  186. A couple more PostgreSQL C questions
  187. Question on inserting and querying at the same time.
  188. Stable sort?
  189. converting Informix outer to Postgres
  190. =?iso-2022-jp?B?GyRCJCo7fjRWJCwkIiRrO34kRzk9JCQkXiQ7JHMkTiRHG yhC?=
  191. Re: [HACKERS] Tsearch Index Size and GiST vs. GIN
  192. WAL ends before end time of backup dump
  193. I'm lost :-( with FOR...IN
  194. running external programs
  195. Re: RE : Re: first steps in PhP and PostgreSQL
  196. Re: R and postgres
  197. when to use pfree?
  198. X.50x OID representation
  199. Re: database name aliases?
  200. what version of Postgis should i install for Postgres-8.1.5 RHEL 4 -AS RPM
  201. R and postgres
  202. EXECUTE INSERT BUGS?
  203. database name aliases?
  204. data does not exist :-(
  205. Re: [pgsql-general] Daily digest v1.6578 (20 messages)
  206. FOR ... IN
  207. stored procedure / Function
  208. How to force strong passwords
  209. cvs HEAD initdb: vacuuming database template1 ... FATAL: could notidentify a comparison function for type aclitem
  210. Schema search_path and views
  211. timezone difference in timestamp?
  212. DISTINCT is not quite distinct
  213. first steps in PhP and PostgreSQL
  214. PostgreSQL in an embedded platform
  215. Alias for tables/columns?
  216. Re: Issue when inserting Slovak characters in database via PHP code
  217. Re: upgrade to 8.0.9
  218. Re: Header meaning for pg_dump
  219. select result / functions from another database in plpgsql
  220. No subject
  221. .
  222. =?iso-2022-jp?B?GyRCRn42YiRyJDUkOyRGRDokJCRGJGgkbSQ3JCQkRyQ3J GckJiQrGyhC?=
  223. upgrade to 8.0.9
  224. Dump all databases to corresponding files
  225. schema diagram with child tables
  226. basic SQL request
  227. varchar
  228. max_fsm_pages
  229. Converting a timestamp to a time
  230. =?iso-2022-jp?B?GyRCPHIkSD13JEg2YiRIPCtNMxsoQg==?=
  231. ERROR: tuple concurrently updated
  232. help with a query
  233. opening a channel between two postgreSQL-servers?
  234. Re: I can not add up columns when using a left outer join. Any ideas as to why?
  235. Win32 Silent installer ADDLOCAL is ignored
  236. Geometric Datatypes
  237. Issue when inserting Slovak characters in database via PHP code
  238. bytea / large object and image
  239. UNICODE and UTF-8
  240. PostGIS Binary RPM for Red Hat Linux
  241. Simple stored procedure examples?
  242. Per-row security
  243. Odd dump/restore question
  244. Unknown subdirectories in postgres base directory
  245. Re: I can not add up columns when using a left outer join. Any ideas as to why?
  246. DROP INDEX performance/locking
  247. I can not add up columns when using a left outer join. Any ideas as to why?
  248. explosion of tiny tables representing multiple fields--Is thisnecessary?
  249. Re: Is there anyway to...
  250. Invoking java in a trigger