View Full Version : postgresql answers


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

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