PDA

View Full Version : Pgsql General

  1. psql Copy question
  2. simple explain output.
  3. こんにちは
  4. Re: Backslashes in data in version 8.1.2
  5. restoring under a different owner?
  6. Backslashes in data in version 8.1.2
  7. PostgreSQL New RPM Sets for FC/RH
  8. pgplsql and notifications
  9. Same data, different results in Postgres vs. FrontBase
  10. Re: Installing on NT4 machine
  11. Installing on NT4 machine
  12. Mixing different LC_COLLATE and database encodings
  13. Domains
  14. Non-Overlaping date interval index
  15. PostgreSQL Functions / PL-Language
  16. Migration using pg_restore
  17. Updating a sequential range of unique values?
  18. primary index permits duplicates
  19. Re: connecting to pgsql
  20. EnterpriseDB
  21. Performance Tuning
  22. Basic problems using plpythonu - bug?
  23. Btrieve to SQL
  24. Re: Problem with postgres installation
  25. Converting an ASCII database to an UTF-8 database
  26. Take advantage of PREPARE (Pool of Conections)
  27. Implicit conversion from string to timestamp
  28. Re: Problem with postgres installation
  29. importing Npgsql provider into VS2005Express
  30. =?UTF-8?Q?Fwd:_[pgsql-jp:_36715]_Josh_Berkus=E6=B0=8F=E3=81=AE?==?UTF-8?Q?=E8=AC=9B=E6=BC=94MP3?=
  31. Fixing up a corrupted toast table
  32. connecting to pgsql
  33. return setof and Temp tables
  34. Problem with postgres installation
  35. Ident authentication failed without su to user
  36. C trigger using system(3) to execute a php script
  37. How do I use the backend APIs
  38. Re: Oracle tried to buy MySQL
  39. address matching and verification
  40. A question about Vacuum analyze
  41. usage of copy command in pgsql
  42. How much clustered?
  43. Join tables using the closest datetime values
  44. Oracle tried to buy MySQL
  45. Multiple-index optimization not working for = ANY operator
  46. Re: Postgres using 100% CPU
  47. Re: I see this as the end of BDB in MySQL without a doubt.
  48. Dynamic datalogging function/scheme
  49. Connecting process to PostgreSQL works stunningly slow
  50. vacuumdb out of memory error
  51. function callback
  52. Date last vacuum
  53. Re: Does PG really lack a time zone for India?
  54. stateful UDF?
  55. Eliminating seconds fractions from timestamps?
  56. (NONE)
  57. pg_dump data filter/tree
  58. sqlite speed comparison
  59. switch / case in plpgsql functions
  60. Oracle purchases Sleepycat - is this the "other shoe" for MySQL AB?
  61. Time complexity of statements
  62. Minor Releases 7.3 thru 8.1 Available to Fix Security Issue
  63. Postgres using 100% CPU
  64. Object ownership in a new database
  65. differences between pg_dump and pg_restore with -t
  66. Unhandled Exception - Executing Samples under win32
  67. Get affected table name in trigger function?
  68. Re: Get affected table name in trigger function?
  69. altering objects owned by other user
  70. type int2vector
  71. differences between pg_dump and pg_restore with -t
  72. Re: Dropping a database that does not exist
  73. using schema-qualified names in INSERTs
  74. PG and Tivoli Data Protection
  75. indexes for ILIKE
  76. Debian apt-get
  77. "out of shared memory error" with temp tables
  78. dumb question
  79. Seeking comments on schema design and data integrity
  80. Re: implicit cast of empty string to timestamp
  81. Each foo must have a bar
  82. Out of memory error during updating huge table
  83. Storing a kazillion small blobs in postgresql. Smart?
  84. Last modification time
  85. Re: Last modification time
  86. Adding pl/perl support
  87. Return types of a function
  88. Limiting with a left outer join
  89. Re: Tool
  90. Sequence skipping values
  91. (NONE)
  92. Tool
  93. Re: Is there a way to limit CPU usage per user
  94. "psql -At -F" export column from table to .csv
  95. Dropping a database that does not exist
  96. backslash separated values for a field
  97. Re: implicit cast of empty string to timestamp
  98. Re: implicit cast of empty string to timestamp
  99. implicit cast of empty string to timestamp
  100. How to use pg_stat_activity correctly ?
  101. Re: Database Comparison tool?
  102. Re: Return more then one value using PL
  103. Re: r trim of characters other than space
  104. distinct not working in a multiple join
  105. Re: Update table with data from another table
  106. Re: PQputline error with pg_restore
  107. Re: PgAdmin3 for Suse AMD64
  108. Update table with data from another table
  109. PgAdmin3 for Suse AMD64
  110. Debian Packages For PostgreSQL
  111. Re: PQputline error with pg_restore
  112. Database Comparison tool?
  113. About CASE Studio - generate SQL output (how to link tablespace totable definition)
  114. Situation with delphi7 x postgresql 8.1.2
  115. referential integrity without trigger
  116. r trim of characters other than space
  117. Re: loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index"
  118. What's faster?
  119. Request to have VACUUM ignore cost based limits
  120. Re: owner as namespace?
  121. owner as namespace?
  122. Re: Insert into other database
  123. Insert into other database
  124. wal copies for high availability
  125. Create a new database from JDBC?
  126. Problem using ODBC from .NET framework
  127. plruby
  128. Confirming the autovacuum daemon is running
  129. Problem with sequence table
  130. Re: loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index"
  131. Postgre replication/clustering on 7.4 and RHEL AS 4
  132. loading pg_description ... FATAL: duplicate key violates unique constraint "pg_description_o_c_o_index"
  133. alter superuser...
  134. futex lockup?
  135. Is there a way to limit CPU usage per user
  136. B-tree performance improvements in 8.x
  137. Why pg_hba not in table?
  138. Re: Why pg_hba not in table?
  139. Re: what is the data type for files(.txt,.doc,.jpeg) in
  140. Syncing Databases Weekly
  141. Clarification Regarding Vacuum and template1
  142. Commercial Use
  143. UNION or OR / INTERSECT or AND ?
  144. Installation of PostGIS
  145. Sequences/defaults and pg_dump
  146. strange query runtime
  147. query
  148. what is the data type for files(.txt,.doc,.jpeg) in pgsql
  149. Trying to auto start Postgres when server boots up
  150. Any way to make PG driver obey PrintWarn?
  151. Re: SESSION_USER vs. CURRENT_USER
  152. SESSION_USER vs. CURRENT_USER
  153. Regex
  154. ODBC driver for ps81 win32
  155. About connect to server
  156. ftp download won't work
  157. Question
  158. Compile of Pgmail function fails
  159. change current user in pl/pgsql function
  160. Re: old style outer joins
  161. old style outer joins
  162. pg_dump, pg_restore
  163. Source ports for psql
  164. accidentally deleted rows
  165. Neat trick to make sure plpgsql is installed as part of a schema
  166. Array of Composite Type as Stored Procedure parameter.
  167. SELECT with REAL...
  168. update with subquery - unexpected results
  169. plpgsql direct from C?
  170. information_schema.columns.column_default filtered based on user
  171. System/database design question re schemas
  172. OTL ptogramming readiness recipes
  173. Socket command type I unknown
  174. Should I use PL/PGSQL or Perl/PGSQL?
  175. Error with temporary tables
  176. Bug with sequences and WAL ?
  177. How to find first non-vacation day
  178. grouping of functions
  179. performance about trigger (after insert, update, delete)
  180. Number format problem
  181. Postgres 7.3.2 -> 8.1.2 upgrade performance issue
  182. Number format problem
  183. Re: Alternative to knoda, kexi and rekall?
  184. PgSQL as part of commercial product
  185. error calling pgmail function
  186. News from IBM (DB2)
  187. Automating Backup
  188. Automating backup
  189. Logging queries
  190. logging settings
  191. C Language Stored Procedure Returning No Data
  192. =?ISO-8859-1?B?c3BlY2lmeWluZyB1bml4IGRvbWFpbiBzb2NrZXQgbmFtZQ ==?=
  193. eqpg doesn't like bit fields
  194. Any way to extract records from the WAL?
  195. question about MAKE_EXPIRED_TUPLES_VISIBLE
  196. Re: Alternative to knoda, kexi and rekall?
  197. dependencies between objects
  198. Re: How to find release notes
  199. How to find release notes
  200. plpgsql parameters
  201. Indexes again
  202. NULL values and string
  203. Primary keys for companies and people
  204. Creating views (Multiple Databases)
  205. pgsql on win xp user permissions
  206. postmaster startup time
  207. Stack Depth
  208. storing XML and querying
  209. Building html documentation
  210. Gotcha's in copying data between servers via file copy
  211. Concatenated VARCHAR becomes TEXT in view
  212. Re: Converting Text to Bytea
  213. Re: libpq questions
  214. Help in compiling 8.1.2 from source
  215. Passwords when changing users -> roles
  216. OID question
  217. PostgreSQL 8.1 without readline and zlib
  218. Converting Text to Bytea
  219. triggers and SELECT
  220. triggers, rules and alter table
  221. Re: PostgreSQL + hibernate
  222. returning a cursor from a function?
  223. Equivalent of a RECORD[] data type used in a function?
  224. Re: libpq questions
  225. Re: libpq questions
  226. Re: Data Conversion
  227. postmaster crash
  228. Data Conversion
  229. Re: plpython error logs
  230. help with locked table(s)/transactions(s)
  231. Best way to handle table trigger on update
  232. Re: execution plan : Oracle vs PostgreSQL
  233. Re: Automatic monitoring
  234. Postgres 8.1 for Mac
  235. bytea size + performance issues
  236. bytea size + performance issues
  237. size of bytea + performance issues
  238. size of bytea + performance issues
  239. Automatic monitoring
  240. size of bytea + performance issues
  241. size of bytea + performance issues
  242. size of bytea + performance issues
  243. size of bytea + performance issues
  244. size of bytea + performance issues
  245. size of bytea + performance issues
  246. function returns setof column type problems
  247. plpython error logs
  248. libpq questions
  249. looking for consulting
  250. How to enumerate/drop user sessions in windows