View Full Version : answers

Pages : 1 2 3 4 5 [6] 7 8 9 10 11
  1. Error linking libpq into client program
  2. Error linking libpq into client program
  3. sql standard: \' or ''
  4. sql standard: \' or ''
  5. Listing databases
  6. Listing databases
  7. question regarding cursors in plpgsql, declare and bound params (v3 protocol)
  8. question regarding cursors in plpgsql, declare and bound params (v3 protocol)
  9. list types
  10. list types
  11. Fw: set autocommit TO FALSE on postgres 7.4
  12. Fw: set autocommit TO FALSE on postgres 7.4
  13. help me
  14. help me
  15. example database setup
  16. example database setup
  17. postgres mirroring (real-time)
  18. postgres mirroring (real-time)
  19. vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
  20. vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
  21. plpgsql question
  22. plpgsql question
  23. Is Linux 2.6.5 kernel good enough for production?
  24. Is Linux 2.6.5 kernel good enough for production?
  25. How to abort psql when backtick (shell) commands return non-zero?
  26. How to abort psql when backtick (shell) commands return non-zero?
  27. FYI, foxpro to postgresql conversion scripts
  28. FYI, foxpro to postgresql conversion scripts
  29. Embedded SQL inherently faster than others?
  30. Embedded SQL inherently faster than others?
  31. Variable in PostgreSQL 7.4.x
  32. Variable in PostgreSQL 7.4.x
  33. Postgres to oracle data migration
  34. Postgres to oracle data migration
  35. [Fwd: help building datetime from varchars]
  36. [Fwd: help building datetime from varchars]
  37. interval output format available that removes ambiguity ?
  38. interval output format available that removes ambiguity ?
  39. Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird
  40. Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird
  41. create synopsis wrong ?
  42. create synopsis wrong ?
  43. pgsql documentation error ?
  44. pgsql documentation error ?
  45. Cache lookup failure for pg_restore?
  46. Cache lookup failure for pg_restore?
  47. Parenthesis in Queries
  48. Parenthesis in Queries
  49. wait_seconds in pg_ctl
  50. wait_seconds in pg_ctl
  51. insert through function only
  52. GRANT TEMPORARY ON DATABASE to Public
  53. GRANT TEMPORARY ON DATABASE to Public
  54. insert through function only
  55. C Functions, datatypes
  56. C Functions, datatypes
  57. XID Data Types
  58. XID Data Types
  59. Per-session data?
  60. Per-session data?
  61. pdx pug or pug domain owner
  62. pdx pug or pug domain owner
  63. set autocommit TO FALSE on postgres 7.4
  64. set autocommit TO FALSE on postgres 7.4
  65. Constrint Name Length...
  66. Constrint Name Length...
  67. is this valid
  68. is this valid
  69. unattended backupscript not working with 7.4.2, works in 7.1
  70. unattended backupscript not working with 7.4.2, works in 7.1
  71. Anyone interested in a Pittsburgh-area Postgres users' group?
  72. Anyone interested in a Pittsburgh-area Postgres users' group?
  73. Tracking structural changes from psql
  74. Tracking structural changes from psql
  75. bad characters in database
  76. bad characters in database
  77. users rights per table
  78. users rights per table
  79. Vacuumdb Errors --Any ideas?
  80. Vacuumdb Errors --Any ideas?
  81. cionnected users to server
  82. cionnected users to server
  83. CLUSTER not working
  84. CLUSTER not working
  85. pgsql folder and its contents
  86. pgsql folder and its contents
  87. One or Both Foregin Keys
  88. One or Both Foregin Keys
  89. "out of memory" error
  90. "out of memory" error
  91. JDBC caching plpgsql function errors?
  92. JDBC caching plpgsql function errors?
  93. synchronizing MS access and postgresql tables
  94. synchronizing MS access and postgresql tables
  95. hugetlb feature linux 2.6 kernel
  96. Calls to find Users and databases open...
  97. Calls to find Users and databases open...
  98. hugetlb feature linux 2.6 kernel
  99. Check a value in array
  100. Check a value in array
  101. TCP only listening on localhost???
  102. TCP only listening on localhost???
  103. Plpgsql problem passing ROWTYPE to function
  104. Plpgsql problem passing ROWTYPE to function
  105. "Idle in Transaction" and hung connections
  106. "Idle in Transaction" and hung connections
  107. Timestamp problems...wrong weeks.
  108. Timestamp problems...wrong weeks.
  109. Follow-up to original post, more information:
  110. Follow-up to original post, more information:
  111. trying to restore after a server failure...need some help
  112. trying to restore after a server failure...need some help
  113. Unable to use index?
  114. Unable to use index?
  115. Performance problem with correlated sub-query
  116. Performance problem with correlated sub-query
  117. postgresql web problems?
  118. postgresql web problems?
  119. Postgre and Web Request
  120. Postgre and Web Request
  121. Mixed Case column names (php 4.3.5 & pg 7.4.2)
  122. Mixed Case column names (php 4.3.5 & pg 7.4.2)
  123. docs search not working?
  124. docs search not working?
  125. Calling a function that returns a cursor using libpq
  126. Calling a function that returns a cursor using libpq
  127. Optimizer choosing smaller index instead of right one
  128. Optimizer choosing smaller index instead of right one
  129. error while CLUSTERing!
  130. error while CLUSTERing!
  131. Updates not atomic with respect to indexes
  132. Updates not atomic with respect to indexes
  133. locking question
  134. locking question
  135. Cannot open relation pg_cast_source_target_index
  136. Cannot open relation pg_cast_source_target_index
  137. WAL details
  138. WAL details
  139. BLOB help needed...
  140. BLOB help needed...
  141. Problem installing postgresql 7.3.6 on Redhat 7.3
  142. Problem installing postgresql 7.3.6 on Redhat 7.3
  143. composite type and assignment in plpgsql
  144. composite type and assignment in plpgsql
  145. Temp table problem.
  146. Temp table problem.
  147. questions on rules
  148. questions on rules
  149. Help on "unexpected EOF..client reset by peer" errors
  150. Help on "unexpected EOF..client reset by peer" errors
  151. pg_restore problem
  152. pg_restore problem
  153. Question
  154. Question
  155. loading data into postgresql became slow after i used VACUUME command.
  156. loading data into postgresql became slow after i used VACUUME command.
  157. List Removal
  158. List Removal
  159. Postgres alongside MS SQL Server
  160. Postgres alongside MS SQL Server
  161. shadowing (like IB/Firebird)
  162. shadowing (like IB/Firebird)
  163. Arbitrary precision modulo operation
  164. Arbitrary precision modulo operation
  165. Restart increment to 0 each year = re-invent the sequences mecanism?
  166. Restart increment to 0 each year = re-invent the sequences mecanism?
  167. Migrating Fox (dbf) to PostgreSQL
  168. Migrating Fox (dbf) to PostgreSQL
  169. PostgreSQL 7.4.2 initdb problem
  170. PostgreSQL 7.4.2 initdb problem
  171. target list evaluation wrt sequences
  172. target list evaluation wrt sequences
  173. Install plpython
  174. Install plpython
  175. Silent overflow
  176. Silent overflow
  177. Synchronize unicode data using copy or pg_dump
  178. Synchronize unicode data using copy or pg_dump
  179. Question about inserts
  180. Question about inserts
  181. Case insensitive search
  182. Case insensitive search
  183. New replication software pgpool available
  184. New replication software pgpool available
  185. Has anyone come up with a work-around for the capitalization of non C-locale letters?
  186. Has anyone come up with a work-around for the capitalization of non C-locale letters?
  187. pg_autovacuum startup script
  188. pg_autovacuum startup script
  189. Executing SQL which is stored in database
  190. Executing SQL which is stored in database
  191. Illegal characters in database names, table names, user names...
  192. Illegal characters in database names, table names, user names...
  193. Missing OID rant
  194. Missing OID rant
  195. Unicode + LC_COLLATE
  196. Unicode + LC_COLLATE
  197. What is wrong here?
  198. What is wrong here?
  199. Restoring a Databases that features tserach2
  200. Restoring a Databases that features tserach2
  201. FW: Postgres alongside MS SQL Server
  202. FW: Postgres alongside MS SQL Server
  203. postgresql idle
  204. postgresql idle
  205. Multiple DBs, One app, How to do relations?
  206. Multiple DBs, One app, How to do relations?
  207. Installation - SuSE 9.0
  208. Installation - SuSE 9.0
  209. ident authentication problem
  210. ident authentication problem
  211. kill -2
  212. kill -2
  213. 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time
  214. 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time
  215. Unicode problem ???
  216. Unicode problem ???
  217. Ordering YYYY MM DD in reverse chrono order
  218. Ordering YYYY MM DD in reverse chrono order
  219. TPC H data
  220. TPC H data
  221. index elements of a composite?
  222. index elements of a composite?
  223. staggered query?
  224. staggered query?
  225. PL/SQL question
  226. PL/SQL question
  227. Connection reset by peer
  228. "dump" and "restore" doesn't seem to work
  229. Connection reset by peer
  230. "dump" and "restore" doesn't seem to work
  231. Downgrading from Postgresql 7.4 to 7.1
  232. Problem updating a large binary field (PostgreSQL, ODBC, VC++)
  233. Index on computed column
  234. PostgreSQL on SMB/CIFS Shares on FreeBSD 5
  235. Downgrading from Postgresql 7.4 to 7.1
  236. Index on computed column
  237. Problem updating a large binary field (PostgreSQL, ODBC, VC++)
  238. Looking for help building 'rhdb-explain' Visual Explain tool
  239. I cannot view the website of postreSQL correctly
  240. upgrade postgres 7.1 to 7.4.2
  241. PostgreSQL on SMB/CIFS Shares on FreeBSD 5
  242. Looking for help building 'rhdb-explain' Visual Explain tool
  243. composite types
  244. upgrade postgres 7.1 to 7.4.2
  245. I cannot view the website of postreSQL correctly
  246. Can I reset the lower bound of an array.
  247. cursor questions
  248. composite types
  249. Can I reset the lower bound of an array.
  250. Replication
  251. cursor questions
  252. Replication
  253. Can anyone share ETL tools with Postgres experiences?
  254. Is there a newer version of DBD::Pg?
  255. 7.4.2 initdb problem
  256. Redundancy software for PostgreSQL
  257. Solution to Error 429
  258. db security (md5)
  259. Using of GeQo
  260. doubt about pg_dumpall
  261. Storing images in a field
  262. plan-reading extensive tutorial?
  263. Inapropriate content
  264. Date manipulation
  265. Folding subtotals into query?
  266. Cursors and PHP
  267. Python to postgresql interface
  268. Documentation tool
  269. Suppress output from function?
  270. build contrib
  271. Vb databound
  272. Accessing RelOptInfo structure from the executor module
  273. Locale support on Mac OS X
  274. Indexing null dates
  275. Mixed UTF8 / Latin1 database
  276. Parse error a in short stored procedure : What's wrong ?
  277. Postgresql system requirements to support large databases.
  278. Syntax question - compound value comparisons
  279. Table Lock issue
  280. pg_clog corruption?
  281. Problems with Triggers
  282. PLpgSQL-Problem
  283. Anyone using pgreplicator?
  284. User permission
  285. Basix for Data General / Basix for Sco Unix
  286. SQL script
  287. SRF problem
  288. SRF problem
  289. when restoring or loading
  290. trigger function SQL statement
  291. PostGIS and 7.4.1
  292. upgrading postgresql from 7.2 to 7.3, getting error
  293. Optimal configuration to eliminate "out of file descriptors" error
  294. constraint help
  295. major-domo not set up right
  296. mini survey
  297. Donating
  298. Stored procedures output variables
  299. columns refered to in view
  300. random_page_cost
  301. cache lookup of relation 165058647 failed
  302. allowing vacuum/ analyze to operate on whole schemas.
  303. Disable NOTICE echoing
  304. insert rule not firing on insert with exists subselect
  305. Join works in 7.3.6, fails in 7.4.2
  306. verifying unicode locale support
  307. performance problem aftrer update from 7.1 to 7.4.2
  308. Filesystem vs. Postgres for images
  309. Executing script file
  310. specifics about BIT(n) types
  311. Problems setting shared_buffers to large value
  312. PostgreSQL Invalid Page Header in Block XXXXX
  313. db schema diff
  314. Regular expressions
  315. error with start up pgsql.
  316. REINDEX slow?
  317. ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
  318. pg_ctl written in c
  319. which filesystem will database be saved to?
  320. system date != now()
  321. Postmaster won't shut down
  322. Access Conversion
  323. help needed regarding Query processing in postgres
  324. COPY TO order
  325. Errors in transactions
  326. running postgresql database from loopback filesystem?
  327. Data Encryption in PostgreSQL, and a Tutorial.
  328. Why would query return PGRES_NONFATAL_ERROR?
  329. Sorting in Unicode not working
  330. Accented chars in several apps
  331. Select/Group by/Order by question
  332. Upgrading from 7.3.6 to 7.4.2 pg_dumpall question
  333. pgsql yum update for Fedora system?
  334. Postgresql yum update for Fedora Core 1 system?
  335. Error Message from pgsql v7.3.6
  336. pg_ctl problem
  337. First Question: to_char statement problems
  338. To_char statement problems
  339. Date Comparison Help
  340. extract epoch and index scanning
  341. Orphaned trigger -- bug?
  342. pg_ctl problem
  343. Big string using Zeos from Delphi
  344. Oid problem
  345. Problem with pg_dump - reg.
  346. eval in plpgsl
  347. MacOS X, Postgresql and Aqua Tcl/Tk
  348. Moving from narrow to wide tables
  349. Are functions automatically transactioned?
  350. ERROR: invalid memory alloc request size 0
  351. Error numbers
  352. timestamp precision with or without timezones
  353. \? not working in psql
  354. How to list domains
  355. Can the username calling a function be made available within thefunction?
  356. How estimated rows is running ?
  357. More aggregate functions?
  358. Informations about functions ...
  359. Tcl load command and mac os x
  360. Logging database and statement with errors
  361. PERFORM statement inside procedure
  362. thread_test.c problems
  363. Crash in postgres/linux on verly large database
  364. Subqueries failing inside pl/pgsql fuction called by trigger
  365. ignore
  366. pg_autovacuum won't make on FreeBSD
  367. Upgrade
  368. ignore this test
  369. set timestamp oddness
  370. domains
  371. Date differences
  372. left and overleft/notright revisited: why !>> and !<< might be poornames
  373. Cursors and Transactions, why?
  374. Storing jpgs
  375. Evening in NYC
  376. Mirroring tables from Oracle to Postgresql
  377. Need to replace PostgreSQL 7.4 with 7.3 on cygwin
  378. Optimize query
  379. Version 1.0.0.4 released
  380. RPM init-script: Why the locale setting?
  381. Invalid page header in block...
  382. Creating a trigger function
  383. Recursive FOREIGN KEY?
  384. thread_test.c problems
  385. Best Practices for Storing Set Combinations
  386. postgres 7.4.2: float(20) results in error msg, but should not since7.4)
  387. Problem in calling prepare statement from STORED PROCEDURE
  388. namespace dilemma
  389. relfilenode on 7.2.3
  390. Casting int to bool with join...
  391. Storage cost of a null column
  392. execute function after user connect
  393. Optimization on UPDATEs and FOREIGN KEYs...
  394. PostgreSQL 7.4.2 warnings in HPUX IPF: LOG: could not resolve "localhost": host nor service provided
  395. glibc update.. effect on PG
  396. FUNCTION problem
  397. Loading text files into a text attribute
  398. Create Type Problem
  399. SQL Question: Query for Newest Records
  400. Problems compiling Apache 2.0.49 with mod_auth_pgsql
  401. Some Aberdeen report
  402. Compound keys and foreign constraints
  403. Select Union
  404. A simple question about Read committed isolation level
  405. Problems Vacuum'ing
  406. 7.2.3-7.4.2 migration
  407. Problem restoring Database
  408. Checking FKs after COPY and disabled Triggers
  409. Whats missing from postgresql
  410. recursive trigger
  411. 7.4.1 upgrade issues
  412. ECPG - bug in EXEC SQL WHENEVER NOT FOUND?
  413. why is this index not being used?
  414. Postgres dump utility
  415. copy command verbose
  416. Large table performance and vacuum
  417. PHP on slackware
  418. Setting up Postgresql on Linux
  419. Setting up Postgresql on Linux
  420. Setting up Postgres on Linux
  421. Trigger Update Issue
  422. relocatable binary distribution
  423. extented ascii problem
  424. Management of "varchar types"
  425. sum of a time column
  426. performance problems: join conditions
  427. building 7.4.1 (on linux) with --disable-shared
  428. ERROR: function round(double precision, integer) does not exist - WTF?
  429. Question on stored functions
  430. Tom Lane heads up
  431. Setting up Postgresql on Linux
  432. ORDER by Clauses do not seem to be working correct
  433. Fastest way to query limited time ordered data set
  434. Setting up Postgresql on Linux
  435. Aggregate function capability with \d in psql
  436. Enable/Disable triggers
  437. Information about a column
  438. Inherited tables and foreign keys
  439. clarification of postgres limitations
  440. Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?
  441. need advice.
  442. using Postgres to store many small files
  443. Setting up Postgresql in Linux
  444. REFERENCES error message complaint, suggestion
  445. Slony-I makes progress
  446. gist index build produces corrupt result on first access totable.
  447. Mistake in my query or Index Scan on subquery failure? (7.4)
  448. Error message
  449. autocommit to off?
  450. making a copy of a table within the same database
  451. How index are running and how to optimise ?
  452. Large Object
  453. Trigger using 'if NEW = OLD'
  454. SPI memory managment issue
  455. Selecting reals into doubles
  456. plpgsql trigger function with arguments
  457. constraints
  458. ת·¢: docs on tsearch2
  459. Setting up Postgresql on Linux
  460. Record order change after update
  461. Setting up Postgresql on Linux
  462. Max/min of 2 values function, plpgsql efficency?
  463. max table size
  464. Data in table changed?
  465. More info on table fields
  466. Installing Postgresql in Irix
  467. how to detect last change
  468. Setting up Postgresql on Linux
  469. can you run a psql command line query?
  470. How to Cancel a query ?
  471. Setting up Postgresql on Linux
  472. sql query to get field types
  473. Linux Labs
  474. using the "copy from" command
  475. libpq API for PQcmdTuples()
  476. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  477. using the "copy from" command to load tables from a txt flat file
  478. ORDER BY problem
  479. INSERTS and Queries
  480. Different version of PostgreSQL on same machine?
  481. elog: out of memory
  482. A simple question (under pressure :-))....
  483. referring to computed values from the select list in the where andorder clauses
  484. count(1) return 0?
  485. Postgres slow after a couple of days
  486. Are Triggers Synchronous
  487. dumping fields from Perl
  488. inlined sql functions in 7.4
  489. ispell tsearch2 dictionary
  490. SERIAL type - auto-increment grouped by other field
  491. inheritance of triggers (OO tables)
  492. Korean characters in a SQL_ASCII database?!?
  493. Where are the backend/commands?
  494. postmaster out of memory....
  495. help with correlated delete and outer join
  496. pgCluster in production environment
  497. Memory usage
  498. Triggers per transaction, workaround? prospects?
  499. Copying data from one table to another
  500. installation -- help ?
  501. Trigger function aborts the transaction on exception
  502. value too long error
  503. Postgresql bajo Windows Míralo Ve
  504. setting datestyle for different databases within a cluster
  505. Regarding BITs vs. INTs
  506. clear defunct entries from pg_stat_activity
  507. Restoring a table with a different name
  508. XML Challenge
  509. PostgreSQL in Cluster
  510. Here there is a Postgresql for Windows Sample APP
  511. On Update (trigger hint)
  512. field must appear in the GROUP BY clause or be used in an aggregatefunction?
  513. compartmentalizing users
  514. PostgreSQL insert speed tests
  515. Case of strings
  516. check for user validity
  517. change db encoding
  518. correlated delete with "in" and "left outer join"
  519. Simple, but VERYuseful enhancement for psql command - or am I missing something?
  520. Help with a query
  521. Postmasters pile up
  522. Postgres clustering?
  523. Hostname change - pgsql won't start
  524. PostgreSQL on XFS experiences?
  525. [PgSQL 7.4.1] Problem with subquery
  526. PL/pgSQL debugger
  527. help using arrays in a function
  528. Windows Library for libpq
  529. postgreSQL licenseing
  530. Simplyfying many equals in a join
  531. How to drop sequence?
  532. reindexing, pg_class (and other system tables)
  533. key = currval('tab_key_seq') choses SEQSCAN?!
  534. REINDEX issues
  535. TG_RELNAME problem
  536. Moving from MySQL to PGSQL....some questions
  537. invalid memory alloc request size
  538. tsearch2 trigger alternative
  539. PLSQL Question regarding multiple inserts
  540. Inheritance and column references problem
  541. select statement against pg_stats returns inconsistent data
  542. Sequence Permissions.
  543. Rows to columns
  544. Irreversible performance drop after increasing shared mem
  545. dynamic views
  546. ON DELETE RULE problem
  547. Why does app fail?
  548. Column headings using Comment?
  549. Create Schema functionality question
  550. Found this in the server log on MAC OSX