PDA

View Full Version : Pgsql General

  1. libpq/libpq-fs.h
  2. datatype advice numeric vs. varchar
  3. Re: How I can read-back a serial value just inserted?
  4. Re: How I can read-back a serial value just inserted?
  5. Re: How I can read-back a serial value just inserted?
  6. Newbie questions (pg_global, tablespace, pg_temp, ...)
  7. FATAL: invalid frontend message type 47 server closed the connectionunexpectedly
  8. Alter definition of a column
  9. pg_dump without oids
  10. Building web sites using a database
  11. Re: Controlling memory of session
  12. Complete newbie question on odbc
  13. SELECT INTO TEMPORARY problem
  14. Diagnosing deadlock / connection hang
  15. Index bloat of 4x
  16. Newbie questions (pg_global, tablespace, pg_temp, ...)
  17. Controlling memory of session
  18. copy row tree
  19. Cursor body?
  20. Re: Need help on SP
  21. The jdbc and current_timestamp
  22. Process won't start in Windows
  23. GUID/UUID Support
  24. [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)
  25. 8.1 vs 8.2.1 view optimization
  26. Multi-column constraint behaviour
  27. lock query
  28. Temp Table Within PLPGSQL Function - Something Awry
  29. trigger howto question
  30. Re: Coercion in PGSQL?
  31. Elegant copy of a row using PL
  32. Mounting a data dir read only
  33. Re: Need setup help for Postgresql 8.1.3 on Solaris 10
  34. invalid byte sequence for encoding "UTF8"
  35. Dynamic loading of Perl Code in Postgres functions
  36. Need help on SP
  37. Coercion in PGSQL?
  38. Very long "or" where clause
  39. Custom index type for indexing long texts?
  40. Collating Question...
  41. Re: Transaction callback
  42. Linking tables and indexes
  43. Improve Postgres Query Speed
  44. postmaster disconnects after heavy load inserts from plperlu -> waht to do?
  45. Reserve a value in a serial type field
  46. NOTIFY QUESTION
  47. Glacially slow nested SELECT
  48. Unpredicatable behavior of volatile functions used in cursors
  49. Avoiding empty queries in tsearch
  50. Runtime error when calling function from .NET ( Function returnsrecord)
  51. Re: Performance with very large tables
  52. Re: Performance with very large tables
  53. check table existence...
  54. Persistent connections in PHP with PDO
  55. Re: Performance with very large tables
  56. Performance with very large tables
  57. Backup the part of postgres database
  58. Avoiding empty queries in tsearch
  59. PQexec does not return.
  60. Re: Antw: Re: Problems with unique restrictions
  61. substr negative indexes
  62. Antw: Re: Problems with unique restrictions
  63. like query backslash
  64. index type for indexing long texts
  65. automatic build of return type
  66. XEON familiy 5000, 5100 or 5300?
  67. Problems with unique restrictions
  68. installing 8.2 on solaris 10?
  69. Backup and restore UTF8 data
  70. Re: I've compiled and installed -- what next?
  71. Remove diacritical marks in SQL
  72. Re: Checkpoint request failed on version 8.2.1.
  73. FK Constraint on index not PK
  74. Version 8.2 for HP-UX
  75. WAL question
  76. error in open cursor
  77. Re: Need setup help for Postgresql 8.1.3 on Solaris 10
  78. Re: PG compilation
  79. Need setup help for Postgresql 8.1.3 on Solaris 10
  80. plpgsql and arrays
  81. Select Query
  82. Re: Corrupt database? 8.1/FreeBSD6.0
  83. Corrupt database? 8.1/FreeBSD6.0
  84. Function which returns record
  85. documentation vs reality: template databases
  86. RESTORE Error
  87. pg_standby testing notes
  88. generate_series with month intervals
  89. Remove duplicate rows
  90. storing SMALL large objects to postgres with C# (.NET ODBC layer)
  91. Checkpoint request failed on version 8.2.1.
  92. crosstab - pivot - transpose
  93. Optimize expresiions.
  94. Cluster all tables in database to PK index
  95. Knowing the length(convert(username using windows_1251_to_utf8))
  96. PG compilation
  97. Question - Query based on WHERE OR
  98. plpgsql trapping full detail error message
  99. Moving the database from winxp to linux
  100. tsearch2 headline() query subselect help
  101. Prelink errors?
  102. Problems With VIEWS
  103. Re: Export to shape file
  104. replication advice needed
  105. Re: Autovacuum Improvements
  106. Foreign Key Identification
  107. Recording insert, updates, and deletes
  108. join problem...
  109. pg_dump and very slow database
  110. SP in PostgreSQL
  111. date of table creation
  112. PostgreSQL Connections?
  113. Trying to load MySQL data
  114. remove embedded carriage returns
  115. How does one perform a case-insenstive query on test or char fields
  116. Re: PGPASS.CONF =?UTF-8?B?wr9pcyB0aGVyZSBhIHdheSB0byBw?=
  117. Re: is there a tracking trace tool like the "SQL Analizer
  118. index creation on 7.3
  119. ERROR: invalid memory alloc request size, and others
  120. Operator performance question
  121. Re: Autovacuum Improvements
  122. Postgres Replication
  123. Confused by misleading error message on SP creation
  124. Temporary table: cross-transaction conflicts?
  125. Array constructor requires one argument
  126. 8.2.1 TSearch changes?
  127. Database "postgres"
  128. DISABLE/ENABLE TRIGGER question
  129. COPY FROM and sequences
  130. Re: Autovacuum Improvements
  131. Questions about horizontal partitioning
  132. SELECT INTO using Views?
  133. insert only unique values in to a table, ignore rest?
  134. Re: Newbie Constraint ?
  135. Re: is there a tracking trace tool like the "SQL Analizer
  136. Re: Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4
  137. Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4
  138. Slony in Windows installer?
  139. is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?
  140. Sorting
  141. Postgres Differential backup
  142. doubts
  143. Advice needed on using postgres in commercial product
  144. Sorting with DISTINCT ON
  145. Command "connect by prior" in PostgreSQL ?
  146. Web interface to update/change postgres data.
  147. TRIGGER BEFORE INSERT
  148. MI5 Persecution: Security Service Tribunal Denies
  149. registering ODBC driver...
  150. losing my large objects with Postgresql 8.1.4 and 8.1.5
  151. Continue sequence
  152. configure; make on cygwin doesn't produce DLLs
  153. Re: [ADMIN] vacuum fails with 'invalid page header' message
  154. Slony across platforms
  155. PyGreSQL Install
  156. vacuum v. vacuumdb
  157. More activity in pg_stat_activity
  158. Continue sequence
  159. Re: Deleting From View?
  160. Database Corruption - last chance recovery options?
  161. GUI tool that can reverse engineering schemas
  162. Interrupted pg_dump / pg_restore Upgrade
  163. upgrading and pg_restore versions
  164. Bug in 8.2 (&8.1) dump & restore
  165. MI5 Persecution: Communications with Security Service Tribunal in 1999
  166. Any form of connection-level "session variable" ?
  167. Update to 8.2 in openSUSE 10.2
  168. Dependency conflicts on CentOS 4.4
  169. Need help in PGSQL
  170. Using duplicate foreign keys
  171. Discovering time of last database write
  172. pg_dump question
  173. Moving from 7.2.1 to 8.1.5 - looking for jdbc
  174. self-referential UPDATE problem on 7.4
  175. How to use the SQL parser subsystem
  176. Pure PostgreSQL unit tests - test and debug pgsql constraints and procedures/functions
  177. I will hold your copy for 24 hours
  178. LargeObjects Total Size
  179. MI5 Persecution: Eye Say, and Lord Gnome Answers
  180. Table inheritance implementation.
  181. Accessing a custom FileSystem (as in Mysql "Custom Engine")
  182. MI5 Persecution: Counter-surveillance sweep by Nationwide Investigations Group
  183. could not open file xxxx for writing: Permission denied
  184. Tabbed data in tab-separated output
  185. Re: [pgsql-es-ayuda] Update to 8.2 in openSUSE 10.2
  186. pg_dump problems
  187. granting SELECT on _all_ database objects (even non existingobjects)
  188. superuser authentication?
  189. "no unpinned buffers available" ? why? (hstore and plperl involved)
  190. database design and refactoring
  191. Index Scanning
  192. queueing via database table?
  193. Re: Geographical redundancy
  194. Combining data in different rows?
  195. PostgreSQL 8.2.1 expected release date?
  196. ldap auth problem
  197. About auto_increment
  198. Re: About auto_increment
  199. Re: About auto_increment
  200. Schema and Function names
  201. regular expression limit
  202. Replacing all CHAR colums with VARCHAR
  203. How to convert "money" columns to "numeric"?
  204. Re: spooky refusal to insert
  205. spooky refusal to insert
  206. permission denied for relation
  207. MI5 Persecution: Observer article
  208. Application validation of data on insert
  209. Installing support for python on windows
  210. Database versus filesystem for storing images
  211. MI5 Persecution: .net magazine article
  212. Re: slow speeds after 2 million rows inserted
  213. COALESCE function
  214. =?iso-2022-jp?B?GyRCPDpOaUNXJDckXiQ5GyhC?=
  215. =?iso-2022-jp?B?GyRCPDpOaUNXJDckXiQ5GyhC?=
  216. Generic timestamp function for updates where field names vary
  217. Question from eBay Member regarding Item #150057720098
  218. How to use Php connecting to pgsql
  219. Re: Geographical redundancy
  220. psql script error handling
  221. Re: slow speeds after 2 million rows inserted
  222. slow speeds after 2 million rows inserted
  223. Index vacuum improvements in 8.2
  224. How to unlock a row
  225. Re: NEED URGENT HELP....
  226. questions about migrating form postgres 7 to 8
  227. Geographical redundancy
  228. Re: DB problem
  229. Why ContinueUpdateOnError is not implemented in npgsql
  230. Optimising "full outer join where" for muti-row to multi-columnview
  231. Seeking help on subscription problem
  232. Backup Restore
  233. odbc and pgadmin.support newsgroup from news server are not functional
  234. Date
  235. LDAP configuration problem
  236. FW: select union with table name
  237. Re: select union with table name
  238. select union with table name
  239. unique constraint on more than one tables
  240. Improve response time of a SQL command
  241. OS X Tiger, and PostgreSQL 8.2 don't mix?
  242. =?gb2312?B?tPC4tDogW0dFTkVSQUxdIE5lZWQgSGVscA==?=
  243. Need Help
  244. libnss_pgsql? anyone have it working?
  245. Is PostgreSQL for this?
  246. Is PostgreSQL for this?
  247. MI5 Persecution: Financial Times
  248. Re: DB problem
  249. MI5 Persecution: Bizarre magazine
  250. MI5 Persecution: BBC h2g2 online