PDA

View Full Version : pgsql Novice

Pages : 1 2 3 4 5 6 [7] 8 9 10 11 12 13
  1. Re: psql is very slow
  2. Invalid Page Header
  3. Accessing PG/Linux from a Windows client
  4. Preferred method for full backup
  5. exporting data from one DB to another asynchronously
  6. encoding problem
  7. dblink + rule on select
  8. dblink + rule on select
  9. Re: [HACKERS] pg_config --pgxs
  10. Check constraints for dummies?
  11. pg_restore
  12. Efficiency of Views
  13. pg_config --pgxs
  14. escaping string in a function
  15. Re: Alternative to MS Access Last() function
  16. Alternative to MS Access Last() function
  17. delay of function
  18. Large select, best practice question
  19. Re: View running Processes ?
  20. dropping an index
  21. Re: php cant see new table!!
  22. Select with Regular Expressions
  23. install problems
  24. (NONE)
  25. createlang Utility Error
  26. alter table, placing the new column after the id
  27. install
  28. Squences with letters aswell as numbers
  29. Finding the right logging level
  30. Generic archive functions.
  31. unique index
  32. Failure Recovery
  33. How to enable remote anoymous logins? (+ admin books?)
  34. How do you backup functions only?
  35. Uppercase initials in Win XP
  36. references versus foreign keys
  37. exporting to DTD
  38. tsearch2: rebuilding of fulltext index
  39. UNSUSCRIBE
  40. Regarding PL/SQL with C
  41. Regarding PL/SQL with C
  42. Copy data from one table to another
  43. Transaction Questions
  44. View running Processes ?
  45. Schema Questions
  46. Regarding Postgres access through C
  47. Regarding Postgres access through C
  48. Re: plpgsql-function with timestamp
  49. drop index
  50. SQL Question
  51. table inheritance
  52. Newbie basic and silly question
  53. Newbie basic and silly question
  54. Function testing if a string is a number ?
  55. inserting a value as null
  56. Re: [postgis-users] PostGIS Geometry column
  57. get the inserted row id
  58. php cant see new table!!
  59. readline library not found
  60. Index usage btree+gist ?
  61. Query question, subselects and referencing out?
  62. Ident authentication failed without su to user
  63. Cloning databases using rsync
  64. reinstallation of Posstgresql 8.0 program
  65. Writing Python triggers and the TD dictionary value
  66. PostGIS Geometry column in pg8.1.3
  67. Index usage btree+gist ?
  68. Re: Queries to Export
  69. Queries to Export
  70. Version 8.1
  71. pgsql-novice-request@postgresql.org
  72. performance
  73. newst packages for ubuntu
  74. Re: A function to count number of terms - something wrong please help
  75. Indexed Views
  76. Query does not return rows unless a LIMIT statement is used.
  77. could not send data to client: Broken pipe
  78. one table from the db on a separate drive
  79. Reusing columns in SELECT list
  80. BLOB type storing... once again?
  81. Return column value from previous and next row in a recordset
  82. Can't Find Any Tables with DatabaseMetaData.getTables()
  83. Re: Creating Text Files from Tables
  84. Re: Creating Text Files from Tables
  85. Re: SQL Question
  86. SQL Function Help
  87. Autovacuum log messages
  88. granting access to information_schema
  89. Re: SQL Query gone wrong.. please help
  90. How to Include Contributed Modules in Automated Install
  91. SQL Query gone wrong.. please help
  92. Re: SQL Question
  93. How to control memory usage of postgresql
  94. data corruption how zero bad page blocks etc
  95. Help on Learning (trigger) Functions
  96. Foreign Keys With Arrays
  97. phpPgAdmin login problem
  98. Select date & time
  99. Backing Up
  100. Dropping sub-tables
  101. Postgres Installation problem.
  102. variables outside of functions
  103. function return type is a setof some column type
  104. createdb: could not connect to database
  105. How do I interpret the data returned from a DeadLock-Exception?(Java)
  106. Create table and update it within one function ?
  107. schemas in functions
  108. function privileges
  109. Generalization Hierarchies & Table Inheritance
  110. pg_dump - sort data?
  111. Can one turn off constraints/indices temporarily?
  112. prob in accessing psql at all
  113. prob in accessing psql at all
  114. Stress Testing
  115. Reverting from subtables to no subtables.
  116. How To Return a Row or Result Set
  117. How To Return a Row or Result Set
  118. Re: copy
  119. How to GRANT SELECT on all tables?
  120. subscribe-digest
  121. function returning a setof a column type
  122. (NONE)
  123. Re: copy
  124. Re: How to define variables in psql?
  125. lost archives, alpha data files
  126. How to define variables in psql?
  127. Re: put text list into table form
  128. Dynamic column names in plpgsql
  129. Insert Text
  130. Upgrade to PG 8 before starting major development?
  131. Help, 400 million rows, query slow, I stopped after 5 days
  132. Schema with Postgress 8.1
  133. wrong objects order using pg_dump
  134. Re: Question about support for SUSE 10
  135. problem with pg_dump - attrdef record(s) missing
  136. Restoring SQL Databse for use in PostgreSQL.
  137. put text list into table form
  138. Problem with pg_dump
  139. Using drop database from psql
  140. Problema con postgresql 8.1.2
  141. Password Authentication Error
  142. Update & Lack of Error Message
  143. Charting postgres schemas and table data into Kivio
  144. Maximum useful number of partitions in a table
  145. Re: default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
  146. default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
  147. msysconf error
  148. Performance issue
  149. column number instead of column name
  150. Re: Problems with select statement
  151. Initdb panic: invalid record offset at 0/0 creating template1
  152. save to another database
  153. Curious date problem
  154. Problems with select statement
  155. Moving existing tables into an inheritence hierarchy
  156. Swappng Filds
  157. Huge size of Data directory
  158. Re: !!Famous Software ftp download 2006!!
  159. alter table set tablespace over nfs getting stuck
  160. Finding and replacing text within records
  161. First post - first question
  162. Fw: Help needed
  163. Query problem
  164. block transactions in stored procedures
  165. Help with query
  166. help with query: advanced ORDER BY...
  167. User variables like: SET @a='test';
  168. Setting a variable for current session (set, define or something) for auditing
  169. How to set a Default Value
  170. moving db off a rooted server
  171. storing record-array in varchar?
  172. Re: A question about pages. Now is VERY clear!
  173. Sort of Complex Query - Howto Eliminate Repeating Results
  174. Re: Removing duplicate entries
  175. Re: Removing duplicate entries
  176. trigger / to_char()-function / extract()-function
  177. A question about pages. Still not clear
  178. Re: Removing duplicate entries
  179. Open Office2
  180. Comparing databases
  181. Removing duplicate entries
  182. convert bool result query
  183. Re: Intel Macs and PostgreSQL
  184. A question about pages
  185. Error Returned by A Function
  186. translating this SQL query from a different dialect
  187. Preventing access of user1 to user2's database
  188. Re: SQL Question
  189. database ->xml
  190. Re: how to recall the initial definition (CREATE TABLE) of a table ?
  191. What does 'schema' mean ?
  192. Re: how to recall the initial definition (CREATE TABLE) of a table ?
  193. how to recall the initial definition (CREATE TABLE) of a table ?
  194. Triggers and speed - 7.4.5 / 8.0.3
  195. how to list all tables in a database
  196. User login with username and password
  197. primary key on lower(varchar)
  198. SQL Question
  199. Problem when trying to compile and link program on Windows to libpq
  200. Problem Upgrading from 8.0 to 8.1 (WinXP) ...not still solved!!
  201. Block same entry
  202. index over boolean fields?
  203. Best Type to use
  204. sending N selects with begin and commit and get the result
  205. Re: Best way to manage users
  206. Re: can't connect to postgresql via phppgadmin and pgaccess
  207. can't connect to postgresql via phppgadmin and pgaccess
  208. pg_xlog directory
  209. GRANT access rights on rows
  210. Problem UPDATE Statement
  211. Best way to manage users
  212. which database to login to to create global users?
  213. Replacing Tables
  214. dropping an unused sequence?
  215. function problem
  216. Re: backup by schema
  217. can't log on to phppgadmin
  218. Sequential Scans On Complex Query With UNION - see why this fails
  219. Re: Cracked software fastest download!
  220. Re: PG_Dump Users and Groups
  221. Limit to mail size?
  222. Restoring to a different tablespace
  223. Postgresql 8.1
  224. Correct way to set up Variables [Was - Simple Accumulating Number Loop?]
  225. pg:8.0 -> 8.1 - COPY and UTF-8 error on restore.
  226. pg_trigger permissions
  227. ecommerce soolution
  228. help with date_part & day of week
  229. Simple Accumulating Number Loop?
  230. ?linux distro?
  231. limiting number of allowed rows in a table
  232. Re: We want to monitor total size of database
  233. We want to monitor total size of database
  234. Complex Query Help- For Me, Anyway
  235. speeding up pg_dump?
  236. (NONE)
  237. Logs not Rotating
  238. Re:
  239. Re:
  240. PostgreSQL Logging
  241. 2 Questions
  242. Postgres 8.1 choosing the larger index for an index scan
  243. long transaction with concurrent SELECT statements
  244. Tsearch 2, index in different table?
  245. Re: problem with nasty latin2 sorting
  246. Re: GIS and postgresql
  247. plpgsql function returning SETOF
  248. GIS and postgresql
  249. Re: can not create trigger with parameter
  250. Re: transfer database from Linux to Windows