PDA

View Full Version : Pgsql General

  1. Re: User can not more login
  2. Re: Connection string
  3. Re: Connection string
  4. cannot create table using pl/perl
  5. Problem with a dropped database
  6. deploy postgre question
  7. Deploying app. using PostgreSQL
  8. Migrating PostgreSQL database to MySQL/MS Access
  9. Automatic Backup Script
  10. Connection Object
  11. Jasper Reports
  12. Best approach for a "gap-less" sequence
  13. table space for temporal tables
  14. VACUUM VERBOSE output to STDERR
  15. Help.
  16. database file encryption
  17. Blackberry experts?
  18. Re: [NOVICE] Unable to connect to PostgreSQL 8 from PGAdmin III
  19. How to use the full text index feature on PostgreSQL 8.x
  20. my first procedure
  21. High available solution
  22. No comerr32.dll and krb5_32.dll on WIN32 build
  23. CURRENT_TIMESTAMP wierd behaviour
  24. How to do auto numbering on INT column
  25. How to do auto numbering on INT column
  26. Setting Slony on a large production database
  27. corruption - toasted table
  28. psycopg problem
  29. Connection string
  30. Too many open files from postgres.
  31. Syslog v/s filename in pg_ctl command
  32. Re: WIN32 Build?
  33. PL/pgSQL Problem
  34. WIN32 Build?
  35. Not so much load balancing as load limits
  36. Tuning to speed select
  37. psql/readline clears screen
  38. Data warehouse & OLAP
  39. sizing of a server
  40. Does DROP TABLE free up disk space immediately?
  41. DB connectivity from a client machine
  42. clients and libs and versions (oh my)
  43. Why is default value not working on insert?
  44. Accessing Database Data from C Function
  45. read only transaction, temporary tables
  46. DISTINCT to get distinct *substrings*?
  47. restoring a backup, incompatible with server
  48. Restoring database from old DATA folder
  49. Installing and using SLONY-I cluster
  50. I need a function
  51. DROP TABLESPACE fails
  52. FATAL Error
  53. Varchar concatenate fields as Char or Varchar, not Text
  54. psql: absolutes and toggles
  55. XPath question - big trouble
  56. does pgsql downloading mirror sites work?
  57. Re: does pgsql downloading mirror sites work?
  58. psql internal variables
  59. could not open relation - why?
  60. server optimisation
  61. error initing db
  62. Disabling and enabling constraints and triggers to make pg_restore work
  63. Problem writing function
  64. Re:
  65. running PostGres without installing it
  66. Consulta
  67. missing chunk number 0 for toast value xxxxx
  68. Ajax/PostgreSQL
  69. Re:
  70. Slow transfer speeds
  71. PostgreSQL Internals
  72. Scheduling Automatic Backups
  73. Recover lost database from DATA folder
  74. PostgreSQL engagment
  75. Problem connecting to local host
  76. pg_dump sequence problem
  77. Locale/encoding problem/question
  78. disjunctive queries
  79. Create function problem
  80. Importance of re-index
  81. PITR Questions
  82. Well, Pervasive is now out....
  83. PITR timeline question
  84. SAVEPOINT and FOR UPDATE
  85. xmin
  86. Vacuum, Analyze, ReIndex from within VB.NET 2003
  87. CREATE DATABASE
  88. How to read log files
  89. Row-level style access with sub tables
  90. Dumping database using 8.1 or 7.1
  91. Re: Query performance
  92. Re: Query performance
  93. Re: Query performance
  94. Re: Query performance
  95. TSearch: Need debug help
  96. Query performance
  97. Re: [HACKERS] Rebuilding DB from broken hardrive.
  98. SELinux + CREATE TABLESPACE = ?
  99. Re: Tape backup, 2 versions, same database name, which is pg_dump
  100. Re: logic/db question
  101. Tape backup, 2 versions, same database name, which is pg_dump backing up
  102. Join Question
  103. logic/db question
  104. PostgreSQL on RAM Disk / tmpfs
  105. Re: Performance/Issues with CMP and JBoss
  106. Fulltime Opportunities in Silicon Valley!
  107. best ways to handle large matrix data
  108. Re: ECPG and COPY
  109. Re: Help with plpgsql - subst variable value
  110. when do pg_temp SCHEMAS get purged?
  111. pgstat.c: send/EINTR issue
  112. Handling foreign_key_violation in plpgsql
  113. Strange error message
  114. plTcl - how to create proc/function libraries
  115. Best Procedural Language?
  116. Re: proper use of array datatype
  117. Re: proper use of array datatype
  118. Where do Tcl questions go?
  119. Can you run out of oids?
  120. money type depreciated?
  121. LISTEN considered dangerous
  122. prepare, execute & oids
  123. Performance/Issues with CMP and JBoss
  124. Autovacuum help..
  125. Where did the compat-postgresql-libs rpm get to?
  126. pg_restore performance on solaris 10/6
  127. Unicode sorting problem
  128. Re: Error in PostgreSQL query with psycopg
  129. Dynamic pgplsql triggers
  130. Postgres on 64bit Windows Server with WOW64
  131. pg_xlog not cleaned up
  132. Error in PostgreSQL query with psycopg
  133. Antw: Re: Antw: Re: Query questions
  134. Antw: Re: Query questions
  135. Query questions
  136. Triggers in Postgres
  137. Sobre PGSQL y ANSI SQL 92
  138. Do I need to a driver or library?
  139. pg_statio_all_indexes
  140. Corrupted DB? could not open file pg_clog/####
  141. create function syntax error
  142. Partitioning: CREATE OR REPLACE RULE freezes.
  143. Auto Installation
  144. Secure connections with changing ip addresses?
  145. Performance of the listen command
  146. Help
  147. Create spatial_ref_sys entry from srtext ?
  148. Questions about update, delete, ctid...
  149. Consulta de importar o restaurar base
  150. newbie here
  151. Re: copy losing information
  152. automatic and randomally population
  153. server administration problem: Database startup and permissions
  154. Using an alternate PGDATA on RHEL4 with SELinux enabled
  155. Backslash as ordinary char vs. not; set via a connection/sessionvariable
  156. PostgreSQL theoretical maximums.
  157. Can't start PostgreSQL
  158. PostgreSQL theoretical maximums.
  159. Update entire column with new date values
  160. Permissions to connect to postgres database
  161. UTF-8, upper() and Chinese characters yielding blank result
  162. JDBC
  163. Database Oid from SPI
  164. Shared buffers
  165. PostgreSQL and Windows 2003 DFS Replication
  166. Problem with table slowing down - Help with EXPLAIN reqd
  167. Performance Postgresql en HP-UX 11.x
  168. CREATE DATABASE question.
  169. Understanding VARHDRSZ
  170. Database corruption with Postgre 7.4.2 on FreeBSD 6.1?
  171. Generating unique session ids
  172. What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation
  173. Table Inheritence...Just Columns?
  174. Re: copy losing information
  175. copy losing information
  176. Database Design Theory - PostgreSQL Custom Types
  177. wrong timestamp
  178. Error using OLD and NEW records
  179. loop with circular updates
  180. Database Restore errors
  181. Constraint on an aggregate? (need help writing trigger, i think..)
  182. question about default value and timestamp
  183. Executing an SQL query from an internal function...
  184. Mapping/DB Migration tool
  185. Re: Plperl return_next and bytea binary data?
  186. Using currval() in an insert statement...
  187. Re: Splitting Timestamps
  188. Splitting Timestamps
  189. Re: Lock changes with 8.1 - what's the right lock?
  190. Re: Lock changes with 8.1 - what's the right lock?
  191. Re: Lock changes with 8.1 - what's the right lock?
  192. Archiving wal files
  193. sequences vs oids as primary keys
  194. CASE statement and SETOF values
  195. Does a GRANT on a table cascade/implied to its SEQUENCES
  196. Beginner's questions about creating a custom data type in PostgreSQL...
  197. gmake Errors: pg_backup_archiver.c: undefined reference to `lo_create'
  198. gmake Errors: pg_backup_archiver.c: undefined reference to `lo_create'
  199. Re: Why can't I connect to postgres?
  200. Re: Why can't I connect to postgres?
  201. unknown error message
  202. Why can't I connect to postgres?
  203. What about pgtclsh
  204. Plperl return_next and bytea binary data?
  205. Error dumping and restoring postgis db
  206. type of b-tree
  207. Table Inheritance and foreign key problem.
  208. join table with empty fields and default
  209. ECPG. Badly stuck
  210. plpythonu and type record
  211. Your PayPal account has been temporarily limited due to Unauthorized Access.
  212. newbies problem
  213. Re: [JDBC] Is what I want possible and if so how?
  214. Antw: problem with windows installer
  215. Impact of vacuum full...
  216. PGSQL 8.1.4 on Win2003 at istanbul :), could not access status of transaction xxxxx , could not open file "pg_subtrans/000A": Invalid argument
  217. problem with windows installer
  218. question for JAVA developer who r using postgres sql as backend
  219. ECPG (usage of simple select statement)
  220. setting serial start value
  221. Column info without executing query
  222. Create index hanging
  223. ECPG usage
  224. pg_dump & pg_restore suggestion
  225. access method "gin" does not exist
  226. calling stored procedure using ECPG
  227. Ann: PyPgExplorer-0.8
  228. Re: function is quick for one row but super slow on more than 5..
  229. timestamp and calculations.
  230. psql seems to hang during delete query
  231. Linking Tables from 2 databases
  232. Alter Sequencie
  233. Problem creating a function
  234. Re: Constraint for two fields unique any order
  235. Constraint for two fields unique any order
  236. Difference between function and procedure?
  237. Messages to pgsql-general list not being posted
  238. VACUUM and index
  239. problem creating users via pythons script
  240. what step need to configure postgres for java application
  241. shortcircuit logic in plpsql
  242. postgreSQL dot.net install?
  243. postmaster: StreamConnection: accept: No such device or address
  244. Just want to verify Posgresql works on DRDB
  245. Re: How to pass array of values to a pgplsql function
  246. Antw: Performance problem with query
  247. number of distinct values in tsearch2 gist index
  248. How to pass array of values to a pgplsql function
  249. cannot un-install postgresql
  250. custom installer