View Full Version : postgresql answers


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

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