PDA

View Full Version : Pgsql General

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