PDA

View Full Version : Pgsql General

  1. what compression is used in on disk bitmap index implementation
  2. Row-Level Access Control via FK to pg_catalog.pg_authid
  3. (no subject)
  4. change data type int4 to serial
  5. Sockets in perl (Db transaction ends abnormally at client when server closes client socket)
  6. Re: Recursive Left Joins Causing Trouble in 8.2.3 RESOLVED (kind of)
  7. Re: Recursive Left Joins Causing Trouble in 8.2.3 RESOLVED (kind of)
  8. Quering 4 or more physicale different PostgreSQL server at once
  9. Expanding the crosstab function to extra rows
  10. How can you tell if a function is immutable from psql?
  11. tsearch2: word position
  12. Security: Online banking account has been blocked.
  13. Slow running to_tsvector (tsearch2 in PG 8.2.3)
  14. Odd behaviour of timestamptz
  15. Nice article on Unicode and it's encodings (utf8, utf16 and utf32)
  16. number of tables limited over time (not simultaneous)?
  17. Error upgrading on W2K
  18. postgresql vs mysql
  19. REVOKE ALL
  20. Crosstab
  21. can't stop the postmaster?
  22. invalid input syntax for integer: "NULL"
  23. Views: having a rule call a function vs. using a before trigger
  24. Complex search advice?
  25. Re: open source - content management system - that uses PostGreSQL
  26. Warning "TupleDesc reference leak"
  27. Having performance problems with TSearch2
  28. Having performance problems with TSearch2
  29. Syncing postgres data with Pocket PC
  30. pgPL/SQL Documentation
  31. boolean operator on interval producing strange results
  32. =?iso-8859-9?Q?Postgresql_Kilitli_Sat=FDr_Kontrol=FC?=
  33. Re: [pgsql-es-ayuda] postgreSQL
  34. Out of memory on vacuum analyze
  35. How to force disconnections from a Perl script?
  36. RPM compat-postgresql-libs-4-2 for IA-64
  37. Per Database Roles
  38. delete from ... where not in
  39. Write errors in postgres log
  40. What about TSearch2
  41. complex referential integrity constraints
  42. encoding problem at restore
  43. open source - content management system - that uses PostGreSQL
  44. Why *exactly* is date_trunc() not immutable ?
  45. Question about Item -- Respond Now
  46. Automated backups for PG running on Windows Server?
  47. Encryption/Decryption in PGSQL
  48. tsearch2 index missing
  49. CodeGear working on a new DB access layer for Delphi, but.....
  50. User-interfaces with transaction support
  51. Re: Help with an index and the optimizer
  52. Re: Problem with index not always being used
  53. Addons
  54. How do I use returning in a view?
  55. pg_tablespace.spcacl
  56. indexes across multiple tables
  57. How would you handle updating an item and related stuff all at once?
  58. Re: [ANNOUNCE] Advisory on possibly insecure securitydefiner functions
  59. eBay Unpaid Item Reminder for Item #190010839322
  60. Synchronize tables question....
  61. Anticipatory privileges
  62. values from now() in the same transaction
  63. Have anyone this man e-mail ?
  64. problems: slow queries with tsearch2
  65. rule creating infinite recursion not sure why
  66. up-to-date docs on vacuum
  67. Is it possible to compress a table any further?
  68. pg_restore - problems restoring the data
  69. Setting up functions in psql.
  70. requests / suggestions to help with backups
  71. Small request re error message
  72. How to append the contents of a table to a file
  73. Inequality operators are not deduced.
  74. How to use slash commands in a function
  75. ROLE INHERIT
  76. invalid regular expression: invalid backreference number
  77. Problem writing sql statement....
  78. how to hide database objects from users, that don't have access tothem
  79. Where art thou pg_clog?
  80. Re: Database performance comparison paper.
  81. Database performance comparison paper.
  82. massive memory allocation until machine crashes
  83. clarififcation
  84. Protect PL/PGSQL source
  85. postgresql 8.2 Installation error at "gmake"
  86. Constraint enforcement
  87. gmake Error "/libpython2.4.a: could not read symbols: Bad value"with ./configure --with-python
  88. User privilege information.
  89. user input during runtime
  90. Option to undo last update on table.
  91. WARNING: some databases have not been vacuumed in 1953945422 transactions
  92. pg_dump and buffer usage
  93. How to create an archive for old records?
  94. Installing on weendoze vista.
  95. Re: [pgsql-advocacy] PostgreSQL 9.0
  96. Problem with INNER JOIN
  97. Re: [ANNOUNCE] Advisory on possibly insecure security definerfunctions
  98. Stored Procedure examples
  99. How to search, how to post?
  100. Recover anything from dropped database?
  101. Best practice for 8.1.5 -> 8.2 migration - with big database?
  102. Protect PL/PGSQL source
  103. Adding audit trail fields and triggers to all tables
  104. Cast record as text
  105. Robert Grinnell is out of the office on holiday.
  106. Thank you for your email
  107. Daniel Simmler is out off office
  108. converting a specified year and week into a date
  109. Problem with 'tr' command
  110. Help, Can't figure out what is wrong with my stored procedure
  111. Infinite loop in transformExpr()
  112. help and Links using postgreSQL with ASP
  113. Timestamp/Timezone - does this make sense?
  114. suggestions on improving a query
  115. SEQUENCE primary key
  116. Advisory on possibly insecure security definer functions
  117. Slony Replication problem
  118. Using PITR for creating Hot Standby
  119. Function in psql to Compare two numbers and return the bigger value
  120. Proper escaping for char(3) string, or PHP at fault, or me at fault?
  121. Having a problem with my stored procedure
  122. PGSQL 8.2.3 Installation problem
  123. A view needs at least one column whereas a table doesn't...
  124. Possible outer join bug with coalesce in 8.2
  125. Function, that returns set of 2 tables columns
  126. Union Query Improvement
  127. backup database by cloning itself
  128. missing FROM-clause (more)
  129. missing FROM-clause
  130. Keyword OWNED not recognized in pg v. 8.1
  131. PGSQL backup options
  132. Keyword OWNED not recognized in pg v. 8.1
  133. Still unclear about PQexecParams and "create view"
  134. Testing embedded SQL in C
  135. Function to return list of all prime numbers in range
  136. Headache with a plpgsql function
  137. Dumb question - how to tell if autovacuum is doing its job in 8.2.x
  138. Help with install postgres 8.2 win32 version
  139. flaky hardware?
  140. how to store whole XML file in database
  141. 8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"
  142. How to avoid using sequential scan
  143. pg_dump: [tar archiver] write error appending to tar archive
  144. Re: PostgreSQL and OpenLdap
  145. How to set UTF8 to query browser of PgAdmin III
  146. ERROR: failed to build any 8-way joins
  147. Naming conventions
  148. Adjacency List or Nested Sets to model file system hierarchy?
  149. Re: "no value found for parameter 1" error for query with noparameters
  150. Re: getting postgres to emulate mysql/sqlserver bit datatype
  151. getting postgres to emulate mysql/sqlserver bit datatype
  152. "no value found for parameter 1" error for query with no parameters
  153. How to preserve characters with accent?
  154. Re: [ADMIN] Priorities for users or queries?
  155. Re: [ADMIN] Priorities for users or queries?
  156. Re: Priorities for users or queries?
  157. win32 install fail
  158. MOVE cursor in plpgsql?
  159. drop table if exists mytable;
  160. Trouble w/plperl sproc on red hat 9
  161. bytea characteristics
  162. Some unknown error in a function
  163. Modifying a foreign key constraint?
  164. Re: Modifying a foreign key constraint?
  165. trigger for pg_authid
  166. Automating databse creation
  167. does anyone have a tool to convert SP'sT-SQL to Postgres
  168. intarray index vs gin index
  169. Re: Automating databse creation
  170. Adding TEXT columns tanks performance?
  171. Possibly odd question; diff results?
  172. Move data between two databases SQL-ASCII to UTF8
  173. PgSQL dump
  174. Problems shutting down Postmaster
  175. Ouch!
  176. Client connection: Port 5432 / Postgres
  177. Under Red Hat AS in a WIndows Virtual Machine
  178. [Security] New RPM Sets for Fedora Core / Red Hat Enterprise Linux
  179. Data migration from version 7.2.1 to 8.1.5
  180. Error on table insert: attribute 13 has wrong type
  181. Array OUT columns in a record returned from a function - part deux
  182. Persistent dead rows
  183. simplifying SQL
  184. temp tables in functions?
  185. SQL textbook
  186. 'greatest' function?
  187. a request for the 8.1.7 and 8.2.2 tarballs and the good reasons why
  188. Database corruption.
  189. Re: partitioning / rules - strange behavior
  190. DBI-Link 2.0
  191. Service startup - troubleshooting
  192. Installing PostgreSQL on Windows XP
  193. line folding versus shop line
  194. invalid page header in pg_statistic
  195. Read Committed Transation Isolation Problem
  196. Postgres training down under.
  197. Footprints on Postgres
  198. Re: getting status transaction error
  199. Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
  200. leaving this group
  201. Re: pg_dump/restore and functions/triggers/trigger functions
  202. pg_dump/restore and functions/triggers/trigger functions
  203. Array OUT columns in a record returned from a function
  204. Npgsql and 57014 query_canceled error message
  205. 8.2.2 Announcement?
  206. tsearch2 parser configuration
  207. getting status transaction error
  208. Re: daylight savings patches needed?
  209. Re: daylight savings patches needed?
  210. daylight savings patches needed?
  211. Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade
  212. Creating an index on a live database
  213. pg_restore single table privileges/indexes
  214. Cursor timeout in postgres
  215. Re: Storing database in cluster (Memory)
  216. Re: PostgreSQL on Solaris: Changing Compilers During Point Upgrade
  217. Hardware
  218. PostgreSQL on Solaris: Changing Compilers During Point Upgrade
  219. create operator class problem
  220. Re: Very strange error
  221. Re: Very strange error
  222. Re: Problems With DELETE
  223. Very strange error
  224. Re: Storing database in cluster (Memory)
  225. Storing database in cluster (Memory)
  226. Retrieving affected tables
  227. accidentally deleted user --> postgres
  228. New RPM Sets for Fedora Core / Red Hat Enterprise Linux
  229. postgresql fails to start after symlinking pgdata dir
  230. partitioning / rules - strange behavior
  231. When to use compound PK instead of a FK?
  232. ERROR: missing cache data for cache id 27
  233. [1/2 OFF] Update on Varlena.com Access problem
  234. some ports closed in Fedora
  235. table updated status
  236. Rule, update and aggregate functions
  237. Some issues with planner and query optimization
  238. Can a database be restored successfully after new installation.
  239. sql formatter/beautifier
  240. Query optimization problem
  241. Backup ?
  242. database backup trouble
  243. PostgreSQL/FireBird
  244. Postgres SQL Syntax
  245. Re: Compilation Error AIX
  246. Append text using Concat on an Update query
  247. Re: I "might" have found a bug on 8.2.1 win32
  248. Re: I "might" have found a bug on 8.2.1 win32
  249. Re: Subqueries - performance and use question
  250. Re: I "might" have found a bug on 8.2.1 win32