View Full Version : Pgsql General



  1. multiple default values specified for column?
  2. What Front-End you suggest ?
  3. Re: MS Access / Postgres ODBC / Outer joins
  4. SELECT FOR SHARE and FOR UPDATE
  5. Re: PostgreSQL Gotchas --- count()
  6. ANN: Rekall V2.4.0
  7. SELECT FOR SHARE
  8. How to delete Large Object from Database?
  9. copy data between database
  10. Re: PostgreSQL Gotchas --- count()
  11. Re: PostgreSQL 8.1 vs. MySQL 5.0?
  12. vacuum
  13. Re: Dump all except some tables?
  14. Re: PostgreSQL 8.1 vs. MySQL 5.0?
  15. Re: MS Access / Postgres ODBC / Outer joins
  16. Re: License question
  17. MS Access / Postgres ODBC / Outer joins
  18. Re: PostgreSQL Gotchas
  19. Re: PostgreSQL 8.1 vs. MySQL 5.0?
  20. Re: PostgreSQL Gotchas
  21. Re: PostgreSQL Gotchas
  22. Re: PostgreSQL 8.1 vs. MySQL 5.0?
  23. PostgreSQL Gotchas
  24. Re: a bug, now(), default CURRENT_TIME, WAL Logs.
  25. Indexen on 8.0.3
  26. pg_restore --disable-triggers does not stop triggers
  27. How to uninstall Postgres on Iinux.
  28. text file import
  29. Fedora Core 3 x86_64 compat libraries?
  30. Dump all except some tables?
  31. Re: PostgreSQL 8.1 vs. MySQL 5.0?
  32. How to uninstall Postgres
  33. PostgreSQL 8.1 vs. MySQL 5.0?
  34. portable pgsql binary/pkg building on OSX ...
  35. Trying to append text to the end of a text string
  36. Re: [ADMIN] System Tables
  37. SPI_prepare, SPI_execute_plan do not return rows when using parameters
  38. Problems with group by ... order by
  39. Syntax for use of point
  40. PostgreSQL on Slash Dot
  41. Re: Securing Postgres
  42. Re: Securing Postgres
  43. Re: Securing Postgres
  44. Re: Securing Postgres
  45. Re: Securing Postgres
  46. Securing Postgres
  47. Re: License question[VASCL:A1077160A86]
  48. Securing Postgres
  49. Cast to integer
  50. transaction toggling
  51. Untyped result (setof / rowset) from Functions ?
  52. query execution
  53. PostgreSQL Database export from Linux to Windows
  54. New Point Releases Now Available
  55. Re: License question[VASCL:A1077160A86]
  56. Fw: License question
  57. selfmade datatype in C and server-crash
  58. Or selection on index versus union
  59. Re: License question
  60. a bug, the bugs list, and how to break the website search.
  61. Re: License question
  62. Isolated transactions?
  63. optimizing common subqueries
  64. License question
  65. Advice on development environment for veritical product[VASCL:A105BF1C720]
  66. Re: [INTERFACES] how to monitor dead connections to postgresql database
  67. Avoiding evaluating functions twice.
  68. need help on setting up pgsql
  69. export a select result in a file ?
  70. Re: Connecting form Access or VB6 to PostgreSQL 8
  71. Windows Postgresql and Dev-Cpp/Dev-C++/MINGW configuration example
  72. mysql hash table equivalent?
  73. Suggest forums software for postgresql?
  74. int values from PQExecParams in binary result mode
  75. Re: Help with inventory control - Thank You!
  76. Re: strip zeros from fractional part
  77. Re: Integration with MS Sql Server
  78. strip zeros from fractional part
  79. Integration with MS Sql Server
  80. Casting numeric values to double
  81. Limitations of PostgreSQL
  82. Re: Postgresql Vb.1 beta 2 win binary
  83. Re: Postgresql Vb.1 beta 2 win binary
  84. Re: Postgresql Vb.1 beta 2 win binary
  85. Postgresql Vb.1 beta 2 win binary
  86. pg_dump output mode
  87. Compiling contrib module - intarray
  88. Re: Portable PostgreSQL
  89. Re: Portable PostgreSQL
  90. Portable PostgreSQL
  91. Postgresql 8.0 and XP
  92. Maximum # of schemas
  93. Pertinent to list? PostgreSQL and Dev-Cpp Dev-C++ on Windows example
  94. Broken pipe
  95. varchar to text
  96. Broken pipe
  97. 8.1 'make check' fails
  98. Multiple database queries
  99. scoring differences between bitmasks
  100. Query optimization
  101. Re: Help with inventory control - THANK YOU!!!
  102. not quite expected behaviour when using IN clause
  103. Many-To-Many Bridge Table Index
  104. Exporting just schema/metadata (w/o data) in Postgres
  105. Get all table names that have a specific column
  106. Help with inventory control
  107. Re: Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails
  108. Improving GROUP BY?
  109. Re: installing several PostgreSQL instances on Windows
  110. installing several PostgreSQL instances on Windows
  111. to drop a 30GB database. is it slow?
  112. postmaster does not shut down
  113. DBLINK on WINDOWS?
  114. Re: DBI/DBD::Pg mem. use goes exponential
  115. security documentation
  116. Many-To-Many Bridge Table Index
  117. Does copy abort on a failed insertion?
  118. pl/pgsql function debugging
  119. 8.0.1 SRPM on RHEL v.3
  120. Re: Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails
  121. DBI/DBD::Pg mem. use goes exponential
  122. Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails
  123. How can I check if my cursor statement is using index
  124. pg_restore error
  125. Hardware requirements
  126. Re: Migration from MS SQL 2K
  127. Migration from MS SQL 2K
  128. pgsql-ru-general@postgresql.org and
  129. Setting up a fine-grained permission system
  130. Perl regular expressions
  131. Re: [PG7.4] Using the data from temp table within a function
  132. Migration From MS SQL 2K
  133. trigger self recursion
  134. Re: ERROR: type "temp_gc" already exists
  135. Re: postgresql and C++/C
  136. Triggers after a rule
  137. postgresql and C++/C
  138. Re: ERROR: type "temp_gc" already exists
  139. Problem with Cursor in Oracle from Postgresql via ODBC
  140. restore
  141. Slow query using LIMIT
  142. Mysterious query plan
  143. Query Question
  144. Performance woes relating to DISTINCT (I think)
  145. insertion becoming slow
  146. insertion becoming slow
  147. change db encoding?
  148. Restore xxxxx.backup database
  149. insertion becoming slow
  150. Can't change language through LC_MESSAGES
  151. c-language function .h file changes between (major) versions
  152. [SQL] add column if doesn't exist (fwd)
  153. Error migrating from 7.4.3 to 8.0.3
  154. could not send data to server: Operation not supported
  155. Index use in BETWEEN statement...
  156. insertion becoming slow
  157. RI_ConstraintTrigger question
  158. regarding select into
  159. Function keys cause psql to segfault
  160. 66 Sexy couple 66
  161. createdb problem
  162. What is an 'unused item pointer'
  163. Extraordinarily slow!!
  164. Problems creating view
  165. Slow connection to the database
  166. question about to return two diferent tables from a function
  167. tsearch2 for alphabetic character strings & codes
  168. Backend crash with user defined aggregate
  169. Re: Lines of code in PG 8.0 & 8.1?
  170. Trouble upgrading from 8.0.1 to 8.0.3
  171. Can not get ODBC to log. Trace is not working.
  172. Prepared query logging omits bind values
  173. Re: PQtrace doesn't work
  174. COPY - permission denied
  175. SQL command to dump the contents of table failed: PQendcopy() failed.
  176. Re: Finding (and deleting) dupes in relation table
  177. How many insert + update should one transaction handle?
  178. Data Entry Tool for PostgreSQL
  179. Redhat 9 RPM dependency problem
  180. Re: Finding (and deleting) dupes in relation table
  181. Finding (and deleting) dupes in relation table
  182. Getting the amount of overlap when using OVERLAPS
  183. Replicating new sequences
  184. Questions about Rollback - after insert, update, delete ... operations?
  185. Need for java based web admin tool
  186. database update question
  187. Referencing columns in a record (or dereferencing variables)
  188. Lines of code in PG 8.0 & 8.1?
  189. wrong protocol sequence?
  190. ORDER BY results
  191. date_trunc('week', '2005-01-01'::TIMESTAMP)
  192. index row size exceeds btree maximum
  193. COPY and Unicode...
  194. returning the primary key value
  195. Fetching column names for a table
  196. pgclient hostbased authentication
  197. Postgres locks table schema?
  198. Re: pgclient hostbased authentication
  199. Re: pgclient hostbased authentication
  200. connecting windows xp to remote server
  201. Re: pgclient hostbased authentication
  202. How to create case insensitive unique constraint
  203. Re: Errror in beltane
  204. Problems with leftover types in pg_temp schemas
  205. Network Flow Schema + Bulk Import/Updates
  206. Re: Problems with leftover types in pg_temp schemas
  207. FATAL: the database system is starting up
  208. Problem with libpq3 & postgresql8
  209. Win32 Backup and Restore of large databases.
  210. pg_index_indrelid_index error, any ideas ??
  211. array_dims array_lower/upper distance
  212. Preventing duplicate records according to several fields
  213. pg_autovacuum not sleeping
  214. More efficient INs when comparing two columns
  215. Slow search.. quite clueless
  216. deactivating/activating constraint
  217. running vacuum in scripts
  218. how to read the transaction logs?
  219. shared Locks
  220. update problem in triggers
  221. Re: [pgsql-general] Daily digest v1.5557 (21 messages)
  222. Re: character varying == text?
  223. Problems with vacuumdb
  224. VACUUM anomoly
  225. postgres 8.03 initdb error for Rhel ES-4
  226. Re: Arrrr... date formatting.
  227. Blob data type and it's efficiency on PostgreSQL
  228. Arrrr... date formatting.
  229. HELP - Recover function delete
  230. Inserting slows down
  231. Replicator
  232. How to modify a tuple returned by SPI_copytuple?
  233. help me pls
  234. Implementing a change log
  235. 8.1 beta2 RPMs
  236. Query Cost
  237. PDF Documentation?
  238. ltree and ordering - what index?
  239. unsubscribe
  240. Re: Anyone use Eclipse?
  241. Re: Divide a float4 by 1 - what is going on???????
  242. Divide a float4 by 1 - what is going on???????
  243. Re: Setting WHERE on a VIEW with aggregate function.
  244. pg_ctl reload breaks our client
  245. Duplicate Values or Not?!
  246. Restoring just a table or row from a backup copy.
  247. Re: Setting WHERE on a VIEW with aggregate function.
  248. Contraint Trigger Permissions
  249. Setting WHERE on a VIEW with aggregate function.
  250. Neither column can be NULL if the column is part of the combinationof primary key columns?