Home : Bytes IT Community / View Full Version : PostgreSQL

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

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