PDA

View Full Version : Pgsql General

  1. Re: Postgres crashes,help to recover
  2. Creating a database with psql
  3. Administration of raster data
  4. Postgres crashes,help to recover
  5. Wishlist?
  6. $B40A4L5NA$NAG?M=PD%%[%9%H$N%"%k%P%$%H(B
  7. psql: error while loading shared libraries: psql: undefined symbol: get_progname
  8. EXCEPTION in pl/pgsql
  9. How to pass the password for login in psql
  10. RAMFS with Postgres
  11. Re: pg_dump and write locks
  12. Re: Hot to restrict access to subset of data
  13. Stored Procedures for Security
  14. pg_dump and write locks
  15. Old question - failed to find conversion function from "unknown"
  16. Slow first query
  17. missing chunk number 0 for toast value ...
  18. $B!y!z0lK|1_J,%W%l%<%s%H!z!y(B
  19. off topic
  20. Composite type within a composite type?
  21. Re: How to find the number of rows deleted
  22. index row size exceeds btree maximum, 2713 - Solutions?
  23. unsubscribe
  24. About retrieving objects' priviledge info such as grantee & its privilegesfor a specific object (view, table, function, etc.)
  25. point(lseg,lseg) does not exist
  26. free space map settings
  27. ODBC
  28. Error while vacuuming
  29. Re: Seg fault in postgres 7.4.7?
  30. TRUNCATE locking problem
  31. Changes to not deferred FK in 8.0.3 to 7.4?
  32. How to find the number of rows deleted
  33. PG based wiki engine
  34. (Win32 Postgres) Slow to Connect first - OK afterwards
  35. foreign key constraints and inheritence
  36. 7.3.4 dump/restore error
  37. encoding and locale
  38. PostgreSQL select
  39. Lost main database directory but not tablespace holding the database - how to recover?
  40. Trigger on Update
  41. Re: problem after restoring a backup database on a different
  42. Re: Postgres for Fedora Core 2 OS ****************
  43. Re: Postgres for Fedora Core 2 OS ****************
  44. Return SETOF or array from pl/python
  45. Re: how to insert '\\' in postgres database using java
  46. CVS - psql segfault
  47. PLPGSQL how to get transaction isolation level info
  48. Re: Looking for a good ERD Tool
  49. problem after restoring a backup database on a different PC
  50. how to insert '\\' in postgres database using java
  51. uncompressing pgAdmin backup file in windows
  52. How to create unique constraint on NULL columns
  53. Asynchronous connection and command processing.
  54. Function returning any (tuple) type
  55. Re: Looking for a good ERD Tool
  56. gborg down
  57. How to obtain the list of data table name only
  58. Help needed with PGOleDB driver and ADO
  59. Re: i need you help about postgresql(rollback)
  60. cursors problem
  61. Re: To Postgres or not
  62. Re: DB/clog corruption
  63. Re: Quotation marks in queries
  64. PostgreSQL 8.0.3
  65. Re: To Postgres or not
  66. Recursive stored procedure in C.
  67. Re: Quotation marks in queries
  68. Quotation marks in queries
  69. ERROR: could not open relation
  70. Stopping Postgres
  71. Errors building older versions of PostgreSQL
  72. Table Update Systems (was: chosing a database name)
  73. Standalone Parser for PL/pgSQL
  74. Transparent encryption in PostgreSQL?
  75. Transparent encryption in PostgreSQL?
  76. stored proc help
  77. Re: [SQL] dynamically loaded functions
  78. Nulls in timestamps
  79. re my previous e-mail client-server example
  80. Slow delete
  81. Re: To Postgres or not
  82. Client-Server Example
  83. chosing a database name
  84. fts error
  85. What's Popular for CMS and RAD with PHP/PostgreSQL?
  86. To Postgres or not
  87. Schema accidentaly dropped in pg_namespace table
  88. Re: index bloat
  89. INSERT INTO from a SELECT query
  90. Strange memory behaviour with PGreset() ...
  91. strange error with temp table: pg_type_typname_nsp_index
  92. 7.4.7: strange planner decision
  93. Re: NTFS partition autodetection during instalation
  94. NTFS partition autodetection during instalation
  95. Re: illegal sort order
  96. Re: CreateTable --> schema not found
  97. Re: Migrating a Microsoft-SQL database to Postgres
  98. Fw: Re: Windows version of PostgreSQL 8?
  99. pgcrypto : how to get SHA1(string) as a 40-char string, NOT binary string?
  100. can you tell me how to use rollback work in 'pgsql' function? and give me a exsample?
  101. Transaction Handling in pl/pgsql?
  102. How to use rollback in function with 'pgsql'?
  103. current_timestamp - 20 minutes
  104. user privilege to create c function
  105. Re: 7.2 -> 7.4: horrible performance hit!
  106. getting the ranks out of items with SHARED
  107. 7.2 -> 7.4: horrible performance hit!
  108. export/import database
  109. Windows version of PostgreSQL 8?
  110. gborg borked again?
  111. Re: FW: index bloat
  112. Re: [PERFORM] Projecting currentdb to more users
  113. Checkpoints are occurring too frequently...
  114. illegal sort order
  115. Temp tables...
  116. Transaction Handling in pl/pgsql
  117. PL/SQL to PLpg/SQL - NO_DATA_FOUND
  118. Windows version of PostgreSQL 8.x?
  119. Re: index bloat
  120. Japanese words not distinguished
  121. Schema accidentaly dropped in pg_namespace table
  122. utf-8 and cultural sensitive sorting
  123. Pb with boolean between MS-Access and PostgreSQl 8.0.3
  124. Re: index bloat
  125. Converting MySQL tinyint to PostgreSQL
  126. Quoting $user as Parameter to SET
  127. table locking and SELECT FOR UPDATE
  128. Re: A trigger that acts on a column with a given column
  129. Db and schema names in logged errors
  130. {Virus?} *DETECTED* Online User Violation
  131. upgrading from 8.0 rc5
  132. strange problem with pl/pgsql function caching of bad values
  133. {Virus?} Rbgbqsvkmzwndu
  134. max_prepared_connections
  135. Re: PostgreSQL Hosting
  136. Data type to store latitude and longitude
  137. PG 8.0.3 ignores parameter listen_addresses ?
  138. Foreign Key written as a trigger
  139. array Q
  140. Transaction isolation levels
  141. How to fix invalid multibyte character for locale error
  142. DB/clog corruption
  143. GBorg borked!
  144. Re: Which record causes referential integrity violation on delete
  145. Wikipedia hackers wanted
  146. $B:#J?5$$G$9$+!)(B
  147. Transaction isolation levels
  148. PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure
  149. UPDATE from a SELECT on two fields.
  150. many updates to single row in single transaction
  151. pg_user does not exist
  152. anybody used ERWin with pg?
  153. index usage in multi-column ORDER BY
  154. dump the database data
  155. Re: Pl/PgsSQL array
  156. Re: Hot to restrict access to subset of data
  157. Postgresql 7.4.8 inconsistent index usage
  158. Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SETglnum = glnum; is OK ?
  159. PostgreSQL Scalability
  160. Re: index bloat
  161. Re: Full outer join question.
  162. mail change for list?
  163. Re: Populating huge tables each day
  164. Re: automating backup ?
  165. Building Latest (8.1)
  166. Postgres SQL server hosting
  167. User authorization
  168. Re: automating backup ?
  169. ERROR: "TZ"/"tz" not supported
  170. Re: Generate a list of (days/hours) between two dates
  171. Performance Tuning Best Practices for 8
  172. Re: automating backup ?
  173. performance for insert / update
  174. Re: Indexes not used - what am I missing?
  175. Indexes not used - what am I missing?
  176. Re: Populating huge tables each day
  177. Re: Populating huge tables each day
  178. Vacuum analyze question on estimated rows
  179. Populating huge tables each day
  180. problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4
  181. Generate a list of (days/hours) between two dates
  182. Re: DANGER Windows version might hurt you
  183. Re: Web application development on Win32, deployment on Linux
  184. Status of pg_dump
  185. Re: Windows XP installation problem
  186. Re: Web application development on Win32, deployment on Linux
  187. Windows XP installation problem
  188. Web application development on Win32, deployment on Linux
  189. number of records returned by cursors
  190. Re: How to compare the schemas ?
  191. vacuum error
  192. Tablespaces across same raid...
  193. Re: automating backup ?
  194. Finding points within 50 miles
  195. Infix Function?
  196. MacOSX, fink, missing readline/readline.h
  197. Re: Win32 users?
  198. Re: Win32 users?
  199. plpgsql function changes?
  200. PL/pgSQL function to validate UPC and EAN barcodes - works! Improvements?
  201. Re: Postgres 8.0 windows processes, field testing, and
  202. Re: startup time
  203. create rule ... as on insert
  204. Raid and tablespaces configuration
  205. Non-unique index performance
  206. problem calling psql from another program
  207. Win32 users?
  208. Postgres 8.0 windows processes, field testing, and Hibernate
  209. Postmaster Out of Memory
  210. Vacuum causing crashes
  211. Is there a standard database model for poker?
  212. Re: setting up PostgreSQL on Linux RHL9 to allow ODBC
  213. Loopback IDENT authentication broken in FC4
  214. multi-languages in a table
  215. TX semantics backward compatibility
  216. How to compare the schemas ?
  217. plpgsql and schema
  218. Help me urgently
  219. Performance counters?
  220. Changing password for the postgres user?
  221. fields and foreign keys
  222. Re: help about the function
  223. help about the function
  224. Corrupted index
  225. multiple action rules
  226. PROBLEM: Function does not exist
  227. Re: dump/restore bytea fields
  228. Setting global vars for use with triggers
  229. Vacuum advice
  230. dump/restore bytea fields
  231. Perl DBI issue
  232. setting up PostgreSQL on Linux RHL9 to allow ODBC connections fromWindows
  233. Problem on function returning setof custom type
  234. how to xml on debian?
  235. Problems upgrading to 7.4.8 from 7.2.4
  236. Clustering and replication options
  237. Re: scroll cursor bug or me?
  238. $B%a%"%I8r49<+M3(B
  239. Re: startup time
  240. Postfix/Maildrop and too many connections issues
  241. Debugging PL/pgSQL
  242. Escape handling in strings
  243. startup time
  244. CONVOLUTED CROSS-TAB ? UNION ? INTERSECT ? 16.9 second performance.... Is there a better way ???
  245. index selection by query planner
  246. Re: compilation postgresql/solaris error
  247. Re: renumber id's in correct order (compact id's)
  248. Explain analyze gives no info
  249. compilation postgresql/solaris error
  250. Howto repair template1