PDA

View Full Version : Pgsql General

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