View Full Version : postgresql answers


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

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