View Full Version : Pgsql General



  1. Unable to restart postgres - database system was interrupted
  2. Re: Restore database from files (not dump files)?
  3. Table definition changes when a row is dropped and recreated
  4. Ident authentication failed for user - URGENT
  5. HELP: Urgent, Vacuum problem
  6. Row-based authorization
  7. Re: Row-based authorization
  8. Where are my non-SQL-standard time functions?
  9. Time Stamp auto Field
  10. Re: JOIN work somehow strange on simple query
  11. Timestamps
  12. iplike.so access denied help!!
  13. Working with one live and one development database
  14. How to speed up Exclusive Locking
  15. [Fwd: Re: PG Admin]
  16. unaccent as stored procedure?
  17. Install/Uninstall Issues
  18. Problem working with dates and times.
  19. n00b RAID + wal hot standby question
  20. Windows Binary for pgDesigner
  21. Instal/Uninstall Problem
  22. Re: [HACKERS] getting index columns from information_schema?
  23. PG Admin
  24. pgsql bug found?
  25. Re: DBI module for postgres 1.4.3
  26. logs not ending up at Syslog
  27. Re: Unsuccessful SIGINT
  28. Re: DBI module for postgres 1.4.3
  29. Version 8.1
  30. Problems to create the portuguese dictionary
  31. Locking for function creation
  32. vacuum in standalone mode
  33. Storing files in postgres db
  34. Re: select query not using index
  35. How to use different lc_collate nad lc_ctype settings.
  36. Re: named cache
  37. select query not using index
  38. Re: initdb problem on Windows XP Home
  39. Re: initdb problem on Windows XP Home
  40. Re: initdb problem on Windows XP Home
  41. Unsuccessful SIGINT
  42. Re: Unsuccessful SIGINT - More Info
  43. Highload website database architecture
  44. best way to setup raid array in this situation
  45. Re: CertFirst Legit?
  46. trouble inserting into new partitions of partitioned tables
  47. DBI module for postgres 1.4.3
  48. porducing documentation from postgres
  49. Data corruption problem...
  50. 8.1.5 installation problem with initdb on WinXP Home
  51. Problem with function parameters
  52. transfer just the data directories from linux to windows?
  53. Re: Problem with function parameters
  54. FK locking still too strong
  55. Re: initdb problem on Windows XP Home
  56. Restoring database from files on disk
  57. Re: Restoring database from files on disk
  58. COPY FROM and NULL AS does not work
  59. Tsearch2 - Error using tsquery object in GROUP BBY queries
  60. Re: Tsearch2 - Error using tsquery object in GROUP BBY
  61. named cache
  62. initdb problem on Windows XP Home
  63. Restore database from files (not dump files)?
  64. Re: [pgsql-general] Separation of clients' data within a database
  65. Any issues w/PostgreSQL 8.0.4 on Win2K3 x64?
  66. Separation of clients' data within a database
  67. Need testers for 8.2 RC1 RPMs
  68. Function to replace decimal value with character ?
  69. Blob fields and backups
  70. Erorr in running create set command
  71. Stripping kernel FreeBSD - postgres
  72. postgresql 8.2 rc1 - crash
  73. Float8 precision problem
  74. Please help... syntax Error in create set ..
  75. Re: Including unique users in huge data warehouse in Postgresql...
  76. Version 8.1
  77. Re: Convert Oracle DECODE to CASE Automatically
  78. Convert Oracle DECODE to CASE Automatically
  79. Create index on array element?
  80. Re: How to implement backup protocol
  81. coalesce with all nulls can only be assigned to text
  82. Postgresql data integrity during RAID10 drive rebuild
  83. Re: Postgresql data integrity during RAID10 drive rebuild
  84. LOCK ... NOWAIT throws error
  85. Concatenate performance question
  86. Looking for pgsql sysadmin
  87. Dynamic views
  88. Dynamic views
  89. sudden drop in delete performance
  90. Calling pg_dump from another application in safe mode
  91. Please help.-- unable to load xxid.so
  92. unixodbc, oid and c++ error at insert
  93. Ident authentication failed for user "dsivam"
  94. Windows default editor for psql \e
  95. MI5 Persecution: Lander on C4
  96. MI5 Persecution: Observer article
  97. MI5 Persecution: .net magazine article
  98. MI5 Persecution: Financial Times
  99. using a sequence as the functional equivalent to Oracle rownum
  100. MI5 Persecution: Bizarre magazine
  101. MI5 Persecution: BBC h2g2 online
  102. Re: using a sequence as the functional equivalent to Oracle rownum
  103. slow inet within cidr query
  104. Including unique users in huge data warehouse in Postgresql...
  105. Re: AIX and getaddrinfo (was Re: Upgrade problem)
  106. MI5 Persecution: harassment at work
  107. MI5 Persecution: their methods and tactics
  108. MI5 Persecution: their methods and tactics
  109. MI5 Persecution: my response to the harassment
  110. MI5 Persecution: abuse in set-up situations and in public
  111. MI5 Persecution: Bernard Levin expresses his views
  112. MI5 Persecution: Bernard Levin expresses his views
  113. Very minor "configure" issue?
  114. MI5 Persecution: who knows about it?
  115. Datafiles binary portable?
  116. MI5 Persecution: how and why did it start?
  117. MI5 Persecution: cost of the operation
  118. MI5 Persecution: Capital Radio - Chris Tarrant
  119. MI5 Persecution: bugging and counter-surveillance
  120. MI5 Persecution: the BBC, television and radio
  121. Re: Question about encoding
  122. [Windows] Pg_Restore on 8.1.5 and so on...
  123. Problem with unique key
  124. Re: Problem with unique key
  125. sequence help
  126. Re: A generic trigger to log chanes on database tables
  127. Re: Why overlaps is not working
  128. Re: IS it a good practice to use SERIAL as Primary Key?
  129. are wombats good?
  130. where are wombats?
  131. Re: postgresql bug
  132. interested in wombats
  133. NULLs ;-)
  134. CertFirst Legit?
  135. Re: IS it a good practice to use SERIAL as Primary Key?
  136. backend crash following load command
  137. Re: IS it a good practice to use SERIAL as Primary Key?
  138. Unexpected sort order.
  139. DB crashed
  140. Re: IS it a good practice to use SERIAL as Primary Key?
  141. fatal error on 8.1 server
  142. SSL error: decryption failed or bad record mac
  143. PostgreSQL doesn't accept connections when Windows Server is rebooted
  144. Re: IS it a good practice to use SERIAL as Primary Key?
  145. Re: OID Perfomance - Object-Relational databases
  146. How to increace nightly backup speed
  147. Returning multiple rows from a function?
  148. IN clause in a cursor
  149. -b command line parameter in pg_dump
  150. Re: Buffer overflow in psql
  151. Solaris 10 problem
  152. pg_restore error
  153. Question about encoding
  154. Re: Connecting via ssh tunnel
  155. new server
  156. starting postgres on windows
  157. Re: Upgrade problem
  158. Re: Question about PG cache selection strategy
  159. Slow left outer join
  160. Upgrade
  161. CONNECT privilege
  162. Re: CONNECT privilege
  163. Re: CONNECT privilege
  164. have pg_restore create a new database?
  165. Re: advanced index (descending and table-presorted descending)
  166. Re: Grant group revoke user isue
  167. Clone all user defined triggers in schema
  168. Editing contrib modules which are loaded by default?
  169. which version? old user coming back....
  170. Development of cross-platform GUI for Open Source DBs
  171. Connecting via ssh tunnel
  172. How to restore a dumbed file in postgreSQL
  173. indexes
  174. Carriage-Return in text field
  175. PGDATA
  176. PGDATA
  177. vacuum: out of memory error
  178. Re: Postgres scalability and performance on windows
  179. more than one row returned by a subquery used as an expression
  180. How to clone a table so that primay and foreign keys remain
  181. IN clause
  182. Re: COPY FROM : out of memory
  183. Re: MSSQL to PostgreSQL : Encoding problem
  184. Re: Postgres scalability and performance on windows
  185. Re: Stuck in "DELETE waiting"
  186. Re: Postgres scalability and performance on windows
  187. Re: IS it a good practice to use SERIAL as Primary Key?
  188. tsearch to spellcheck
  189. 2 problems of my postgresql
  190. Dollaw sign quoting disabled
  191. Re: Extract between year *and* month
  192. Vienna migrating some DB's from Oracle to PG
  193. Re: PostgreSQL equivalent of the Oracale 'unique' qualifier
  194. COPY FROM encoding error
  195. Thanks for all the help on replacing 'unique'
  196. more on database design
  197. Calculating percentages in Postgresql
  198. Re: ORDER BY
  199. where to download postgresql-server-7.2.2-1.i386.rpm?
  200. error server connection
  201. pg_get_serial_sequence is inconsistent
  202. Re: kerberos authentication error with Windows 2003 SP1 AD
  203. functions: stable/volatile
  204. Re: phpPgAdmin, cannot connect to server
  205. =?iso-2022-jp?B?GyRCPXUkMSRGJC8kQCQ1JCQbKEI=?=
  206. problem in joins
  207. pg_hba.conf
  208. Druid for postgreSQL - can I export my ERD to MS Access?
  209. Can't Create Tablespace On Windows 2003
  210. Running a query as a specific, different user
  211. tsearch trigger: function public.tsearch2(tsvector, text) does not exist
  212. phpPgAdmin, cannot connect to server
  213. composite type insert
  214. User-defined-type in C crashing PostgreSQL server: What am I doingwrong?
  215. After Update Triggers
  216. Allowing SYSDATE to Work
  217. Is there a PostgreSQL utility that is similiar to Oracles sql loader?
  218. Copy command to load data into a PostgreSQL DB
  219. Shutting down a warm standby database in 8.2beta3
  220. Select slow over network
  221. tracking errors in psql
  222. user defined C-lang pg function bug
  223. function visibility
  224. Client SSL validation using root.crt
  225. Re: dependency on 32 bit libpq.so on 64 bit Postgres server.
  226. pg_dump : option --exclude-schema not recognized
  227. explain analyze taking longer than executing the query?
  228. Eliminating bad characters from a database for upgrading from 7.4 to 8.1
  229. Extract between year *and* month
  230. Linux hard drive/device nodes for a Postgres RAID array
  231. Accessing postgres in perl app using ssl authentication
  232. PostgreSQL: Question about rules
  233. SPI
  234. statement_timeout
  235. Partial index
  236. Strange Postgresql crash
  237. odd result set
  238. Why the data changes it's value by itself!
  239. problem in to_char() function
  240. PostGreSql cannot start after windows update
  241. Re: dependency on 32 bit libpq.so on 64 bit Postgres server.
  242. Postgres misses readline
  243. Re: ORDER BY
  244. calculated default
  245. Re: ORDER BY
  246. dependency on 32 bit libpq.so on 64 bit Postgres server.
  247. Transaction id wraparound problem
  248. How to crash postgres using savepoints
  249. Data conversion tools?
  250. Not your father's question about deadlocks