PDA

View Full Version : Pgsql General

  1. JDBC addBatch more efficient?
  2. Changed Hosts, Lots of Errors in PostgreSQL - HelpPlease!
  3. SQL error
  4. Initial ugly reverse-translator
  5. very slow updates in 8.3?
  6. No server after starting
  7. Upgrade 8.3
  8. Re: How to tell if 64 bit vs 32 bit engine?
  9. Re: How to tell if 64 bit vs 32 bit engine?
  10. good experience with performance in 8.2 for multi column indexes
  11. Client Authentication
  12. Re: In the belly of the beast (MySQLCon)
  13. Re: In the belly of the beast (MySQLCon)
  14. Re: In the belly of the beast (MySQLCon)
  15. Re: In the belly of the beast (MySQLCon)
  16. problem with tsearch and utf-8 on postgresql 8.1
  17. Re: Problems running PostGreSQL silent install
  18. Using meta-data for foreign key?
  19. Unable to add a new column to a table named "in" (look like a bug ...)
  20. Duplicate Symbols - Compiler Warnings
  21. String concat issues in 8.3.1 (8.3.1 bug?)
  22. pg 8.3.0 unexpected sending network packet?
  23. Binary bytea to literal strings
  24. Curiosity with catalog table array attribute index dimensions
  25. ALTER TABLE DDL Triggers?
  26. How to retore a pg_dumpall dump?
  27. How do I measure user disk usage on Postgresql table?
  28. table as log (multiple writers and readers)
  29. "vacuum" and "cluster"
  30. "vacuum" and "cluster"
  31. Master-master replication with PostgreSQL
  32. Re: Storing and accessing GeoData( Latitude and Longitude) in PostgreSQL 8.3
  33. Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
  34. Need help to clean up after failed CLUSTER
  35. How to recovery data from folder data installation?
  36. I need to ecrypt one column to an output file
  37. Help needed in PITR
  38. util/int8.h: missing int8_text() function
  39. strange dump problem
  40. Suggestion for psql command interpretation
  41. session_replication_role
  42. Not Geography
  43. Which Python library - psycopg2 or pygresql?
  44. precompilers
  45. Re: PostgreSQL 8.3 XML parser seems not torecognize the DOCTYPE element in XML files
  46. Installation of contrib/tablefunc - problems
  47. Copying large object in a stored procedure
  48. COPY to STDOUT and pipes
  49. Storage sizes for dates/times (documentation bug?)
  50. Re: How do I make sure that an employee and supervisor belong to the same company?
  51. Verifying SSL Certificate on the Client Side
  52. How do I make sure that an employee and supervisor belong to the same company?
  53. two not null columns
  54. Unacceptable postgres performance vs. Microsoft sqlserver
  55. generate_series woes
  56. how to get pg_restore to continue if an error occurs
  57. The default text search configuration will be set to "simple" ?
  58. No Return??
  59. VACUUM hanging on PostgreSQL 8.3.1 for larger tables
  60. Post-installation questions
  61. rule to update view that inserts into log
  62. Problems in PITR backup&recovery
  63. Re: Problem. createdb: could not connect to database postgres: could not connect to server: No such file or directory
  64. Re: Problem. createdb: could not connect to database postgres:
  65. Problems in PITR backup&recovery
  66. Deleting row in 7.4 takes for ever
  67. SQL injection, php and queueing multiple statement
  68. tsearch2 and hyphenated terms
  69. Re: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
  70. createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
  71. PostgreSQL Processes on a linux box
  72. Operator COMMUTATOR - how does postgresql use this information
  73. PG 8.3 review in Linux Mag
  74. PostgresSQL on a networked drive with multiple users
  75. Re: how to use transaction isolation
  76. Postgres on shared network drive
  77. Date / interval question
  78. pgcrypto and dblink
  79. =?ISO-8859-1?Q?Can=B4t_connect_but_listen_address?= =?ISO-8859-1?Q?_and_pg=5Fhba_configured_correctly?=
  80. Re: how to use transaction isolation
  81. Way to shutdown/freeze/stop an individual database without taking postmaster down?
  82. ODBCng vs psqlODBC
  83. Re: Disable Triggers
  84. pl/java on Solaris
  85. Proper Installation of Postgres and Postgis on 10.5 Intel
  86. percentile rank query
  87. Re: begin transaction locks out other connections
  88. visibility rule in a EXECUTE with multi sql
  89. howto set a variable in transaction context
  90. how to use postgre sql from inside process
  91. Re: Dump/Transfer Sequence Problems
  92. include PostgreSQL utilities into 3rd party program package
  93. Write in file from postgres
  94. Re: Trouble with foreign key
  95. SQL fast in PSQL, very slow using MS.NET driver
  96. Debugging Pl/PgSQL functions with the debug contrib module
  97. connecting VB to postgreSQL
  98. more SSL crash woes....
  99. wrong query result
  100. =?us-ascii?Q?Trouble=20with=20foreign=20key?=
  101. Re: Persistent objects within PG or the availability ofnon-logged tables or databases?
  102. More SSL crash woes
  103. select statement fails
  104. How does psql actually implement the \d commands
  105. ecpg-timestamp- interval problem V8.2.x
  106. Determining weather a query fired a trigger
  107. Problem after VACUUM ANALYZE
  108. Number or parameters for functions - limited to 32 ?
  109. Silent install 8.3 diiffers from 8.2
  110. Functions and transactions
  111. representative needed
  112. dirty select
  113. High Availability / Replication with Sequoia
  114. test ignore
  115. Postgresql Conferences/events in Europe?
  116. Most Occurring Value
  117. tsvector_update_trigger throws error "column is not of tsvector type"
  118. "too many trigger records found for relation xyz"
  119. Cannot use a standalone backend to VACUUM in "postgres""
  120. BD removed
  121. Subtracting Two Intervals
  122. plperlu and perl 5.10
  123. Re: Silent install 8.3 diiffers from 8.2
  124. Preparing full text search input for use in PostgreSQL 8.3
  125. Query optimisation
  126. calendar best practices for postgres
  127. edb-debugger, debugging pl/pgsql
  128. select distinct and index usage
  129. Removing Context messages
  130. Text Search Configuration Problem
  131. Silent install 8.3 diiffers from 8.2
  132. Limiting postgresql resources
  133. Using tsearch2 in a Bayesian filter
  134. Re: Exception messages -> application?
  135. Re: pg_dump and schemas
  136. default value based on select
  137. Re: [Slony1-general] ERROR: XX000: cache lookup failed for relation
  138. mac ports question
  139. Benetl 1.7, free ETL tool using postgreSQL is out !!!
  140. Newby Help needed
  141. Re: ERROR: XX000: cache lookup failed for relation
  142. Re: dump data into complex type table
  143. Duplicate Key violation on dump&reload using pg_restore
  144. Word boundaries in regular expressions
  145. Re: pg_dump and schemas
  146. pl/pgsql RECORD data type, how to access to the values
  147. too many LWLocks taken
  148. psql: FATAL: role "xyz" is not permitted to log in
  149. Direct access to GIST structure
  150. Re: how to insert values into complex type field
  151. Question about pg_catalog.pg_trigger.
  152. pg_dump and schemas
  153. creating a temp table in a function
  154. Exception messages -> application?
  155. Upgrading from 8.2.0 to 8.3.1
  156. Re: how to insert values into complex type field
  157. ERROR: XX000: cache lookup failed for relation
  158. Conversion to 8.3
  159. referencing column aliases in select list
  160. Re: Secure "where in(a,b,c)" clause.
  161. Re: deadlock
  162. Re: deadlock
  163. Re: deadlock
  164. To many records returned
  165. pg_dump ignoring without oids
  166. Autograph Annoucement (ERD Tool)
  167. pg_dump / load seems really slow..
  168. slow pgsql tables - need to vacuum?
  169. Array operator "sum array values" + matching dimensions
  170. deadlock
  171. choosing the right locking mode
  172. is it helpful for the optimiser/planner to add LIMIT 1
  173. Secure "where in(a,b,c)" clause.
  174. 518 http://bloqueadorgsm.vilabol.uol.com.br - Bloqueador gps gsm -localizador gps gsm - sem mensalidade - alarme automotivo , alarme paracarros 5186636506054453128125570
  175. Serial Data Type
  176. Proper Way to Disable Triggers
  177. PG 8.3.x doesn't get build
  178. timestamp problem
  179. Re: (FAQ?) JOIN condition - 'WHERE NULL = NULL'
  180. FW by pgsql-general-owner@postgresql.org : [pgsql-general] Daily digest v1.8030 (22 messages)
  181. PGCon 2008, Are you going?
  182. (FAQ?) JOIN condition - 'WHERE NULL = NULL'
  183. Problem with planner choosing nested loop
  184. Numbering rows by date
  185. drop database regardless of connections
  186. Re: Array operator "sum array values" + matching dimensions
  187. pgAdmin III Error
  188. Is there an md5sum for tables?
  189. Logging of autovacuum activity
  190. Too many commands in a transaction
  191. Update Join ?
  192. Primary Key with auto increment field
  193. anyone have experience with using Talend ETL tool
  194. dblink ,dblink_exec not participating in a Transaction??
  195. Foreign keys causing conflicts leading to serialization failures
  196. Connection reset by peer / broken pipe
  197. Re: Using tables in other PostGreSQL database
  198. Getting weird pg_tblspc error, has anyone seen this before?
  199. upgrading to 8.3, utf-8 and latin2 locale problem
  200. pg_standby/warm standby questions
  201. Role attribute for user email?
  202. minimum and maximum functions
  203. HOWTO caching data across function calls: temporary tables, cursor?
  204. Re: Primary Key with serial the solution?
  205. FATAL: bogus freespace amount
  206. Very slow catalog query
  207. Array operator "sum array values"
  208. Can Postgres 8.x start if some disks containing tablespaces are not mounted?
  209. simple update queries take a long time - postgres 8.3.1
  210. returning array from function or "structured error"
  211. PostgreSQL and Java on WindowsXP
  212. shortcut for select * where id in (arrayvar)
  213. Logging/Viewing parameters of a prepared statement
  214. ANALYZE getting dead tuple count hopelessly wrong
  215. Removing redundant itemsets
  216. round() and cast to numeric
  217. [pgsql-general] Daily digest v1.8035 (19 messages)
  218. [pgsql-general] Daily digest v1.8037 (17 messages)
  219. Locale / Encoding mismatch
  220. =?us-ascii?Q?postgreSQL=20multithreading?=
  221. database 1.2G, pg_dump 73M?!
  222. [pgsql-general] Daily digest v1.8032 (18 messages)
  223. [pgsql-general] Daily digest v1.8033 (18 messages)
  224. [pgsql-general] Daily digest v1.8034 (21 messages)
  225. [pgsql-general] Daily digest v1.8031 (18 messages)
  226. [pgsql-general] Daily digest v1.8036 (18 messages)
  227. Connection to PostgreSQL Using Certificate: Wrong Permissions onPrivate Key File
  228. [pgsql-general] Daily digest v1.8030 (22 messages)
  229. GSoC Proposal: PL/Mono
  230. Escaping \n
  231. performance impact of using uuid over int4
  232. Function for more readable function source code
  233. general optimisation rule for slice of table frequently accessed.
  234. SQL question
  235. Re: creating a trigger to access another postgres database?
  236. Primary Key with serial
  237. Re: Using tables in other PostGreSQL database
  238. Re: Fragments in tsearch2 headline
  239. Re: Users, groups and inheritance questions
  240. Re: Delete after trigger fixing the key of row numbers
  241. Schema design question
  242. Out of memory
  243. Database trigger across multiple postgres databases
  244. Re: Survey: renaming/removing script binaries(createdb, createuser...)
  245. Users, groups and inheritance questions
  246. Re: Users, groups and inheritance questions
  247. PostgreSQL terminates after crash of another serverprocess
  248. pg_stat_user_tables
  249. creating a trigger to access another postgres database?
  250. Re: Delete after trigger fixing the key of row numbers