View Full Version : postgresql answers


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

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