View Full Version : Pgsql General



  1. Has anyone used the libpqxx C++ API for PostgreSQL
  2. TSearch2 Changeset 25387
  3. Compiling PL/R library on win32
  4. RESTORING A DATABASE WITH DIFFERENT TIMEZONES
  5. Website Hosting Service and Security
  6. 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...
  7. PG 8.2.0 - TSearch2 "Wrong affix file format"
  8. Password strength requirements
  9. Broken link on website...
  10. Need help on "org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command"
  11. Connecting performance
  12. Directly programmed query plans?
  13. Re: FW: postgres kerberos how to
  14. Re: Starting Postgresql
  15. Starting Postgresql
  16. Re: FW: postgres kerberos how to
  17. Re: postgres kerberos how to
  18. citing postgresql?
  19. windows - silent uninstall question
  20. Re: Autovacuum Improvements
  21. plperl trigger problem
  22. Simple Trigger Error
  23. Re: postgres kerberos how to
  24. propagate changes from template1 to existing databases
  25. postgres kerberos how to
  26. xml2 install problem
  27. admin82.sql
  28. Changing passwords from client application
  29. Unable to start server - winxp
  30. Re: Savepoints in PL/pgSQL
  31. bi-directional replication support
  32. inheritance
  33. A trigger question
  34. psql too noisy
  35. Savepoints in PL/pgSQL
  36. Float Infinity
  37. MAGIC_MODULE and libc
  38. Re: Stored Procedure and Trigger they puzzle me
  39. Help compile pgmemcache against PG 8.2
  40. Re: Stored Procedure and Trigger they puzzle me
  41. problems with silent installation
  42. FreeBSD 6.0 PostgreSQL upgrade
  43. anyone got any suggestions for clustering?
  44. View optimization
  45. Anyone? Best way to authenticate postgres against active directory?
  46. Let's play bash the search engine
  47. Second attempt, roll your own autovacuum
  48. feature request for Postgresql Rule system.
  49. Creating an Independant Application
  50. The meaning of the log levels seems unclear ...
  51. pam ldap postgres troubles cannot get postgres to auth via ldap
  52. pgcluster-1.7.0rc1-patch
  53. Changes in 8.2's PHP behaviour?
  54. permission in the db or in the application?
  55. Re: Stored Procedure and Trigger they puzzle me
  56. installing postgres on win Me...
  57. Tsearch2 install on postgres 8.2 NOTICE messages
  58. fedora core 6 startup script for pg 8.2
  59. Creating an Application
  60. determining which table to lookup depending on data values
  61. How non-superuser can restore database containing procedures
  62. PDOStatement:closeCursor
  63. Re: Functions on tables
  64. Performance of outer joins?
  65. Regular expression and Group By
  66. Re: [pgsql-www] Subcribing to this list, what's the secret?
  67. Stored Procedure and Trigger they puzzle me
  68. Authenticating with x509 certificate
  69. Functions on tables
  70. Re: Functions on tables
  71. A major rewrite of the Postgres OLE DB Provider.
  72. temp tables and function performance
  73. FreeBSD shared memory settings
  74. query on table name to return columns and data types?
  75. free space?
  76. strange slow performance
  77. b-tree index performance
  78. Needed files - embedded postgres
  79. updating a view
  80. A few SQL questions
  81. PITR / what directories/files can be ignored?
  82. Failed to set permision Win2k3-PG Installation Issues
  83. Re: [pgsql-www] Subcribing to this list, what's the
  84. could not write to log -> PANIC -> System down
  85. Performing backup from VB.NET
  86. 8.2 server core dump
  87. Re: about the RULE system
  88. unix/linux administration tools
  89. iplike.so permission denied
  90. How to check constraints before call of simple_heap_insert()?
  91. Slow query in 8.2.0
  92. creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)
  93. pg_controldata output documentation
  94. INSERT INTO row value constructors
  95. out of memory woes
  96. a question for the way-back machine
  97. grant all privileges on database
  98. Re: grant all privileges on database
  99. Subcribing to this list, what's the secret?
  100. selinux/postgresql/jfs
  101. plperl exception catching
  102. EXECUTE INTO on 8.2
  103. Large IN query optimization
  104. about the RULE system
  105. storage
  106. MySQL drops support for most distributions
  107. Pltcl error - could not create "normal" interpreter
  108. Weird PG 8.1.3 date error
  109. Re: [girgen@FreeBSD.org: Re: port fault on pg_ctl's place]
  110. dynamic plpgsql question
  111. error messages without schema name
  112. =?KOI8-R?Q?Re:_[pgsql-ru-general]_index_=CE=C1_=D4=C1=C2=CC=C9=C3=D5_=D3?= =?KOI8-R?Q?_~_700_000_=DA=C1=D0=C9=D3=C5=CA:_?= =?KOI8-R?Q?=DE=C5=CD_=DA=C1=CE=D1=D4_=D0=CF=D3=D4=C7=D2=C 5=D3=3F=3F=3F?=
  113. A VIEW mimicing a TABLE
  114. order by text-type : whitespaces ignored??
  115. PostgreSQL 8.2 : warnings during the built with ICC 9.1.045
  116. function accepting and returning rows; how to avoid parentheses
  117. changing the permission of _lots_ of tables
  118. Re: Postgres friendly RegEx?
  119. Statement timeout not working on broken connections with active queries
  120. TIMESTAMP WITHOUT TIME ZONE
  121. Postgres friendly RegEx?
  122. Re: Online index builds
  123. indexed function performance
  124. Database-based alternatives to tsearch2?
  125. Re: Are updateable view as a linked table in ms-access a bad idea?
  126. Re: a question on SQL
  127. a question on SQL
  128. Re: a question on SQL
  129. Re: resetting sequence to cur max value
  130. date comparisons
  131. resetting sequence to cur max value
  132. Are updateable view as a linked table in ms-access a bad idea?
  133. Running initdb from another process
  134. PostgreSQL Developer Full-time Position
  135. (Perl) script to set up an instance for regression tests
  136. Unrecognized time zone name error.
  137. PostgreSQL 8.2 : IPO link warning with ICC 9.1.045
  138. Re: returning parameters from function
  139. where can i find posges sql include directory...FC5.installing rpms
  140. Database Synchronization
  141. server speed question
  142. any api in libpq to get the number of connections
  143. returning parameters from function
  144. Why DISTINCT ... DESC is slow?
  145. Re: Why DISTINCT ... DESC is slow?
  146. 8.2.0 Installation Problem
  147. possible typo on 8.2 manual
  148. What to do if I don't want any encode translation?
  149. Metadata from NEW and OLD constructs?
  150. forcing compression of text field
  151. Status of SSL encryption in ODBC driver
  152. shell script to populate array values
  153. Re: World Wide International Law: Linux is compulsory (mandotary) in all schools/universities world-wide
  154. out of memory error on 3 table join
  155. Geometric Types
  156. Creating multiple Rules for on update
  157. Numeric or Integer for monetary values?
  158. search_path when restoring to new db
  159. Re: drop role with privileges
  160. Re: drop role with privileges
  161. Re: installation problem, for Postgres 8.2.0
  162. Events tables, model discussion in regards to the performances
  163. inheritance and index use (similar to UNION ALL)
  164. tsearch2 and pdf files
  165. installation problem, for Postgres 8.2.0
  166. Postgres 8.1.5, 64 bit server running on FC4
  167. Remove diacritic
  168. vtd-xml 1.9 released
  169. Re: World Wide International Law: Linux is compulsory (mandotary)
  170. db andtable schemas
  171. PostgreSQL 8.2.0 : New RPM Sets for Fedora Core / Red HatEnterprise Linux
  172. deepak invites you to join Zorpia
  173. drop role with privileges
  174. ALTER TABLE RENAME and primary key
  175. contrib/fuzzystrmatch search_path: what does it mean?
  176. PostgreSQL 8.2.0 and ip4r?
  177. localhost resolving
  178. help understanding analyze
  179. character varying length
  180. Re: Performance figures from DbMail list
  181. TOAD-like FOSS query builder for postgreSQL?
  182. TOAD-like query builder for PostgreSQL?
  183. restoring pgdump.sql
  184. strange (maybe) behaviour of table lock
  185. FW: Male/female
  186. Male/female
  187. creating functions with variable argument lists
  188. LISTEN / NOTIFY
  189. Questions about postgresql-8.2.0-2PGDG.src.rpm
  190. error with Subquery
  191. delete in PG 8.1.5 is slow
  192. Excluding schema from backup
  193. Auto Backup facility?
  194. (NONE)
  195. pg_log missing
  196. porting time calcs to PG
  197. Re: porting time calcs to PG
  198. SET statement_timeout
  199. The relative stability of different procedural languages
  200. Indexes and Inheritance
  201. tsearch2: pg8.1 to pg8.2
  202. How to use outer join in update
  203. Vote for your favorite database
  204. loading data, creating indexes, clustering, vacuum...
  205. Performance figures from DbMail list
  206. PostgreSQL 8.2 on IA-64 : 2 regression tests FAILED
  207. pg_controldata output documentation
  208. partition insert question
  209. Tsearch2 / PG 8.2 Which stemmer files?
  210. Re: DBI module for postgres 1.4.3
  211. pg_dump/pg_Restore 8.1.5 db -> 8.2 tsearch2 problem
  212. Asynchronous replication of a PostgreSQL DB to a MySQL target
  213. Uninstall pg_trgm
  214. Internal function call from C-language function
  215. Cast boolean to text
  216. how to install 8.2 with yum on centos 4?
  217. can this be done in one SQL selcet statement?!
  218. Sanity check...
  219. how to install 8.2 with yum?
  220. VACUUM and transactions in different databases
  221. Re: VACUUM and transactions in different databases
  222. Problems connecting to server
  223. concatenation operator || with "null" array
  224. Trying to Understand Table Inheritance
  225. Error with the odbc driver and the large objects
  226. Update Perrformance with nested loop vs. merge-join
  227. cant connect php to postgresql
  228. Re: HELP: Urgent, Vacuum problem
  229. Help on Update Rule for View
  230. dynamic SQL - variable substitution in plpgsql
  231. From Clause
  232. Why does explain differ from explan analyze?
  233. Array shift equivalent?
  234. Re: Error in installing compat-postgresql-libs rpm
  235. plpythonu array parameter
  236. Error in installing compat-postgresql-libs rpm
  237. Re: Errors trying to install compat-postgresql-libs:
  238. Locking in PostgreSQL?
  239. Re: Locking in PostgreSQL?
  240. 8.2 contrib. "Full Disjunction"
  241. =?iso-2022-jp?B?GyRCJVAlKyRAJGgbKEI=?=
  242. Re: [ANNOUNCE] PostgreSQL 8.2 Now Available
  243. Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available)
  244. Anything I can do to speed up this query?
  245. Re: Anything I can do to speed up this query?
  246. Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2 Now Available)
  247. Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2
  248. Re: Anything I can do to speed up this query?
  249. Re: Anything I can do to speed up this query?
  250. Errors trying to install compat-postgresql-libs: