View Full Version : postgresql answers


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

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