PDA

View Full Version : Pgsql General

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