PDA

View Full Version : Pgsql General

  1. schema 8.1.5
  2. Effect of large text field data on queries
  3. Compiling ELF 64-bit on Solaris
  4. more than 32 parameters to a function?
  5. Updating client table definitions from server tables without losing client data
  6. PostgreSQL uses in the weather service
  7. =?iso-2022-jp?B?GyRCRD5AXDhyPkQkNyReJDskcyQrISkbKEI=?=
  8. UK Hosting Providers
  9. pg_autovacuum / pg_class
  10. [Triggers] Check if OLD or NEW records are NULL
  11. grouping excluding some text results
  12. Reducing pg_dump & pg_restore times
  13. pg_dumpall failing from possible corrupted shared memory
  14. pg_dumpall failing
  15. NOTICE: word is too long INSERT 0 3014
  16. Enableing contrib modules on Debian
  17. Compiling ELF 64-bit on Solaris
  18. Problem with 8.1.5 RPMs for Redhat AS 4
  19. Postgres history and the 30th Anniv. of Ingres, gathering at UCB...
  20. Monitoring Postgres - Get the SQL queries which are sent to postgres
  21. password cookie
  22. Re: DBI-Link, Oracle, database encoding
  23. DBI-Link, Oracle, database encoding
  24. Difficulty passing in an array of values to EXECUTE SELECT statement
  25. Re: [pgsql-es-ayuda] identificar usuario con registro en una tabla
  26. How to get joins to work
  27. 8.2beta1 installation fails
  28. Google Co-op
  29. Re: recovery from xid wraparound
  30. Re: recovery from xid wraparound
  31. regarding PostgreSQL
  32. What is causing 'canceling statement due to user request' ?
  33. How to improve ODBC performance
  34. Re: recovery from xid wraparound
  35. PostgreSQL in article I wrote
  36. postgres under Suse linux
  37. Re: recovery from xid wraparound
  38. Re: recovery from xid wraparound
  39. recovery from xid wraparound
  40. recovery from xid wraparound
  41. missing FROM-clause entry
  42. failing 8.1.4 autovacuum
  43. Any documentation about cayenne
  44. Fw: [ANNOUNCE] == PostgreSQL Weekly News - October 22 2006 ==
  45. Re: Encoding problem
  46. postgresql-python-3.8.1-3PGDG.i686.rpm
  47. Encoding problem
  48. Re: strange encoding behavior
  49. Re: How to determine initdb parameters on old database?
  50. Postrgres Sequence Error
  51. Column Deletion
  52. storage size of "bitstring"?
  53. How to find out about zlib compression
  54. Wordpress & PostgreSQL ...
  55. Re: Log-based repliaction?
  56. 8.2 release schedule
  57. Log-based repliaction?
  58. old duplicate emails
  59. Custom types and array equality
  60. Runaway functions killed all active connections
  61. unstable postgres on freebsd
  62. strange encoding behavior
  63. SQL injection in a ~ or LIKE statement
  64. Question with tsearch2 (or it might be a general one too)
  65. c (lowercase) privilege
  66. PostgreSQL, LGPL and GPL.
  67. Upgrade 7.4 to 8.1 or 8.2?
  68. skip duplicate key error during inserts
  69. Re: Link error: LNK2019: unresolved external symbol _pg_detoast_datum
  70. Where is the pg_terminate_backend() function? Way to execute shellcmd
  71. Performance: fsync vs. commit delay
  72. why not kill -9 postmaster
  73. Ghost open transaction
  74. verifying data integrity after migrating for postgres 7.3 to postgres 8.1
  75. plpgsql FOUND bug when SELECT INTO assigns a NULL value?
  76. SQL function inlining
  77. Some newbie question
  78. Latest /etc/rc.d/init.d/postgresql startup/shutdown script
  79. VACUUM and open transactions
  80. Ubuntu Help
  81. Help needed
  82. pg_dump encoding problem
  83. Re: Overload after some minutes, please help!
  84. PostGIS
  85. Re: hardware failure - data recovery
  86. Re: Overload after some minutes, please help!
  87. Re: Overload after some minutes, please help!
  88. PostgreSQL and Munin
  89. Re: Overload after some minutes, please help!
  90. timestamp as primary key?
  91. Interval referential integrity
  92. trigger postgresql 7.4
  93. problems installing pg on solaris
  94. Is it possible to port from Postgres to Versant
  95. Newbie needs help with ERROR: could not write to file "base/16390/2682": No space left on device
  96. hardware failure - data recovery
  97. Link error: LNK2019: unresolved external symbol _pg_detoast_datum
  98. column refernce question
  99. Drop All the Databases
  100. division by zero error in a request
  101. Stats Collector Won't Start
  102. increasing LIMIT with ORDER BY changes queryplan (7.4)
  103. Information regarding currently locked tables
  104. Re: Maximum size of database
  105. Moving postgres users accounts from one postgres 7.3 to postgres 8.0
  106. Re: help with sql query
  107. Urgen help required
  108. Cannot connect to Fedora Core 5 server from the network
  109. COPY FROM STDIN instead of INSERT
  110. Is Postgres good for large Applications
  111. Connection Pooling for Postgres
  112. Postgres Database Slow
  113. FastCgi / PostgreSQL: FATAL: Ident authentication failed for user "user_name"
  114. Maximum size of database
  115. Fixed-point scalars?
  116. Strange behavior on non-existent field in subselect?
  117. not so sequential sequences
  118. uuid c function contrib
  119. Re: Database users Passwords
  120. help with sql query
  121. How to _really_use a non-default tablespace
  122. Database users Passwords
  123. ERRORDATA_STACK_SIZE exceeded
  124. Re: Any documatation about porting from Oracle to PostgreSQL
  125. Can we convert from Postgres to Oracle !!???
  126. Re: Any documatation about porting from Oracle to PostgreSQL
  127. Using Sockets in postgres
  128. Permission problem with create tablespace
  129. pg_locks: who is locking ?
  130. calling two shared objects in one single function call
  131. datatype preceded by underscore creates array
  132. function for current date-time
  133. difference b/w text and varchar datatypes
  134. old Pg interface
  135. Real time query analyzer
  136. Dates rejected
  137. ERROR: current transaction is aborted, commands ignored until end of transaction block
  138. Fast backup/restore
  139. techdocs.2 how long has this be around?
  140. postgres' web site malfunctional ?
  141. Re: SPAM: Re: [SLE] SPAM: AMD Dual core "clock speed"
  142. Data visibility
  143. Same-page UPDATEs in bloated tables
  144. How to make a copy of schema
  145. Triggers
  146. Aggregate in Correlated SubQuery
  147. a math function with error handling
  148. BEGIN WORK READ ONLY;
  149. Re:
  150. PostgreSQL Shared Memory and Semaphors
  151. Performance problem
  152. SQL syntax error handling within SPI functions in C
  153. problem with using O_DIRECT
  154. Backup DB not getting connected
  155. Query
  156. Server Added Y'day. Missing Today
  157. Re: looping through query to update column
  158. Postgresql 6.13
  159. Re: looping through query to update column
  160. Partitioning vs. View of a UNION ALL
  161. Execute a function upon a connection made/closed
  162. encoding problem
  163. Re: looping through query to update column
  164. Performance Problem
  165. Postgresql guidelines for version numbering
  166. Create Index on Date portion of timestamp
  167. Re: Storing images in PostgreSQL databases (again)
  168. looping through query to update column
  169. A query planner that learns
  170. Error handling inside PL/pgSQL functions
  171. Question on MD5 authentication
  172. bad error message
  173. some log statements ignored
  174. Searching a tool [like XAMPP on linux] of linux/apache/pgsql/php installer
  175. Re: Can a function determine whether a primary key constraint exists on a table?
  176. Can a function determine whether a primary key constraint exists on a table?
  177. cursors and ASP page
  178. Override system-defined cast?
  179. user defined aggregate with multiple arguments
  180. CUBE, ROLLUP, GROUPING SETS?
  181. Automatic row numbering / sequence in view ?
  182. Storing Procedures / Transactions
  183. Looping through Arrays
  184. strange error when inserting via a SRF into a table with a foreign key constraint
  185. Re: [Slony1-general] Using slony with many schema's
  186. invalid data in PID file
  187. Is it possible to return custom type as proper ROW?
  188. rewriting query to move filter conditionout of a subselect
  189. How does PG access wal files?
  190. STABLE functions
  191. Schema - update search_path
  192. Re: [PERFORM] Postgre 8.0 Installation - Issues
  193. Re: [HACKERS] Clarification needed
  194. Versioning/updating schema
  195. left outer join on multi tables
  196. Re: restoring a file system backed-up data dir
  197. restoring a file system backed-up data dir
  198. Re: more anti-postgresql FUD
  199. more anti-postgresql FUD
  200. Find out the number of rows returned by refcursor?
  201. Problem with executing PostgreSQL on Embedded Linux
  202. time type strange behaviour
  203. Automatic row numbering / sequence in view ?
  204. Re: [PERFORM] Postgre 8.0 Installation - Issues
  205. Re: [PERFORM] Postgre 8.0 Installation - Issues
  206. Re: adjusting primary key
  207. adjusting primary key
  208. List of supported 64bit OS
  209. Problem compiling PostGIS 1.1.4
  210. Newbie question about importing text files...
  211. query optimization with UDFs
  212. Size of tuples
  213. pg_autovacuum taking locks on multiple tables at the same time
  214. Re: Determining caller of a function (due to a cascaded
  215. plpgsql handling a set of values
  216. postgres query log analysis?
  217. Re: Intentionally produce Errors
  218. Intentionally produce Errors
  219. database corruption question
  220. column privileges
  221. pg_dump VS alter database ... set search_path ...
  222. refcursor error 55000
  223. Automatic locale detection?
  224. PL/SQL: function call like $1($2)
  225. failure to connect to postgres DB via pg.el
  226. EXECUTE command in stored procedure
  227. predefined functions
  228. Problem with a date when restoring on postgresql 7.4.9 : date/timefield value out of range
  229. please how to unsuscribe to list
  230. increment row number function question
  231. performace review
  232. Re: failure to connect to postgres DB via pg.el
  233. time conversion fuinctions
  234. How to force the parser to use index scan instead of sequential scan
  235. =?iso-2022-jp?B?GyRCSzskNyQkJEckOSQrISkbKEI=?=
  236. exploiting features of pg to obtain polymorphism maintaining ref.integrity
  237. Alter table alter column
  238. shared_buffer setting
  239. Re: Storing images in PostgreSQL databases (again)
  240. how to get number of minutes?
  241. Re: Installation on mandriva 2006
  242. Re: Storing images in PostgreSQL databases (again)
  243. PL/SQL Optimum search
  244. URGENT - startup process (PID 29541) was terminated by signal 6
  245. UTF-8
  246. Re: storing transactions
  247. DELETE eats up all memory and crashes box
  248. server closed the connection unexpectedly
  249. Europe/Moscow timezone
  250. postgresql /var fill