PDA

View Full Version : Pgsql General

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