View Full Version : answers

Pages : 1 2 3 4 [5] 6 7 8 9 10 11
  1. enable thready safety on Mac OS X 10.3.4
  2. Performance problem on RH7.1
  3. Speed of pg_dump -l -s (List Schema) Variations
  4. (NONE)
  5. Deadlock. Referential Integrity checks select for update?
  6. Running two postmasters on one host: could not create semaphores
  7. Multi-Language upper(),lower()
  8. Ranking values within a query (pseudo-ROWNUM) **fixed**
  9. psql
  10. hackers dudes
  11. Ranking values within a query (pseudo-ROWNUM)
  12. Renaming a schema
  13. Possible To Modify Part of String in Certain Rows?
  14. Queries not always using index on timestamp search
  15. 7.4.3 RPMS for RHEL3
  16. PostgreSQL Optimizer
  17. strange apllicaion error
  18. PHP: Too many open links (0) with libpg7.4.3
  19. Replace-function
  20. unicode and sorting(at least)
  21. Blob
  22. Performance
  23. langauges, locales, regex, LIKE
  24. clusters and database instances
  25. LIKE and REGEX on postgres
  26. LIKE and encoding and locale
  27. Catching errors
  28. Dump produces file with new line characters
  29. coalesce and nvl question
  30. simultaneous use of JDBC and libpq
  31. timestamp without time zone format
  32. Logging duration of batch runs
  33. FW: problems with installing postgres
  34. setting autocommit off in pgsql
  35. Point in time recovery
  36. Parameters from trigger to function.
  37. incremental backups?
  38. Datatype sizes; a space and speed issue?
  39. Deleting all but one row of a list of non-uniques
  40. Planner choice & tuning
  41. flock user defined function
  42. Connection gets into state where all queries fail
  43. Can I interrupt queries already processing in the server?
  44. More psql problems... >.<
  45. 7.5 Windows version
  46. PostgreSQL Docs for Paper (benchmark and contrib)
  47. Experience with postgres/apache host providers
  48. psql
  49. insert with select as value
  50. pgpool 2.0 is available
  51. How can I add a new language localization(locale) support
  52. User Privileges using dblink
  53. Do we need more emphasis on backup?
  54. PGplSql: Relation 44451 does not exist
  55. who can run utility - pg_controldata ?
  56. JDBC driver inserting into a table with Bytea type gets out of memory error.
  57. Possible SET SESSION AUTHORIZATION bug
  58. New to the list; would this be an okay question?
  59. New to the list; would this be an okay question?
  60. Database name in the log
  61. Database name in the log
  62. Problem while OS-Update
  63. Problem while OS-Update
  64. PGSQL service dieing...
  65. PGSQL service dieing...
  66. Is this a "Stupid Question" ?
  67. Is this a "Stupid Question" ?
  68. IpcMemoryCreate Failed
  69. IpcMemoryCreate Failed
  70. Postgresql installation.
  71. Postgresql installation.
  72. pivot table sql -- COUNT() not working as expected
  73. pivot table sql -- COUNT() not working as expected
  74. Relocation error pg_dumpall undefined symbol get_progname in 7.4.3
  75. Help please - completely baffled by quoting
  76. Help please - completely baffled by quoting
  77. Relocation error pg_dumpall undefined symbol get_progname in 7.4.3
  78. Need help with Dead Lock - reg.
  79. Need help with Dead Lock - reg.
  80. administering files, data type "file"
  81. administering files, data type "file"
  82. File System Restore
  83. File System Restore
  84. INSERT BEFORE Trigger
  85. INSERT BEFORE Trigger
  86. syntax error but command executes anyway?
  87. syntax error but command executes anyway?
  88. How do I clean up a site from an old version to install anew
  89. How do I clean up a site from an old version to install anew
  90. Current Query from Trigger
  91. Current Query from Trigger
  92. RHEL 2.1 rpms for 7.4.2
  93. RHEL 2.1 rpms for 7.4.2
  94. UPDATE inside an Update trigger
  95. UPDATE inside an Update trigger
  96. Article on open-source databases
  97. Article on open-source databases
  98. UTF8 vs C_LOCALE
  99. UTF8 vs C_LOCALE
  100. Trigger to update records out of memory
  101. Trigger to update records out of memory
  102. INSERT ON DUPLICATE KEY UPDATE
  103. INSERT ON DUPLICATE KEY UPDATE
  104. Restoring a table with blobs - Without doing a full restore - Is it even possible ?
  105. Restoring a table with blobs - Without doing a full restore - Is it even possible ?
  106. Variadic functions in plpgsql?
  107. Variadic functions in plpgsql?
  108. virtual fields on VIEW?
  109. virtual fields on VIEW?
  110. PgSQL shut down
  111. PgSQL shut down
  112. User Rights
  113. User Rights
  114. Just saying thank you for PostgreSQL
  115. Just saying thank you for PostgreSQL
  116. 7.4 windows version?
  117. 7.4 windows version?
  118. Connection Problem to DB Table
  119. Connection Problem to DB Table
  120. test post
  121. test post
  122. pg_dump out of shared memory
  123. pg_dump out of shared memory
  124. putting binary data in a char field?
  125. putting binary data in a char field?
  126. 7.4 for Windows?
  127. 7.4 for Windows?
  128. MySQL to Postgres.
  129. MySQL to Postgres.
  130. Off Topic: Book about High available / Load Balancing / Cluster
  131. Off Topic: Book about High available / Load Balancing / Cluster
  132. Join a varchar array
  133. Join a varchar array
  134. List prime key column names
  135. List prime key column names
  136. 7.4's INFORMATION_SCHEMA.Columns View
  137. 7.4's INFORMATION_SCHEMA.Columns View
  138. PostgresSQL 7.3.x removal
  139. PostgresSQL 7.3.x removal
  140. korean encoding, sort order off anyhow
  141. korean encoding, sort order off anyhow
  142. Database accesss using plperl
  143. Database accesss using plperl
  144. Remembering values in pl/pgsql
  145. Remembering values in pl/pgsql
  146. Tracking down deadlocks
  147. Tracking down deadlocks
  148. PostGres ODBC MFC Application
  149. PostGres ODBC MFC Application
  150. reference to a view
  151. reference to a view
  152. why no answer? [Fwd: backup and restore just with use ofjdbc?]
  153. why no answer? [Fwd: backup and restore just with use ofjdbc?]
  154. Query
  155. Query
  156. Multicolumn indexes and ORDER BY
  157. Multicolumn indexes and ORDER BY
  158. "Interesting" query planning for timestamp ranges in where clause?
  159. "Interesting" query planning for timestamp ranges in where clause?
  160. how does license work for non-profit companies?
  161. how does license work for non-profit companies?
  162. building 7.4.3 on Solaris 9/Intel
  163. building 7.4.3 on Solaris 9/Intel
  164. postgresql.conf for pg_stat_activity
  165. postgresql.conf for pg_stat_activity
  166. Installation problem - mutex_lock/unlock or libpq.so ?
  167. Installation problem - mutex_lock/unlock or libpq.so ?
  168. PostgreSQL 7.4.3 Now Available ...
  169. PostgreSQL 7.4.3 Now Available ...
  170. Fw: Feature idea
  171. Fw: Feature idea
  172. Feature idea
  173. Feature idea
  174. Why is a union of two null-results automatically casted to type text ?
  175. Why is a union of two null-results automatically casted to type text ?
  176. C_LOCALE vs. UTF8
  177. C_LOCALE vs. UTF8
  178. Can you help me with this query?
  179. Can you help me with this query?
  180. pg_hba auth failure
  181. pg_hba auth failure
  182. perl access
  183. perl access
  184. perl access
  185. perl access
  186. Error application using Powerbuilder 7 and postgresql 7.3
  187. Error application using Powerbuilder 7 and postgresql 7.3
  188. info about dependenciës between objects (add to ToDo)
  189. info about dependenciës between objects (add to ToDo)
  190. Question about array data types
  191. Question about array data types
  192. HTML output
  193. HTML output
  194. "alter sequence" equivilant in 7.2?
  195. "alter sequence" equivilant in 7.2?
  196. backup and restore just with use of jdbc?
  197. backup and restore just with use of jdbc?
  198. large dimension table
  199. large dimension table
  200. Trying to minimize the impact of checkpoints (resend)
  201. Trying to minimize the impact of checkpoints (resend)
  202. Set returning functions and Crystal Reports
  203. Set returning functions and Crystal Reports
  204. bytea functions
  205. bytea functions
  206. Installing 7.4.2
  207. Installing 7.4.2
  208. Information Schema - Can the views be applied to older versions ofPostgreSQL
  209. Information Schema - Can the views be applied to older versions ofPostgreSQL
  210. lost pg_xlog // recover database-structure without it?
  211. lost pg_xlog // recover database-structure without it?
  212. Keep history of modifications
  213. Keep history of modifications
  214. out of memory error
  215. out of memory error
  216. Can't compile a contrib util: dbsize (probably simply though)
  217. Can't compile a contrib util: dbsize (probably simply though)
  218. Opteron scaling with PostgreSQL
  219. Opteron scaling with PostgreSQL
  220. global temporary tables?
  221. global temporary tables?
  222. Returning rowsets/results from a function to another one in plpgsl.
  223. Returning rowsets/results from a function to another one in plpgsl.
  224. Trouble with locking tables - reg.
  225. Trouble with locking tables - reg.
  226. FK issue
  227. FK issue
  228. Transactions and insertion ordering
  229. Transactions and insertion ordering
  230. VACUUM FULL produce warnings
  231. VACUUM FULL produce warnings
  232. How to tell when postmaster is ready
  233. How to tell when postmaster is ready
  234. Postgresql vs. aggregates
  235. Postgresql vs. aggregates
  236. tablespaces and schemas
  237. tablespaces and schemas
  238. index with LIKE
  239. index with LIKE
  240. check constraint on char field
  241. check constraint on char field
  242. How to determine whether a view's column is indexed?
  243. How to determine whether a view's column is indexed?
  244. pg_dumpall and large objects
  245. pg_dumpall and large objects
  246. Another win for PostgreSQL
  247. Another win for PostgreSQL
  248. Help in finding the error
  249. Help in finding the error
  250. using regexp backreferences
  251. using regexp backreferences
  252. Prevent users from creating tables
  253. Prevent users from creating tables
  254. Multiple databases on seperate drives/file systems?
  255. Multiple databases on seperate drives/file systems?
  256. replication
  257. replication
  258. Index on points
  259. Index on points
  260. problem with inserting a generated seq no into not null field
  261. problem with inserting a generated seq no into not null field
  262. When to use postgreSQL , when to use other
  263. When to use postgreSQL , when to use other
  264. encrypted passwords
  265. encrypted passwords
  266. mailing list oddities
  267. mailing list oddities
  268. "security definer" not being set when function replaced
  269. "security definer" not being set when function replaced
  270. could not bind IPv4 socket: Address already in use
  271. could not bind IPv4 socket: Address already in use
  272. core dump
  273. core dump
  274. generic insert into table
  275. generic insert into table
  276. bug in 7.4.2, concern unicode and russian content of db
  277. bug in 7.4.2, concern unicode and russian content of db
  278. Identifying the 'current user' when using a connection pool
  279. Identifying the 'current user' when using a connection pool
  280. postgres on SuSE 9.1
  281. postgres on SuSE 9.1
  282. contents of pg_database vanished..
  283. contents of pg_database vanished..
  284. Index question
  285. Index question
  286. curius behavior of planner after analyze, (Pg7.5)
  287. curius behavior of planner after analyze, (Pg7.5)
  288. pg_dump, bytea, dump order questions
  289. pg_dump, bytea, dump order questions
  290. Tsearch case sensitive with dotted search terms.
  291. Tsearch case sensitive with dotted search terms.
  292. pg_dump and tsearch2
  293. pg_dump and tsearch2
  294. tsearch2 queries faster than expected
  295. tsearch2 queries faster than expected
  296. Need more speed for this query :)
  297. Need more speed for this query :)
  298. Dropping schemas and "illegal seek"
  299. Updating a unique constrant
  300. Dropping schemas and "illegal seek"
  301. Turn off "money" formatting?
  302. Updating a unique constrant
  303. Turn off "money" formatting?
  304. CREATE DATABASE on the heap with PostgreSQL?
  305. Changing from money...
  306. CREATE DATABASE on the heap with PostgreSQL?
  307. Changing from money...
  308. timestamp outside of bounds
  309. timestamp outside of bounds
  310. row access
  311. Concurrent access related issue.
  312. How to find out who is calling the function
  313. row access
  314. Perl DBI error string question pg7.4.2
  315. Concurrent access related issue.
  316. How to find out who is calling the function
  317. Aggregate C function accumulating a text array
  318. Queries slow from within plpgsql
  319. Unable to use NNTP server
  320. Perl DBI error string question pg7.4.2
  321. Aggregate C function accumulating a text array
  322. Queries slow from within plpgsql
  323. Unable to use NNTP server
  324. dynamic function question
  325. Backup and Restore of PostgreSQL
  326. ERROR: Invalid UNICODE character sequence found (0xed5c30)
  327. pg_xlog
  328. pg_class could not be found
  329. The pgreplication project
  330. Insert increment based on a group by?
  331. Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'
  332. TimeOf(Subselects|Joins)FromLargeTables?
  333. Who is managing the postgresql documentation?
  334. Ingres & PostgreSQL
  335. A "linking" Question
  336. again, invalid page header in block ...
  337. Page access pattern in query plan using index scan
  338. COPY error handling
  339. table content transfer from mysql to postgresql
  340. Timestamp precision and rounding
  341. zope, postgresql and idle connections
  342. JDBC: what exactly does nullsAreSortedHigh() return?
  343. Running Totals and stuff...
  344. Inet performance
  345. Building Thread-Safe on OS X
  346. interactive backend output
  347. Pg_dump error
  348. GRANT question
  349. statement-level statistics are disabled error (postgresql.conf)
  350. Creating a session variable in Postgres
  351. Dynamic SQL
  352. async problems?
  353. Securing a db app - RFC
  354. ORDER BY with plpgsql parameter
  355. Databases on separate filesystems
  356. How to identify which column in a table is the primary key
  357. More really old emails
  358. db design question
  359. after using pg_resetxlog, db lost
  360. Disappointing news
  361. Insert speed question
  362. PostgreSQL Tablespaces
  363. pg_dump question
  364. COPY FROM fails to trigger rules
  365. ODBC, ADO, Return Value from SP problem
  366. pg_dump and errors
  367. confused by superuser-definition
  368. Separating application from data
  369. Receiving three month old messages
  370. PostgreSQL Array & Java
  371. Large table search question
  372. Error handling in stored functions/procedures
  373. This is another testmail
  374. Trying to mail from my virtual network
  375. information schema
  376. Embedded SQL - Unable to connect to PostgreSQL Database
  377. locating postgresql lib and include files for SuSE 9.0 RPMS?
  378. Use arrays to store multilanguage texts
  379. postgresql anonymous cvs?
  380. Dump 7.1.3->7.4.2
  381. Use composite type for column data type
  382. turn WAL off.
  383. ERROR: date/time field value out of range: "28/05/2004 02:15:57"
  384. pg_dump and schema namespace notes
  385. What does error code PGSQL_TUPLES_OK (2) actually mean?
  386. Connecting to an External DB (repost)
  387. query results different after vacuum analyze? 7.4.0
  388. How do I unsubscribe?
  389. PostgreSQL Logs
  390. pg_restore quick question
  391. HOWTO: Integrating Posgresql queries into an event loop
  392. Database Size Limiting
  393. Howto handle views/Rules Privileges
  394. custom error messages/numbers
  395. statement level triggers in PostgreSQL , anybody??
  396. Naive schema questions
  397. connecting to an external postgresql db
  398. Connection log entries - random port number recorded
  399. One more time on ONE-TO-MANY
  400. Problem with sequences on a reload of a pg_dump file
  401. temas del comando COPY
  402. Postgresql Logging
  403. performance very slow
  404. Error: server closed the connection unexpectedely
  405. Casting hexadecimal to int
  406. insert/update
  407. planer don't use index. bad plan for where id = x or id in (select...)
  408. timestamps
  409. unix_socket
  410. Poatgresql database on more than one disk
  411. About table schema
  412. Iterating over an varchar array?
  413. restore from a pg_dumpall file
  414. md5 function available since ...?
  415. FW: Majordomo results: subscribe pgsql-general
  416. Abnormal Exit Quandary
  417. Error building PHP with PostgreSQL support
  418. Combining several rows
  419. PL/pgSQL: FOUND not set by EXECUTE?
  420. dump / restore questions
  421. pg_dump error
  422. DB design opinions - Foreign Key usage
  423. how many record versions
  424. restore from xlog
  425. psql -E is not working in 7.4.2 like 7.3.4
  426. could not open relation "pg_trigger_tgrelid_tgname_index"
  427. Schemaball v0.10
  428. extreme memory use when loading in a lot of data
  429. Making a new tarball
  430. Automatically fudging query results?
  431. dynamic parameters in procedure
  432. enforce unique rows?
  433. feature idea – automatic update tracking using date fields – feedback pls
  434. initdb fails
  435. Problem with public schema
  436. Index not being used properly
  437. Unix timestamp , unix timestamp with microseconds ?
  438. Data change logs
  439. Web DB Management tool
  440. postmaster shutdown failed
  441. Unix timestamp , unix timestamp with microseconds
  442. reading vacuum verbosity
  443. Am I locking more than I need to?
  444. can't get async mode to deliver small batches of rows
  445. Problem converting interval to seconds
  446. Windows CE (.NET) data provider for PostgreSQL
  447. PG_HBA.conf still keeps complaining. I've done all I could imagine.
  448. problem with sorting using 'ORDER BY' when character fieldis filled with numerical values
  449. backend terminated abnormally
  450. problem with sorting using 'ORDER BY' when character field is filledwith numerical values
  451. Porting SQL Server 2000 database to PostgreSQL
  452. psql -E option is not working in 7.4.2 like 7.3.4
  453. Unable to run testlibpq.c program
  454. Settings for autovacuum for batch uploading of data?
  455. list of open connections / terminate a connection?
  456. relocation error
  457. asynchronous query example in C?
  458. Dblink question
  459. grant wildcard
  460. Unresponsive vacuum process
  461. Does INSERT inserts always at the end ?
  462. pg_temp_N temp schema buildup
  463. Is using cross-version pg_autovacuum possible/safe?
  464. pg_autovacuum seems to be a neat freak and cleans way too much
  465. Restricted query
  466. Function - sequence - cast
  467. left outer join issue?
  468. Access to the DB
  469. Help! Error Compiling
  470. A problem with the IN clause
  471. will I need nested transactions ?
  472. serial autoincrement and related table
  473. type conversion date <-> timestamp
  474. Upgrade from 7.3.4 to 7.4.2 went wrong
  475. RTRIM always used with JDBC?
  476. table column information
  477. Interesting Unique Index Needed - Functional?
  478. filesystem option tuning
  479. Domains with constraints?
  480. one to many
  481. PgSQL 7.4.2 - NaN on Tru64 UNIX
  482. Column names and datatypes
  483. Identifying diskspace leakage
  484. slow query if add order by
  485. Scary behavior after power failure
  486. PostgreSQL error message:
  487. CAST truncates without warning
  488. setting local time without restarting server
  489. Inserting NULL value into date datatype
  490. After update complete set
  491. DBI remote connection problem
  492. referential integrity constraints not checked inside PL/pgSQL functions?
  493. Functionality in database or external langauge
  494. pg_xlog becomes extremely large during CREATE INDEX
  495. PGSTATBUFF: Warning - receive buffer full
  496. Profiling PostgreSQL
  497. Maximum Number Notifications
  498. Confusion about inheritance -- NEVER MIND
  499. Confusion about inheritance
  500. dbmirror
  501. Need a hardware optimization pointer
  502. Washintonians and Oregonians
  503. Type conversions and nulls
  504. Shared memory segment error
  505. LISTEN/NOTIFY with JDBC
  506. template1, createdb, schemas, and owners
  507. security question
  508. bytea
  509. How to move data from 1 database to another?
  510. JDBC problem
  511. Trying to compute the median
  512. query of database to get permitted users list
  513. domain type and array, is it possible?
  514. nested elseif woes
  515. ideal postgresql install
  516. Rows to columns query
  517. basic question (shared buffers vs. effective cache size)
  518. Very slow query
  519. Option required to dump bytea fields?
  520. Cancel query based on a timeout
  521. passing strings to functions
  522. full tuple count in cursor.
  523. alter owner on schema?
  524. error messages (not valid postgresql link resoucre)
  525. Slow network retrieves
  526. Join one of Canada's finest business men...
  527. graphical ERD tool
  528. Strengthing mail restriction rules in Postfix
  529. pg_restore -L option
  530. Storing a file hash as primary key
  531. any experience with multithreaded pg apps?
  532. My database hurts "ERROR: duplicate key violates unique constraint"
  533. How can I do conditional 'drop table' in Postgres
  534. Trigger function to know which fields are being updated
  535. Removing OIDs without recreate
  536. Interpreting vacuum verbosity
  537. creation permissions when moving from 7.2 -> 7.4
  538. regexp replace?
  539. Copy entire row on elete
  540. 7.2 or 7.4 for critical data?
  541. New DBManager 2.3.0 is Released
  542. Changing the size of a varchar field
  543. select for update & lock contention
  544. error code with psql
  545. error code with psql
  546. Procedure calling syntax with complex types
  547. Procedure calling syntax with complex types
  548. CHECK constraints and optimizations
  549. CHECK constraints and optimizations
  550. Error linking libpq into client program