View Full Version : Pgsql General



  1. Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2. JOIN on set of rows?
  3. SECURITY RELEASES: 7.2.8 - 7.3.10 - 7.4.8 - 8.0.3
  4. sequence values question
  5. Hosting options on Postgres - what's best?
  6. psqlodbc / Solaris 10
  7. Loading a list of SQL scripts with relative paths
  8. pg_dump fails on 7.4 Postgres
  9. pg_dump problem Postgres 7.4
  10. Re: Data Modelling Tools
  11. database export in pgsql
  12. Delphi - Developers start develop Access components for Postgres?
  13. ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)
  14. alter views
  15. Re: Adventures in Quest for GUI RAD
  16. Log Analyzer
  17. Array manipulation/syntax question
  18. Re: Data Modelling Tools
  19. Re: Data Modelling Tools
  20. Data Modelling Tools
  21. Re: PostGreSQL -> SQL server
  22. Re: WHERE
  23. Re: WHERE
  24. WHERE
  25. Re: Clustering Database Servers
  26. Trigger that spawns forked process
  27. Clustering Database Servers
  28. PostGreSQL -> SQL server
  29. Function to return number of words in a string?
  30. Re: aide postgres
  31. bug in Postgresql?
  32. aide postgres
  33. Postgres and GnuPlot
  34. createdb rftDatabase error and error of standard in must be a tty
  35. need trigger help
  36. Need input on postgres used for phpBB
  37. Re: Any experiance with PostgreSQL and SQLRelay
  38. function call error
  39. Re: Adventures in Quest for GUI RAD
  40. Samba server Error
  41. Re: Adventures in Quest for GUI RAD
  42. starting
  43. Shorthand for foreign key indices
  44. Re: [HACKERS] Invalid unicode in COPY problem
  45. Re: [HACKERS] Invalid unicode in COPY problem
  46. Re: [HACKERS] Invalid unicode in COPY problem
  47. Invalid unicode in COPY problem
  48. Functions!
  49. with or without timezone?
  50. inherit with foreign key reference
  51. pg_ctl bug or feature?
  52. Connecting to Postgres using Rekall
  53. Error connecting to remote socket
  54. SQL History
  55. Re: Adventures in Quest for GUI RAD
  56. Error connecting to remote socket
  57. Duplicate key error when updating unique columns
  58. Question about running "Vacuum" through JDBC
  59. Re: postmaster crash - another server process exited abnormally
  60. Extracting date from timestamp
  61. Cursor problem
  62. postmaster crash - another server process exited abnormally
  63. plphp1.1 make fails
  64. Re: Adventures in Quest for GUI RAD
  65. Re: Adventures in Quest for GUI RAD
  66. Re: Adventures in Quest for GUI RAD
  67. Wht all database profiler / performance monitoring tools are available
  68. Anyone doing a 8.0.2-x86_64-RHEL4.rpm?
  69. Adventures in Quest for GUI RAD
  70. "current transaction is aborted, commands ignored until end of transactionblock" Error
  71. Unicode and unaccent()
  72. Re: Booleans - Why in Postgres and not in Oracle or Mysql?
  73. Re: Booleans - Why in Postgres and not in Oracle or Mysql?
  74. Booleans - Why in Postgres and not in Oracle or Mysql?
  75. Re: ECPG - Timestamp to ascii Conversion PG version 7.4
  76. ECPG - Timestamp to ascii Conversion PG version 7.4
  77. Postmaster not reporting number of connections correctly
  78. Select of a function that returns a array
  79. Slony v. DBMirror
  80. Postgres, tablespaces, and quotas
  81. Howto prevent write based on date
  82. Inserting a record into another table ... inside a schema
  83. can I send execution log into a file.
  84. Re: Postgres 8.02 connectivity
  85. Re: Postgres 8.02 connectivity
  86. Postgres 8.02 connectivity
  87. Rpm packaging of 8.0.2 libraries
  88. postgresql replication
  89. Re: [INTERFACES] calculated identity field in views,
  90. plpythonu and booleans
  91. Tablespaces on partition with quotas
  92. Re: Postgres vs Firebird?
  93. Re: Postgres vs Firebird?
  94. Re: Postgres vs Firebird?
  95. Postgres vs Firebird?
  96. nonremovable row ?
  97. plpython bug
  98. Re: [ADMIN] Postgre 8.0 for Linux i586
  99. Re: Rekall for Debian ?
  100. Rekall for Debian ?
  101. remote tcp connection problem PG 8.0.1
  102. Re: Favorable Postgresql write up
  103. Postgre 8.0 for Linux i586
  104. getting the ranks of items
  105. Re: Very interesting article about the future of databases
  106. Very interesting article about the future of databases
  107. default column value using a function, trigger, or whatever
  108. Re: plpythonu and dollar quoting
  109. Re: Favorable Postgresql write up
  110. Interesting article on transactional algorithms includes PostgreSQL study
  111. plpythonu and dollar quoting
  112. Favorable Postgresql write up
  113. Re: 7.3.9 Install Question - init.d/postgresql error?
  114. unsubscribe
  115. Date addition/subtraction
  116. Sorting by constant values
  117. Adding Records With SERIAL Primary Key
  118. MVCC and insert
  119. pgEdit 1.1 beta
  120. Re: Deep integration of PostgreSQL with Apache
  121. Re: Deep integration of PostgreSQL with Apache
  122. does database shut down cleanly when WAL device fails?
  123. Dynamically access to field on a RECORD variable
  124. postgresql 8 abort with signal 10
  125. Re: some questions : psql
  126. Deep integration of PostgreSQL with Apache
  127. some questions : psql
  128. query is wery slow with _t() function
  129. Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems
  130. Security
  131. PostgreSQL 8.0.2 and Tiger
  132. 7.3.9 Install Question - init.d/postgresql error?
  133. DBmirror replication - replacement for DBMirror.pl
  134. unable to open editor.
  135. Persistent Connections in Webserver Environment
  136. scripts in Postgres
  137. Python DB-API 2.0 oddity (was: I receieved an example of Rekall script)
  138. Function call identification
  139. Re: could not load library plperl.so
  140. 'prepare' is not quite schema-safe
  141. could not load library plperl.so
  142. libpq and PQexecPrepared
  143. Can't compile plphp
  144. $BFMA3$N%a!<%k$r$5$;$FD:$-$^$7$?!#(B
  145. Using pgcrypto with AES-256 bits?
  146. Re: [ODBC] retrieving images stored by php / pgsql
  147. Re: [ODBC] Adventures with P2P and Scripts in Windows
  148. Re: Problem while using commit..
  149. VB ODBC connection to Postgresql, DAO,ADO,RDO,DSN???
  150. Re: the eternal tunnig question
  151. Re: Fatal error
  152. the eternal tunnig question
  153. Fatal error
  154. success with p2p ip connection
  155. Re: Postgres filling up hard drive with swap files
  156. "Other users on Template1" when there aren't any
  157. more experiments with p2p ip connection
  158. p2p ip connection problems
  159. Re: ip connection on local p2p network
  160. ip connection on local p2p network
  161. win-1251 cyrillic support ?
  162. Tuning queries inside a function
  163. Re: Increasing statistics results in worse estimates
  164. Re: Increasing statistics results in worse estimates
  165. Composite types as columns used in production?
  166. out of memory for query result
  167. Problem: message type 0xxx arrived from server while idle
  168. casting unnamed row types
  169. Re: Postgresql and VBA vs Python
  170. Re: GUITools update
  171. Re: GUITools update
  172. temp tables ORACLE/PGSQL
  173. Re:
  174. Increasing statistics results in worse estimates
  175. Postgresql and VBA vs Python
  176. oid or schema name of current plpgsql function
  177. info on strange error messages on postgresql
  178. Clustering
  179. OT: phpPgAdmin
  180. Linux Journal Users' Choice Award Nominations
  181. Clarification
  182. ERROR: Could not convert UTF-8 to ISO8859-1
  183. Help
  184. Help
  185. Thanks for insights into internal design
  186. Problem with GIST-index and timestamps
  187. temp tables ORACLE/PGSQL
  188. Free rekall for Postgresql
  189. Postgresql, Windows, Peer-2-Peer network
  190. Visual Query Builder
  191. I must be daft, but I can't figure out what is wrong with this
  192. SPI cursors pinned buffer and moving to the first tuple.
  193. missing chunk number 0 for toast value
  194. Thanks for Rekall link!
  195. Re: populating a table via the COPY command using C code.
  196. Serial / auto increment data type
  197. on insert rule & primary key
  198. Re: populating a table via the COPY command using C code.
  199. dump and restore a single table containing large objects
  200. restarting after power outage
  201. populating a table via the COPY command using C code.
  202. Re: After insert trigger question
  203. Reduce size of $PGDATA for "demo cdrom"?
  204. After insert trigger question
  205. Query Designer
  206. free WINDOWS rekall?
  207. Why sequential scan for currval?
  208. Re: Change Windows path to Unix path...
  209. Re: Performance difference between ANY and IN, also array syntax
  210. www.thekompany.com rekall
  211. Performance difference between ANY and IN, also array syntax
  212. subqueries and qualification of table names
  213. blob storage
  214. Re: UltraSPARC versus AMD - Slowaris
  215. Re: PRIMARY KEY on a *group* of columns imply that each column is NOT NULL?
  216. PRIMARY KEY on a *group* of columns imply that each column is NOT NULL?
  217. plruby on Windows
  218. Query Designer
  219. Re: Calculated bigserial column in a view
  220. Re: UltraSPARC versus AMD
  221. About index - "a query or data manipulation command can use at mostone index per table"
  222. out of memory
  223. Re: Change Windows path to Unix path...
  224. Change Windows path to Unix path...
  225. Intervals
  226. oid wraparound
  227. jdbc3 and ResultSet.getFetchSize()
  228. savepoints
  229. Re: optimal hardware for postgres?
  230. Re: Toad Adm. Datasource Location
  231. Postgres source (tar file) for Fedora Core OS?
  232. I can't create a new database with GB18030 encoding
  233. pgadminIII - creating servers
  234. pgexplorer adm
  235. Corruption on production system
  236. Re: Intuitive Software and Mario Brothers
  237. Toad Adm. Datasource Location
  238. Re: rollback vs. commit for closing read-only transaction
  239. rollback vs. commit for closing read-only transaction
  240. Re: plpgsql function not working
  241. plpgsql function not working
  242. unsubscribe
  243. DDL from psql console?
  244. installation as service failed on windows xp
  245. Re: What does "tuple concurrently updated" mean?
  246. Re: Pgpool questions
  247. Hosting Service Recommendations
  248. column size in libpq
  249. Help-Urgent
  250. SQLException "Connection is closed. Operation is not permitted"