PDA

View Full Version : Pgsql General

  1. Runtime error when calling function from .NET ( Function returnsrecord)
  2. Re: Performance with very large tables
  3. Re: Performance with very large tables
  4. check table existence...
  5. Persistent connections in PHP with PDO
  6. Re: Performance with very large tables
  7. Performance with very large tables
  8. Backup the part of postgres database
  9. Avoiding empty queries in tsearch
  10. PQexec does not return.
  11. Re: Antw: Re: Problems with unique restrictions
  12. substr negative indexes
  13. Antw: Re: Problems with unique restrictions
  14. like query backslash
  15. index type for indexing long texts
  16. automatic build of return type
  17. XEON familiy 5000, 5100 or 5300?
  18. Problems with unique restrictions
  19. installing 8.2 on solaris 10?
  20. Backup and restore UTF8 data
  21. Re: I've compiled and installed -- what next?
  22. Remove diacritical marks in SQL
  23. Re: Checkpoint request failed on version 8.2.1.
  24. FK Constraint on index not PK
  25. Version 8.2 for HP-UX
  26. WAL question
  27. error in open cursor
  28. Re: Need setup help for Postgresql 8.1.3 on Solaris 10
  29. Re: PG compilation
  30. Need setup help for Postgresql 8.1.3 on Solaris 10
  31. plpgsql and arrays
  32. Select Query
  33. Re: Corrupt database? 8.1/FreeBSD6.0
  34. Corrupt database? 8.1/FreeBSD6.0
  35. Function which returns record
  36. documentation vs reality: template databases
  37. RESTORE Error
  38. pg_standby testing notes
  39. generate_series with month intervals
  40. Remove duplicate rows
  41. storing SMALL large objects to postgres with C# (.NET ODBC layer)
  42. Checkpoint request failed on version 8.2.1.
  43. crosstab - pivot - transpose
  44. Optimize expresiions.
  45. Cluster all tables in database to PK index
  46. Knowing the length(convert(username using windows_1251_to_utf8))
  47. PG compilation
  48. Question - Query based on WHERE OR
  49. plpgsql trapping full detail error message
  50. Moving the database from winxp to linux
  51. tsearch2 headline() query subselect help
  52. Prelink errors?
  53. Problems With VIEWS
  54. Re: Export to shape file
  55. replication advice needed
  56. Re: Autovacuum Improvements
  57. Foreign Key Identification
  58. Recording insert, updates, and deletes
  59. join problem...
  60. pg_dump and very slow database
  61. SP in PostgreSQL
  62. date of table creation
  63. PostgreSQL Connections?
  64. Trying to load MySQL data
  65. remove embedded carriage returns
  66. How does one perform a case-insenstive query on test or char fields
  67. Re: PGPASS.CONF =?UTF-8?B?wr9pcyB0aGVyZSBhIHdheSB0byBw?=
  68. Re: is there a tracking trace tool like the "SQL Analizer
  69. index creation on 7.3
  70. ERROR: invalid memory alloc request size, and others
  71. Operator performance question
  72. Re: Autovacuum Improvements
  73. Postgres Replication
  74. Confused by misleading error message on SP creation
  75. Temporary table: cross-transaction conflicts?
  76. Array constructor requires one argument
  77. 8.2.1 TSearch changes?
  78. Database "postgres"
  79. DISABLE/ENABLE TRIGGER question
  80. COPY FROM and sequences
  81. Re: Autovacuum Improvements
  82. Questions about horizontal partitioning
  83. SELECT INTO using Views?
  84. insert only unique values in to a table, ignore rest?
  85. Re: Newbie Constraint ?
  86. Re: is there a tracking trace tool like the "SQL Analizer
  87. Re: Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4
  88. Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4
  89. Slony in Windows installer?
  90. is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?
  91. Sorting
  92. Postgres Differential backup
  93. doubts
  94. Advice needed on using postgres in commercial product
  95. Sorting with DISTINCT ON
  96. Command "connect by prior" in PostgreSQL ?
  97. Web interface to update/change postgres data.
  98. TRIGGER BEFORE INSERT
  99. MI5 Persecution: Security Service Tribunal Denies
  100. registering ODBC driver...
  101. losing my large objects with Postgresql 8.1.4 and 8.1.5
  102. Continue sequence
  103. configure; make on cygwin doesn't produce DLLs
  104. Re: [ADMIN] vacuum fails with 'invalid page header' message
  105. Slony across platforms
  106. PyGreSQL Install
  107. vacuum v. vacuumdb
  108. More activity in pg_stat_activity
  109. Continue sequence
  110. Re: Deleting From View?
  111. Database Corruption - last chance recovery options?
  112. GUI tool that can reverse engineering schemas
  113. Interrupted pg_dump / pg_restore Upgrade
  114. upgrading and pg_restore versions
  115. Bug in 8.2 (&8.1) dump & restore
  116. MI5 Persecution: Communications with Security Service Tribunal in 1999
  117. Any form of connection-level "session variable" ?
  118. Update to 8.2 in openSUSE 10.2
  119. Dependency conflicts on CentOS 4.4
  120. Need help in PGSQL
  121. Using duplicate foreign keys
  122. Discovering time of last database write
  123. pg_dump question
  124. Moving from 7.2.1 to 8.1.5 - looking for jdbc
  125. self-referential UPDATE problem on 7.4
  126. How to use the SQL parser subsystem
  127. Pure PostgreSQL unit tests - test and debug pgsql constraints and procedures/functions
  128. I will hold your copy for 24 hours
  129. LargeObjects Total Size
  130. MI5 Persecution: Eye Say, and Lord Gnome Answers
  131. Table inheritance implementation.
  132. Accessing a custom FileSystem (as in Mysql "Custom Engine")
  133. MI5 Persecution: Counter-surveillance sweep by Nationwide Investigations Group
  134. could not open file xxxx for writing: Permission denied
  135. Tabbed data in tab-separated output
  136. Re: [pgsql-es-ayuda] Update to 8.2 in openSUSE 10.2
  137. pg_dump problems
  138. granting SELECT on _all_ database objects (even non existingobjects)
  139. superuser authentication?
  140. "no unpinned buffers available" ? why? (hstore and plperl involved)
  141. database design and refactoring
  142. Index Scanning
  143. queueing via database table?
  144. Re: Geographical redundancy
  145. Combining data in different rows?
  146. PostgreSQL 8.2.1 expected release date?
  147. ldap auth problem
  148. About auto_increment
  149. Re: About auto_increment
  150. Re: About auto_increment
  151. Schema and Function names
  152. regular expression limit
  153. Replacing all CHAR colums with VARCHAR
  154. How to convert "money" columns to "numeric"?
  155. Re: spooky refusal to insert
  156. spooky refusal to insert
  157. permission denied for relation
  158. MI5 Persecution: Observer article
  159. Application validation of data on insert
  160. Installing support for python on windows
  161. Database versus filesystem for storing images
  162. MI5 Persecution: .net magazine article
  163. Re: slow speeds after 2 million rows inserted
  164. COALESCE function
  165. =?iso-2022-jp?B?GyRCPDpOaUNXJDckXiQ5GyhC?=
  166. =?iso-2022-jp?B?GyRCPDpOaUNXJDckXiQ5GyhC?=
  167. Generic timestamp function for updates where field names vary
  168. Question from eBay Member regarding Item #150057720098
  169. How to use Php connecting to pgsql
  170. Re: Geographical redundancy
  171. psql script error handling
  172. Re: slow speeds after 2 million rows inserted
  173. slow speeds after 2 million rows inserted
  174. Index vacuum improvements in 8.2
  175. How to unlock a row
  176. Re: NEED URGENT HELP....
  177. questions about migrating form postgres 7 to 8
  178. Geographical redundancy
  179. Re: DB problem
  180. Why ContinueUpdateOnError is not implemented in npgsql
  181. Optimising "full outer join where" for muti-row to multi-columnview
  182. Seeking help on subscription problem
  183. Backup Restore
  184. odbc and pgadmin.support newsgroup from news server are not functional
  185. Date
  186. LDAP configuration problem
  187. FW: select union with table name
  188. Re: select union with table name
  189. select union with table name
  190. unique constraint on more than one tables
  191. Improve response time of a SQL command
  192. OS X Tiger, and PostgreSQL 8.2 don't mix?
  193. =?gb2312?B?tPC4tDogW0dFTkVSQUxdIE5lZWQgSGVscA==?=
  194. Need Help
  195. libnss_pgsql? anyone have it working?
  196. Is PostgreSQL for this?
  197. Is PostgreSQL for this?
  198. MI5 Persecution: Financial Times
  199. Re: DB problem
  200. MI5 Persecution: Bizarre magazine
  201. MI5 Persecution: BBC h2g2 online
  202. MI5 Persecution: harassment at work
  203. MI5 Persecution: why the security services?
  204. MI5 Persecution: their methods and tactics
  205. array quotation problem
  206. MI5 Persecution: my response to the harassment
  207. MI5 Persecution: purpose in publicizing it; censorship in uk.* newsgroups
  208. MI5 Persecution: abuse in set-up situations and in public
  209. MI5 Persecution: why won't the British police do their job and put a stop to it?
  210. ORDER BY col is NULL in UNION causes error?
  211. MI5 Persecution: Bernard Levin expresses his views
  212. MI5 Persecution: who knows about it?
  213. MI5 Persecution: how and why did it start?
  214. MI5 Persecution: cost of the operation
  215. MI5 Persecution: Capital Radio - Chris Tarrant
  216. MI5 Persecution: bugging and counter-surveillance
  217. MI5 Persecution: the BBC, television and radio
  218. Functions to obtain group members- PostgreSQL prior to 8.1
  219. Optimization of unnecessary GROUP BY columns
  220. =?us-ascii?Q?pgAdmin=20crashes?=
  221. could not open relation:no such file or directory
  222. Re: Need some Technical support !!!
  223. Re: NEED URGENT HELP....
  224. Re: NEED URGENT HELP....
  225. Does pgsql's regex processor optimize Common-Prefix?
  226. seeking for suggestions - sporadic performance degradation
  227. I NEED A HACKER TO WORK WITH AS A PARTNER FOR A BIG DEAL
  228. ERROR: could not access status of transaction
  229. Re: Merry Christmas!
  230. table locks
  231. convert(... using windows_1251_to_utf8) - works on cli, but not in a c prog.
  232. Re: Problem with large table not using indexes (I think)
  233. tape backups
  234. Troubles restoring PgSQL 8.1.3 after a crash
  235. Clustering & Load Balancing & Replication
  236. psql "SCHEMA" switch
  237. Problem with index in OR'd expression
  238. Re: Unable to start server - winxp
  239. lo_import
  240. Re: Unable to start server - winxp
  241. which schema to install contrib modules
  242. Tricky join question
  243. Tsearch2 default locale on postgres 8.2
  244. =?gb2312?B?tPC4tDogW0dFTkVSQUxdIFVuYWJsZSB0byBzdGF ydCBzZXJ2ZXIgLSB3aW4=?==?gb2312?B?eHA=?=
  245. Re: Unable to start server - winxp
  246. DBmirror
  247. Best Perl DBI Driver for Postgres
  248. How could I get a win32/aix version of plruby?
  249. 'Indirect' clustering?
  250. Partitioning Vs. Split Databases - performance?