PDA

View Full Version : Pgsql General

  1. new.id has wrong value in INSERT RULE
  2. Re: BIG installations of PostgresQL?
  3. BIG installations of PostgresQL?
  4. Create a pg table from CSV with header rows
  5. character varying == text?
  6. Re: Deadlock
  7. Questions about "varchar" NOT NULL default = char(1) ?
  8. CLUSTER equivalent
  9. How to check is the table system
  10. Deadlock
  11. Strange Bug in exim4 postgresql lookup code or libpq?
  12. Asychronous database replication
  13. Problem with 64-bit Postgres
  14. How to clone a cursor ?
  15. Copy DataBases Server to server
  16. Help trying to write my first plpgsql function...
  17. Re: MS SQL - PostgreSQL
  18. Re: MS SQL - PostgreSQL
  19. Re: MS SQL - PostgreSQL
  20. importing shape files nightmare!
  21. TSearch2 snowball version error
  22. ERROR: cursor 'xxx' does not exist
  23. Backup and Restore mechanism in Postgres
  24. buffer manager
  25. XlogFlus error message
  26. Upgrade instructions ->7.4.8/8.0.3 incomplete regarding tsearch2
  27. how to list rules?
  28. CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT again
  29. Re: MS SQL - PostgreSQL
  30. Re: MS SQL - PostgreSQL
  31. Re: MS SQL - PostgreSQL
  32. Partial dates
  33. "Unsubcribe"
  34. MS SQL - PostgreSQL
  35. Re: Question about PHP and PostgreSQL
  36. Setting date format for a single output column?
  37. Re: Question about PHP and PostgreSQL
  38. Pushing result set to table on different machine?
  39. Code Tables: varchar or serial pkey?
  40. Ranking Results
  41. oracle's first_value function for postgres?
  42. GNUmed release 0.1 announcement
  43. Speed problems
  44. full outer join performance
  45. Using COPY command when input file contain backslashes?
  46. Re: Replication
  47. Re: Utility that creates table schema from csv data?
  48. kernel log un upgrade of postgresql-common
  49. how to supress Notice messages or decrease verbosity level
  50. Utility that creates table schema from csv data?
  51. Building postgres on Suze
  52. PQtrace doesn't work
  53. Re: If an index is based on 3 columns will a query using two of the columns utilize the index?
  54. If an index is based on 3 columns will a query using two of the columns utilize the index?
  55. help me learn
  56. Replication
  57. list manipulation at column level
  58. $B!!!L7oL>$J$7!M(B
  59. linux pg pointed to windows partition for db
  60. Function to test for Valid Date
  61. arrays, composite types
  62. index and ilke question
  63. pg_autovacuum not doing anything
  64. Followup to week truncation thread
  65. gis driver dll .so
  66. can't drop table
  67. Returning XML with SELECT statements? IS THIS POSSIBLE?
  68. Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect
  69. locale and encoding
  70. ERROR: type "temp_gc" already exists
  71. ERROR: bogus varno
  72. ecpg -C INFORMIX
  73. Can't connect to instance with pgaccess
  74. query profiling
  75. Problem creating a database in a script; '"template1" is being accessed'
  76. to_ascii, or some other form of magic transliteration
  77. Re: data Transfer rate priority on Postgres ?
  78. Route Miles
  79. FW: Configuring Postgres to use unix sockets
  80. constraints on composite types
  81. Re: Problem using NULLIF in a CASE expression
  82. Problem using NULLIF in a CASE expression
  83. Is this a bug or am I doing something wrong?
  84. Support for Limit in Update, Insert...
  85. per user logging
  86. Tricky SELECT question involving subqueries
  87. pgsql
  88. Formatting TimeStamp
  89. 8.1beta timezone question
  90. pg_restore - authentication failed?
  91. [awitney@sgul.ac.uk: Re: Access management for DB project.]
  92. Partial commit within the trasaction
  93. EMS PostgreSQL Manager vs. TheKompany DataArchitect
  94. Access management for DB project.
  95. Acting on dropped/timed-out connections
  96. Bash script to update sequences
  97. Cost based SELECT/UPDATE
  98. change column data type from smallint to integer
  99. max number of triggers in a table
  100. Re: RAID0 and pg_xlog
  101. Re: Email Verfication Regular Expression
  102. Re: Postgresql Books: Which one ?
  103. Email Verfication Regular Expression
  104. Benchmarks?
  105. psqlodbc don't work on winxp64
  106. Re: 64 bits?
  107. table size performace
  108. back references using regex
  109. Help with row locks on 7.4 to 8.0 migration
  110. Re: How to write jobs in postgresql
  111. SLOOOOOOOW
  112. Basic locking question
  113. GUID / UUID RFC
  114. "select ..... for update of ..." doesn't support full qualified table name?
  115. tsearch2 & unicode
  116. PostgreSQL and XML support
  117. Installation problem
  118. long transactions, SAVEPOINTS, performance and memory consumption
  119. $BIwB/5U1g6f3ZIt(B
  120. PostgreSQL local replication
  121. Insert Ignore or something similar...
  122. Bug or ?
  123. Debug plpgSQL stored procedures
  124. Setting up a database for 10000 concurrent users
  125. Set search path by user
  126. PLPGSQL function schema or table parameter
  127. remote connection, web hosting, IP adress
  128. Re: Shared disk storage
  129. ECPG in stored procedures?
  130. Shared disk storage
  131. information_schema queries fail for different users
  132. SLOOOOOOOW
  133. concatenate text
  134. Upgrading from 7.4 to 8.0.1
  135. Re: Deferred triggers?
  136. Unicode limits
  137. Block Size and various FS settings
  138. Embed PostgreSQL in application
  139. pgsql with UTF-8 on Windows OS
  140. RAID0 and pg_xlog
  141. Total memory used by postgresql
  142. FAQ/Documentation about Postgresql on Windows XP
  143. Not able to insert the large data to HP-UX IA machines
  144. Re: LOG: unexpected EOF within message length word
  145. Re: LOG: unexpected EOF within message length word
  146. Re: LOG: unexpected EOF within message length word
  147. Query questions
  148. Re: LOG: unexpected EOF within message length word
  149. Schema overlay question
  150. operators, operator classes, Btree and index usage
  151. Self creating tables
  152. REVOKE question
  153. Re: lock problem
  154. LOG: unexpected EOF within message length word
  155. Question regarding FOUND
  156. how to retrieve error message details
  157. same size VARCHAR or INT IX faster?
  158. Trouble with bytea in SPI...
  159. Performance question (FOR loop)
  160. Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
  161. Re: Deferred triggers?
  162. Re: ECPG examples...
  163. Re: ECPG examples...
  164. ECPG examples...
  165. Check if SELECT is granted
  166. ODBC and inappropriate select *
  167. query
  168. lock problem
  169. Schema problems RedHat / SuSE 9.3 for version 7.4.8
  170. Array of created types
  171. Don't understand transaction error
  172. Transaction error
  173. Order By for aggregate functions (Simulating Group_concat)
  174. Re: newbie - postgresql or mysql
  175. Select All Columns
  176. Exception in Query when mixing explicit join and implicit join
  177. Out Of Memory Error on GiST Index
  178. Problem running or executing a function in Postgresql
  179. shared_buffers + Windows
  180. syslog message I do not understand
  181. PostgreSQL local replication
  182. Deferred triggers?
  183. Re: newbie - postgresql or mysql
  184. temp tables remain after server restart
  185. =?iso-8859-1?q?Messages=20doesn=B4t=20appear?=
  186. PQexecParams-Problem
  187. newbie - postgresql or mysql
  188. Re: detection of VACUUM in progress
  189. Re: Removing all users from a group
  190. Re: How do I copy part of table from db1 to db2 (and rename the columns)?
  191. Removing all users from a group
  192. Searching for LTree dmoz-testdata
  193. user defined type, plpgsql function and NULL
  194. Postgresql version
  195. Get postgresql workin in french...
  196. Is this still valid for current Postgresql versions?
  197. Help with SPI...
  198. 8.1 observation
  199. Re: Invalid page header in pg_class
  200. optimum settings for dedicated box
  201. PostgreSQL 8.1 changes...
  202. detection of VACUUM in progress
  203. or kills performance
  204. 8.1beta1 RPMs
  205. Php abstraction layers
  206. Re: Select gives the wrong results
  207. $BK\3J$J=PD%%[%9%HBgJg=8(B
  208. Cursor declaration
  209. Re: psql from Linux script
  210. Re: psql from Linux script
  211. temp_buffers
  212. psql from Linux script
  213. Re: [SQL] question
  214. Access more than one database from pgAdmin III
  215. update functions locking tables
  216. "GiST access is not concurrent"
  217. Select gives the wrong results
  218. revoke on database not working as expected
  219. max_connections
  220. About dropped notifications
  221. Planner create a slow plan without an available index
  222. Re: regarding threads and transactions - problem 2
  223. stack depth limit exceeded
  224. boolean default value
  225. A real currency type
  226. Re: =?Big5?B?oUc=?= Re: A strange problem
  227. =?Big5?B?pl7C0KFH?= Re: A strange problem
  228. Dumb question about 8.1 beta test
  229. An update rule affecting an after insert trigger
  230. A strange problem
  231. Re: Postgresql Function Cookbook/General howto
  232. About "ERROR: must be *superuser* to COPY to or from a file"
  233. GROUP BY requirement
  234. PG 8.0 "CONNECT BY" patch
  235. Altering functions cast
  236. SPs performance...
  237. PQConnectdb SSL (sslmode): Is this a bug
  238. postgresql performance degradation over time....
  239. Postgresql Function Cookbook/General howto
  240. pg_restore problem when restoring big table
  241. TG_OP and undefined OLD values
  242. Re: Problems Reinstalling PostgreSQL on XP
  243. Re: Is there going to be a 8.1 beta for win32?
  244. bytea or large objects?
  245. copy command feature requests
  246. postgres optimizer
  247. Is there going to be a 8.1 beta for win32?
  248. Serials jumping
  249. Re: regarding threads and transactions - problem 2
  250. Re: regarding threads and transactions - problem 2