PDA

View Full Version : Pgsql General

  1. "field doesn't exist" even though I'm sure it does
  2. view management
  3. convert access sql to postgresql
  4. Primary Key
  5. unexplainable error
  6. public schema doubt
  7. pl-pgsql "return set of..." "return next..." performance question
  8. Re: public schema doubt
  9. ERROR: out of memory
  10. postgres 8 on solaris 9
  11. Composite types for composite primary/foreign keys?
  12. Substitute column in SELECT with static value?
  13. Windows Installer Problems/Stall Solution Error 2769
  14. ERROR: cache lookup failed for type
  15. Common criteria evaluation?
  16. getting the number of rows affected by a query
  17. automating backups with windows scheduled tasks and pg_dumpall
  18. Request for suggestion on replication methods
  19. ERROR: there is no parameter $1
  20. Question about PostgreSQL from Delphi newsgroups
  21. Re: pg_dump problem
  22. Cisco MDS support
  23. Postgresql and resource isolation
  24. Compressed Backup too big
  25. 8.3 vs 8.2 sql compatiblity issue
  26. PostgreSQL 8.2 and Firebird 1.5 comparative
  27. PostgreSQL 8.2.5 compile problem
  28. Re: FW: Chunk Delete
  29. Compiled debugger plug in for windows, any one have it?
  30. moving from mysql to postgree
  31. Chunk Delete
  32. Query Performance Test
  33. Serial IDs
  34. Re: pg_dump problem
  35. =?iso-2022-jp?B?GyRCSC84KyQ3JF4kNyQ/GyhCISE=?=
  36. implicit casting bug or feature?
  37. Re: Enforcing Join condition
  38. XML schema
  39. Variable LIMIT and OFFSET in SELECTs
  40. Chunk Delete
  41. Re: pg_dump problem
  42. Windows x64 Port
  43. psql Segmentation fault
  44. Re: pg_dump problem
  45. Re: PLpgsql debugger question
  46. Qeury a boolean column?(using postgresql & EJB)
  47. PLpgsql debugger question
  48. pg_dump problem
  49. autovacuum and reindex
  50. reserving space in a rec for future update
  51. Postgres table size
  52. Sharing database handles across forked child processes
  53. Impact of table scan on shared buffers
  54. Which JDBC Pool to use
  55. Path to top of tree
  56. Bulk Load Ignore/Skip Feature
  57. Client-requested cast mode to emulate Pg8.2 on v8.3
  58. FreeBSD portupgrade of 8.1 -> 8.2
  59. PITR and warm standby setup questions
  60. Re: Linux v.s. Mac OS-X Performance
  61. Using generate_series to create a unique ID in a query?
  62. WAL segments size
  63. Strange error while working with derived table
  64. Re: Linux v.s. Mac OS-X Performance
  65. update record with two-column primary key
  66. =?ISO-8859-1?Q?Us=FAario_Conectados?=
  67. Linux v.s. Mac OS-X Performance
  68. How to uninstall the geometry package?
  69. Filter tables
  70. reverse strpos?
  71. Accessing a db with pgAdmin
  72. Re: Linux v.s. Mac OS-X Performance
  73. pg_tables and temp tables
  74. float to int
  75. Duplicating a table row while honouring key constraints
  76. Regression in 8.3?
  77. MI5 Persecution: Neil Fox (Nov/1998) (1957)
  78. MI5 Persecution: Flying Eye (Mar/1999) (4131)
  79. MI5 Persecution: Johnny Boy (21/Aug/1998) (6305)
  80. MI5 Persecution: Johnny Boy (19/June/1999) (8479)
  81. MI5 Persecution: Brighton 24/9/98 (10653)
  82. MI5 Persecution: POSK 2/2/98 (12827)
  83. MI5 Persecution: Leicester Square 9/2/98 (15001)
  84. plperl and regexps with accented characters - incompatible?
  85. Verison 8.3 PL/pgSQL debugger Question
  86. strange infinite loop in plpgsql
  87. Importance of CPU floating point performance...
  88. any way to query for current connections to db?
  89. Re: any way to query for current connections to db?
  90. looping over the rows in a table
  91. Is "query" a reserved word in 8.3 plpgsql?
  92. Insert statements really slow
  93. pg_dumpall and authentication
  94. Warning about max_fsm_pages: what's that?
  95. PIPELINED Functions
  96. Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
  97. pg_ctl & show all
  98. configure using libxml
  99. PQexec(), what should I do for the "NULL in command" problem?
  100. Re: System V IPC on Windows
  101. Open Source GIS System
  102. subselect field "problem"
  103. Re: System V IPC on Windows
  104. Re: System V IPC on Windows
  105. Optimal time series sampling.
  106. INSERT performance deteriorates quickly during a large import
  107. System V IPC on Windows
  108. Strange variable behaviour when using it in limit clause in plpgsql stored procedure
  109. why there is no interval / interval operator?
  110. Re: "Resurrected" data files - problem?
  111. ldap authentication allows logon with blank password
  112. what is the date format in binary query results
  113. Rollback capacity
  114. Recovering / undoing transactions?
  115. Exclusive Locks Taken on User Tables?
  116. strange timezone problem
  117. Re: Postgresql simple query performance question
  118. Re: Postgresql simple query performance question
  119. list of postgres related unexpected 'features'
  120. The .pgpass file
  121. md5() sorting
  122. Temporary, In-memory Postgres DB?
  123. prepared statements suboptimal?
  124. number errors
  125. =?Windows-1252?Q?=91--pwfile=92_command_?=
  126. returning dynamic record
  127. ORDER BY a string
  128. Re: Syntax error in a large COPY
  129. Exclusive Locks Taken on User Tables?
  130. Syntax error in a large COPY
  131. How does the query planner make its plan?
  132. How to find non-unique indexes in system tables
  133. external editor for psql
  134. Re: Postgresql simple query performance question
  135. Problem starting the server with Mac OSX
  136. RPATH issue with libpq on Solaris 8 (gcc)
  137. Re: Postgresql simple query performance question
  138. generic crosstab
  139. Re: Postgresql simple query performance question
  140. How to create primary key
  141. safely increase a single column integer value
  142. running postgresql
  143. Is there a way to tell how far along a COPY is in the process?
  144. Filter sequence
  145. Locale and indexes: howto?
  146. php and postgres - too many queries too fast?
  147. any way for ORDER BY x to imply NULLS FIRST in 8.3?
  148. what could be blocking an insertion?
  149. Re: Would an index benefit select ... order by?
  150. Bitemporal sequenced unique constraint (function/trigger)
  151. How to temporarily disable a table's FK constraints?
  152. Selecting all but a few fields in a query
  153. Npsql is much faster than ODBC ?
  154. Re: Would an index benefit select ... order by?
  155. What makes a Postgres DBA?
  156. Restore a database
  157. Re: COPY ... FROM and index usage
  158. Small dedicated install of PgSQL for a program
  159. Would an index benefit select ... order by?
  160. index usage in joins q'n
  161. Problem starting the server with Mac OSX
  162. unexpected behavior in combining timestamps with times zone and intervals
  163. setting for maximum acceptable plan cost?
  164. Cybercluster
  165. Copy the database..
  166. Questions concerning check constraints
  167. index on array?
  168. young guy wanting (Postgres DBA) ammo
  169. XML database
  170. Improve Search
  171. Calculation for Max_FSM_pages : Any rules of thumb?
  172. Need Refrences
  173. Storing float array
  174. =?UTF-8?Q?Re:__select_random_order_by_random?=
  175. Re: Scrolling cursors in PL/PgSQL
  176. Re: Scrolling cursors in PL/PgSQL
  177. test
  178. Re: Scrolling cursors in PL/PgSQL
  179. =?UTF-8?Q?Re:__select_random_order_by_random?=
  180. Populating large DB from Perl script
  181. Solaris 10, mod_auth_pgsql2
  182. Re: select random order by random
  183. =?UTF-8?Q?select_random_order_by_random?=
  184. REQ: pgagent to send out alert/emails if error occurs
  185. day of week
  186. If Postgresql DLL files causing any kind of conflict for two different versions of Postgresql installed on one machine
  187. Attaching information about users
  188. anybody attending FOSS.in 2007 ??
  189. posgresql-8.2 startup problem
  190. Number to Words Conversion
  191. Search path in group_roles not honered for logins
  192. Re: Securing stored procedures and triggers
  193. PostgreSQL Conference Fall 2007 wrap up
  194. how can I shut off "more"?
  195. current_user changes immediately after login
  196. Re: Securing stored procedures and triggers
  197. Server's Locale
  198. getting list of tables from command line
  199. Re: active connections
  200. Replacing RDBMS
  201. Securing stored procedures and triggers
  202. Re:
  203. configure password
  204. Join between tables of two or more databases
  205. strange message from pg_dumpall
  206. Re:
  207. generating UPDATE SET ... WHERE PK = ...
  208. Re:
  209. Updated .vim file
  210. pgsql.broken.csc
  211. Table has type character varying, but query expects character varying
  212. active connections
  213. PG windows service issues
  214. Re: PostgreSQL .msi Installation Failure
  215. Re: Selecting K random rows - efficiently!
  216. Checking empty array
  217. Pgaccess
  218. Locale collation issues
  219. reg. rewrite rules
  220. plperl ubuntu problem
  221. How can I easily and effectively support (language) translation of column values?
  222. sql
  223. nonstandard use of
  224. how to unsubscribe from this group?
  225. Delete/Update with order by
  226. SSL Connectivity on Solaris 10 x86
  227. Partitioning: how to exclude unrelated partitions?
  228. ALTER TRIGGER Before / After?
  229. Stored procedure for generation next sequence value
  230. Raid Chunk Sizes for DSS type DB
  231. Base Backups from PITR Standby
  232. reg. rewrite rules
  233. DST problem on pg 8.2.5
  234. function and passing the table name to be used with SQL stmnt
  235. Collation sequence and use of operatings system's locale
  236. A few questions
  237. postgresql in PHP
  238. Automatic schema updates
  239. Problems with PostgreSQL DBI-Link / DBD-ODBC
  240. Re: select count() out of memory
  241. pg_restore
  242. Which index can i use ?
  243. How can I easily and effectively support (language) translation of column values?
  244. Postgres+Apache+PHP (again, but in different setup)
  245. createdb argument question
  246. I want to search my project source code
  247. Stored Procs Vs User Defined Functions vis-a-vis UDF's in Postgresql
  248. Version 8.3
  249. Postgres+Apache+PHP (again, but in different setup)
  250. Re: 8.2.3: Server crashes on Windows using Eclipse/Junit