View Full Version : postgresql answers


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

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