PDA

View Full Version : Pgsql General

  1. Column as arrays.. more efficient than columns?
  2. Getting sequence name for a non-serial column
  3. fillfactor Question
  4. =?iso-8859-1?Q?pg=5Fdump_doesn=B9t_dump_everything=3F?=
  5. Querying database for table pk - better way?
  6. now() vs current_user
  7. Is the ole db provider broken?
  8. psql connect_timeout feature
  9. SQL for Deleting all duplicate entries
  10. how to find the number of rows inserted into the master table?
  11. temp tables and sequences in functions
  12. SQL query with IFs (?) to "Eliminate" NULL Values
  13. PostgreSQL and Crystal Report
  14. How to 'register' functions, so they can be called (plpythonu)
  15. Controlling locale and impact on LIKE statements
  16. Controlling locale and impact on LIKE statements
  17. Documentation fix regarding atan2
  18. psql hanging
  19. UTF8 frustrations
  20. Database owner can't analyze/vacuum all of the database tables
  21. SELECT question (splitting a field)
  22. Partition Reindexing
  23. Re: Data Warehousing
  24. Symlinking (specific) tables to different Drives
  25. Max File size per Table (1G limit??)
  26. Suggestion for new function on pg_catalog: get_config()
  27. Vacuum process idle but hogging memory 8.2.4
  28. Connecting to PostgreSQL server with Mono using ident authetication
  29. Statistics collection question
  30. Cannot install under Windows Vista
  31. Re: invalid byte sequence for encoding "UTF8": 0xff
  32. Re: Instances where enable_seqscan = false is good
  33. invalid byte sequence for encoding "UTF8": 0xff
  34. Data Warehousing
  35. Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
  36. Error Message: invalid command-line arguments for serverprocess
  37. PostgreSQL with Kerberos and Active Directory
  38. Open Source Application Server (PostgreSQL Perspective)
  39. IRS Notification - Tax refund (Internal Revenue Service)
  40. WAL Archiving problem
  41. Error Message: invalid command-line arguments for serverprocess
  42. Reporting services for PostgreSQL
  43. Open Source Application Server (PostgreSQL Perspective)
  44. JOIN issues (Left vs Right for sorting), and "Nested Loop" problem
  45. Export data to MS Excel
  46. computing and updating the size of a table with large objects
  47. Obtaining random rows from a result set
  48. URGENT: Whole DB down ("no space left on device")
  49. Out of memory error, FreeBSD 6.2, PostgreSQL 8.2.4
  50. Query the catalog
  51. return 1 formatted result instead of multiple results
  52. E_BAD_ACCESS with palloc/pfree in base type
  53. auditing in postgresql
  54. Metadata
  55. Out of shared memory (locks per process) using table-inheritance style partitioning
  56. Select question
  57. why does a system catalog insert/update/delete not fire a trigger?
  58. rules and rows affected
  59. date of next Version 8.2 release
  60. PostgreSQL with Kerberos and Active Directory
  61. Autovacuum not vacuuming pg_largeobject
  62. Parallel transactions to full vacuum
  63. accessing PG using Perl:DBI
  64. \copy only select rows
  65. What kind of locks does vacuum process hold on the db?
  66. Re: PostgreSQL Conference Fall 2007
  67. Can this function be declared IMMUTABLE?
  68. pg_dump.... pg_restore...how long does it take?
  69. counting columns
  70. show connection limit?
  71. SSL and crash woes.
  72. Re: postgresql connection string to Vb.NET
  73. Question regarding autovacuum in 8.1
  74. postgresql connection string to Vb.NET
  75. Re: pgsql Windows installer fixed registry key
  76. Etc/% timezones
  77. pg_dump.... pg_restore...how long does it take?
  78. Performance issue with nested loop
  79. How to avoid "Seq Scans"?
  80. Can postgresql support chinese word?
  81. Will Index improve the speed?
  82. autovacuum not running
  83. Is there a better way to do this?
  84. Install on 32 or 64 bit Linux?
  85. Question regarding autovacuum
  86. Can this function be declared IMMUTABLE?
  87. 8.1.10 release?
  88. OT? Courier + PgSQL problem
  89. ecpg: dtime_t vs timestamp
  90. Reliable and fast money transaction design
  91. Turning off atime on PostgreSQL DB volumes
  92. difference between function and stored procedure
  93. Indexing Foreign Key Columns
  94. INSERT doc discrepancy
  95. One database vs. hundreds?
  96. ERROR: table row type and query-specified row type do not match
  97. Creating indices on foreign keys
  98. =?us-ascii?Q?Crashed_DB_and_=22base=22_WAL_files?=
  99. =?us-ascii?Q?Crashed_DB_and_=22base=22_folder_files?=
  100. Read Access to database
  101. delete vs insert vs update due to primary key dups -> which isbetter
  102. naming a primary key possible?
  103. how to print a schema
  104. String Escaping in Pattern Matching
  105. Is this a bug? Insert float into int column inserts rounded valueinstead of error.
  106. pgsql Windows installer fixed registry key
  107. Re: PostgreSQL vs Firebird feature comparison finished
  108. Windows Download
  109. Npgsql GUI problem C#.net
  110. How to restore my database ?
  111. psql \copy command runs as a transcation?
  112. PickSplit method of 2 columns ... error
  113. Re: [ANNOUNCE] == PostgreSQL Weekly News - August 26 2007 ==
  114. [ERROR] syntax error at end of input
  115. EXPLAIN ANALYZE not considering primary and unique indices!
  116. create or replace for tables and schemas
  117. Removing pollution from log files
  118. Tables dissapearing
  119. pgloader - Can't find textreader/csvreader
  120. Restore v. Running COPY/INDEX seperatly
  121. Detecting whether a point is in a box.
  122. SQL Diff ?
  123. LDAP service lookup
  124. Re: Varchar -> Integer[] conversion
  125. Can someone else verify if this is a bug?
  126. MI5 Persecution: Neil Fox (March/1998) (6000)
  127. Bigtime scaling of Postgresql (cluster and stuff I suppose)
  128. MI5 Persecution: Capital Radio (11/April/1997) (4777)
  129. MI5 Persecution: GLR: David Hepworth (9/May/1997) (3554)
  130. MI5 Persecution: GLR: David Hepworth (21/Feb/1997) (2331)
  131. MI5 Persecution: Life is so hard (1108)
  132. MI5 Persecution: BBC1 TV News - 18/Dec/2002 (8446)
  133. MI5 Persecution: Channel Four TV News - 10/April/2002 (7223)
  134. MI5 Persecution: BBC-TV See You, See Me - 7/Dec/2001 (6000)
  135. MI5 Persecution: C4 SnowMail - January/2001 (4777)
  136. MI5 Persecution: England expects every man to do his duty (3554)
  137. MI5 Persecution: Nicholas Witchell - 10/April/1999 (2331)
  138. MI5 Persecution: Chris Tarrant - 10/March/1999 (1108)
  139. Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
  140. connect by service name in psql
  141. Add Column BEFORE/AFTER another column
  142. lc_collate issue
  143. Re: Can tsearch do some basic text mining
  144. Re: FATAL: could not reattach to shared memory (Win32)
  145. Re: FATAL: could not reattach to shared memory (Win32)
  146. Re: [OT - sorta] How to extract a substring using Regex
  147. Out of Memory - 8.2.4
  148. ERD of information_schema / system catalog?
  149. Re: [OT - sorta] How to extract a substring using Regex
  150. tsearch query question
  151. pgsql functions: get column headers; optional arguments
  152. simple query runs 26 seconds
  153. cant get spatial data..
  154. pgsql functions: get column headers; optional arguments
  155. Simple Regex question, hoping for direct answer (no Socratic approach necessary)
  156. How to extract a substring using Regex
  157. Re: FATAL: could not reattach to shared memory (Win32)
  158. Re: Adapter update.
  159. 64 bit PG on OSX, FATAL: could not create shared memory segment
  160. Adapter update.
  161. Apache + PHP + Postgres Interaction
  162. Argument type list
  163. Error Installing postgres 8.2.4 on Windows Server 2003 64bit
  164. Re : reporting tools
  165. Undetected corruption of table files
  166. FATAL: could not reattach to shared memory (Win32)
  167. Re: Postgres, fsync and RAID controller with 100M of internal cache & dedicated battery
  168. Local authentication/security
  169. table column vs. out param [1:0]
  170. PostgreSQL vs Firebird feature comparison finished
  171. Re: pg_dump causes postgres crash
  172. pg_dump causes postgres crash
  173. %TYPE
  174. CPU load high
  175. ERROR: could not open relation with OID
  176. reporting tools
  177. Geographic High-Availability/Replication
  178. How to switch off Snowball stemmer for tsearch2?
  179. Adapter update.
  180. "out of memory" error
  181. Postgres, fsync and RAID controller with 100M of internal cache & dedicated battery
  182. Re: raw data into table process
  183. Problem with UPDATE and UNIQUE
  184. Pgcluster 1.7 Fail safe !!!
  185. Re: Pgcluster 1.7 Fail safe !!!
  186. PG Seg Faults Performing a Query
  187. Converting non-null unique idx to pkey
  188. history table
  189. Array with Subselect / ANY - cast?
  190. Need help doing a PostgreSQL vs Firebird feature comparison
  191. Audit-trail engine inner-workings
  192. problem Linking a TTable component to a pgsql view using BCB5
  193. do you have an easy example of postgis and mapserver?
  194. Using oid as pkey
  195. MI5 Persecution: Channel Four TV News - 12/Feb/1999 (6000)
  196. MI5 Persecution: Dimbleby / John Major, April 1997 (4777)
  197. MI5 Persecution: Ken Clarke (2), April 1997 (3554)
  198. MI5 Persecution: Ken Clarke (1), April 1997 (2331)
  199. MI5 Persecution: Overview (1108)
  200. MI5 Persecution: David Hepworth (2) 16/5/97 (18230)
  201. Auto-partitioning?
  202. MI5 Persecution: Victor Lewis-Smith 9/5/97 (17007)
  203. PGError: input out of range
  204. Solution to Bus error(coredump) from postgres binary
  205. MI5 Persecution: Continuing Silence 9/5/97 (15784)
  206. SUBSTRING performance for large BYTEA
  207. Automated testing of functions
  208. Join query help
  209. MI5 Persecution: Peak Practice 26/4/97 (14561)
  210. Re: Installation problems
  211. MI5 Persecution: I am being ignored 17/4/97 (13338)
  212. Re: Stripping apostrophes from data
  213. MI5 Persecution: Striking out action 10/3/97 (12115)
  214. Re: Stripping apostrophes from data
  215. Re: Stripping apostrophes from data
  216. Re: Stripping apostrophes from data
  217. Re: Table description
  218. MI5 Persecution: No Justice 20/11/96 (9669)
  219. MI5 Persecution: WTGROMT 18/11/96 (8446)
  220. MI5 Persecution: Excellent web page 19/10/96 (7223)
  221. MI5 Persecution: Usual targets of such abuse 10/10/96 (6000)
  222. MI5 Persecution: Just too crazy 30/9/96 (4777)
  223. MI5 Persecution: Latest technology 31/7/96 (3554)
  224. MI5 Persecution: BBC+ITN=MI5 23/7/96 (2331)
  225. MI5 Persecution: Silly-billy 6/7/96 (1108)
  226. MI5 Persecution: Silly-billy 6/7/96 (6000)
  227. MI5 Persecution: Old_500 5/7/96 (4777)
  228. MI5 Persecution: alt.fan.mike-corley 6/6/96 (3554)
  229. MI5 Persecution: Bernard Levin 1/6/96 (2331)
  230. MI5 Persecution: Fitted up 26/4/96 (1108)
  231. Installation problems
  232. pg_class.relfilenode for large tables
  233. POSTGRE CRASH AND CURRVAL PROBLEM HELP!
  234. entry log
  235. MI5 Persecution: Fitted up 26/4/96 (1108)
  236. Searching for Duplicates and Hosed the System
  237. WAITING in PG_STATS_ACTIVITY
  238. Postgresql performance in production environment
  239. query large amount of data in c++ using libpq
  240. Seeking datacenter PITR backup procedures [RESENDING]
  241. query large amount of data in c++ using libpq
  242. server closed the connection unexpectedly
  243. server closed the connection unexpectedly
  244. waiting in pg_stats_activity
  245. SUBSTRING performance for large BYTEA
  246. Automating logins for mundane chores
  247. Partitioning
  248. Question on INDEX and SQL - stalling my database?
  249. Problem with pg_hba.conf?
  250. =?gb2312?q?Antique_1912-1949_Porcelain_teapot_528_chinaware_400_=A3=ACWebs ite_extreme_security=A3=ACinvitation_visit?=