PDA

View Full Version : Pgsql General

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