PDA

View Full Version : Pgsql General

  1. Re: WAL Log Size
  2. beginner: what permissions required to install on windows 2000+
  3. what happens if something goes wrong in transaction?
  4. How to monitor the progress of a stored procedure?
  5. PostgreSQL UK 2008 Conference
  6. on update, how to change the value?
  7. Can't start Postgres anymore
  8. HELP FOR LOADING a .psql file (same question again but explained neatly)
  9. beginner postgis question lat/lon
  10. debug nonstandard use of \\ in a string literal
  11. help for loading a psql file
  12. RHEL3 configure ssl
  13. Regarding interval conversion functions and a seeming lack ofusefulness
  14. Re: PostgreSQL-installation-problem on Windows XP Homeedition
  15. Slow query with 100% cpu
  16. dump/restore on different locale
  17. How to "paste two tables side-by-side"?
  18. Re: v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8
  19. bug in 8.3? foreign key refers to different type
  20. Re: Invalid username specified: A required privlege is not held by the client
  21. citext in windows.
  22. How can I get the first and last date of a week, based on the weeknumber and the year
  23. UUID-OSSP for windows.
  24. How to copy tables between databases?
  25. utf8 issue
  26. win32: how to backup (dump does not work)
  27. Re: APEX / HTML DB for PostgreSQL
  28. Re: [SQL] Deploying PostgreSQL on virtualized hardware
  29. Custom conversion
  30. dbi_link and dbi:ODBC
  31. Query meltdown: caching results
  32. =?iso-2022-jp?B?GyRCPWkkYSReJDckRiEjRk1BMyROJWEhPCVrJEs/PCQvJCobKEI=?=
  33. syntax error at or near "PROCEDURAL"
  34. Deploying PostgreSQL on virtualized hardware
  35. Windows 8.3 installer leaves a debug flag on?
  36. copy with escape
  37. disabling triggers, constaints and so on
  38. how to auto GRANT custom ACL on a new table?
  39. give a hand to a user having trouble with MySQL?
  40. process pool
  41. Cascading Trigger - changing row on delete does not delete row
  42. HOW does 8.3 CREATE REPLACe .. FUNCTION ..COST work
  43. no-arg cluster and locks ...
  44. v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8
  45. Cascading Trigger - changing row on delete does not delete row
  46. More formal definition of functions in documentation
  47. request help forming query
  48. "RETURNS SETOF" function question
  49. autovacuum not freeing up unused space on 8.3.0
  50. Planner: rows=1 after "similar to" where condition.
  51. Invalid username specified: A required privlege is not held by the client
  52. =?iso-2022-jp?B?GyRCJDMkcyRKSlEkSk02JCRKfSRiJEokJCRIO1ckJCReJ DkkMSRJGyhC?=
  53. Return Query with simple function
  54. 8.3 INSTALL: Why must I backup while my database is busy?
  55. Cascading Trigger - changing row on delete does not delete row
  56. plpgsql function
  57. APEX / HTML DB for PostgreSQL
  58. reindexing
  59. Benetl version 1.5
  60. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  61. =?iso-2022-jp?B?GyRCPWkkYSReJDckRiEjRk1BMyROJWEhPCVrJEs/PCQvJCobKEI=?=
  62. PostgreSQL's hashing function?
  63. Queries w/ "computed" table names? (eval in Pg?)
  64. Function problem
  65. /var/lib/postgres on Hitachi E5K160 60 GByte (Raid-1 + Hotfix)
  66. Re: Function problem
  67. joining on concatonation?
  68. Understanding ps -ef "command" column
  69. current_query pg_stat_activity column
  70. Selecting large objects stored as bytea
  71. Unique indicies
  72. configure build flags
  73. Postgres 8.3 broke everything
  74. New inst. 8.3.0 has no client
  75. client_encoding
  76. Function parameters change when update to 8.3
  77. need some help on figuring out how to write a query
  78. Re: No pgxs.mk with win32 binaries
  79. Disable Triggers
  80. Disable Triggers
  81. Re: Install problem w/8.3 on windows 2000 : application failed to initialize properly (0xc0000022)
  82. Re: PostgreSQL 8.3.0 RPMs are available for download
  83. text and bytea
  84. selective backup and restore
  85. Querying the schema for column widths - what syntax do I use?
  86. No pgxs.mk with win32 binaries
  87. Trigram performance penalty on varchar?
  88. unnesesary sorting after Merge Full Join
  89. Install problem w/8.3 on windows 2000 : application failed to initialize properly (0xc0000022)
  90. Feedback on PLJava
  91. Mac ordering with locales
  92. Re: dynamic crosstab
  93. select...into non-temp table raises 'duplicate key ... pg_type_typname_nsp_index'
  94. pgplsql and arrays
  95. Suggestions for schema design?
  96. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  97. Error in PlPython procedure
  98. How to view temp tables
  99. Vacuous errors in pg_dump ... | pg_restore pipeline
  100. ts_headline
  101. temp table in 8.3
  102. Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
  103. Re: SPI-functions and transaction control
  104. Re: longest prefix match
  105. Re: Using sequences in SQL text files
  106. is a unique key on null field bad?
  107. dynamic crosstab
  108. initdb problem with Windows Installer for PostgreSQL 8.2.4
  109. Vertical and Horizontal Table Partition
  110. Auto incrementing primary keys
  111. ERROR: relation with OID 1322527 does not exist
  112. (NONE)
  113. Order of SUBSTR and UPPER in statement
  114. Regex query not using index
  115. How to make update rapidly?
  116. type casting in 8.3
  117. Trouble with Mixed UTF-8 and Latin1 data
  118. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  119. Postgresql v mysql on debian etch
  120. Trigger
  121. Is my db dead ?
  122. Cascading Update query
  123. Cost of views on views?
  124. "RETURN QUERY" mystery
  125. Execute
  126. how to list column names.
  127. PostgreSQL 8.3.0 RPMs are available for download
  128. Question for Postgres 8.3
  129. postgresql-8.3.0-1-binaries-no-installer: gssapi32.dllmissed ?
  130. question about PANIC: hash table "Shared Buffer Lookup Table" corrupted
  131. Re: "pg_ctl: cannot be run as root"
  132. Re: [pgsql-advocacy] PostgreSQL Certification
  133. encoding does not match server's locale
  134. Postgres with daemontools or similar
  135. Use index for upper(customername) like 'ABC%'
  136. free ETL tool using postgreSQL, new major release
  137. Re: [pgsql-advocacy] PostgreSQL Certification
  138. Re: [pgsql-advocacy] PostgreSQL Certification
  139. Out of Memory errors while running pg_dump
  140. commit fails, rollback needed?
  141. Alternative to tableoids?
  142. lazy validation on complex criterion
  143. Re: postgresql book - practical or something newer?
  144. loading files into tables
  145. Universal libpq.a ?
  146. Re: "pg_ctl: cannot be run as root"
  147. Re: PostgreSQL Certification
  148. backup tableoids (pg_class.oid) ?
  149. Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
  150. msvcr80.dll and PostgreSQL 8.3 under Windows XP
  151. PGSQL ERROR: FATAL: terminating connection due to administrator command
  152. Reload only specific databases from pg_dumpall
  153. Reverse key index
  154. how to add array of objects to a record
  155. Personal Information Error
  156. Re: Performance problems with Postgresql/ZFS/Non-globalzones on Solaris?
  157. Function returning subset of columns from table (return type)
  158. =?iso-2022-jp?B?GyRCRVhOTyROO3JKKiRIJE8hIiQzJCYkJCQmJGIkTiRAJ Eg7VyQkGyhC?=
  159. Re: Performance problems with Postgresql/ZFS/Non-global zones on Solaris?
  160. temp sequence
  161. first message: SELECT <column> FROM <t
  162. =?iso-2022-jp?B?GyRCQWpALSQsJCQkJD13QC0kSD1QMnEkKiQmISohKhsoQ g==?=
  163. need help optimizing query
  164. Log query statistics
  165. =?iso-2022-jp?B?GyRCOCskSiQvJEYkYjdrOT0kRyQ5ISMbKEI=?=
  166. Re: Very long execution time of "select nextval('..');"
  167. Re: Performance problems with Postgresql/ZFS/Non-globalzones on Solaris?
  168. Request for help with database of Kenyan election violence
  169. [OT] "advanced" database design (long)
  170. Good F/OSS license summary
  171. Empty to NULL conversion - Ruby - Postgres ?
  172. Re: [Pljava-dev] pljava.dll - bogus error
  173. Re: [pgsql-advocacy] PostgreSQL Certification
  174. Re: PostgreSQL on a CompactFlash
  175. Re: Is PostGreSql's Data storage mechanism "inferior"?
  176. newbie question
  177. temp table question
  178. I can't restart postgres
  179. Complex query optimization
  180. pg_restore fails for postgis data dump
  181. PL/Tcl implementation
  182. Cross-schema VIEW
  183. check current time and timezone config
  184. Re: problem with ORDER BY
  185. Re: problem with ORDER BY
  186. Log query statistics
  187. Re: Dump schema without the functions
  188. arrays of floating point numbers / linear algebra operations into the DB
  189. problem with ORDER BY
  190. [UMN_MAPSERVER-USERS] query postgres AND oracle
  191. Re: postgresql book - practical or something newer?
  192. Re: PostgreSQL on a CompactFlash
  193. Re: [ADMIN] Backup
  194. Re: Log file permissions?
  195. Re: [pgsql-advocacy] PostgreSQL Certification
  196. Re: postgresql book - practical or something newer?
  197. Re: [ADMIN] Backup
  198. PostgreSQL 8.3 RC2 Install problems on Windows Vista Home PremiumPT_BR
  199. variable table names in trigger functions
  200. Recover by Log
  201. warm standby examples.
  202. postgres startup method for ubuntu
  203. Log file permissions?
  204. Re: Is PostGreSql's Data storage mechanism "inferior"?
  205. Re: Oracle Analytical Functions
  206. Re: can't create index with 'dowcast' row
  207. unique constraint
  208. close connection
  209. Re: Disk configurations....
  210. Test User.
  211. Finding all columns (in all tables) with a value
  212. looking up foreign keys
  213. Delete from base table and not partitions
  214. Converting from MySQL...need book ideas
  215. Create a function that returns multiple columns
  216. postgres rule with where clause
  217. change the default data directory
  218. PostgreSQL/PHP Application Server
  219. can't create index with 'dowcast' row
  220. Installing PostGreSQL - 2
  221. PostgreSQL/PHP Application Server
  222. maximum amount of data to be written during checkpoint?
  223. check constraint question
  224. Re: pg_xlog and standby - SOLVED
  225. changing the default directory
  226. Getting all tables into memory
  227. [Fwd: Re: retry: converting ASCII to UTF-8]
  228. constraints in table
  229. PGCon vs Postgresql Conference
  230. retry: converting ASCII to UTF-8
  231. Best practices for protect applications agains Sql injection.
  232. ascii to utf-8
  233. Count
  234. Re: altering foreign keys
  235. Re: altering foreign keys
  236. CSV options in COPY
  237. Postgresql + digital signature
  238. Tips for upgrading from 7.4
  239. pg_xlog and standby
  240. Installing PGSQL
  241. create a limited user in Postgre
  242. Selecting max(pk) is slow on empty set
  243. Errors with run_build.pl - 8.3RC2
  244. Graphics
  245. Problem of capital case-insensitive letter with accent
  246. US Military / Government Approval
  247. Re: Problem of capital case-insensitive letter with accent
  248. publicar
  249. (un)grouping question
  250. PG-8.2 backup strategies