View Full Version : postgresql answers


Pages : 1 2 3 4 5 6 [7] 8 9 10 11

  1. Looking for help building 'rhdb-explain' Visual Explain tool
  2. upgrade postgres 7.1 to 7.4.2
  3. Can I reset the lower bound of an array.
  4. I cannot view the website of postreSQL correctly
  5. cursor questions
  6. composite types
  7. Replication
  8. Can I reset the lower bound of an array.
  9. cursor questions
  10. Replication
  11. Can anyone share ETL tools with Postgres experiences?
  12. Is there a newer version of DBD::Pg?
  13. 7.4.2 initdb problem
  14. Redundancy software for PostgreSQL
  15. Solution to Error 429
  16. db security (md5)
  17. Using of GeQo
  18. doubt about pg_dumpall
  19. Storing images in a field
  20. plan-reading extensive tutorial?
  21. Inapropriate content
  22. Date manipulation
  23. Folding subtotals into query?
  24. Cursors and PHP
  25. Python to postgresql interface
  26. Documentation tool
  27. Suppress output from function?
  28. build contrib
  29. Vb databound
  30. Accessing RelOptInfo structure from the executor module
  31. Locale support on Mac OS X
  32. Indexing null dates
  33. Mixed UTF8 / Latin1 database
  34. Parse error a in short stored procedure : What's wrong ?
  35. Postgresql system requirements to support large databases.
  36. Syntax question - compound value comparisons
  37. Table Lock issue
  38. pg_clog corruption?
  39. PLpgSQL-Problem
  40. Problems with Triggers
  41. Anyone using pgreplicator?
  42. User permission
  43. Basix for Data General / Basix for Sco Unix
  44. SQL script
  45. SRF problem
  46. SRF problem
  47. when restoring or loading
  48. trigger function SQL statement
  49. PostGIS and 7.4.1
  50. upgrading postgresql from 7.2 to 7.3, getting error
  51. Optimal configuration to eliminate "out of file descriptors" error
  52. constraint help
  53. mini survey
  54. major-domo not set up right
  55. Donating
  56. Stored procedures output variables
  57. columns refered to in view
  58. random_page_cost
  59. cache lookup of relation 165058647 failed
  60. allowing vacuum/ analyze to operate on whole schemas.
  61. Disable NOTICE echoing
  62. insert rule not firing on insert with exists subselect
  63. Join works in 7.3.6, fails in 7.4.2
  64. verifying unicode locale support
  65. performance problem aftrer update from 7.1 to 7.4.2
  66. Filesystem vs. Postgres for images
  67. Executing script file
  68. specifics about BIT(n) types
  69. Problems setting shared_buffers to large value
  70. PostgreSQL Invalid Page Header in Block XXXXX
  71. db schema diff
  72. Regular expressions
  73. error with start up pgsql.
  74. REINDEX slow?
  75. ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
  76. pg_ctl written in c
  77. which filesystem will database be saved to?
  78. system date != now()
  79. Postmaster won't shut down
  80. Access Conversion
  81. help needed regarding Query processing in postgres
  82. COPY TO order
  83. Errors in transactions
  84. running postgresql database from loopback filesystem?
  85. Data Encryption in PostgreSQL, and a Tutorial.
  86. Why would query return PGRES_NONFATAL_ERROR?
  87. Sorting in Unicode not working
  88. Accented chars in several apps
  89. Select/Group by/Order by question
  90. Upgrading from 7.3.6 to 7.4.2 pg_dumpall question
  91. pgsql yum update for Fedora system?
  92. Postgresql yum update for Fedora Core 1 system?
  93. Error Message from pgsql v7.3.6
  94. pg_ctl problem
  95. First Question: to_char statement problems
  96. To_char statement problems
  97. Date Comparison Help
  98. extract epoch and index scanning
  99. Orphaned trigger -- bug?
  100. pg_ctl problem
  101. Big string using Zeos from Delphi
  102. Oid problem
  103. Problem with pg_dump - reg.
  104. eval in plpgsl
  105. MacOS X, Postgresql and Aqua Tcl/Tk
  106. Moving from narrow to wide tables
  107. Are functions automatically transactioned?
  108. ERROR: invalid memory alloc request size 0
  109. Error numbers
  110. timestamp precision with or without timezones
  111. \? not working in psql
  112. How to list domains
  113. Can the username calling a function be made available within thefunction?
  114. How estimated rows is running ?
  115. More aggregate functions?
  116. Informations about functions ...
  117. Tcl load command and mac os x
  118. Logging database and statement with errors
  119. PERFORM statement inside procedure
  120. thread_test.c problems
  121. Crash in postgres/linux on verly large database
  122. Subqueries failing inside pl/pgsql fuction called by trigger
  123. ignore
  124. pg_autovacuum won't make on FreeBSD
  125. Upgrade
  126. set timestamp oddness
  127. Date differences
  128. domains
  129. left and overleft/notright revisited: why !>> and !<< might be poornames
  130. Cursors and Transactions, why?
  131. Storing jpgs
  132. Evening in NYC
  133. Mirroring tables from Oracle to Postgresql
  134. Need to replace PostgreSQL 7.4 with 7.3 on cygwin
  135. Optimize query
  136. Version 1.0.0.4 released
  137. RPM init-script: Why the locale setting?
  138. Invalid page header in block...
  139. Creating a trigger function
  140. Recursive FOREIGN KEY?
  141. thread_test.c problems
  142. Best Practices for Storing Set Combinations
  143. postgres 7.4.2: float(20) results in error msg, but should not since7.4)
  144. Problem in calling prepare statement from STORED PROCEDURE
  145. namespace dilemma
  146. relfilenode on 7.2.3
  147. Casting int to bool with join...
  148. Storage cost of a null column
  149. execute function after user connect
  150. Optimization on UPDATEs and FOREIGN KEYs...
  151. PostgreSQL 7.4.2 warnings in HPUX IPF: LOG: could not resolve "localhost": host nor service provided
  152. glibc update.. effect on PG
  153. FUNCTION problem
  154. Loading text files into a text attribute
  155. Create Type Problem
  156. SQL Question: Query for Newest Records
  157. Problems compiling Apache 2.0.49 with mod_auth_pgsql
  158. Some Aberdeen report
  159. Compound keys and foreign constraints
  160. Select Union
  161. A simple question about Read committed isolation level
  162. Problems Vacuum'ing
  163. 7.2.3-7.4.2 migration
  164. Problem restoring Database
  165. Checking FKs after COPY and disabled Triggers
  166. Whats missing from postgresql
  167. recursive trigger
  168. 7.4.1 upgrade issues
  169. ECPG - bug in EXEC SQL WHENEVER NOT FOUND?
  170. why is this index not being used?
  171. Postgres dump utility
  172. copy command verbose
  173. Large table performance and vacuum
  174. PHP on slackware
  175. Setting up Postgresql on Linux
  176. Setting up Postgresql on Linux
  177. Setting up Postgres on Linux
  178. Trigger Update Issue
  179. relocatable binary distribution
  180. extented ascii problem
  181. Management of "varchar types"
  182. sum of a time column
  183. performance problems: join conditions
  184. building 7.4.1 (on linux) with --disable-shared
  185. ERROR: function round(double precision, integer) does not exist - WTF?
  186. Question on stored functions
  187. Tom Lane heads up
  188. Setting up Postgresql on Linux
  189. ORDER by Clauses do not seem to be working correct
  190. Fastest way to query limited time ordered data set
  191. Setting up Postgresql on Linux
  192. Aggregate function capability with \d in psql
  193. Enable/Disable triggers
  194. Information about a column
  195. Inherited tables and foreign keys
  196. clarification of postgres limitations
  197. Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?
  198. need advice.
  199. using Postgres to store many small files
  200. Setting up Postgresql in Linux
  201. REFERENCES error message complaint, suggestion
  202. Slony-I makes progress
  203. gist index build produces corrupt result on first access totable.
  204. Mistake in my query or Index Scan on subquery failure? (7.4)
  205. Error message
  206. autocommit to off?
  207. making a copy of a table within the same database
  208. How index are running and how to optimise ?
  209. Large Object
  210. Trigger using 'if NEW = OLD'
  211. SPI memory managment issue
  212. Selecting reals into doubles
  213. plpgsql trigger function with arguments
  214. constraints
  215. ת·¢: docs on tsearch2
  216. Setting up Postgresql on Linux
  217. Record order change after update
  218. Setting up Postgresql on Linux
  219. Max/min of 2 values function, plpgsql efficency?
  220. max table size
  221. Data in table changed?
  222. More info on table fields
  223. Installing Postgresql in Irix
  224. how to detect last change
  225. Setting up Postgresql on Linux
  226. can you run a psql command line query?
  227. How to Cancel a query ?
  228. Setting up Postgresql on Linux
  229. sql query to get field types
  230. Linux Labs
  231. using the "copy from" command
  232. libpq API for PQcmdTuples()
  233. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  234. using the "copy from" command to load tables from a txt flat file
  235. ORDER BY problem
  236. INSERTS and Queries
  237. Different version of PostgreSQL on same machine?
  238. elog: out of memory
  239. A simple question (under pressure :-))....
  240. referring to computed values from the select list in the where andorder clauses
  241. count(1) return 0?
  242. Postgres slow after a couple of days
  243. Are Triggers Synchronous
  244. dumping fields from Perl
  245. inlined sql functions in 7.4
  246. ispell tsearch2 dictionary
  247. SERIAL type - auto-increment grouped by other field
  248. inheritance of triggers (OO tables)
  249. Korean characters in a SQL_ASCII database?!?
  250. Where are the backend/commands?
  251. postmaster out of memory....
  252. help with correlated delete and outer join
  253. pgCluster in production environment
  254. Memory usage
  255. Triggers per transaction, workaround? prospects?
  256. Copying data from one table to another
  257. installation -- help ?
  258. Trigger function aborts the transaction on exception
  259. value too long error
  260. Postgresql bajo Windows Míralo Ve
  261. setting datestyle for different databases within a cluster
  262. Regarding BITs vs. INTs
  263. clear defunct entries from pg_stat_activity
  264. Restoring a table with a different name
  265. XML Challenge
  266. PostgreSQL in Cluster
  267. Here there is a Postgresql for Windows Sample APP
  268. On Update (trigger hint)
  269. field must appear in the GROUP BY clause or be used in an aggregatefunction?
  270. compartmentalizing users
  271. PostgreSQL insert speed tests
  272. Case of strings
  273. check for user validity
  274. change db encoding
  275. correlated delete with "in" and "left outer join"
  276. Simple, but VERYuseful enhancement for psql command - or am I missing something?
  277. Help with a query
  278. Postmasters pile up
  279. Postgres clustering?
  280. Hostname change - pgsql won't start
  281. PostgreSQL on XFS experiences?
  282. [PgSQL 7.4.1] Problem with subquery
  283. PL/pgSQL debugger
  284. help using arrays in a function
  285. Windows Library for libpq
  286. postgreSQL licenseing
  287. Simplyfying many equals in a join
  288. How to drop sequence?
  289. reindexing, pg_class (and other system tables)
  290. key = currval('tab_key_seq') choses SEQSCAN?!
  291. REINDEX issues
  292. TG_RELNAME problem
  293. Moving from MySQL to PGSQL....some questions
  294. invalid memory alloc request size
  295. tsearch2 trigger alternative
  296. PLSQL Question regarding multiple inserts
  297. Inheritance and column references problem
  298. select statement against pg_stats returns inconsistent data
  299. Sequence Permissions.
  300. Rows to columns
  301. Irreversible performance drop after increasing shared mem
  302. dynamic views
  303. ON DELETE RULE problem
  304. Why does app fail?
  305. Column headings using Comment?
  306. Create Schema functionality question
  307. Found this in the server log on MAC OSX
  308. DBD::Pg 1.32 ready for testing
  309. Meet this embebed postgresql in Visual Basic
  310. Binary data in PostgreSQL
  311. HELP with a Query
  312. backup and restore questions
  313. Problems with plpgsql and FOR loops
  314. Replication options
  315. finding out actual tuple size
  316. Post gresql commands
  317. Join with equals?
  318. embeding postgre
  319. PHP + Postgres: More than 1000 postmasters produce 70.000 contextswitches
  320. How can I delete a primary or foreign key?
  321. Inherited tables and column references
  322. Slow queries in PL/PGSQL function
  323. Slow queries in PL/PGSQL function
  324. pg_restore problem
  325. Modular application needing additional columns?
  326. Replication options
  327. postgresql & unicode
  328. Edit Tables...
  329. Inner join question
  330. VACUUM Question
  331. Refer to n'th field of a table?
  332. How do I get query result(select e.g.) from a dynamic command(EXECUTE)?
  333. VACUUM Question
  334. Big Tables vs. many Tables vs. many Databases
  335. wishlist: dynamic log volume control
  336. Prepared statements and cursors
  337. [Re] Need help with postgresql/apache/php optimisation
  338. [Re] Need help with postgresql/apache/php optimisation
  339. pg_dumpall dies
  340. cannot use createlang after removing public schema
  341. Adding Functionality
  342. autodoc and debian
  343. Numbering a records
  344. Differences between postgres and mysql
  345. pg_dump and pg_dumpall fail when trying to backup database
  346. Select statment question
  347. CRM Academic Research Request
  348. how to merge a table from another DB
  349. GPG MD5 Checksum for postgres 7.4
  350. pg_dump and circular dependency
  351. unsubscribe
  352. Reuse of Subselects
  353. String manipulation
  354. summary aggregate information from a second table
  355. function returning a record
  356. psql, 7.4, and the \d command
  357. Repost: Syntax - or unavailability of same - for variable join??? Can anyone help?
  358. Cascade delete triggers change user credentials
  359. Dates
  360. to_char problem
  361. using a .postgresql/root.crt
  362. Select for update, locks and transaction levels
  363. Fosdem
  364. How do I call multiple functions in one trigger?
  365. PostgreSQL on Windows
  366. Replication in postgresql
  367. Inputting columns of data
  368. tsearch2: restoring problem
  369. Dazed and Confused
  370. making tsearch2 dictionaries
  371. Pg + perl + apache
  372. Best replication options
  373. Wire protocol v3 details
  374. postgresql system column errors
  375. SQL99 IGNORE
  376. Index storage question...
  377. Providing the password to psql from a script
  378. nonblocking libpq large object access?
  379. How to determine current database?
  380. resource monitoring
  381. Using NOTIFY... Slow Client Querys
  382. timestamp/date comparison
  383. Too much CPU usage
  384. inheritance vs performance
  385. book for postgresql
  386. update set x=(subquery on same table)
  387. Join 2 aggregate queries?
  388. Mysql to Postgresql
  389. Schizophrenic design and solution to it
  390. Idle Connection force-close ?
  391. help with query speed
  392. Connect to PostgreSQL with kylix3
  393. PostgreSQL on OpenSSI
  394. error when executing dynamic commands with transaction
  395. Migrating 7.1.3 to 7.3.4 problem
  396. Not using index
  397. Error language Python (trusted)
  398. Is a capital letters title for this ML blocked?
  399. No More Processes
  400. Prepared queries
  401. createdb feature request
  402. Anyone used GForge?
  403. pl/pythonu
  404. Function parameters of rowtype
  405. Converting timestamps and IP addresses
  406. pg_class and relfilenode
  407. Temporary views
  408. Join query on 1M row table slow
  409. PQunescapeBytea
  410. Changing schema owner?
  411. Duplicate oid and primary key values
  412. Now that I have --enabled-nls...
  413. pl/pythonu and Triggers
  414. Strange Slow query
  415. number of rows in a cursor
  416. Please help re function packaging...
  417. IP adrss and networks in Postgresql
  418. FWD: Try on these correction update for Windows
  419. Case sensitivity
  420. book for postgresql
  421. db_space
  422. odbc problems
  423. CPU Usage
  424. Oracle SQLNet on same server as Postgres
  425. setting default value by "trigger"
  426. Quad Xeon vs. Dual Itanium
  427. Increasing Max Connections Mac OS 10.3
  428. TSearch and rankings
  429. functions and temporary tables
  430. Check for prepared statement
  431. query progress indicator
  432. disallowing multiple NULLs in a unique constraint
  433. Foreign Key on Inheriting Table?
  434. fsync = true beneficial on ext3?
  435. piping output to file
  436. Repost: postmaster growing to consume all memory
  437. Partial index in other DB
  438. CREATE BLOB
  439. Where do I find the init-script
  440. Unable to create a PL/PGSL function : Did I miss something ?
  441. benchmarks?
  442. connectby for BYTEA keys
  443. duplicate key violates unique constraint "pg_class_oid_index"
  444. Can anyone recommend accounting software using PGSQL?
  445. SHOW TABLES ?
  446. Syntax (or unavailability of same) for variable join results?
  447. Indexes and sorting
  448. retrieving parts of a resultset
  449. Getting table attributes
  450. PL/Ruby
  451. how can I select into an array?
  452. Run 2 versions of Postgresql on one machine?
  453. Casting 'record' to a composite type.
  454. Starting the Server ?
  455. Upcoming events: Chemnitzer Linux-Tag
  456. pgsql 7.4.1 copy - end-of-copy marker corrupt
  457. Sort order confusion
  458. Analyze not doing anything?
  459. functional index "real world" uses
  460. functional index "real world" uses
  461. : Proper tool to display graphics?
  462. ERROR: column 'xxx' does not exist (under v. 7.4.1)
  463. dblink - custom datatypes don't work
  464. pg_restore and large files
  465. size of mailing lists?
  466. Proper tool to display graphics?
  467. Can LIKE use indexes or not?
  468. dblink: rollback transaction
  469. Improving performance with a Function instead of a View
  470. Predictive or scoring solution for PostgreSQL ?
  471. Wrong week day language
  472. Copying tables between databases
  473. Resize varchar column
  474. Transaction end on error
  475. RETURN NEXT and reversing order
  476. application developers list?? or report engine using postgres?
  477. BLOB problem
  478. Anyone has nls activated on Mac OS X?
  479. problem with jdbc connection to postgesql
  480. Specifying a index
  481. large crontab database design
  482. Multicolumn Indexing using R-Tree
  483. Copy and xml files
  484. BLOB problem
  485. Before ship 7.4.2
  486. recursive query?
  487. Transfer database tables to a schema
  488. cannot extend error
  489. Select Question
  490. Return Value of a Function
  491. Postgresql 7.3 And Redhat Enterprise 3
  492. isolating users from each other
  493. How to kick out automatically stuck in queries
  494. Array in stored procedure
  495. Error with pg_restore (parse error at or near "BY" at character 144
  496. Functions in CHECK constraint not getting dumped before tables.
  497. partial indexes
  498. Search across multiple sources
  499. Does SET STATISTICS lock the table?
  500. Incorrect Results From Select When Using Non-English Characters
  501. Problem with function
  502. Help: System requirements for postgresql 7.4.1
  503. Viewing detailed lock information
  504. How to...
  505. select ... distinct performance
  506. Using PostgreSQL to store ip traffic information
  507. Insert question null/not null serial, etc.
  508. Fw: [JDBC] Trigger function aborts the transaction on exception
  509. Large object insert/update and oid use
  510. Unicode vs SQL_ASCII DBs
  511. PostgreSQL 7.4.1 and pgdb.py
  512. Two joins on same foreign key
  513. DB cache size strategies
  514. Are there commands to enquire about table structure?
  515. Problem with API (libpq) - detailed error codes
  516. IDENT and pg_hda.conf
  517. No Database Drivers
  518. subqueries vs. separate queries
  519. Planner configuration
  520. Grant question
  521. A strange Vacuum error ...
  522. Pl/tcl auto-load problem
  523. Very slow query - why?
  524. Specifying many rows in a table
  525. Single step Sql script GUI editor
  526. 7.3.4 freezing
  527. Sorting is ignoring spaces
  528. Seaching without accents
  529. Interest in database-based email?
  530. Help, I've killed my system?
  531. Fw: postgres DB duplication
  532. Manually authenticating users in pg_shadow
  533. Is autocommit=true bad?
  534. Call a function when a User (dis)connects from the Server/Database
  535. Logging all queries
  536. Looking for mail relays ...
  537. Postgress resumes ...
  538. Adding missing FROM clause - thanks or no thanks?
  539. Increase stored proc. parameters max count
  540. How can the sequence become out of sequence?
  541. Broken Link on techdocs
  542. Permission Problems:-)?
  543. Reloading Template1
  544. Foreign keys on inherited attributes
  545. postmaster growing to consume all memory
  546. Embedded transactions
  547. crlf and copy
  548. how to enumerate rows ?!?
  549. pg_largeobject and oid mistmach after restore
  550. Executing a query and returning the result set using the SPI