PDA

View Full Version : Pgsql General

  1. Connections not closing
  2. Re: Change owner of all database objects
  3. Re: Change owner of all database objects
  4. Image in postgresql 7.3
  5. Error Starting postmaster.exe (8.1.2-1) on XP - GPF
  6. Partitioning: Planner makes no use of indexes on inherited table?!
  7. Re: PostgreSQL Top 10 Wishlist
  8. SELECT Rules or stored procedure
  9. Modify the password of the service account?
  10. Text field performance
  11. Windows re-installation problem
  12. pg_dump throws no buffer space available error
  13. prepared statement results don't clear?
  14. Indexes
  15. mac os x compile failure
  16. Replicating a remote database (backuping)
  17. Rule problem: return value of insert
  18. Change owner of all database objects
  19. Distance calculation
  20. Re: A tale of two similar databases
  21. Re: About Full-text searching under postgresql
  22. Permission denied on relation
  23. About Full-text searching under postgresql
  24. full text search
  25. tablespace and pg_dump
  26. general questions about joins in queries
  27. linking temporary tables from MS Access?
  28. Is there a way to list runaway queries and kill them?
  29. A tale of two similar databases
  30. Stored procedures..PLEASE HELP
  31. Re: Strange error while executing query from front end:
  32. Strange error while executing query from front end:
  33. Re: Strange error while executing query from front end:
  34. ODBC MSAccess
  35. Re: Plans for 8.2?
  36. Ref cursor with Geometric Function
  37. lists all users under groups
  38. Huge number of disk writes after migration to 8.1
  39. Real-time TB databases (not PostgreSQL related)
  40. Create/Erase 5000 Tables in PostGRE SQL in execution Time
  41. Create/Erase 5000 Tables in PostGRE SQL in execution Time
  42. Re: Plans for 8.2?
  43. temporary tables, pgAdminIII
  44. Rule system and unsucessful updates.
  45. Zonder moeite 5000,- Euro verdienen in 2 weken tijd
  46. visual query builder for Postgres?
  47. Fwd: Re: sort character data in arbitrary order?
  48. join table design question
  49. Upgrading 8.1.1 to 8.1.2 in Windows
  50. migrar
  51. Cube/Rollup/ and Connect by prior
  52. Drupal and postgreSQL
  53. sort character data in arbitrary order?
  54. Upgrading 8.1.1 to 8.1.2 in Windows
  55. Re: Unregister Windows Service pg_ctl error
  56. Re: Moving PostgreSQL data directory on Windows
  57. Re: Plans for 8.2?
  58. Re: Unable to connect to a dabase
  59. Apache::DBI and DBD::Pg
  60. Encoding Problem
  61. Error when inserting millions of records
  62. How to use parameters in stored procedures?
  63. Temporary tables
  64. Re: Moving PostgreSQL data directory on Windows
  65. Moving PostgreSQL data directory on Windows
  66. Row Size and Indexing
  67. Re: Plans for 8.2?
  68. FATAL: terminating connection due to administrator command
  69. How to reset a sequence so it will start with 1 again?
  70. PostgreSQL Top 10 Wishlist
  71. extend sql?
  72. Indexing Question
  73. MAX without FROM
  74. Security implications of untrusted triggers
  75. Large object restore problem w/triggers
  76. Locales problems with debian sarge3.1
  77. Re: Plans for 8.2?
  78. Plans for 8.2?
  79. Problem with restoring database from 7.3.1 to 8.0.1
  80. select into multiple variables
  81. Issue with fixseq.sql in 8.1 release notes
  82. Re: Granting Privleges on All Tables in One Comand?
  83. Concept about stored procedures
  84. Re: regarding triggers
  85. Finding orphan records
  86. sql (Stored procedure) design question
  87. Granting Privleges on All Tables in One Comand?
  88. Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
  89. Returning SQL statement
  90. Re: Create Produre for DROP row
  91. getting access to geodistance (what do I need to install/enable) in an existing db install
  92. Re: xml export tool?
  93. Re: index and MVCC
  94. Different exponent in error messages
  95. Re: [SPAM] - how can we use outer join in Postures - Found word(s) if you received this in error in the Text body
  96. Create Produre for DROP row
  97. cursors as table sources
  98. Rules on 8.0.2
  99. Recommend IDE for PG Development
  100. Connection specific information - Temporary table used in Sybase tostore information
  101. psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
  102. Array as a parameter to stored procedure.
  103. Re: help with rules for system table
  104. Unsuscribe
  105. ANN: PgBrowser-1.6 and PgBrowser-1.7
  106. copy a postgres dbase to the same machine with different name?
  107. q: explain analyze
  108. Re: regarding triggers
  109. Sequence Manipulation Functions
  110. regarding triggers
  111. Best programming language / connectivity for best performance
  112. Re: read txt and insert table
  113. calling stored procedure with array paramenter (for psql)
  114. Re: autocommit to off
  115. (NONE)
  116. function overloading
  117. read txt and insert table
  118. Vacuum all tables unders under one schema (not under one database)
  119. pg_dump creates bad dump / pgadmin crash issue
  120. Re: E-mail harvesting on PG lists?
  121. Re: Authentication via LDAP
  122. Authentication via LDAP
  123. pgpool and ODBC
  124. Re: Unregister Windows Service pg_ctl error
  125. Unregister Windows Service pg_ctl error
  126. help with rules for system table
  127. Fedora + Yum + 8.1
  128. CRITICAL RELEASE: Minor Releases to Fix DoS Vulnerability
  129. userdefined types
  130. help with rules for system table
  131. Performance Low Using the Prepare and Execute
  132. programming in pgsql
  133. PGError: server closed the connection unexpectedly
  134. COPY to
  135. Re: Oracle DB Worm Code Published
  136. Oracle DB Worm Code Published
  137. Re: E-mail harvesting on PG lists?
  138. write on screen
  139. Role Permissions
  140. The connection is dead
  141. Drop user doesn't drop granted privs?
  142. contrib library in windows
  143. Flagging and/or Cleansing/Correcting bad telephone number data
  144. why am I getting a seq scan on this query?
  145. (Select *) vs. (Select id) from table.
  146. ./configure --with-openssl=path fails
  147. Re: Adding another primary key to a populated table
  148. Re: 'Official' definition of ACID compliance?
  149. RECORD return types in general, dblink in particular
  150. More atomic online backup
  151. pg_dump throws no buffer space available error
  152. Relational Inheritance Features.
  153. Strange behavior
  154. Relational Inheritance Thoughts
  155. Indexes works only on miss
  156. Problems reading dump files coming from version 7.1 into version 8.1.
  157. Autocommit in Fedora 3
  158. constraint on type object in oracle
  159. "Could not open relation with OID x" while deleting a row
  160. Problems building pg 8.1.1
  161. Arrays and Performance
  162. Data loading from a flat file...
  163. Adding another primary key to a populated table
  164. Hardware recommendation for PostgreSQL on Windows?
  165. Suse Linux 10.0
  166. Best Data type for Binary Data?
  167. ACID compliance
  168. NEW variable values in trigger functions
  169. Drop database/create database broken in 7.4?
  170. java.sql.SQLException: ERROR: invalid byte sequence for encoding
  171. Getting timestamp without milliseconds
  172. Re: Monitoring PostgreSQL connections using cricket and
  173. 'Official' definition of ACID compliance?
  174. Re: Can't connect to postgresql using 'psql -d database -U user -W'
  175. Loading large amounts of data in a SQL command
  176. Problem with Starting server 7.4.10_1 on FreeBSD
  177. Can't connect to postgresql using 'psql -d database -U user -W'
  178. Putting restrictions on pg_dump?
  179. unsubscribe
  180. plpgsql question
  181. pg admin III and primary keys (for backup/restore)
  182. "REFERENCES" and UNIQUE
  183. create summaries and update a second table?
  184. copy from error
  185. copy from error
  186. problem with partitioning and indexed order by
  187. I can't use pgsql with my main user session on Linux
  188. Anyone doing a 8.1.0-ia64-RHEL4-as.rpm ?
  189. postgresql7.4 can't start (SSL)
  190. Unique transaction ID
  191. When it is better to use "timestamp without time zone"?
  192. Moving Tablespaces
  193. Moving Tablespaces
  194. Query in postgreSQL version Windows
  195. PostgreSQL Arrays and Performance
  196. initdb : invalid local name
  197. Re: SQL Command - To List Tables ?
  198. postgresql-8.1.1 on SuSE 10.0 install issue
  199. who is connected to the database ??
  200. Re: pg_dump error codes
  201. bit/integer operations in postgres
  202. Re: Visual FoxPro 9 ODBC errors
  203. Re: I want to know how to improve the security of postgresql
  204. build Postgresql on Solaris 64 bits
  205. Re: Query in postgreSQL version Windows
  206. initdb: invalid locale name
  207. insert serial numbers
  208. generic way to retrieve array as rowset
  209. who has some document about extending postgresql
  210. Problem restoring db-dump on Postgres 8.0.4 Power5
  211. Ident authentication failed
  212. Re: INSERT OR UPDATE
  213. INSERT OR UPDATE
  214. Re: using PG with Syslog
  215. inserting many rows
  216. Re: Query in postgreSQL version Windows
  217. How to search?
  218. Casting issue with aggregated function
  219. Need Licensing Information for bundling POSTGRESQL With Softwares
  220. pg_dump error codes
  221. Re: Postgre sql win32 silent install
  222. Postgre sql win32 silent install
  223. inherits index
  224. SET SESSION TRANSACTION command
  225. Last line is not read from postgres.conf
  226. pg_reload_conf() does not unset archive_command
  227. How to change postgres.conf file from client
  228. Details of row level locking
  229. FW: new beginner to postgresql. Looking at it for a church
  230. veil docs
  231. MDX support in postgresql
  232. Re: POSTGRES DB 3 800 000 rows table, speed up?
  233. How to read wal?
  234. Correct way to set up Variables [Was - Simple Accumulating Number Loop?]
  235. unique constraint with a null column?
  236. Delete / F/K error
  237. Visual FoxPro 9 ODBC errors
  238. Data types
  239. Re: Forum Software
  240. Order by, expressions & column aliases issue
  241. Re: a few questions
  242. Forum Software
  243. Hang investigation
  244. In processing DDL, when does pg_catalog get updated?
  245. Re: Simple Accumulating Number Loop?
  246. storing PDFs
  247. another problem with stored procedures
  248. Stored Procedure: PL/Perl or PL/SQL?
  249. Re: [Bulk] Re: Final stored procedure question, for now anyway
  250. Re: windows xp install problem ("failed to set