View Full Version : postgresql answers


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

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