PDA

View Full Version : Pgsql General

  1. Where
  2. Ordering and unicode
  3. Locale/Indexing
  4. run vacuum from within a function
  5. PREPARE TRANSACTION and webapps
  6. Performance of autovacuum and full vacuum of database
  7. help with writing stored procedure
  8. Re: How to install Slony in windows
  9. How to install Slony in windows
  10. save history error, ignorable?
  11. I must not understand the permissions system
  12. Re: Hanging creating of function
  13. [Fwd: I must not understand the permissions system]
  14. TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE
  15. plpgsql using EXECUTE function
  16. Compiling libpq on Windows
  17. time zone - timestamp
  18. pgdump from 8.0.4 not valid for import into 8.1.0
  19. Time trigger
  20. Re: Windows installer fails for 8.1
  21. PL language selection
  22. Windows installer fails for 8.1
  23. Re: Postmaster failing to start on reboot
  24. Re: Postmaster failing to start on reboot
  25. Re: Postmaster failing to start on reboot
  26. script
  27. Dynamic web sites with PostgreSQL
  28. Re: [ANNOUNCE] PostgreSQL 8.1.0 RPMs are available for download
  29. 8.1.0 for RH8 here
  30. Kudos to the pgAdmin3 Team
  31. set-valued function difference in 8.1.0 vs 8.0.2
  32. build errors on MacOSX
  33. invalid UTF-8 byte sequence detected
  34. Re: Hanging creating of function
  35. Hanging creating of function
  36. Foreign key reference causes invalid DELETE trigger calls
  37. using new bitmap scans to index bit columns?
  38. Where Statement
  39. libpq version in rpm packages
  40. Re: resetting superuser password
  41. PostgreSQL now() function returns incorrect time
  42. Error in installation of PostGIS in new PostgreSQL 8.1
  43. psql scripts
  44. Question on Insert / Update
  45. Postmaster failing to start on reboot
  46. How to obtain the code af a function ?
  47. resetting superuser password
  48. insert on duplicate update?
  49. Debian packages
  50. temporary tables
  51. PostgreSQL 8.1.0 RPMs are available for download
  52. psql error on quitting...
  53. PostgreSQL 8.1.0 Officially Released
  54. Re: psql error on quitting...
  55. Transactions, Triggers and Error Messages
  56. clustering by partial indexes
  57. Re: Transactions, Triggers and Error Messages
  58. Re: Transactions, Triggers and Error Messages
  59. Transactions, Triggers and Error Messages
  60. Re: Connect to a database in a .sql file
  61. upgrading from backend version 811 to 812
  62. Re: Programmatic method to determine currently installed Windows PostrgreSQL version
  63. Re: [ANNOUNCE] PostgreSQL 8.1.0 Release Candidate 1
  64. Number of items in a cursor...
  65. newbie design question re impact of VACUUM
  66. Detect Locked Row Without Blocking
  67. WinXP - statistics collector errors
  68. Schemas shown in ODBC
  69. autovacuum,8.1, Win
  70. database export problem
  71. Beyond the 1600 columns limit on windows
  72. ident client authentication
  73. unsubscribe
  74. odbc in postgresql and php
  75. Perl::DBI and interval syntax
  76. [OTAnn] Feedback
  77. Get One item from an array..
  78. Re: Programmatic method to determine currently installed Windows PostrgreSQL version
  79. Programmatic method to determine currently installed Windows PostrgreSQL version
  80. PROBLEM: Function does not exist
  81. Re: PostgreSQL, UTF-8 and Mac OS X
  82. Re: PostgreSQL, UTF-8 and Mac OS X
  83. Re: I just can't get it:record_in, record_out(I know i try to do something postgres is not developed for but there are many 'buts')
  84. Re: Aggregates, group, and order by
  85. Recuperate each line of a result into a variable ?
  86. Re: Aggregates, group, and order by
  87. Aggregates, group, and order by
  88. PygreSQL ByteA
  89. Connect to a database in a .sql file
  90. Subqueries
  91. CREATE TEMP TABLE AS ... ON COMMIT DROP fails
  92. Best way to use indexes for partial match at beginning
  93. Question about 8.1 release news
  94. How to create a virtual column
  95. Setting max_fsm_pages
  96. sequence aliases?
  97. joining a query with a select count(*)
  98. Missing variable "role" in "pg_settings"?
  99. Duplicate Row Removal
  100. I just can't get it:record_in, record_out(I know i try to do something postgres is not developed for but there are many 'buts')
  101. Missing seconds in a date (timestamp)
  102. pl/pgsql list as parameter.
  103. Division
  104. Re: Bug in Role support?
  105. BLOB and OID
  106. tablename.columnname notation for columnnames of joined tables
  107. Using native win32 psql.exe using alternative cygwin terminal
  108. records to text representation
  109. Array Values and References
  110. Image File System Question
  111. Array in a Type
  112. Looping through arrays
  113. Postgresql connection on suse 10
  114. Re: OT It is here: Oracle 10g Express
  115. Re: Changing ids conflicting with serial values?
  116. Re: Remotely reload server config?
  117. Querying for related tables
  118. Save prepared plan...
  119. Remotely reload server config?
  120. question about Postgresql and rsync
  121. how to emit line number in a function?
  122. Re: FOSS Reporting tools (was Oracle 10g Express - any danger for Postgres?)
  123. Documentation HELP
  124. Re: left join a parenthesised inner join group
  125. left join a parenthesised inner join group
  126. Built in function question
  127. Changing ids conflicting with serial values?
  128. CDBaby.com: PostgreSQL + Ruby on Rails
  129. Re: Replicating databases
  130. Re: Data Dictionary generator?
  131. Data Dictionary generator?
  132. Lock Modes (Documentation)
  133. Function to insert entire row%ROWTYPE into other table
  134. database owner does not own public schema
  135. Linking
  136. Postgres + CentOS
  137. Re: [ANNOUNCE] PostgreSQL 8.1.0 Release Candidate 1
  138. looking for multi-language app example using postgresql
  139. md5 hash on table row
  140. Backend connection pooling memleak
  141. Clustered indexes - When to use them?
  142. Replicating databases
  143. Re: PostgreSQL on 64-bit operating systems
  144. Part of original Postgresql cook book back online
  145. Re: A Not Join
  146. Cannot install -- "/lib/cpp" failed sanity check
  147. Copying data from one column to another
  148. Re: PostgreSQL, Mac OS X and locales
  149. Linking
  150. Dumb Questions - upgrade notes?
  151. PostgreSQL on 64-bit operating systems
  152. Re: Oracle 10g Express - any danger for Postgres?
  153. Re: A Not Join
  154. Disappearing Records
  155. Table Qualifiers in Update Statement
  156. Postgres Object-oriented db
  157. rh7.3 binaries
  158. Cpanel and PostgreSQL 8.1rc
  159. Re: Help pls with UPDATE
  160. How may I keep prepended array items positive?
  161. insert multiple rows
  162. trapping errors in plpgsql?
  163. Re: Partitioning attempts
  164. Partitioning attempts
  165. vacuuming strangeness
  166. replace() and Regular Expressions
  167. SQL injection
  168. Help pls with UPDATE
  169. Re: PostgreSQL 8.1 vs. MySQL 5.0?
  170. Updating within Triggers
  171. PostgreSQL 8.1.0 Release Candidate 1
  172. Starting PostgreSQL 8.0.4 with more memory [FreeBSD 6.0]
  173. Re: Why database is corrupted after re-booting
  174. create table in transaction fails
  175. Oracle 10g Express - any danger for Postgres?
  176. =?ISO-8859-1?Q?Sorting_problems_with_SELECT_*_FROM_t?==?ISO-8859-1?Q?able_WHERE_name_LIKE_=27=D6=25=27?=
  177. Please HELP - URGENT - transaction wraparound error
  178. function example?
  179. Generating an ANSI compliant schema recreation script
  180. pgsql "info" files?
  181. dynamic table naming in function
  182. Enhancement Request : Expressions for format string in PlPgsql RAISE statement
  183. Re: Can I use variable to store sql data?
  184. which charset use for cyrilic?
  185. Backup problem...No BIN directory!!!
  186. mysql replace in postgreSQL?
  187. Installation trouble
  188. problems after pg_resetxlog
  189. tsearch2 setweight
  190. Frequency of Analyze?
  191. querying while copying into a table and optimizations
  192. serial number in output
  193. Learning server programming
  194. Re: Why database is corrupted after re-booting
  195. Function written in C, hangs on one machine and not another...
  196. tablename.columnname%TYPE in Functions & Types
  197. copy data from utf16 csv file
  198. aix build question re: duplicate symbol warning
  199. Connections to DB
  200. pg_dump fails when it gets to table containing bytea
  201. missing FROM clause ?
  202. Problem with SSL and postgreSQL 8.0.4
  203. creating users in groups, in 8.1
  204. Re: a stored procedure ..with integer as the parameter
  205. Copy of a schema
  206. Re: Copy of a schema
  207. Seq Scan but I think it should be Index Scan
  208. Variable return type...
  209. Error Message
  210. Re: Postgresql 8
  211. Re: Why database is corrupted after re-booting
  212. Re: Postgresql 8
  213. Postgresql 8
  214. Re: Why database is corrupted after re-booting
  215. Why database is corrupted after re-booting
  216. Where is the webaddress for the most recent postgresql version?
  217. querying PostgreSQL version?
  218. How to get the value in the lastvalue field
  219. Win32 libpq and ecpg thread safety
  220. Re: Dump only functions...
  221. Re: Dump only functions...
  222. Re: a stored procedure ..with integer as the parameter
  223. Re: Dump only functions...
  224. Getting Stated
  225. improve 'where not exists' query..
  226. Re: Why different execution times for different instances for the
  227. Re: alt+F not working after calling pg_dump
  228. alt+F not working after calling pg_dump
  229. Looking for a command to list schemas
  230. Need help with INOUT mis-understanding
  231. the best way to catch table modification
  232. How to use LIKE and $1 in a function ?
  233. Anyone know of a Schema Comparer
  234. Creating table in different database
  235. Re: a stored procedure ..with integer as the parameter
  236. Installation Problem
  237. newbie question: reading sql commands from script files
  238. pl/pgsql help
  239. Autogenerated backup of a password protected database
  240. Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1
  241. Deleting vs foreign keys
  242. Re: a stored procedure ..with integer as the parameter
  243. PostgreSQL vs mySQL, any performance difference for large queries?
  244. Unsubscribe
  245. Re: pg_dump with low priority?
  246. Re: Prevent application log pollution with notice messages
  247. Map of Postgresql Users (OT)
  248. FoxPro in WINE to Postgresql on LINUX?
  249. Re: [ANNOUNCE] PostgreSQL 8.1 Beta 4
  250. Prevent application log pollution with notice messages