PDA

View Full Version : Pgsql General

  1. pointer to feature comparisons, please
  2. Re: setof or array as input parameter to postgresql 8.2 functions
  3. pg_xlog - files are guaranteed to be sequentialy named?
  4. Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
  5. Plperl & create contstraint trigger
  6. Use of PROFILE in Makefiles
  7. PL/PGSQL rowtype return problem
  8. Re: Database performance problem
  9. Re: Database performance problem
  10. Foreign Key error
  11. Database performance problem
  12. PGSQL development tools. Any advice?
  13. Re: PL/PGSQL rowtype return pr
  14. INSERT ... RETURNING in v8.2
  15. Re: PL/PGSQL rowtype return pr
  16. PL/PGSQL rowtype return problem
  17. Date style handling changes between 7.4.12 and 8.2.4
  18. question regarding postgres
  19. Create a table B with data coming from table A
  20. trying to track down postgres deaths
  21. PostGreSQL for a small Desktop Application
  22. Materializing the relation
  23. Distributing PostGres database to various customers
  24. Functions that return both Output Parameters and recordsets
  25. transaction problem using cursors
  26. track ddl changes on single database
  27. automatically execute a function each day
  28. When should I worry?
  29. how to enforce index usage with +0
  30. How to count pairs?
  31. gist index on cube column
  32. odbc with encrypted ssl key?
  33. pg_hba.conf - md5
  34. performance problem with loading data
  35. parametered views
  36. Re: Postmaster processes taking all the CPU
  37. Re: Postmaster processes taking all the CPU
  38. Re: Postmaster processes taking all the CPU
  39. Re: Postmaster processes taking all the CPU
  40. Postmaster processes taking all the CPU
  41. Using the GPU
  42. Using the power of the GPU
  43. Disappearing table - suggestions on possible causes appreciated.
  44. Wider than float8
  45. MI5 Persecution: Goldfish and Piranha 29/9/95 (5705)
  46. MI5 Persecution: Watch Out, Forger About 27/9/95 (4191)
  47. MI5 Persecution: Question and Answer 27/9/95 (2677)
  48. MI5 Persecution: Options 21/9/95 (1163)
  49. Record Types Structure in PL/pgSQL
  50. Apparent Wraparound?
  51. Managing Kernal resource
  52. how to speed up query
  53. What's the correct way to use FunctionCallInvoke()?
  54. Re: [SQL] subtract a day from the NOW function
  55. cube problem
  56. list all columns in db
  57. Generate random password
  58. should the postgres user have a password?
  59. querying the age of a row
  60. the perfect mail archival system
  61. cube for real[]
  62. setting login database
  63. Record Types Structure in PL/pgSQL
  64. failing to start posgresql.
  65. last analyze time in 8.1?
  66. Postgresql 7.4.3/8.2.4 out of memory
  67. Limitations on 7.0.3?
  68. Re: Large Database \d: ERROR: cache lookup failed for relation ...
  69. Jumping Weekends
  70. Suppress checking of chmod 700 on data-dir?
  71. Inheritance and shared sequence
  72. Re: Looking for Graphical people for PostgreSQL tradeshow signage
  73. Numeric Sorting
  74. cube for real[]
  75. function problem
  76. testing new hardware
  77. formatting the output of a function
  78. Re: pl/pgsql debuging, was Re: debugging C functions
  79. String trim function - possible bug?
  80. using subselects
  81. Like operator
  82. wal files restoration
  83. plperl and/or insert trigger problem
  84. Re: Corruption of files in PostgreSQL
  85. Postgresql 7.4.3/8.2.4 out of memory
  86. Re: pl/pgsql debuging, was Re: debugging C functions
  87. Running v8.1 amd v8.2 at the same time for a transition
  88. Creditcard Number Security was Re: Encrypted column
  89. Re: lo or bytea streaming engine??
  90. Join field values
  91. Re: Large Database \d: ERROR: cache lookup failed for relation ...
  92. lo or bytea streaming engine??
  93. CREATE RULE with WHERE clause
  94. Database design wisdom needed
  95. Re: Encrypted column
  96. Foreign keys and indexes
  97. First cut for 8.3 RPM set
  98. $libdir
  99. Turn off logging
  100. Turn off logging
  101. PostgreSQL abnormally terminating with signal 5
  102. Re: Encrypted column
  103. Re: Inserting a path into Database
  104. COPY error
  105. Moving pg_xlog to another drive
  106. pg_dump: ERROR: could not open relation with OID ...
  107. current_date / datetime stuff
  108. Can someone have a look at my pg_hba.conf file ?
  109. what to do when pg_cancel_backend() doesnt work?
  110. Re: Corruption of files in PostgreSQL
  111. Re: Corruption of files in PostgreSQL
  112. Auto Vacuum question?
  113. simple select question
  114. Tablespaces
  115. changing 'mons' in interval?
  116. NULLS and User Input WAS Re: multimaster
  117. Re: general features
  118. Strange delimiters problem
  119. general features
  120. Need a wee bit more info on PostgreSQL's SSL security options
  121. insane index scan times
  122. Re: why postgresql over other RDBMS
  123. Stored Procedures and Functions
  124. Transactional DDL
  125. debugging C functions
  126. There can be only one! How to avoid the "highlander-problem".
  127. High-availability
  128. Re: Slightly OT.
  129. [Fwd: Re: Autovacuum keeps vacuuming a table disabled inpg_autovacuum]
  130. what happened with the news servers?
  131. ERROR: domain domain1 does not allow null values
  132. Multiple customers sharing one database?
  133. Interval Rounding
  134. Seq Scan
  135. Restoring 8.2 to 8.0
  136. Counting queries
  137. Autovacuum keeps vacuuming a table disabled in pg_autovacuum
  138. Re: invalid memory alloc after insert with c trigger function
  139. ERROR: domain domain1 does not allow null values
  140. Does slonik EXECUTE SCRIPT call waits for comands termination?
  141. user restriction
  142. where find recent binary PostgreSQL
  143. left outer join and values()
  144. shut down one database?
  145. invalid memory alloc after insert with c trigger function
  146. synchronisation with news.fr.postgresql.org?
  147. Encoding Sort order
  148. Permission denied for sequence
  149. how to use array with "holes" ?
  150. Numeric performances
  151. collision in serial numbers after INSERT?
  152. Operator whit word
  153. TSEARCH2: disable stemming in indexes and triggers
  154. warm standby server stops doing checkpoints after a while
  155. stable functions
  156. Make for PgSQL?
  157. PITR Base Backup on an idle 8.1 server
  158. removing a restriction
  159. REMOTE CONNECTION
  160. DRDB risk factors?
  161. Problems with createdb.exe and createuser.exe
  162. current transaction is aborted, commands ignored until end of transaction block
  163. pgpool redundancy question
  164. Design Table & Search Question
  165. Notification
  166. Problem - any password accepted
  167. table partitioning pl/pgsql helpers
  168. problem calling psql multiple times from a script ?
  169. On-line / off-line trace of SQL statements presented to the Postgres SQL engine
  170. Database activity monitoring
  171. Full vacuum may reclaim space
  172. jdbc pg_hba.conf error
  173. Question about corruption about openoffice file
  174. Corruption of files in PostgreSQL
  175. function retuning refcursor, order by ignored?
  176. TimeZone List
  177. prepare()
  178. 8.3
  179. SELECT <all fields except "bad_field"> from mytbl;
  180. monitor stats
  181. Re: problems with SELECT query results
  182. opclass for real[]
  183. problems with SELECT query results
  184. Languages and Functions
  185. Re: [HACKERS] Users specific to a Database
  186. psql Tab Completion in Windows
  187. Will a DELETE violate an FK?
  188. arrays in where
  189. postgres access - pg_hba.conf
  190. Monitoring Tool
  191. ERROR: cache lookup failed for type 0
  192. Call a program
  193. Possible DB corruption
  194. Inheritance question
  195. help with query
  196. Stored Procedures Performance: Java vs. PL/Pgsql
  197. Problem with pg_dump.
  198. server side LO
  199. help with query...
  200. application online upgrade strategy
  201. optimisation for a table with frequently used query
  202. hundreds of schema vs hundreds of databases
  203. Dear paypal customer!
  204. Different sort order
  205. table referencing several others
  206. cube
  207. Triggers to allow user create table?
  208. createdb.exe prompting for password on Vista
  209. Size of large object
  210. CUBE SYNTAX
  211. JOIN with ORDER on both tables does a sort when it souldn't
  212. Problems with "anyelement" after upgrading from 8.1.4 to 8.1.9
  213. SOLVED: Corrupted index file after restoring WAL on warm spare server
  214. How to create trigger if it does not exist
  215. backup strategies
  216. crash creating tsearch2 index
  217. can i recover the database to a certain point...
  218. 2 instance of postgres service running against same db files?
  219. Referencing any field in a trigger
  220. Wired behavor with LIMIT
  221. Best way to prevent overlapping dates
  222. ERROR: cache lookup failed for type 0
  223. Cannot get autovacuum configured
  224. Uhm, so, yeah, speaking of /.
  225. Inheritance question
  226. index vs. seq scan choice?
  227. Return rows from function with expressions
  228. Large Database \d: ERROR: cache lookup failed for relation ...
  229. Rookie Questions: Storing the results of calculations vs. not?
  230. Corrupted index file after restoring WAL on warm spare server
  231. Re: postgres - oid question
  232. postgres - oid question
  233. Re: Very big transaction in a stored procedure : how can i commit in the middle of it ?
  234. Very big transaction in a stored procedure : how can i commit in the middle of it ?
  235. Very big transaction in a stored procedure : how can i commit in the middle of it ?
  236. Re: Geographic data sources, queries and questions
  237. Limiting number of rows returned at a time in select query
  238. using bytea vartype non-prepared statements
  239. composite type array and index
  240. Re: Tsearch2: upgrading from postgres 8.1.x to 8.2.x
  241. why postgresql over other RDBMS
  242. Timestamp with time zone: why not?
  243. bytea & perl
  244. Delete with subquery deleting all records
  245. What does this error mean?
  246. Searching data across tables, some large
  247. Database Security
  248. the future of pljava development
  249. Re: query log corrupted-looking entries
  250. Need software infrastructure advice