PDA

View Full Version : Pgsql General

  1. Re: I "might" have found a bug on 8.2.1 win32
  2. Fwd: How to allow users to log on only from my application
  3. What's the best way to index this table for speed?
  4. PGSQL backup types and scheduling.
  5. Re: Subqueries - performance and use question
  6. Defining and Using variables in a postgres function
  7. Subqueries - performance and use question
  8. I "might" have found a bug on 8.2.1 win32
  9. Time Input with format HH.MM.SS
  10. sqldetach (porting from Informix to PostgreSQL)
  11. Problem with Online-Backup
  12. How can I list the function.
  13. Functions, composite types and Notice
  14. Ordering problem with varchar (DESC)
  15. Re: Ordering problem with varchar (DESC)
  16. Ordering problem with varchar (DESC)
  17. sequence skips 30 values, how?
  18. 8.2.1 Compiling Error
  19. Can a function be parameter in PL/PGSQL function?
  20. DBMS Engines and Performance
  21. SELECT FOR UPDATE with ORDER BY to avoid row-level deadlock?
  22. Any Plans for cross database queries on the same server?
  23. When an index and a constraint have the same name...
  24. SELECT FOR UPDATE with ORDER BY to avoid row-level deadlock?
  25. Foreign keys, table inheritance, and TRUNCATE
  26. Retrieving PK of inserted row
  27. Unauthorized users can see db schema and read functions
  28. pg migrator
  29. programming 'like' operator
  30. MULE_INTERNAL translation to win1250
  31. Re: Predicted lifespan of different
  32. PostgreSQL 9.0
  33. PostgreSQL 9.0
  34. "simple" dict with stop words in tsearch2
  35. Re: Predicted lifespan of different PostgreSQL
  36. dependency ?
  37. Locking question?
  38. VACUUM ANALYZE taking a long time, %I/O and %CPU very low
  39. Crazy Error
  40. Re: Postgresql 8.1: plperl code works with LATIN1, fail
  41. strange thing with partitioning / rules / plpgsql
  42. PG Email Client
  43. convert(USING utf8_to_iso_8859_15) on Windows
  44. Load balancing across disks
  45. MULE_INTERNAL translation to win1250
  46. text storage and parsing errors
  47. How to allow users to log on only from my application not from pgadmin
  48. Re: "explain analyse" much slower than actual query
  49. Firing triggers based on certain Insert conditions
  50. "explain analyse" much slower than actual query
  51. virtual (COMPUTED BY) columns?
  52. counting query
  53. tsearch2, locale, UTF-8 and Windows
  54. Limit on number of users in postgresql?
  55. SQL to get a table columns comments?
  56. Password issue revisited
  57. 8.2 planner and "like"
  58. Ayuda sobre Indices
  59. Default fillfactor question (index types other than btree)
  60. Sample C++ code using libpqxx/Postgresql sought
  61. column limit
  62. Loop plpgsql recordset
  63. Re: Can you specify the pg_xlog location from a config
  64. Record not returned until index is rebuilt
  65. RE: Rollback using WAL files?
  66. Predicted lifespan of different PostgreSQL branches
  67. Can you specify the pg_xlog location from a config file?
  68. Postgresql 8.1: plperl code works with LATIN1, fails with UTF8
  69. PostgreSQL data loss
  70. large document multiple regex
  71. Rollback using WAL files?
  72. Installation on Web Server
  73. DBI support for pg native arrays?
  74. bytea performance issue
  75. Linking a Postgres table on Linux to Ms Access
  76. triggers vs b-tree
  77. Duplicate key violation
  78. MI5 Persecution: Surveillance methods 5/8/95 (5971)
  79. MI5 Persecution: But why? 2/8/95 (5066)
  80. MI5 Persecution: Let it go 1/8/95 (4161)
  81. MI5 Persecution: Truth or Troll? 13/5/95 (3256)
  82. MI5 Persecution: Recognition by Strangers is Normal 12/5/95 (2351)
  83. Controlling Database Growth
  84. MI5 Persecution: A doubting Thomas is heard 9/5/95 (1446)
  85. Problem loading pg_dump file
  86. MI5 Persecution: BBC's Hidden Shame 4/5/95 (541)
  87. Postgresql best practices
  88. MI5 Persecution: Newsgroup members join in the discussion (2351)
  89. MI5 Persecution: Intelligence agency sources on the Web (1446)
  90. MI5 Persecution: Toronto Freenet supports free speech (541)
  91. replication choices
  92. loop plpgsql recordset variable
  93. encode, lower and 0x8a
  94. sequence increment jumps?
  95. relationship in a table
  96. Problem with result ordering
  97. column limit
  98. SQL Newbie Question
  99. upgrading pl/pgsql triggers from 7.4 to 8.2
  100. Postgresql 64bit question
  101. libeay32.dll & ssleay32.dll in system PATH
  102. Postgresql Backup
  103. indexing primary and foreign keys w/lookup table
  104. column insert/alter got me stumped!
  105. Converting 7.x to 8.x
  106. Idle in transaction - Explination ..
  107. capacity of tables
  108. Cannot Restart PostgreSQL-8.1.4
  109. Stats collector frozen?
  110. missing cache data for cache id 27
  111. Re: how to read bytea field
  112. Interval quantity units - a new one?
  113. Numeric to integer Type conversion
  114. NETEZZA cursors, anyone?
  115. NETEZZA cursors, anyone?
  116. Example of RETURNING clause to get auto-generated keys from INSERT
  117. Calling all SoCal PostgreSQL Users!
  118. Date Questions
  119. copy schema X to schema Y in the same DB
  120. Problem with replace
  121. dump desde dentro de una base
  122. how to read bytea field
  123. IPC resource managements on Solaris 10
  124. CREATE FUNCTION Fails with an Insert Statement in it
  125. PostgreSQL 8.2 utilities with Java app on Windows XP
  126. psql substitution variables
  127. PostgreSQL 8.1: createdb: xflush error ?
  128. Postgres processes have a burst of CPU usage
  129. Installing PostgreSQL under Cpanel
  130. Postgresql.conf
  131. array_to_string return is different between Windows and Linux systems
  132. [Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]
  133. New US DST Rules & PostgreSQL
  134. Problems compiling from source
  135. Re:
  136. Re: Trouble creating database with proper encoding
  137. Re: Trouble creating database with proper encoding
  138. show all record between two date after group by and aggrigation...
  139. Re: Installing Postegres side-by-side with M$ SQL server]
  140. Re: [HACKERS] Autovacuum Improvements
  141. too many trigger records found for relation "item" - what's that about??
  142. printf-like format strings
  143. selecting random rows
  144. Loop in loop
  145. Tracking database activity
  146. Re: Enable/Disable Triggers
  147. MSSQL/ASP migration
  148. Re: Loop in loop
  149. CAST function for user defined type
  150. security question
  151. Is there an equivalent of the W3c HTML checker for SQL?
  152. Re: [ANNOUNCE] == PostgreSQL Weekly News - January 21 2007 ==
  153. Re: Installing Postegres side-by-side with M$ SQL server]]
  154. triggers and TriggerData
  155. can't CREATE TRIGGER
  156. Migrate 8.0 dump to 7.4
  157. postgresql scalability, active-active cluster
  158. Replicating Binary Data from MS SQL 2000 to PG 8.2
  159. Using transactions with plpythonu
  160. More grist for the PostgreSQL vs MySQL mill
  161. Regular expressions and arrays and ANY() question
  162. lanmanager and ntlm hash function contribution
  163. Multiple column index question.
  164. Help : Microsoft SQL Server equivalents in PostGreSQL
  165. Installing Postegres side-by-side with M$ SQL server
  166. Multiple column index usage question
  167. Postgresql 8.0.10 on FC4
  168. Multiple column indexes
  169. Query Help
  170. A Picture is Worth
  171. Password encryption method
  172. EnterpriseDB Apology
  173. octet string type contribution
  174. MI5 Persecution: what people said (4074)
  175. MI5 Persecution: £20,000 Reward (3241)
  176. Re: Finding bogus dates
  177. =?us-ascii?Q?PostgreSQL=20and=20embedded=20PC=20with=20 Compact=20Flash=3F?=
  178. Can't use passwords for users
  179. help me to solve the problem
  180. how to show serial number of record
  181. Installation of PostgreSQL Service under admin account
  182. trigger question
  183. find columns that contain a single value for all rows
  184. MI5 Persecution: Website Index (2342)
  185. MI5 Persecution: Hotchkies FAQ (1440)
  186. Spam from EnterpriseDB?
  187. MI5 Persecution: Dirk Gently on the Toronto Case (541)
  188. uninstalling postgre sql on Fedora core 5
  189. DB benchmark and pg config file help
  190. apt-get install postgresql.deb??
  191. Re: drive failre, corrupt data...
  192. Re: Finding bogus dates
  193. pg_passwd alternative in Postgres 8.1.5
  194. Finding bogus dates
  195. Clearing plans
  196. drive failre, corrupt data...
  197. Who is Slony Master/Slave + general questions.
  198. Defining data directory while installing [WinXP]
  199. Get SQL dump from readonly FS
  200. Ask about large database?
  201. Re: Controlling memory of session
  202. libpq/libpq-fs.h
  203. datatype advice numeric vs. varchar
  204. Re: How I can read-back a serial value just inserted?
  205. Re: How I can read-back a serial value just inserted?
  206. Re: How I can read-back a serial value just inserted?
  207. Newbie questions (pg_global, tablespace, pg_temp, ...)
  208. FATAL: invalid frontend message type 47 server closed the connectionunexpectedly
  209. Alter definition of a column
  210. pg_dump without oids
  211. Building web sites using a database
  212. Re: Controlling memory of session
  213. Complete newbie question on odbc
  214. SELECT INTO TEMPORARY problem
  215. Diagnosing deadlock / connection hang
  216. Index bloat of 4x
  217. Newbie questions (pg_global, tablespace, pg_temp, ...)
  218. Controlling memory of session
  219. copy row tree
  220. Cursor body?
  221. Re: Need help on SP
  222. The jdbc and current_timestamp
  223. Process won't start in Windows
  224. GUID/UUID Support
  225. [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)
  226. 8.1 vs 8.2.1 view optimization
  227. Multi-column constraint behaviour
  228. lock query
  229. Temp Table Within PLPGSQL Function - Something Awry
  230. trigger howto question
  231. Re: Coercion in PGSQL?
  232. Elegant copy of a row using PL
  233. Mounting a data dir read only
  234. Re: Need setup help for Postgresql 8.1.3 on Solaris 10
  235. invalid byte sequence for encoding "UTF8"
  236. Dynamic loading of Perl Code in Postgres functions
  237. Need help on SP
  238. Coercion in PGSQL?
  239. Very long "or" where clause
  240. Custom index type for indexing long texts?
  241. Collating Question...
  242. Re: Transaction callback
  243. Linking tables and indexes
  244. Improve Postgres Query Speed
  245. postmaster disconnects after heavy load inserts from plperlu -> waht to do?
  246. Reserve a value in a serial type field
  247. NOTIFY QUESTION
  248. Glacially slow nested SELECT
  249. Unpredicatable behavior of volatile functions used in cursors
  250. Avoiding empty queries in tsearch