View Full Version : postgresql answers


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

  1. lost pg_xlog // recover database-structure without it?
  2. Keep history of modifications
  3. Keep history of modifications
  4. out of memory error
  5. out of memory error
  6. Can't compile a contrib util: dbsize (probably simply though)
  7. Can't compile a contrib util: dbsize (probably simply though)
  8. Opteron scaling with PostgreSQL
  9. Opteron scaling with PostgreSQL
  10. global temporary tables?
  11. global temporary tables?
  12. Returning rowsets/results from a function to another one in plpgsl.
  13. Returning rowsets/results from a function to another one in plpgsl.
  14. Trouble with locking tables - reg.
  15. Trouble with locking tables - reg.
  16. FK issue
  17. FK issue
  18. Transactions and insertion ordering
  19. Transactions and insertion ordering
  20. VACUUM FULL produce warnings
  21. VACUUM FULL produce warnings
  22. How to tell when postmaster is ready
  23. How to tell when postmaster is ready
  24. Postgresql vs. aggregates
  25. Postgresql vs. aggregates
  26. tablespaces and schemas
  27. tablespaces and schemas
  28. index with LIKE
  29. index with LIKE
  30. check constraint on char field
  31. check constraint on char field
  32. How to determine whether a view's column is indexed?
  33. How to determine whether a view's column is indexed?
  34. pg_dumpall and large objects
  35. pg_dumpall and large objects
  36. Another win for PostgreSQL
  37. Another win for PostgreSQL
  38. Help in finding the error
  39. Help in finding the error
  40. using regexp backreferences
  41. using regexp backreferences
  42. Prevent users from creating tables
  43. Prevent users from creating tables
  44. Multiple databases on seperate drives/file systems?
  45. Multiple databases on seperate drives/file systems?
  46. replication
  47. replication
  48. Index on points
  49. Index on points
  50. problem with inserting a generated seq no into not null field
  51. problem with inserting a generated seq no into not null field
  52. When to use postgreSQL , when to use other
  53. When to use postgreSQL , when to use other
  54. encrypted passwords
  55. encrypted passwords
  56. mailing list oddities
  57. mailing list oddities
  58. "security definer" not being set when function replaced
  59. "security definer" not being set when function replaced
  60. could not bind IPv4 socket: Address already in use
  61. could not bind IPv4 socket: Address already in use
  62. core dump
  63. core dump
  64. generic insert into table
  65. generic insert into table
  66. bug in 7.4.2, concern unicode and russian content of db
  67. bug in 7.4.2, concern unicode and russian content of db
  68. Identifying the 'current user' when using a connection pool
  69. Identifying the 'current user' when using a connection pool
  70. postgres on SuSE 9.1
  71. postgres on SuSE 9.1
  72. contents of pg_database vanished..
  73. contents of pg_database vanished..
  74. Index question
  75. Index question
  76. curius behavior of planner after analyze, (Pg7.5)
  77. curius behavior of planner after analyze, (Pg7.5)
  78. pg_dump, bytea, dump order questions
  79. pg_dump, bytea, dump order questions
  80. Tsearch case sensitive with dotted search terms.
  81. Tsearch case sensitive with dotted search terms.
  82. pg_dump and tsearch2
  83. pg_dump and tsearch2
  84. tsearch2 queries faster than expected
  85. tsearch2 queries faster than expected
  86. Need more speed for this query :)
  87. Need more speed for this query :)
  88. Dropping schemas and "illegal seek"
  89. Updating a unique constrant
  90. Dropping schemas and "illegal seek"
  91. Turn off "money" formatting?
  92. Updating a unique constrant
  93. Turn off "money" formatting?
  94. CREATE DATABASE on the heap with PostgreSQL?
  95. Changing from money...
  96. CREATE DATABASE on the heap with PostgreSQL?
  97. timestamp outside of bounds
  98. Changing from money...
  99. timestamp outside of bounds
  100. row access
  101. Concurrent access related issue.
  102. How to find out who is calling the function
  103. row access
  104. Perl DBI error string question pg7.4.2
  105. Concurrent access related issue.
  106. How to find out who is calling the function
  107. Aggregate C function accumulating a text array
  108. Queries slow from within plpgsql
  109. Unable to use NNTP server
  110. Perl DBI error string question pg7.4.2
  111. Aggregate C function accumulating a text array
  112. Queries slow from within plpgsql
  113. Unable to use NNTP server
  114. dynamic function question
  115. Backup and Restore of PostgreSQL
  116. ERROR: Invalid UNICODE character sequence found (0xed5c30)
  117. pg_xlog
  118. pg_class could not be found
  119. The pgreplication project
  120. Insert increment based on a group by?
  121. Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'
  122. TimeOf(Subselects|Joins)FromLargeTables?
  123. Who is managing the postgresql documentation?
  124. Ingres & PostgreSQL
  125. A "linking" Question
  126. again, invalid page header in block ...
  127. Page access pattern in query plan using index scan
  128. COPY error handling
  129. table content transfer from mysql to postgresql
  130. Timestamp precision and rounding
  131. zope, postgresql and idle connections
  132. JDBC: what exactly does nullsAreSortedHigh() return?
  133. Running Totals and stuff...
  134. Inet performance
  135. Building Thread-Safe on OS X
  136. interactive backend output
  137. Pg_dump error
  138. GRANT question
  139. statement-level statistics are disabled error (postgresql.conf)
  140. Creating a session variable in Postgres
  141. Dynamic SQL
  142. async problems?
  143. Securing a db app - RFC
  144. ORDER BY with plpgsql parameter
  145. Databases on separate filesystems
  146. How to identify which column in a table is the primary key
  147. More really old emails
  148. db design question
  149. after using pg_resetxlog, db lost
  150. Disappointing news
  151. Insert speed question
  152. PostgreSQL Tablespaces
  153. pg_dump question
  154. COPY FROM fails to trigger rules
  155. ODBC, ADO, Return Value from SP problem
  156. pg_dump and errors
  157. confused by superuser-definition
  158. Separating application from data
  159. Receiving three month old messages
  160. PostgreSQL Array & Java
  161. Large table search question
  162. Error handling in stored functions/procedures
  163. This is another testmail
  164. Trying to mail from my virtual network
  165. information schema
  166. Embedded SQL - Unable to connect to PostgreSQL Database
  167. locating postgresql lib and include files for SuSE 9.0 RPMS?
  168. Use arrays to store multilanguage texts
  169. postgresql anonymous cvs?
  170. Dump 7.1.3->7.4.2
  171. Use composite type for column data type
  172. turn WAL off.
  173. ERROR: date/time field value out of range: "28/05/2004 02:15:57"
  174. pg_dump and schema namespace notes
  175. What does error code PGSQL_TUPLES_OK (2) actually mean?
  176. Connecting to an External DB (repost)
  177. query results different after vacuum analyze? 7.4.0
  178. How do I unsubscribe?
  179. PostgreSQL Logs
  180. pg_restore quick question
  181. HOWTO: Integrating Posgresql queries into an event loop
  182. Database Size Limiting
  183. Howto handle views/Rules Privileges
  184. custom error messages/numbers
  185. statement level triggers in PostgreSQL , anybody??
  186. Naive schema questions
  187. connecting to an external postgresql db
  188. Connection log entries - random port number recorded
  189. One more time on ONE-TO-MANY
  190. Problem with sequences on a reload of a pg_dump file
  191. temas del comando COPY
  192. Postgresql Logging
  193. performance very slow
  194. Error: server closed the connection unexpectedely
  195. Casting hexadecimal to int
  196. insert/update
  197. planer don't use index. bad plan for where id = x or id in (select...)
  198. timestamps
  199. unix_socket
  200. Poatgresql database on more than one disk
  201. About table schema
  202. Iterating over an varchar array?
  203. restore from a pg_dumpall file
  204. md5 function available since ...?
  205. FW: Majordomo results: subscribe pgsql-general
  206. Abnormal Exit Quandary
  207. Error building PHP with PostgreSQL support
  208. Combining several rows
  209. PL/pgSQL: FOUND not set by EXECUTE?
  210. dump / restore questions
  211. pg_dump error
  212. DB design opinions - Foreign Key usage
  213. how many record versions
  214. restore from xlog
  215. psql -E is not working in 7.4.2 like 7.3.4
  216. could not open relation "pg_trigger_tgrelid_tgname_index"
  217. Schemaball v0.10
  218. extreme memory use when loading in a lot of data
  219. Making a new tarball
  220. Automatically fudging query results?
  221. dynamic parameters in procedure
  222. enforce unique rows?
  223. feature idea automatic update tracking using date fields feedback pls
  224. initdb fails
  225. Problem with public schema
  226. Index not being used properly
  227. Unix timestamp , unix timestamp with microseconds ?
  228. Data change logs
  229. Web DB Management tool
  230. postmaster shutdown failed
  231. Unix timestamp , unix timestamp with microseconds
  232. reading vacuum verbosity
  233. Am I locking more than I need to?
  234. can't get async mode to deliver small batches of rows
  235. Problem converting interval to seconds
  236. Windows CE (.NET) data provider for PostgreSQL
  237. PG_HBA.conf still keeps complaining. I've done all I could imagine.
  238. problem with sorting using 'ORDER BY' when character fieldis filled with numerical values
  239. backend terminated abnormally
  240. problem with sorting using 'ORDER BY' when character field is filledwith numerical values
  241. Porting SQL Server 2000 database to PostgreSQL
  242. psql -E option is not working in 7.4.2 like 7.3.4
  243. Unable to run testlibpq.c program
  244. Settings for autovacuum for batch uploading of data?
  245. list of open connections / terminate a connection?
  246. relocation error
  247. asynchronous query example in C?
  248. Dblink question
  249. Unresponsive vacuum process
  250. grant wildcard
  251. Does INSERT inserts always at the end ?
  252. pg_temp_N temp schema buildup
  253. Is using cross-version pg_autovacuum possible/safe?
  254. pg_autovacuum seems to be a neat freak and cleans way too much
  255. Restricted query
  256. Function - sequence - cast
  257. left outer join issue?
  258. Access to the DB
  259. Help! Error Compiling
  260. A problem with the IN clause
  261. will I need nested transactions ?
  262. serial autoincrement and related table
  263. type conversion date <-> timestamp
  264. Upgrade from 7.3.4 to 7.4.2 went wrong
  265. RTRIM always used with JDBC?
  266. table column information
  267. Interesting Unique Index Needed - Functional?
  268. filesystem option tuning
  269. Domains with constraints?
  270. one to many
  271. PgSQL 7.4.2 - NaN on Tru64 UNIX
  272. Column names and datatypes
  273. Identifying diskspace leakage
  274. slow query if add order by
  275. Scary behavior after power failure
  276. PostgreSQL error message:
  277. CAST truncates without warning
  278. setting local time without restarting server
  279. Inserting NULL value into date datatype
  280. After update complete set
  281. DBI remote connection problem
  282. referential integrity constraints not checked inside PL/pgSQL functions?
  283. Functionality in database or external langauge
  284. pg_xlog becomes extremely large during CREATE INDEX
  285. PGSTATBUFF: Warning - receive buffer full
  286. Profiling PostgreSQL
  287. Maximum Number Notifications
  288. Confusion about inheritance -- NEVER MIND
  289. Confusion about inheritance
  290. dbmirror
  291. Need a hardware optimization pointer
  292. Washintonians and Oregonians
  293. Type conversions and nulls
  294. Shared memory segment error
  295. LISTEN/NOTIFY with JDBC
  296. template1, createdb, schemas, and owners
  297. security question
  298. bytea
  299. How to move data from 1 database to another?
  300. JDBC problem
  301. Trying to compute the median
  302. query of database to get permitted users list
  303. domain type and array, is it possible?
  304. nested elseif woes
  305. ideal postgresql install
  306. Rows to columns query
  307. basic question (shared buffers vs. effective cache size)
  308. Very slow query
  309. Option required to dump bytea fields?
  310. Cancel query based on a timeout
  311. passing strings to functions
  312. full tuple count in cursor.
  313. error messages (not valid postgresql link resoucre)
  314. alter owner on schema?
  315. Slow network retrieves
  316. Join one of Canada's finest business men...
  317. graphical ERD tool
  318. Strengthing mail restriction rules in Postfix
  319. pg_restore -L option
  320. Storing a file hash as primary key
  321. any experience with multithreaded pg apps?
  322. My database hurts "ERROR: duplicate key violates unique constraint"
  323. How can I do conditional 'drop table' in Postgres
  324. Trigger function to know which fields are being updated
  325. Removing OIDs without recreate
  326. Interpreting vacuum verbosity
  327. creation permissions when moving from 7.2 -> 7.4
  328. regexp replace?
  329. Copy entire row on elete
  330. 7.2 or 7.4 for critical data?
  331. New DBManager 2.3.0 is Released
  332. Changing the size of a varchar field
  333. select for update & lock contention
  334. error code with psql
  335. error code with psql
  336. Procedure calling syntax with complex types
  337. Procedure calling syntax with complex types
  338. CHECK constraints and optimizations
  339. CHECK constraints and optimizations
  340. Error linking libpq into client program
  341. Error linking libpq into client program
  342. Error linking libpq into client program
  343. Error linking libpq into client program
  344. sql standard: \' or ''
  345. sql standard: \' or ''
  346. Listing databases
  347. Listing databases
  348. question regarding cursors in plpgsql, declare and bound params (v3 protocol)
  349. question regarding cursors in plpgsql, declare and bound params (v3 protocol)
  350. list types
  351. list types
  352. Fw: set autocommit TO FALSE on postgres 7.4
  353. Fw: set autocommit TO FALSE on postgres 7.4
  354. help me
  355. help me
  356. example database setup
  357. example database setup
  358. postgres mirroring (real-time)
  359. postgres mirroring (real-time)
  360. vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
  361. vacuumdb is failing with NUMBER OF INDEX TUPLES NOT THE SAME AS HEAP
  362. plpgsql question
  363. plpgsql question
  364. Is Linux 2.6.5 kernel good enough for production?
  365. Is Linux 2.6.5 kernel good enough for production?
  366. How to abort psql when backtick (shell) commands return non-zero?
  367. How to abort psql when backtick (shell) commands return non-zero?
  368. FYI, foxpro to postgresql conversion scripts
  369. FYI, foxpro to postgresql conversion scripts
  370. Embedded SQL inherently faster than others?
  371. Embedded SQL inherently faster than others?
  372. Variable in PostgreSQL 7.4.x
  373. Variable in PostgreSQL 7.4.x
  374. Postgres to oracle data migration
  375. Postgres to oracle data migration
  376. [Fwd: help building datetime from varchars]
  377. [Fwd: help building datetime from varchars]
  378. interval output format available that removes ambiguity ?
  379. interval output format available that removes ambiguity ?
  380. Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird
  381. Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird
  382. create synopsis wrong ?
  383. create synopsis wrong ?
  384. pgsql documentation error ?
  385. pgsql documentation error ?
  386. Cache lookup failure for pg_restore?
  387. Cache lookup failure for pg_restore?
  388. Parenthesis in Queries
  389. Parenthesis in Queries
  390. wait_seconds in pg_ctl
  391. wait_seconds in pg_ctl
  392. insert through function only
  393. insert through function only
  394. GRANT TEMPORARY ON DATABASE to Public
  395. GRANT TEMPORARY ON DATABASE to Public
  396. C Functions, datatypes
  397. C Functions, datatypes
  398. XID Data Types
  399. XID Data Types
  400. Per-session data?
  401. Per-session data?
  402. pdx pug or pug domain owner
  403. pdx pug or pug domain owner
  404. set autocommit TO FALSE on postgres 7.4
  405. set autocommit TO FALSE on postgres 7.4
  406. Constrint Name Length...
  407. Constrint Name Length...
  408. is this valid
  409. is this valid
  410. unattended backupscript not working with 7.4.2, works in 7.1
  411. unattended backupscript not working with 7.4.2, works in 7.1
  412. Anyone interested in a Pittsburgh-area Postgres users' group?
  413. Anyone interested in a Pittsburgh-area Postgres users' group?
  414. Tracking structural changes from psql
  415. Tracking structural changes from psql
  416. bad characters in database
  417. bad characters in database
  418. users rights per table
  419. users rights per table
  420. Vacuumdb Errors --Any ideas?
  421. Vacuumdb Errors --Any ideas?
  422. cionnected users to server
  423. cionnected users to server
  424. CLUSTER not working
  425. CLUSTER not working
  426. pgsql folder and its contents
  427. pgsql folder and its contents
  428. One or Both Foregin Keys
  429. One or Both Foregin Keys
  430. "out of memory" error
  431. "out of memory" error
  432. JDBC caching plpgsql function errors?
  433. JDBC caching plpgsql function errors?
  434. synchronizing MS access and postgresql tables
  435. synchronizing MS access and postgresql tables
  436. hugetlb feature linux 2.6 kernel
  437. hugetlb feature linux 2.6 kernel
  438. Calls to find Users and databases open...
  439. Calls to find Users and databases open...
  440. Check a value in array
  441. Check a value in array
  442. TCP only listening on localhost???
  443. TCP only listening on localhost???
  444. Plpgsql problem passing ROWTYPE to function
  445. Plpgsql problem passing ROWTYPE to function
  446. "Idle in Transaction" and hung connections
  447. "Idle in Transaction" and hung connections
  448. Timestamp problems...wrong weeks.
  449. Timestamp problems...wrong weeks.
  450. Follow-up to original post, more information:
  451. Follow-up to original post, more information:
  452. trying to restore after a server failure...need some help
  453. trying to restore after a server failure...need some help
  454. Unable to use index?
  455. Unable to use index?
  456. Performance problem with correlated sub-query
  457. Performance problem with correlated sub-query
  458. postgresql web problems?
  459. postgresql web problems?
  460. Postgre and Web Request
  461. Postgre and Web Request
  462. Mixed Case column names (php 4.3.5 & pg 7.4.2)
  463. Mixed Case column names (php 4.3.5 & pg 7.4.2)
  464. docs search not working?
  465. docs search not working?
  466. Calling a function that returns a cursor using libpq
  467. Calling a function that returns a cursor using libpq
  468. Optimizer choosing smaller index instead of right one
  469. Optimizer choosing smaller index instead of right one
  470. error while CLUSTERing!
  471. error while CLUSTERing!
  472. Updates not atomic with respect to indexes
  473. Updates not atomic with respect to indexes
  474. locking question
  475. locking question
  476. Cannot open relation pg_cast_source_target_index
  477. Cannot open relation pg_cast_source_target_index
  478. WAL details
  479. WAL details
  480. BLOB help needed...
  481. BLOB help needed...
  482. Problem installing postgresql 7.3.6 on Redhat 7.3
  483. Problem installing postgresql 7.3.6 on Redhat 7.3
  484. composite type and assignment in plpgsql
  485. composite type and assignment in plpgsql
  486. Temp table problem.
  487. Temp table problem.
  488. questions on rules
  489. questions on rules
  490. Help on "unexpected EOF..client reset by peer" errors
  491. Help on "unexpected EOF..client reset by peer" errors
  492. pg_restore problem
  493. pg_restore problem
  494. Question
  495. Question
  496. loading data into postgresql became slow after i used VACUUME command.
  497. loading data into postgresql became slow after i used VACUUME command.
  498. List Removal
  499. List Removal
  500. Postgres alongside MS SQL Server
  501. Postgres alongside MS SQL Server
  502. shadowing (like IB/Firebird)
  503. shadowing (like IB/Firebird)
  504. Arbitrary precision modulo operation
  505. Arbitrary precision modulo operation
  506. Restart increment to 0 each year = re-invent the sequences mecanism?
  507. Restart increment to 0 each year = re-invent the sequences mecanism?
  508. Migrating Fox (dbf) to PostgreSQL
  509. Migrating Fox (dbf) to PostgreSQL
  510. PostgreSQL 7.4.2 initdb problem
  511. PostgreSQL 7.4.2 initdb problem
  512. target list evaluation wrt sequences
  513. target list evaluation wrt sequences
  514. Install plpython
  515. Install plpython
  516. Silent overflow
  517. Silent overflow
  518. Synchronize unicode data using copy or pg_dump
  519. Synchronize unicode data using copy or pg_dump
  520. Question about inserts
  521. Question about inserts
  522. Case insensitive search
  523. Case insensitive search
  524. New replication software pgpool available
  525. New replication software pgpool available
  526. Has anyone come up with a work-around for the capitalization of non C-locale letters?
  527. Has anyone come up with a work-around for the capitalization of non C-locale letters?
  528. pg_autovacuum startup script
  529. pg_autovacuum startup script
  530. Executing SQL which is stored in database
  531. Executing SQL which is stored in database
  532. Illegal characters in database names, table names, user names...
  533. Illegal characters in database names, table names, user names...
  534. Missing OID rant
  535. Missing OID rant
  536. Unicode + LC_COLLATE
  537. Unicode + LC_COLLATE
  538. What is wrong here?
  539. What is wrong here?
  540. Restoring a Databases that features tserach2
  541. Restoring a Databases that features tserach2
  542. FW: Postgres alongside MS SQL Server
  543. FW: Postgres alongside MS SQL Server
  544. postgresql idle
  545. postgresql idle
  546. Multiple DBs, One app, How to do relations?
  547. Multiple DBs, One app, How to do relations?
  548. Installation - SuSE 9.0
  549. Installation - SuSE 9.0
  550. ident authentication problem