PDA

View Full Version : Pgsql General

  1. Will changing the server date/time cause problems?
  2. COMMENT and inheritance
  3. Syntax Help Requested
  4. plpgsql replication stored procedure
  5. Question about partitioning
  6. catch SQLException, error code for Foeign key violation,
  7. Re: hard shutdown of system
  8. tsearch2 installation problem
  9. hard shutdown of system
  10. ERROR: could not access status of transaction
  11. Query runs fast or slow
  12. for sale: internetDotComs.com
  13. unique index on variable time
  14. inet value validation
  15. Help about physical page layout in PostgreSQL:
  16. Google Summer of Code (Fix aggregate operators & Implement features such as Data Cubes and Skyline)
  17. Question about selecting rows
  18. starne error from select 1!=-1
  19. Re: Hardware related question: 3ware 9500S
  20. Update from diferents conditions
  21. HUGE Stack space is gettiing consumed
  22. enforce naming convention
  23. 21 bit number for sequence
  24. Replacing MD5 hash in pg_auth...
  25. Fetch in select statement
  26. Querying a BYTEA datatype
  27. Database owner can't select
  28. ilike and utf-8
  29. Re: Curious UDP packets
  30. Curious UDP packets
  31. Re: what the problem with this query
  32. Where is client/server compatibility documented?
  33. Comparing text field
  34. Re: the integer type
  35. export from views
  36. table as hashtable
  37. (NONE)
  38. posting request
  39. browser shows garbage instead of UTF-8 characters
  40. the integer type
  41. Re: How to compile PostGreSQL on Windows 64 bits ?
  42. How to compile PostGreSQL on Windows 64 bits ?
  43. Regex with patterns in table field
  44. corrupted item pointer:???
  45. Is a high tab_reloid worrying?
  46. Re: how can I create the DML for an existing database - within an application
  47. unattened dump
  48. Re: how can I create the DML for an existing database - within an application
  49. Re: how can I create the DML for an existing database - within an application
  50. how can I create the DML for an existing database - within an application
  51. Truncate and Foreign Key Constraint question
  52. Select first ten of each category?
  53. Initdb problem installing 8.1.3-1 on winXP
  54. IA64 RPMs for 8.1.3
  55. IA64 RPMs for 8.1.3
  56. pg_restore --schema always returns an empty dump
  57. Evaluating client processes vs stored procedures
  58. "Hidden" field for each column
  59. Off-Topic: DBMS Market Research
  60. postmaster.pid
  61. Leverage your PostgreSQL V8.1 skills to learn DB2
  62. Re: How to import a CSV file (originally from Excel)
  63. Hardware related question: 3ware 9500S
  64. Could not send Query(connection dead)
  65. Re: How to import a CSV file (originally from Excel) into a Postgresql 8.0.7 database
  66. Re: [HACKERS] RH9 postgresql 8.0.7 rpm
  67. Re: RH9 postgresql 8.0.7 rpm
  68. column data size
  69. hard shut down of system
  70. Re: How to import a CSV file (originally from Excel) into a Postgresql 8.0.7 database
  71. How to import a CSV file (originally from Excel) into a Postgresql 8.0.7 database
  72. Restoring a PITR backup
  73. Re: Debian package for freeradius_postgresql module
  74. sound index
  75. Last Commited Transaction
  76. Fw: Performance UPDATE/INSERT
  77. Re: Debian package for freeradius_postgresql module
  78. Performance UPDATE/INSERT
  79. Re: Debian package for freeradius_postgresql module
  80. Re: Date & Time with time zone
  81. Calculating a hash / fingerprint for a row / tuple
  82. Re: Date & Time with time zone
  83. How to find the latest (partial) WAL file
  84. trigger firing order
  85. Workaround for custom aggregate which would need "internal" as statetype
  86. Re: Debian package for freeradius_postgresql module
  87. installing and using autodoc
  88. Search by distance
  89. WAL archiving and deletion of the WAL segments
  90. Meaning of "loops" in EXPLAIN ANALYSE output
  91. pg_restore 7.4.7 locks itself out
  92. FW: postmaster going down own its on
  93. how to prevent generating same clipids
  94. SSL Client Authentication
  95. Updating & inserting in one shot!
  96. Re: postmaster going down own its on
  97. Asking advice on speeding up a big table
  98. pl/perl error
  99. advice on schema for multilingual text
  100. Expression matching related question
  101. Date & Time with time zone
  102. SSL for an AIX 5.x client - possible?
  103. Is difference between PostgreSQL and mySQL licences for client application minor only
  104. index growth
  105. Create database bug in 8.1.3 ?
  106. Strange syntax for create/drop index
  107. Re: More PostgreSQL conversion fun
  108. Postgresql with Access 97
  109. More PostgreSQL conversion fun
  110. Cannot connect Postgresql 8.1 64 bit
  111. ANALYZE for a schema
  112. Re: pgAdmin3 question
  113. Re: postmaster going down own its on
  114. Load testing across 2 machines
  115. PostgreSQL (file based) database restore
  116. can we remove this guy from the list?
  117. Creating a trigger on n tables?
  118. Re: pgAdmin3 question
  119. pgAdmin3 question
  120. User-defined types
  121. ENC: FAQ 1.1
  122. RES: FAQ 1.1
  123. postmaster going down own its on
  124. how to document database
  125. Re: programatic database dump
  126. help needed (which group do I post these questions to?)
  127. Large text data
  128. encode/decode trouble ('invalid input syntax for type bytea'); bug?
  129. php to import csv to postgres
  130. posgresql <-> oracle
  131. Queries with Regular Expressions
  132. Running Command Line From Trigger?
  133. About checking all dead lock tables
  134. recovering from a --clean dump
  135. The dangers of long running open transactions
  136. plgpsql and transactions
  137. Unique constraint or index, case insensitive, on multiple fields
  138. Debian package for freeradius_postgresql module
  139. Database lost after reboot
  140. Re: "Upcalls" (sort of) from the database
  141. Userid error
  142. autovacuum settings
  143. Re: pgcrypto-crypt
  144. how to select second heigest salary...
  145. help
  146. stored proc vs sql query string
  147. DBD::Pg version 1.48 released
  148. libpq and plpgsql
  149. % tsearch gendict
  150. pgfsck for 8.0.4?
  151. Re: Migrating data from Oracle 9i to PostgreSQL
  152. Backup method
  153. Re: Creating an index on PostgreSQL 7.4.3
  154. Couldn't create a database in PG 8.1.3 win32
  155. could not create shared memory segment in Windows XP
  156. No data found exception
  157. Re: pg_dump and copy command
  158. [IDLE IN TRANSACTION] doing a remote pg_dump
  159. full join question...
  160. 8.1.3's /etc/init.d/postgresql fails, logging "standard in must bea tty"
  161. using initcap() for the French charater
  162. SQL ASCII encoding
  163. Re: Why postgres install requires physical access to server in windows
  164. Oracle outer join syntax
  165. Looking for good PostgreSQL hosters
  166. Column descriptions - could they be propagated to new tables?
  167. Re: Cant find temp tables
  168. pg_dump and copy command
  169. Re: giving users access to specific databases
  170. Not able to install PostgreSQL in my machine
  171. Duda, version para Solaris 10
  172. Re: Why postgres install requires physical access to server in windows
  173. Re: error message on http://techdocs.postgresql.org/ during redirect
  174. Why postgres install requires physical access to server in windows
  175. error message on http://techdocs.postgresql.org/ during redirect
  176. Fw: PostgreSQL support on Redhat Advance Server 2.1
  177. Re: PostgreSQL support on Redhat Advance Server 2.1
  178. Spurious rows returned with left join?
  179. Re: giving users access to specific databases
  180. functions behaviours
  181. Self-referencing and inherited table
  182. Migrating data from Oracle 9i to PostgreSQL
  183. Migrating data from Oracle 9i to PostgreSQL
  184. How can i import .backup file into the database
  185. recover from base directory?
  186. CREATE TABLE (with INHERITS) and ACCESS EXCLUSIVE locks
  187. what datatype is for autonumbering.in postgress
  188. Database restoration performance issue on PostgreSQL 7.4.7
  189. Log Slow Queries
  190. Which error constant to use for "permission deny error when updatinga table that user is not allowd to "
  191. Re: pgsql and streams
  192. Re: database design questions
  193. RAISE function misuse ?
  194. database design questions
  195. what is this error
  196. how to create script of database in postgres..sql(winxp)
  197. Re: MediaWiki and Postgresql?
  198. pl/pgsql uniq varchar[] sort?
  199. Help to realise function
  200. help me...
  201. MediaWiki and Postgresql?
  202. Cant find temp tables
  203. Grouping aggregate functions
  204. installation problem - semaphores
  205. Database security granularity
  206. Re: encryption/decryption
  207. PostgreSQL makes me lie
  208. Re: encryption/decryption
  209. pgpool ABORT + no transaction warning
  210. 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables
  211. WAL Archiving frequency
  212. Re: pgsql continuing network issues
  213. pg_hba.conf errors
  214. How to use views&rules to dynamically choose which table to update
  215. about partitioning
  216. giving users access to specific databases
  217. Recovery with pg_xlog
  218. how to use pg_dump in windows xp
  219. How to use result column names in having cause
  220. pgsql continuing network issues
  221. How to delete all operators
  222. Re: FAQ 1.1
  223. Re: configure: error: file 'tclConfig.sh' is required for Tcl
  224. configure: error: file 'tclConfig.sh' is required for Tcl
  225. Postgres Library natively available for Mac OSX Intel?
  226. configure: error: file 'tclConfig.sh' is required for Tcl
  227. Recovery with pg_xlog
  228. Slony-I for circular replication
  229. PSQL Data Type: text vs. varchar(n)
  230. User defined data type
  231. How to concat strings so that trailing spaces remain
  232. Re: pgsql and streams
  233. Performance Killer 'IN' ?
  234. Slony-I for circular replication
  235. Chasing "signal 11" issues
  236. Re: How to detect primary key of a table
  237. converting timstamptz to local time zone
  238. How to detect primary key of a table
  239. Re: pgsql and streams
  240. [Slightly OT] data model books/resources?
  241. Use functions in Pl/Perl language
  242. Is this possible.
  243. weird GROUP BY error
  244. EXPLAIN SELECT .. does not return
  245. Re: PostgreSQL's XML support comparison against other
  246. ODed on overloads
  247. Re: [SQL] Flight numbers data
  248. Re: Flight numbers data
  249. Comparing 7.4 with 8.0
  250. Foreign key / performance question