View Full Version : Pgsql General



  1. Password authentication failed for user
  2. Update sql question
  3. CHAR LIKE VARCHAR
  4. Re: return two elements
  5. Re: return two elements
  6. how to get sequence list ?
  7. Postgresql fails to start?
  8. db corruption/recovery help
  9. Logging query plan for queries
  10. which commands under PostgreSQL do the similar func provided by "showprocesslist" under mysql
  11. Re: CPU-intensive autovacuuming
  12. return two elements
  13. pg_dump 8.0.3 failing against PostgreSQL 7.3.2
  14. Re: Large Object => invalid input syntax for integer: ""
  15. transactions
  16. Large Object => invalid input syntax for integer: ""
  17. Fyracle?
  18. Re: writting a large store procedure
  19. Download mirrors not found?
  20. CPU-intensive autovacuuming
  21. Getting the Type Definition in the information schema
  22. SELECT DISTINCT performance issue
  23. Re: How do I reinstall libeay32.dll
  24. Re: How do I reinstall libeay32.dll
  25. How do I reinstall libeay32.dll
  26. Preventing Multiple Inheritance
  27. postgresql books
  28. Referencing Serial Type as Foreign Key
  29. Test for array slice?
  30. PG Lightning Admin running on Linux via WINE 2005524
  31. Re: Automate Postgres Backup In windows -> resolved
  32. Re: PostgreSQL Developer Network
  33. Re: [SQL] index row size 2728 exceeds btree maximum, 27
  34. Re: Automate Postgres Backup In windows
  35. Re: Using pg_dump in a cron
  36. Re: SQL call to get pid of current connection
  37. PostgreSQL vs. InnoDB performance
  38. Re: SQL call to get pid of current connection
  39. SQL call to get pid of current connection
  40. adding columns with defaults is not implemented
  41. Limits of SQL
  42. Automate Postgres Backup In windows
  43. Using pg_dump in a cron
  44. Determining when a row was inserted
  45. Re: [SQL] index row size 2728 exceeds btree maximum, 2713
  46. Automate Postgres Backup In windows
  47. Re: Stats not getting updated....
  48. Re: index row size 2728 exceeds btree maximum, 2713
  49. writing a file using procedure
  50. Re: [SQL] index row size 2728 exceeds btree maximum, 2713
  51. Stats not getting updated....
  52. One Sequence for all tables or one Sequence for each table?
  53. writting a large store procedure
  54. Deleting orphaned records to establish Ref Integrity
  55. Re: SRFs returning records from a view
  56. SRFs returning records from a view
  57. hpw to Count without group by
  58. Status of interactive psql's error handling?
  59. Question about backing up partial Database
  60. Re: [UMN_MAPSERVER-USERS] FYI: Google to pay student open source developers
  61. Autonomous Transactions
  62. Old problem needs solution
  63. Can I catch sentences in SQL using triggers?
  64. SQL question.
  65. Newby to DB
  66. TableSpaces across partitions and xlog
  67. MD5 computation (was: RE: For Tom Lane)
  68. Issue with OS X
  69. unsubscribe
  70. freebsd port successful/failed install
  71. US Phone Number Data
  72. How to wait until startup completes
  73. Primary key column numbers...
  74. using pg_dump to dump only a schema?
  75. Re: Primary key column numbers...
  76. Re: [PORTS] Major flood of mail to lists ...
  77. postgreSQL 7.3.8, pg_dump not able to find large object
  78. prevent user change password?
  79. Re: For Tom Lane
  80. interval integer comparison
  81. Missing numbers
  82. tsearch2 + trigram pairing
  83. Accessing PostgreSQL from C++
  84. database auto-commit
  85. pg_get_serial_sequence and table inheritence
  86. How to add an INHERITS to an already populated table ?
  87. a way to reset the postgres password to nothing..
  88. Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
  89. setting up default user
  90. Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
  91. Connecting to Postgres from LAN
  92. Re: Postgres under Windows
  93. Index usage without enable_seqscan
  94. Re: Postgres under Windows
  95. Postgres under Windows
  96. Problem with void integer
  97. Subselects - recursion problem
  98. Carriage return in text fields
  99. Re: [Pypgsql-users] Timestamp with and without time zone...
  100. DBD::Pg for ActiveState Perl on WinXP
  101. Re: Fast request for version checking....
  102. Re: Fast request for version checking....
  103. kernels performance difference
  104. Fast request for version checking....
  105. Re: another failover testing question
  106. Re: enable_sort optimization problem
  107. Question: migrate
  108. solaris 10 vs Linux Debian on SUN Fire v40z
  109. Re: another failover testing question
  110. Re: Query for importing and exporting data from a database
  111. relocation error-urgent
  112. Visual Studio 2005 .Net -> Npgsql -> Postgresql
  113. libpq.so.3 problem, PostgreSQL >= 8.0.2 and RPM installations
  114. Re: Locking rows
  115. Re: another failover testing question
  116. Re: Just a crazy idea!
  117. Just a crazy idea!
  118. Trigger and arguments question
  119. Re: maintenance_work_mem upper limit =1gb??
  120. Archiving solution
  121. another failover testing question
  122. Re: pg_listener records
  123. pg_listener records
  124. maintenance_work_mem upper limit =1gb??
  125. postgresql, pgaccess and tcl/tk (in X11)
  126. Strongly-Typed Refcursor (PowerBuilder Datawindow Clients)
  127. Portability of pgsql database files.
  128. unsupported frontend protocol
  129. Can postgresql catch all the sentences applies to one table?
  130. Query for importing and exporting data from a database
  131. Bgwriter--- BufferSync() and StrategyStatsDump()
  132. bulk loading of bplus index tree
  133. enable_sort optimization problem
  134. Modulus operator returns negative values / numeric division roundsup sometimes
  135. Re: plpython error since upgrading from 7.x to 8.x
  136. unsupported frontend protocol
  137. Re: Compiling Postgresql 8.0.3 on Solaris 10
  138. survey of the postgresql communiity
  139. Compiling Postgresql 8.0.3 on Solaris 10
  140. Re: plpython error since upgrading from 7.x to 8.x
  141. Advice
  142. Re: More detailed error logging?
  143. triggers/functions across databases
  144. Re: postmaster fails to start
  145. plpython error since upgrading from 7.x to 8.x
  146. More detailed error logging?
  147. postmaster fails to start
  148. Re: getting lock information
  149. Re: getting lock information
  150. International Characters
  151. reporting solution for postgresql
  152. getting lock information
  153. Re: table synonyms
  154. pg_autovacuum WinXP service
  155. Update on tables when the row doesn't change
  156. Using PG 8.0 with OpenSSL
  157. Performance question
  158. Re: how to unsubscribe
  159. PostgreSQL release schedule
  160. unsubscribe
  161. Unsubscribe
  162. Does SELECT INTO is affected by default_tablespace?
  163. bigserial coloumn
  164. Re: table synonyms
  165. Re: pg_dump in a production environment
  166. urgent: another postmaster
  167. pg_dump in a production environment
  168. Re: pointers to sql standard, or "most common" sql?
  169. pointers to sql standard, or "most common" sql?
  170. Re: How to recover from : "Cache lookup failed for rela
  171. Re: C++-Language Function/Process List
  172. Re: C++-Language Function/Process List
  173. Re: How to recover from : "Cache lookup failed for rela
  174. Problem merging two rows into same primary key
  175. Re: How to recover from : "Cache lookup failed for rela
  176. Re: How to recover from : "Cache lookup failed for rela
  177. Hash join operator question
  178. Re: Postgresql .NET Data Provider for Visual Studio 2005
  179. Re: Postgres PHP error
  180. PITR restore hot standby
  181. Hash join operator question
  182. Postgres PHP error
  183. Postgresql .NET Data Provider for Visual Studio 2005 beta
  184. Re: table synonyms
  185. Re: table synonyms
  186. How to recover from : "Cache lookup failed for relation "
  187. Re: double quotes inside VBA string ?
  188. Re: table synonyms
  189. Binary installation RPM's from Mandrake 10.1.
  190. GnuPG / PGP signed checksums for PostgreSQL 7.2.8, 7.3.10, 7.4.8, and 8.0.3
  191. GnuPG / PGP signed checksums for PostgreSQL 8.0.2
  192. Re: table synonyms
  193. Exception Handling in C-Language Functions?
  194. GCC 4.0 on Mac OS X
  195. Re: table synonyms
  196. starting postgresql with pgsql password - workarounds?
  197. Finding IP of front end
  198. problems with Win 2000
  199. Error during install on WinXP
  200. Schemas - alter table
  201. Re: Linux user authentication problem
  202. filling database
  203. Execution shell commands from Function
  204. Re: triggers using the correct schema ..
  205. triggers using the correct schema ..
  206. guids / bytea and index use ?
  207. XA connection problem
  208. Fabrica a record in PL/PGSQL
  209. materialized view
  210. securing an information system
  211. Re: numeric precision when raising one numeric to another.
  212. Re: 8.0.3 build error on Mac OS X 10.4
  213. Locale C?
  214. Re: Image storage questions
  215. Re: bulk loader
  216. bulk loader
  217. Re: numeric precision when raising one numeric to another.
  218. Re: numeric precision when raising one numeric to another.
  219. Re: numeric precision when raising one numeric to another.
  220. Re: preserving data after updates
  221. Re: 8.0.3 build error on Mac OS X 10.4
  222. Re: numeric precision when raising one numeric to another.
  223. Re: numeric precision when raising one numeric to another.
  224. Temp tables as session var containers
  225. TSearch2 & Phonemes
  226. unique index with bool
  227. Shared memory and FreeBSD's jail()
  228. Postgresql 7.4.7 docs(PDF)
  229. Preserving data after updates
  230. Re: Count and Results together
  231. Postgres in government
  232. need clarification
  233. Callable Statements are not supported at this time
  234. Ayuda con postgresql
  235. Call dynamic PL/PGSQL function
  236. analyze at startup?
  237. CREATE TABLE problem in plpgsql trigger
  238. error explanation
  239. How can I write trigger on a columns insert/update?
  240. Re: Executing Dynamic DDL
  241. Is postgresql 8.xx jdbc support SCROLL_SENSITIVE?
  242. 8.0.3 build error on Mac OS X 10.4
  243. Re: Newbie question
  244. numeric precision when raising one numeric to another.
  245. Image storage questions
  246. Re: Distinguishing between connections in pg_hba.conf
  247. Re: OLAP with PostgreSQL
  248. connecting to server process via sockets
  249. Relation between pgsql_tmp and work_mem
  250. Sequences question & problem