PDA

View Full Version : Pgsql General

  1. Immutable attributes?
  2. Primary Key and Indices
  3. [Question]batch execute sql command
  4. New PostgreSQL book coming
  5. optimal hardware for postgres?
  6. Book: Beginning DB with Postgresql by Matthew & Stones
  7. run isql.exe batch as DOS command
  8. Intuitive Software and Mario Brothers
  9. Pgpool questions
  10. Article on PostgreSQL V8 release
  11. ☆10000円分無料☆
  12. PRIMARY KEY and indexes
  13. Playing with PostgreSQL and Access VBA
  14. psqlODBC and Access
  15. pg_dump serial UNIQUE NOT NULL PRIMARY KEY
  16. Re: libpq Unicode support?
  17. PHP and Postgresql on Windows
  18. PHP and Postgresql on Windows
  19. Re: libpq Unicode support?
  20. libpq Unicode support?
  21. Re: Postgresql Windows ODBC
  22. Migrating MySQL app to postgres?
  23. plperl function fails to "fire" Slony trigger
  24. Re: [SQL] How to install Postgres that supports 64-bit
  25. UltraSPARC versus AMD
  26. postgres user work with any password!
  27. Re: psqlodbc MSAccess and Postgresql
  28. Optimising Union Query.
  29. Postgresql Windows ODBC
  30. Table Partition
  31. ShmemAlloc: out of memory
  32. artificial keys or not?
  33. Re: Use of temporary tables in functions
  34. Multiple RULES on Views
  35. psqlodbc MSAccess and Postgresql
  36. listing all tables
  37. Table modifications with dependent views - best practices?
  38. Record as a parameter to a function
  39. Install development headers/libraries Win32 v 8.0.2
  40. Returning a RECORD, not SETOF RECORD
  41. timezone() with timeofday() converts the wrong direction?
  42. Waiting for Disconnect
  43. Had a problem with pg_clog
  44. debug levels in server
  45. Get timestamp as UTC
  46. tsearch2 trigger
  47. Re: Most specific match using between
  48. User def. Functions for sysadmin tasks?
  49. Most specific match using between
  50. Finding cardinality of an index
  51. Suggestions
  52. Use of temporary tables in functions
  53. CURRENT_TIMESTAMP and actual time
  54. PLEASE HELP ME
  55. List of Functions
  56. transaction started without BEGIN??? Please help!
  57. (Fwd) Re: windows, cant find ostgresql.conf
  58. Raise exception from regular SQL?
  59. Functions returning RECORD
  60. Windows install/uninstall as a "service"
  61. windows, cant find ostgresql.conf
  62. Baffling sequential scan plan when index scan would be best
  63. CURRENT_TIMESTAMP vs actual time
  64. Strange interaction of union and expressions
  65. electronic-izing unicode texts
  66. Re: Data migration from oracle
  67. Filesystem options for storing pg_data
  68. Re: Binary or compiled version?
  69. Data migration from oracle
  70. export data into xml
  71. Encoding problem
  72. UNSUBSCRIBE
  73. Re: Idea for the statistics collector
  74. lots of puzzling log messages
  75. postgresql start/stop/status script
  76. Re: What means Postgres?
  77. Re: Simplified (a-la [G|N]DBM) DB access
  78. reorder table data
  79. Re: PostgreSQL as a filesystem
  80. What means Postgres?
  81. Datatypes in PL/PSQL functions with multiple arguments
  82. Finding FOREIGN KEY constraints via information_schema
  83. substring and POSIX re's
  84. Trigger Commandline Command from Postgresql
  85. Postgresql 8.0.2 SLES 9 rpm - libpq.so.3 broken
  86. Simplified (a-la [G|N]DBM) DB access
  87. multibyte question
  88. Clarification
  89. Unsubscribe
  90. Re: "pltcl" function.
  91. Re: How to include "EXCEPTION" handling block in PL/TCL function.
  92. Re: tsearch2
  93. Re: PostgreSQL as a filesystem
  94. PG utilities won't prompt for password after Win32 8.0.2 upgrade
  95. current transaction is aborted, commands ignored until end of transaction...
  96. pg_dump fails
  97. Re: Plpgsql function with unknown number of args
  98. PostgreSQL as a filesystem
  99. increasingly slow insert/copy performance
  100. Uninstall existing - postgesql 7.3.2
  101. Indexes in PostgreSQL
  102. Urgent
  103. Plpgsql function with unknown number of args
  104. Help with a plperl function
  105. Building a "complex" select?
  106. Re: ADO and PostgreSQL functions
  107. Hang up on connect
  108. STATUS
  109. ☆10000円分無料☆
  110. "Could not read block" during vacuum
  111. tsearch2
  112. Help! "Access is Denied" Installation on WinXP rolled back
  113. Re: managing kernel
  114. managing kernel
  115. Overload
  116. Admin Tool to Send Me Email
  117. Re: SQL Question
  118. connection or database saving problem with glom (Msg-ID: resent-<20050415013227.P5287@ganymede.hub.org>)
  119. PostgreSQL and Schema (pictures)
  120. connection or database saving problem with glom
  121. PostgreSQL Database cluster with multiple different locale settings?
  122. Re: SQL Question
  123. Re: SQL Question
  124. If statements on select
  125. SQL Question
  126. Re: PostgreSQL 8.0.2 Now Available
  127. Assigning password to the superuser
  128. Re: psql performance
  129. psql performance
  130. Catching dangling LOBs?
  131. pgsql config flag update: apple rendezvous renamed bonjour
  132. use SAVEPOINT function
  133. Help with process list
  134. Some Advice needed with historical data
  135. plpgsql default arguments
  136. File execution
  137. (S)RPMs for PostgreSQL 8.0.2 are ready.
  138. Postgresql RHEL RPMs
  139. pgpool with PostgreSQL 7.4
  140. Can't install pltcl on Windows 8.0
  141. Postgresql 8.0.2 and Tiger?
  142. About ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1
  143. Foreign Keys Question
  144. PostGreSQL (7.3?) recovery, Mac OS X (10.3.8)
  145. unsubscribe
  146. psql vs perl prepared inserts
  147. Composite type versus Domain constraints.
  148. generating a parent/child relationship in a trigger
  149. Suitable Database version
  150. Re: Unique constraint violation on serial column
  151. Re: Unique constraint violation on serial column
  152. Re: Unique constraint violation on serial column
  153. Re: Get Number of milliseconds for an intervall
  154. Re: Get Number of milliseconds for an intervall
  155. Re: Unique constraint violation on serial column
  156. client interfaces
  157. Please help to speed up UPDATE statement
  158. postgres 8 upgrade problem
  159. Get Number of milliseconds for an intervall
  160. Crystal reports 9 fails to recognise data on upgrade to 8.0.1
  161. serial type (text instead of integer) and duplicate keys
  162. Connection closing
  163. Question about Large Objects
  164. The Holy Shroud
  165. Re: oracle script to postgresql
  166. Re: Unique constraint violation on serial column
  167. pg_restore -d password athentication failed
  168. Log File Maintainance
  169. Unique constraint violation on serial column
  170. unsubscribe
  171. large object table space in version 8
  172. Data Mart with PostgreSQL (Please!)
  173. oracle script to postgresql
  174. Inserting a record data type into a table
  175. Asyncron replication from wan to lan with PostgreSQL 8
  176. What are the consequences of a bad database design (never seen that before !)
  177. Re: PostgreSQL 8.0.2 Now Available
  178. Re: Download problem - none of the ftp mirrors work
  179. Help!!
  180. Duplicate records in table
  181. error with vacuumdb
  182. PostgreSQL 8.0.2 Now Available
  183. grant all privileges to all tables in a database
  184. Table inheritance or LIKE table?
  185. Note: Compiling on Windows with free Microsoft compilers
  186. Lost in Foreign Key land
  187. Need help with NPGSQL
  188. table and column information from cursor?
  189. Re: Can't install plpython on Windows 8.0
  190. create user with database and contrib
  191. Accessing environment variables from psql
  192. Data Mart with PostgreSQL
  193. Encoding Issue with UNICODE
  194. Bytea to File
  195. Index use with left join
  196. Can't install plpython on Windows 8.0
  197. sequence advances on failed insert
  198. Iterate OLD/NEW columns in a trigger?
  199. seg fault with tsearch2
  200. WAL on a RAM disk
  201. using limit with delete
  202. converting to hex
  203. Re: COPY command use UTF-8 encoding and NOT UNICODE(16bits)... please confirm. Should postgresql add :set CLIENT_ENCODING to 'UTF-8'; to avoid confusion
  204. Re: COPY command use UTF-8 encoding and NOT
  205. Re: monitoring database activity on solaris
  206. monitoring database activity on solaris
  207. bytea vs large object in version 8
  208. Problems with Set Returning Functions (SRFs)
  209. lower function
  210. Install PG 8.0 on AIX 5.2? Any Veterans?
  211. CentOS questions (From MySQL -> PGSQL)
  212. Big trouble with memory !!
  213. What encoding to use for this error?
  214. resetting postgres password
  215. How to get details about referential integrity violations?
  216. 8.0.2 Beta 1 for Windows available
  217. very slow after a while...
  218. array_append not working
  219. Out of memory error on select
  220. Catching DDL events (or equivalent functionality)
  221. Re: cygwin and psql
  222. unsubscribe
  223. change attnum in pg_catalog.pg_attribute
  224. Check for existence of index
  225. contrib/dbsize
  226. Postmaster running out of discspace; Data corruption?
  227. PL/PERL: raise notice, exception ?
  228. Connection refused
  229. installation AIX - LINUX
  230. Re: [HACKERS] plPHP in core?
  231. insert woes
  232. pg_restore
  233. Re: [HACKERS] plPHP in core?
  234. Re: diskspace usage recovered on db rebuild
  235. Simple UPDATE runs forever
  236. about "allow reporting of which objects are in which tablespace"?
  237. Regarding niladic functions
  238. Checking cursor's state in plpgsql
  239. UNICODE encoding and jdbc related issues
  240. invalid input syntax for type bytea
  241. Vacuum, statistics, & trigger/procedure query plan caching
  242. Re: Crazy Multiplication Issue
  243. Time
  244. Re: stored procedures / C-Language
  245. stored procedures / C-Language
  246. Re: ERROR: invalid page header in block 9869
  247. Re: [HACKERS] plPHP in core?
  248. Raise Exception
  249. How to dump data from database?
  250. field definitions in view results?