PDA

View Full Version : Pgsql General

  1. sync linux and postgresql users and groups
  2. Discover temporary INDEX/TABLE name
  3. Re: Data corruption
  4. Re: Question about query optimization
  5. Re: PG_MODULE_MAGIC check in 8.2
  6. Question about query optimization
  7. SQL subquery question
  8. copy template X -> Y
  9. Recovering deleted or updated rows
  10. autovac state persistence
  11. RE : Re: RE : Re: database design ...
  12. RE : Re: RE : Re: database design ...
  13. RE : Re: database design ...
  14. Re: PG_MODULE_MAGIC check in 8.2
  15. RE : Re: database design ...
  16. Not your father's question about deadlocks
  17. PG_MODULE_MAGIC check in 8.2
  18. connectby usage question
  19. Using SAN Splits to instantly copy a DB
  20. ERROR: type "i" does not exist
  21. The old Insert and retrieving your Serial problem in VB
  22. ORDER BY
  23. LAN
  24. Re: database dump then restore on another system?
  25. Re: PostgreSQL Mhash functions
  26. schema rename - is analyze necessary?
  27. Data corruption
  28. FW: [NOVICE] Creating a new server
  29. Locale configuration with Win XP PostgreSQL 8.1.4
  30. autovac hung/blocked
  31. kerberos authentication error with Windows 2003 SP1 AD
  32. database design ...
  33. Re: can't start postgresql
  34. libpq.so full name?
  35. Trouble migrating from PostgreSQL --> Oracle
  36. Large Object to Bytea Conversion
  37. specified cluster does not exist error
  38. gcj requirement for jdbc driver
  39. Out of memory (Failed on request size 24)
  40. empty folder for downlaoding PostgreSQL 8.1.5 for FC 4
  41. can't start postgresql
  42. PgSQL not recognized
  43. Using PL/pgSQL
  44. Re: Inserting data in composite types
  45. chop off non-meaningful digits
  46. system tables...
  47. Re: SQL - update table problem...
  48. SQL - update table problem...
  49. schema synchronization
  50. Inserting data in composite types
  51. kubuntu & pgadmin
  52. Re: encoding advice requested
  53. Re: DELETE performance issues
  54. RE : Trying to Install PhP-4 Module for PostgreSQL from Ports
  55. Trying to Install PhP-4 Module for PostgreSQL from Ports
  56. specify whitch index to use
  57. Enable monitoring on the health of postgres db
  58. Why isn't it allowed to create an index in a schema other than public?
  59. Pushing the Limits
  60. join condition against where with coalesce
  61. Re: DB Designer??
  62. Re: Speed of postgres compared to ms sql, is this
  63. SQL Join for a Calculation
  64. Speed of postgres compared to ms sql, is this article/comment off?
  65. encoding advice requested
  66. SQL syntax additions for 8.2
  67. Utility to Convert MS SQL Server to Postgres
  68. Automatically Creating INSERT/UPDATE/DELETE Rules on Views
  69. apparent wraparound
  70. wildcard alias
  71. Request for replication advice
  72. FK pointing to a VIEW
  73. Cached dataset
  74. Which DatumGet ?
  75. Using GIN indexes on 8.2
  76. Re: "stopping" a single database in a cluster
  77. tsearch2() with data from other table
  78. SSL Certificate Check
  79. Re: ECPG and multiple threads
  80. Database Mirroring Solution
  81. "stopping" a single database in a cluster
  82. Logging in postgresql.conf - no SQL statements are logged
  83. ECPG and multiple threads
  84. Re: postgres at startup
  85. how & from where to start & admin pgsql on red hat ES 3
  86. LIKE OPERATOR cardinality estimation
  87. Linux vs. FreeBSD
  88. postgres at startup
  89. Multiple currencies in a application
  90. blocking function in PL/Python
  91. Remote tables infrastructure.
  92. AutoVacuum on demand?
  93. zero values in statistic views
  94. Can non-superuser install c functions ?
  95. Installation Instruction For Window
  96. Problem with pg_dump
  97. Mac OS X
  98. Datum problem
  99. ROWTYPE initialization question
  100. [PL/pgSQL] Commit every N rows. Is it possible ?
  101. posgres headers
  102. cannot connect anymore from a remote host
  103. Re: Why overlaps is not working
  104. Why overlaps is not working
  105. Re: autovacuum blues
  106. Re: Table design - unknown number of column
  107. Re: autovacuum blues
  108. Re: [PL/pgSQL] How should I use FOUND special variable.
  109. [PL/pgSQL] How should I use FOUND special variable. Documentation is little unclear for me
  110. Too many open cursors
  111. Changing the number and type of columns in a view
  112. Re: autovacuum blues
  113. Re: RULE - special variables?
  114. Table design - unknown number of column
  115. reproducing this issue on PG 8.0.0 ERROR: index "patient_pkey" is not a btree
  116. authentication question
  117. planer picks a bad plan (seq-scan instead of index) when adding an additional join
  118. Re: [SQL] [ADMIN] Is there anyway to...
  119. dblink / plpgsql - definition list cheats for record returning functions?
  120. Can PostgreSQL notify a client that a trigger has fired?
  121. PostgreSQL RPMs
  122. Survey...Please do help and Respond!!
  123. Performance monitoring
  124. TRIGGERS - access sql query_string that called it?
  125. RULE - special variables?
  126. dblink / plpgsql - definition list cheats for record returning functions?
  127. Does PostgreSQL support multi-instancing?
  128. How much memory is required?
  129. 8.1.2 locking issues
  130. Table and Field namestyle best practices?
  131. 8.1.2 postmaster died
  132. PostgreSQL tutorials
  133. "Broken" Plan? Nested Loop IN Join vs. Nested Loop/Hash Aggregate
  134. killing autovac
  135. Salir de la lista
  136. delete performance is extremely slow
  137. A couple more PostgreSQL C questions
  138. Question on inserting and querying at the same time.
  139. Stable sort?
  140. converting Informix outer to Postgres
  141. =?iso-2022-jp?B?GyRCJCo7fjRWJCwkIiRrO34kRzk9JCQkXiQ7JHMkTiRHG yhC?=
  142. Re: [HACKERS] Tsearch Index Size and GiST vs. GIN
  143. WAL ends before end time of backup dump
  144. I'm lost :-( with FOR...IN
  145. running external programs
  146. Re: RE : Re: first steps in PhP and PostgreSQL
  147. Re: R and postgres
  148. when to use pfree?
  149. X.50x OID representation
  150. Re: database name aliases?
  151. what version of Postgis should i install for Postgres-8.1.5 RHEL 4 -AS RPM
  152. R and postgres
  153. EXECUTE INSERT BUGS?
  154. database name aliases?
  155. data does not exist :-(
  156. Re: [pgsql-general] Daily digest v1.6578 (20 messages)
  157. FOR ... IN
  158. stored procedure / Function
  159. How to force strong passwords
  160. cvs HEAD initdb: vacuuming database template1 ... FATAL: could notidentify a comparison function for type aclitem
  161. Schema search_path and views
  162. timezone difference in timestamp?
  163. DISTINCT is not quite distinct
  164. first steps in PhP and PostgreSQL
  165. PostgreSQL in an embedded platform
  166. Alias for tables/columns?
  167. Re: Issue when inserting Slovak characters in database via PHP code
  168. Re: upgrade to 8.0.9
  169. Re: Header meaning for pg_dump
  170. select result / functions from another database in plpgsql
  171. No subject
  172. .
  173. =?iso-2022-jp?B?GyRCRn42YiRyJDUkOyRGRDokJCRGJGgkbSQ3JCQkRyQ3J GckJiQrGyhC?=
  174. upgrade to 8.0.9
  175. Dump all databases to corresponding files
  176. schema diagram with child tables
  177. basic SQL request
  178. varchar
  179. max_fsm_pages
  180. Converting a timestamp to a time
  181. =?iso-2022-jp?B?GyRCPHIkSD13JEg2YiRIPCtNMxsoQg==?=
  182. ERROR: tuple concurrently updated
  183. help with a query
  184. opening a channel between two postgreSQL-servers?
  185. Re: I can not add up columns when using a left outer join. Any ideas as to why?
  186. Win32 Silent installer ADDLOCAL is ignored
  187. Geometric Datatypes
  188. Issue when inserting Slovak characters in database via PHP code
  189. bytea / large object and image
  190. UNICODE and UTF-8
  191. PostGIS Binary RPM for Red Hat Linux
  192. Simple stored procedure examples?
  193. Per-row security
  194. Odd dump/restore question
  195. Unknown subdirectories in postgres base directory
  196. Re: I can not add up columns when using a left outer join. Any ideas as to why?
  197. DROP INDEX performance/locking
  198. I can not add up columns when using a left outer join. Any ideas as to why?
  199. explosion of tiny tables representing multiple fields--Is thisnecessary?
  200. Re: Is there anyway to...
  201. Invoking java in a trigger
  202. problem accessing a database
  203. I know the bad way...what is the good way?
  204. Isolation / Visibility inside a trigger
  205. Re: new and old not available in rule subselects?
  206. Re: Counting records in a PL/pgsql cursor
  207. Re: Counting records in a PL/pgsql cursor
  208. Re: Weird double single quote issue
  209. start up and shut down script
  210. Re: Does anyone have a compiled dblink_tds for Redhat EL 4.x?
  211. Geometry
  212. Re: Is there anyway to...
  213. Re: Is there anyway to...
  214. Re: Is there anyway to...
  215. not null across multiple columns
  216. Cannot rename file pg_xlog\0000.....
  217. dividing integers not producing decimal fractions
  218. new and old not available in rule subselects?
  219. Select permissions on System tables
  220. Catch multiple records when doing Select Into
  221. creating a dumpfile from a view
  222. Timeout Value on network error
  223. fetching unique pins in a high-transaction environment...
  224. Scalability
  225. Re: [SLE] Can't boot boot iso
  226. =?iso-2022-jp?B?GyRCNTkkNyQvJE0bKEI=?=
  227. Wrong record type - caused by SELECT order ???
  228. Re: pg_dumpall failing from possible corrupted shared memory
  229. Re: Problems running PostGreSQL silent install
  230. Re: CREATE TABLE initial value for PRIMARY KEY
  231. Re: Problems running PostGreSQL silent install
  232. Stripping empty space from all fields in a table?
  233. Simple OUTER JOIN doubt
  234. CREATE TABLE initial value for PRIMARY KEY
  235. Re: DBI-Link, Oracle, database encoding
  236. Re: [SQL] Can we convert from Postgres to Oracle !!???
  237. Mailing list problem?
  238. plpython.so
  239. Replicating changes
  240. plpython
  241. How to know the type of an expression ?
  242. Send email from PostgreSQL, may I ?
  243. Swing JTable and ResultSet TableModel (with big resultsets)
  244. Is postgres installed by default in Fedora Core 5 ??
  245. what is the default username password for PostgreSQL, which was installed with FC5.
  246. =?iso-2022-jp?B?GyRCRn42YiQ3JF4kORsoQg==?=
  247. Function returning setof more than 1 table
  248. arrays of user types.
  249. database not enforcing unqiue constriant
  250. Possible problem with PQescapeStringConn andstandard_conforming_strings