PDA

View Full Version : pgsql Novice

Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13
  1. Converting Firebird UDF's ( User Defined functions -dll ) to PostGreSQL user defined functions
  2. Unable to select pl/java procedural during install
  3. Generic/Ad-Hoc Select Function
  4. libpq-fe.h
  5. multiple psql commands in batch
  6. Creating users with name and email
  7. Locale and Initdb Errors
  8. Postgresql fail as boot time
  9. Re: SQL Count Magic Required.... Second Iteration...
  10. Re: SQL Count Magic Required.... Second Iteration...
  11. Server side communication
  12. Postgresql.conf - which param for in memory keys and tables?
  13. Re: pgrestore, notice, will create implicit.
  14. Re: pgrestore, notice, will create implicit.
  15. pgrestore, notice, will create implicit.
  16. SQL Count Magic Required....
  17. searching multiple tables
  18. Schema usage
  19. Re: What is PostgreSQL 8.0 ??
  20. ODBC access: how to restrict the tables view and column detail?
  21. Re: What is PostgreSQL 8.0 ??
  22. Some Slony questions
  23. Re: What is PostgreSQL 8.0 ??
  24. Re: SQL or table design optimation
  25. trigger help
  26. a MySQL to PostgreSQL successful port, but performance is bad...
  27. Urgent Help
  28. SQL or table design optimation
  29. changing user id
  30. Concatenation containing a "null" term
  31. exception handling in plpgsql
  32. Re: SQL Question - S/B Good...
  33. SQL Question
  34. PostgreSQL Update + (PGISDBRU) PGSQL is Slow Debunked by Real Users
  35. Re: PG on zeta 1.0
  36. Re: PG on zeta 1.0
  37. Re: PG on zeta 1.0
  38. Re: PG on zeta 1.0
  39. Interrupting Cursors
  40. Installing PostGreSQL automatically
  41. Re: PG on zeta 1.0
  42. Re: PG on zeta 1.0
  43. Re: PG on zeta 1.0
  44. Re: PG on zeta 1.0
  45. Re: PG on zeta 1.0
  46. PG on zeta 1.0
  47. send psql output to file and setting pager=more
  48. Re: Database Size Limits
  49. select count(*) and limit
  50. Where to get more info. about the optimizer?
  51. Querying from two tables as if they were appended
  52. OIDS
  53. Database Size Limits
  54. selecting un-ordered rows
  55. MySQL DB to PostgresSQL DB
  56. tools helping with explain output
  57. Re: dates
  58. VACCUM VERBOSE ANALYZE
  59. tools analyzing EXPLAIN
  60. Privileges query?
  61. Re: Wondering if anyone could help me
  62. Q on requirement to connect to a specific DB
  63. Query Formulation Question
  64. Wondering if anyone could help me
  65. Dev DB Structure Updates
  66. difference between := and =
  67. Re: error handling
  68. Re: error handling
  69. Vacuuming static tables.
  70. index not used with inherited tables
  71. Re: error handling
  72. Math Query Help
  73. Math Operations - DB or App?
  74. No quoting in copy CSV mode
  75. Setting sequence ids after importing data
  76. Command line option
  77. Trigger function to change data to correct datatype
  78. UNSUBSCRIBE
  79. Backup Schema w/ SQL Text File
  80. postgres db
  81. postgres db deleted and recreated... "No directory, logging in with HOME=/" error...
  82. 1st Linux Attempt -> I'm Discombobulated...
  83. Switch to Linux Dev Questions
  84. Permission denied: LOCK TABLE test.__proc IN ACCESS SHARE MODE
  85. Re: looking for some suggestions
  86. How to test Perl front end to PostgreSQL DB?
  87. looking for some suggestions
  88. Re: what are the pg_clog and pg_xlog directories ?
  89. Memory consumption problem
  90. Problem with temporary disbaling foreign keys.
  91. what are the pg_clog and pg_xlog directories ?
  92. Re: SQL Order Question
  93. SELECT FOR UPDATE - release lock?
  94. SQL Order Question
  95. Efficiency of indexes on CHAR(n) and VARCHAR(n)
  96. Scheduled function ?
  97. What is really necessary?
  98. Re: Snapshot Copy of a Postgres DB
  99. database size grows (even after vacuum (full and analyze))....
  100. eccn
  101. Snapshot Copy of a Postgres DB
  102. Forgotten Password
  103. client-only for linux?
  104. Multidimensional Arrays
  105. Re: stress tests problems
  106. Memory problems when using savepoints
  107. Tracking progress of (plpgsql?) operations
  108. Multiple Postmasters (Linux)
  109. Re: PGAdmin3 Permisions
  110. PGAdmin3 Permisions
  111. running pg_dumpall as a cron job
  112. Trigger to force fields to lowercase at insert/update
  113. Perl and psql variables
  114. WAL-related Problem?
  115. 8.1 (win32): partial index not used?
  116. Getting the indexes of a table
  117. error handling
  118. Perl and psql variables
  119. How to obtain algebraic sum of equal lines
  120. probable faq: internal format of numerics
  121. Temporarily disable strict UTF-8 checking
  122. Using PostgresQL as a database back-end
  123. Oracle Analytic Functions for PostreSQL
  124. Oracle Analytic Functions for PostreSQL
  125. need help
  126. retrieving specified rows
  127. Re: pg_dump and restore - views
  128. pg_dump and restore - views
  129. A good article...
  130. Re: Find all foreign keys and dropping them from a script.
  131. Schema 'public'
  132. Defining the same relation in another database
  133. Logging problem
  134. Re: Maximum database size
  135. postgresql connection problems
  136. Maximum database size
  137. Accessing fields in a function that returns a set of composite type - How?
  138. Re: Find all foreign keys and dropping them from a script.
  139. Find all foreign keys and dropping them from a script.
  140. Re: The COPY command and csv files
  141. Re: PostgreSQL a slow DB?
  142. Re: PostgreSQL a slow DB?
  143. Install password not recognized
  144. mutually exclusive subtypes
  145. Renaming unnamed FK constraints
  146. Crontab problem with backup
  147. On the subject of inheritance
  148. Steps to open or import a data file from Pg 8.1.3?
  149. Colors/bold chars in a select?
  150. mutually exclusive subtypes
  151. In plpgsql: difference between := and =
  152. The COPY command and csv files
  153. Re: Indexes slower when used in decending vs. ascending order?
  154. Removing Tsearch2
  155. Configure command from a precompiled package
  156. Re: Sequence Current Value Resetting
  157. Re: Indexes slower when used in decending vs. ascending order?
  158. Re: Indexes slower when used in decending vs. ascending order?
  159. How to query for Interval
  160. Curses interface
  161. Indexes slower when used in decending vs. ascending order?
  162. SELECT of a glob
  163. Postgres Config/Tuning problem
  164. Re: Triggering a table id from a sequence
  165. Re: Sequence Current Value Resetting
  166. Triggering a table id from a sequence
  167. Re: Partitioning table - explain said that all partition tables are scanned
  168. count(imdb_id) problem
  169. Postgresql module for freeradius on Debian
  170. Explain query on table with partition tables
  171. How to append records into a file which has serial unique IDs?
  172. Explain query on table with partition tables is strange
  173. WAL - recovery of updated dataset
  174. how to encrypt trigger function
  175. select id,count(imdb_id) problem
  176. replication
  177. Restoring Database problem, tsearch
  178. advice on setting up schema sought
  179. How to append records into a file which has serial unique IDs?
  180. out or memory error
  181. Scheduled Job at PostgreSQL
  182. Foreign keys and inheritance
  183. On "linking" the types of two columns
  184. Layout question
  185. WAL to get back data in 7.4.
  186. Re: Semaphore trouble for installation
  187. Re: BYTEA: insert query max size
  188. query to return hourly snapshot
  189. Re: BYTEA: insert query max size
  190. BYTEA: insert query max size
  191. Re: compare month
  192. Re: compare month
  193. Re: compare month
  194. compare month[modified]
  195. Semaphore trouble for installation
  196. Two configuration issues...
  197. Encoding problem in psql (Windows)
  198. Puzzling behaviour running C Function
  199. PHP libpq Version != Actual PGSQL Version
  200. Plain ANSI C Compiled on Win32
  201. plpgsql questions
  202. Change database encoding
  203. LIMIT clause and long timings
  204. delete from joined tables
  205. Transfer from MySQL to PostgreSQL
  206. Does a connection support multiple transactions.
  207. help with a view (join-query)
  208. Indexes and inheritance
  209. Re: Bytea and perl
  210. foreign key data type dereferencing
  211. kill-9 postmaster
  212. Re: PostgreSQL a slow DB?
  213. Cooked vs Raw Disk Space
  214. Newbie pg_hba.conf question
  215. Problems using PostgreSQL command line tools
  216. Re: Bytea and perl
  217. Bytea and perl
  218. Question about PostgreSQL Metadata
  219. Re: Multiple insertion
  220. Return count between timestamps
  221. log rotation
  222. Alter View foo?
  223. Find and Replace All
  224. Postgres crashes
  225. Performance of plpgsql functions
  226. Copying a column from one table to another
  227. Re: !! DOWNLOAD THE MOST POPULAR 2006's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/PCB/GIS/FEA/CNC/
  228. ESTERROR
  229. Exception in thread "main" java.lang.OutOfMemoryError
  230. Automatic date/time
  231. Permissions to users ??? (FATAL: Ident authentication failed foruser)
  232. How can I make multiple insertions ?
  233. restoring db from 8.1 in a 8.0 db
  234. Re: Where Can I Find The Code Segment For WAL Control?
  235. Function to convert numeric string to number in version 8.0
  236. Relations as arguments to a stored procedure?
  237. Storing sensitive data
  238. Re: psql is very slow
  239. Invalid Page Header
  240. Accessing PG/Linux from a Windows client
  241. Preferred method for full backup
  242. exporting data from one DB to another asynchronously
  243. encoding problem
  244. dblink + rule on select
  245. dblink + rule on select
  246. Re: [HACKERS] pg_config --pgxs
  247. Check constraints for dummies?
  248. pg_restore
  249. Efficiency of Views
  250. pg_config --pgxs