PDA

View Full Version : Pgsql General

  1. Questions regarding generating the WAL File.
  2. Restart after poweroutage
  3. Re: New US DST Rules & PostgreSQL
  4. Stored procedure
  5. orphaned PGDATA/base/ subdirectories
  6. How to disable displaying of a NOTICE context?
  7. More information on how to understand table pg_locks.
  8. insert rule instead oddity
  9. Incorrect "ERROR: database "xxx" is being accessed by other users"
  10. Re: Multi DB performance test
  11. Installing with libs of postgresql-libs
  12. SQL Question - Group By and % results per row
  13. SQL Question - Group By and % results per row
  14. passing passords to pgsql/pg_create/pg_dump programmatically
  15. Tracking disk writes? (again)
  16. finding a column by name in psql
  17. ALTER column TYPE varying question
  18. Re: query ... returned 4 columns
  19. Getting Text data as C string
  20. DBD::Pg/perl question, kind of...
  21. %tsearch gendict snowball spanish
  22. Re: odbc can't edit postgresql database ?? -- Small example
  23. passing an array type to a plpython procedure
  24. question about stored procedure / function
  25. odbc can't edit postgresql database ??
  26. Views dependency
  27. Upgrading Postgres large databases with blobs
  28. pl/pgsql FOR LOOP with function
  29. How to enforce uniqueness when NULL values are present?
  30. Please verify your MoneyBookers account
  31. unary operators, precedence, grouping
  32. Recommendations for postgres upgrade of database with lobs
  33. Moving from 32 to 64 bit builds on Solaris
  34. Is This A Set Based Solution?
  35. index bloat problem
  36. Is This A Set Based Solution?
  37. Re: query ... returned 4 columns
  38. Re: Beginner's Questions
  39. Yet another PostgreSQL C++ binding
  40. Trigger for Audit Table
  41. Re: PostgreSQL to Oracle
  42. Sw to generate ER model
  43. Statistics
  44. Tracking disk writes?
  45. Bitmap AND multicolumn index used !
  46. one-to-one schema design question and ORM
  47. Error code associated to "could not open relation with OID ..."
  48. Beginner's Questions
  49. Can i run pg_ctl under Administrator account ?
  50. Please verify your MoneyBookers account
  51. On default privilege/access behavior and how to change it?
  52. make cascade the default?
  53. Anyone know a good opensource CRM that actually installs with Posgtres?
  54. Weird behaviour on a join with multiple keys
  55. Solaris and Ident
  56. Tsearch2 / Create rule on select
  57. Can psql show me where my script is broken?
  58. group by and aggregate functions on regular expressions
  59. security permissions for functions
  60. Determine users and roles
  61. java.sql.SQLException: The connection attempt failed
  62. query ... returned 4 columns
  63. foreign key support for inheritance
  64. Tabulate data incrementally
  65. DB Modeler
  66. OT: Canadian Tax Database
  67. GIST index on geometry+integer
  68. Real world performance improvements in 8,2
  69. How to use pg_resetxlog if data directory is in c:/Program Files ?
  70. Password for postgres
  71. Query help
  72. pg_restore and database comments
  73. server vendor recommendation
  74. You have received a postcard !
  75. "Cache lookup failed for function" when recreating procs
  76. Database deadlock/hanging
  77. Default Cast type
  78. which is more scalable for the database?
  79. postgres slower on nested queries
  80. vacuum error
  81. Re : Importing *huge* mysql database into pgsql
  82. "oracle to postgresql" conversion
  83. aggregate planning with partitions
  84. Permission problem using lo_export
  85. Importing *huge* mysql database into pgsql
  86. Re: Does it has a way to compact the database size?
  87. plpythonu and PYTHONPATH/sys.path
  88. Postgres Mailing List management solution
  89. Re: Does it has a way to compact the database size?
  90. Re: Does it has a way to compact the database size?
  91. FreeBSD kernel configuration
  92. Re: US Highschool database in postgres
  93. Database slowness -- my design, hardware, or both?
  94. pq_flush: send() failed: Broken pipe
  95. RFC tool to support development / operations work with slony replicated databases
  96. =?iso-2022-jp?B?GyRCJEQkJCRLTWgkPyQhJCEhKiEqGyhC?=
  97. M:M table conditional delete for parents
  98. No buffer space available
  99. Runaway Instances of Postmaster
  100. Bulk insert new and update out of temp table
  101. Why don't dumped files parse in pgAdmin3 query editor?
  102. privileges of views and sequences
  103. =?utf-8?B?XHNldCBhIG11bHTEsWzEsW5lIHZhcsSxYWJsZQ==?=
  104. Re: real multi-master replication?
  105. =?utf-8?B?XHNldCBhIG11bHTEsWzEsW5lIHZhcsSxYWJsZQ==?=
  106. Re : Re : COPY form stdin and file
  107. Postgres ebmail and hermes
  108. COPY form stdin and file
  109. Query timing
  110. Postgres Replication
  111. COPY from and NULL values for double precisions fields
  112. plpgsql and insert
  113. How to capture and handle failed INSERT
  114. real multi-master replication?
  115. pljava on mac
  116. Cannot digest subscribe
  117. how to pass an array to the plpgsql function from Java Code
  118. issue with select currval
  119. xpath and xml namespaces
  120. date format
  121. Re: Interface to posgresql
  122. SAM BROADCASTER v4.2.2
  123. Configure can't find com_err on OpenBSD for --with-krb5
  124. Support for idempotent schema changes?
  125. pg temp tables
  126. pljava for mac osx 10.4.8
  127. I'd love to know what the rest of this error message is.
  128. Large aggregate query running out of memory in ExecutorState
  129. Custom session variables?
  130. How Can I set a non standard date format?
  131. PG Dump 8.2
  132. Re : Re : pg_dump, serial
  133. WITH/RECURSIVE plans
  134. Re : pg_dump, serial
  135. COPY FROM and multiple null strings
  136. psql client quits after 1st command
  137. pg_dump, serial
  138. Re: Add items to a record variable
  139. SOLVED: Re: PostgreSQL primary (sequence) key issue (Ruby/Rails)
  140. Add items to a record variable
  141. Thanks to all
  142. Constraint validation
  143. Fun with Cursors- how to rewind a cursor
  144. rpm containing pgdump
  145. is pg_standby over nfs expected to work?
  146. Connections over SSH tunnels closing after idle time
  147. who uses tsearch2
  148. hardware question - LSI MegaRaid 8480e
  149. PostgreSQL primary (sequence) key issue (Ruby/Rails)
  150. Re:
  151. Re: PG periodic Error on W2K
  152. get username of user calling function?
  153. ftell mismatch with expected position
  154. creating a function with a variable table name
  155. supporting 2000 simultaneous connections.
  156. Bug in row locking?
  157. postgres init script reports failure, but postmaster started
  158. Constructors for dates, times, and timestamps
  159. strange behaviour with sub-select and pl/pgSQL
  160. 2d array issues
  161. TSearch2: Can't build gendict output
  162. Can I getting a unique ID from a select
  163. Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics
  164. cast bytea to text
  165. Please Help ! Error with Access 2003
  166. usage for 'with recursive'?
  167. Assistance with Query Optimisation?
  168. PG periodic Error on W2K
  169. Why does "group by" need to match select fields?
  170. why can't I increase shared buffers to higher value?
  171. Differences in identical queries
  172. Recursive/Wildcard Object Ownership Change
  173. giving a user permission to kill their processes only
  174. 8.1.8 Installer Fails on Win2k Server
  175. Select retrieval slowdown after db drop/reload. Suggestions?
  176. /libexec/ld-elf.so.1: Shared object "libpq.so.4" not found
  177. PostgreSQL 8.2.3, Jboss 4.0.3 and postgresql-8.2-504.jdbc4
  178. Post-Reboot Issue: Postmaster Not Accessible
  179. Curious situation - running program cannot seem to delete records.
  180. Re: How to Kill IDLE users
  181. pgagent install on windows
  182. Difference between UNIQUE constraint vs index
  183. Recovering from a corrupt database
  184. How to Kill IDLE users
  185. How to use OIDs on tables......OR....a better solution?
  186. How often do I need to reindex tables?
  187. MI5 Persecution: Troubling Censorship Issues 20/8/95 (5257)
  188. MI5 Persecution: Stand up for Free Speech 14/8/95 (2602)
  189. pg_dump and restore problem with function as DEFAULT-Constraint
  190. Building a record in a function
  191. select ARRAY[1,4,3] @> ARRAY[3,1] gives ERROR: operator does not exist: integer[] @> integer[] ???
  192. How to debug this crash?
  193. performance of partitioning?
  194. How does filter order relate to query optimization?
  195. Unable to restore dump due to client encoding issues -- or, when isSQL_ASCII really UTF8
  196. Bad performace of a query
  197. SQL names for C constants
  198. postgres powered search engine
  199. US Highschool database in postgres
  200. Connecting to a remote server, pg_hba.conf error?
  201. dropping a master table and all of its partitions?
  202. Most efficient report of number of records in all tables?
  203. grant on sequence and pg_restore/pg_dump problem
  204. psql : password on Win32
  205. Re: help required regarding queryin postgis database from google maps
  206. stored procedure optimisation...
  207. Re: how to sort an array and remove duplicate in plpgsql
  208. Querying all months even if don't exist
  209. how to sort an array and remove duplicate in plpgsql
  210. proper export table to csv? multilineproblem.
  211. Re: [HACKERS] urgent: upgraded to 8.2, getting kernelpanics
  212. PostgreSQL 8.2.x and JDBC driver
  213. pulling hair out trying to force replan
  214. Best way to store and retrieve photo from PostGreSQL
  215. Inserting a new column in between.
  216. some tables unicode, some ascii?
  217. Why can't I put a BEFORE EACH ROW trigger on a view?
  218. M$ Access "crosstab" query tab PostgreSQL equivalent
  219. Re: [HACKERS] 5 Weeks till feature freeze or (do you know where your patch is?)
  220. perfromance world records
  221. FTI (not tsearch) ignores greek
  222. pgfoundry
  223. schema design question
  224. problem installing NPGSQL and pgOLEDB with .NET
  225. how to tell if using unnamed paramaterized queries?
  226. Composite Keys
  227. General Ledger db design
  228. db stats vs table stats
  229. Restore After Changing Table Structures
  230. SQL Question - Using Group By
  231. pg_autovacuum should allow NULL values
  232. PostgreSQL on Windows Paper
  233. false unique constraint error...for me
  234. server closed unexpectedly while executing a function
  235. select all matches for a regular expression ?
  236. ODBCng and OpenOffice 2.1
  237. Ruby on Rails for PostgreSQL
  238. Writing oracle/postgress generic SQL
  239. greedy or not? regexps...
  240. Supported plpgsql BEFORE ... EACH ROW behavior
  241. PGSQL Locking vs. Oracle's MVCC
  242. Installing PGSQL Client
  243. Triggers inherited?
  244. Large Objects
  245. Warning "TupleDesc reference leak"
  246. Moving WAL files
  247. Slony subscription problem
  248. Guarenteeing ordering constraints
  249. how to generate a list of distinct scalar values from a column which type is array
  250. Esay question, about the numeric format