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