PDA

View Full Version : Pgsql General

  1. OLEDB vs ODBC to access postgres
  2. Install Postgresql on Win2000 with Admin Rights
  3. date and time
  4. Checking if Aggregate exists
  5. Problem with update on partitioned table
  6. Toast Table
  7. help optimizing query
  8. ALTER TABLE with USING clause for timestamp
  9. Postgres connection error
  10. Re: Postgres development
  11. Re: MySQL to Postgres question
  12. Re: MySQL to Postgres question
  13. How to concatenate a boolean to a text string for an EXECUTE stmtin a stored proc
  14. scheduling stored procedure
  15. INFINITE RECURSION with rules...
  16. Insert
  17. tabs in psql
  18. table size and storage location
  19. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  20. Transaction wraparound problem with database postgres
  21. Trigger transactions
  22. Postgresql partitioning
  23. Installing on Windows without using msi Installer
  24. C function and enum types parameters
  25. begin-end blocks in psql
  26. Re: 8.3.0 upgrade
  27. MySQL to Postgres question
  28. Re: Transaction wraparound problem with database postgres
  29. --enable-thread-safety bug
  30. Re: cast problem 8.3.1
  31. deadlock error messages
  32. ecpg program getting stuck
  33. MySQL to Postgres question
  34. Re: [postgis-users] how many min. floating-points?
  35. Re: dynamically generated SQL and planner/performance
  36. createuser: could not connect to database postgres: FATAL: could not open file "global/pg_database": No such file or directory
  37. Re: Which JDBC version to use with PostgreSQL 8.1.11?
  38. cursor manipulation
  39. PGSQL database size question
  40. Cast character to boolean
  41. Table size
  42. Running function automatically on (unclean) disconnect
  43. Re: beginner: what permissions required to install on windows 2000+
  44. Re: Problem with async notifications of table updates
  45. Feature request/suggestion - CREATE SCHEMA LIKE
  46. identify database process given client process
  47. postgresql performance tuning tools
  48. Catch-22
  49. Get info about indexes
  50. Get index information from information_schema?
  51. Re: LOCK TABLE HELP
  52. array function problem
  53. Re: 8.3.0 upgrade
  54. Re: Cannot Install PostgreSQL on Windows 2000 Server
  55. Redundant file server for postgres
  56. UPDATE stalls when run in "batch mode"
  57. Updating
  58. Permission template
  59. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  60. Re: how to make this database / query faster
  61. Re: how to make this database / query faster
  62. on insert when ... do instead update
  63. Making a schema "read-only" (was Unexpected message in grant/revoke script)
  64. Unexpected error in grant/revoke script
  65. Unexpected message in grant/revoke script
  66. SQL UPDATE question
  67. How to silence psql notices, warnings, etc.?
  68. shared memory/max_locks_per_transaction error
  69. Re: LOCK TABLE HELP
  70. Blobs
  71. Re: Please Help! Was: Multithread problem: Error intransaction processing
  72. LOCK TABLE HELP
  73. GRANT giving error on sequence in 7.4.19
  74. forcing use of more indexes (bitmap AND)
  75. pgbench not setting scale size correctly?
  76. PG secure for financial applications ...
  77. Question about the cluster command
  78. Using MicroOLAP DAC to connect to Database - Problem with Grid
  79. tsearch2 word separators
  80. empty pg_stat user views
  81. Segmentation fault (core dumped) loading data on 8.3 upgrade: undefinedsymbol 'pg_valid_server_encoding_id',lazy binding failed!
  82. Dump format for long term archiving.
  83. My CPU usage remains over 50% with Postgre
  84. =?ISO-8859-1?Q?Percent-encoding_conversion_to_binary=2C_%C2%A9_?==?ISO-8859-1?Q?=3D_=A9?=
  85. pgfoundry is down
  86. ER diagram tool
  87. Generate schema like uml diagrams from existing db
  88. WAL Archiving Error
  89. Segementation fault in PQgetvalue()
  90. Recomendations on raid controllers raid 1+0
  91. Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT ....ON COMMIT DROP
  92. Reindex does not finish 8.2.6
  93. Column Statistics - How to dertermine for whole database
  94. Duplicate key violation on UPDATE
  95. porting vb6 code to pgplsql, referencing fields
  96. porting vb6 code to pgplsql, referencing fields
  97. table size in 8.3
  98. Service Account password
  99. Re: Checking is TSearch2 query is valid
  100. Subplan and index usage
  101. PostgreSQL won't start
  102. Function Returning SETOF RECORD: Trouble With Char Type
  103. Functional Index Question
  104. oralink
  105. PostgreSQL user documentation wiki open for business
  106. Can't rename an existnig DB because it doesn't exist???
  107. Using PL/R for predictive analysis of data.
  108. pain of postgres upgrade with extensions
  109. porting vb6 code to pgplsql, referencing fields
  110. migration of 7.4 to 8.1
  111. SELECT overhead in explicit transaction
  112. SELECT in explicit transaction
  113. Problem with starting PostgreSQL server 7.4.19
  114. FROM + JOIN when more than one table in FROM
  115. simple UPDATE statement...
  116. Array load from remote site through Perl/DBI
  117. Re: Relocation error:
  118. Trouble with Savepoints in postgres
  119. Normalizing denormalization with materialized views
  120. basic plpgsql / sql funtion question
  121. How to convert postgres timestamp to date: yyyy-mm-dd
  122. ERROR: text search configuration "pg_catalog.english" does not exist
  123. postgre vs MySQL
  124. list user created triggers
  125. Database OID xxxxx now seems to belong to "foo"
  126. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  127. PostgreSQL and MOLAP ?
  128. message contents do not agree with length in message type "T"
  129. split pg_dumpall backups per database
  130. Relocation error: /usr/lib/libpq.so.5: undefined symbol: krb5_cc_get_principal
  131. searching using indexes 8.3
  132. php pg_connect fails, pgsql works
  133. On defining Perl functions within PLPERL code
  134. pg_type.relacl
  135. Trigger to run @ connection time?
  136. Multithread problem: Error in transaction processing
  137. PostreSQL Single File ( Like M$ Access)
  138. problem with pg_statistic_relid_att_index
  139. Re: my problem for i/o error when i use postgre
  140. Fwd: pgsql configuration
  141. Re: my problem for i/o error when i use postgre
  142. Re: [PERFORM] multi-threaded pgloader makes it in version 2.3.0
  143. pgsql configuration
  144. Reindexdb + relation error
  145. restore_command %r option
  146. ISO something like "#if 0 ... #endif" for SQL code
  147. [Fwd: Re: how do you write aggregate function]
  148. Nested xpath() calls "lose" namespace support
  149. =?us-ascii?Q?large=20object=20import?=
  150. gsoc ideas
  151. Re: v8.3 + UTF8 errors when restoring DB
  152. data import - duplicates
  153. v8.3 + UTF8 errors when restoring DB
  154. loading a psql input file on win xp
  155. cache lookup failed for relation X
  156. cache lookup failed for relation X
  157. Re: Watch your PlanetPostgreSQL.org blogs
  158. Service account not showing
  159. Re: Watch your PlanetPostgreSQL.org blogs
  160. Watch your PlanetPostgreSQL.org blogs
  161. shared_buffers and shmmax what are the max recommended values?
  162. PHPs PDO, apache and "never ending sessions"
  163. pg_standby for solaris x86
  164. Cumulative (Running) Sum
  165. Problems with 8.3
  166. Cannot Install PostgreSQL on Windows 2000 Server
  167. Violation of non existing reference
  168. staring pgsql on fedora 8
  169. Re: I'm in need of something that should be there
  170. Re: Postgresql Page Layout details
  171. mssql to postgres problems with bytea help needed
  172. Postgresql Page Layout details
  173. Ask ctid
  174. Terminal completion
  175. PostgreSQL UK Conference 2008
  176. PostgreSQL vs. MySQL benchmarks on SMP FreeBSD 7.0
  177. Requiring a password
  178. executing query results withing psql
  179. Re: Constraint name for named NOT NULL constraintsis ignored
  180. indexing - creates problem
  181. I'm in need of something that should be there
  182. Changing column names in tables 2
  183. JOIN and difference between timestamps
  184. Changing column names in tables
  185. ER Diagram design tools (Linux)
  186. Re: [SQL] Documenting a DB schema
  187. Re: Documenting a DB schema
  188. Re: Documenting a DB schema
  189. Re: Documenting a DB schema
  190. Re: GRANT ALL ON recursive for all tables in my scheme?
  191. Re: using warm standby with drbd???
  192. I don't understand this WARNING on pg_ctl startup
  193. PGPOOL_HA
  194. Import file into bytea field in SQL/plpgsql?
  195. Find Number Of Sundays Between Two Dates
  196. Meaning og Logs
  197. Re: partitioning using dblink
  198. Build 8.3 with OpenSSL on CentOS 5.x?
  199. Re: beginner: what permissions required to install on windows 2000+
  200. Re:
  201. Checkpoints questions
  202. Question about PostgreSQL's bytea compatibility with MS Access as front-end
  203. how do you write aggregate function
  204. Cross database joins feature request
  205. UUID vs int keys....
  206. [off topic] looking for as/400 advice
  207. Re: PostgreSQL Array Use
  208. Re: beginner: what permissions required to install on windows 2000+
  209. =?Windows-1251?B?ztHNzsLbINPP0MDCy8XNyN8gz9DOxcrSwMzIOiDO0iD IxMXIIMTOINDFwMvIx8DWyMguIMPO0s7C28Ug0MXYxc3I3w==? =
  210. PostgreSQL Array Use
  211. Connect to postgres from a dynamic IP
  212. PostgreSQL Docs - Community Documentation
  213. Re: Connect to postgres from a dynamic IP
  214. Querying Headers
  215. Confused about CASE
  216. Re: beginner: what permissions required to install on windows 2000+
  217. Efficiently storing a directed graph
  218. Design suggestion of multiple databases vs multiple schemas within the database
  219. Unicode comment on Postgres vs Sql Server
  220. 8.2.6 > 8.3 blows up
  221. SERIAL and Primary Key
  222. Problems making client perl connection to postgres server
  223. Schema Export/Import
  224. issue with an assembled date field
  225. Removing Users and Revoking Privileges
  226. Upgrade to 8.3.0?
  227. pgsql structure export to XML
  228. Re: partitioning using dblink
  229. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  230. Re: partitioning using dblink
  231. Re: Insert vs Update syntax
  232. Re: partitioning using dblink
  233. Babase, a PostgreSQL database and an example Foxpro conversion
  234. Insert vs Update syntax
  235. ecpg problem
  236. rule question
  237. Text Search zero padding
  238. =?iso-2022-jp?B?GyRCQCdIczBsRVkkPSROTFwkRzgrJEZNXyQ3JCQkTiRHJ DkhIxsoQg==?=
  239. errors in pg_restore on windows?
  240. partitioning using dblink
  241. syntax errors at "line 1" when executing every command
  242. Space wasted by denormalized data
  243. "Consider compacting this relation..." ???
  244. Re: WAL Log Size
  245. LIMIT Question
  246. initlocation on windows
  247. =?iso-2022-jp?B?GyRCJGgkbSQ3JC8kKjRqJCRDVyQ3JF4kORsoQg==?=
  248. "=" or ":=" ?
  249. Re: WAL Log Size
  250. beginner: what permissions required to install on windows 2000+