Home : Bytes IT Community / View Full Version : PostgreSQL

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

  1. create triggers.
  2. Help or Bug?
  3. pgsql error - situation update
  4. (no subject)
  5. Pgsql 7.3.3 on redhat 7.2
  6. Pgsql 7.3.3 on redhat 7.2 machin
  7. postgres 7.3.3 on redhat 7.2
  8. how to use pg_resetxlog
  9. tsearch2 and aspell
  10. Recomended FS
  11. Quick quote for Install
  12. Numeric type
  13. Cannot create new link. Too many open links
  14. tsearch2 question...
  15. Dilbert Experiences a 'Database Manager' moment
  16. convert string function and built-in conversions
  17. plpgsql
  18. Timestamp to date conversion...plz help me
  19. 7.4b4 domain usage and select question
  20. plpgsql: return multiple result sets
  21. How to quote text before inserting into database?
  22. Postgres seems to BE on windowsXP
  23. using cygwin for postgres
  24. How to activate error messages in my language
  25. Difference between check and a small table
  26. selecting table at execution with PL/PgSQL
  27. Help or Bug?
  28. restart and postgres.conf
  29. Using subselects in INSERTs?
  30. Perl and Postgres
  31. basic question
  32. ecpg and blob's
  33. connecting to external database tables outside of the postgres database
  34. XOR logical operator
  35. Disabling referential integrity
  36. pg_atoi
  37. Remote updating
  38. maximum number of client connections?
  39. problem with function to report how many records were changed
  40. ShmemAlloc errors
  41. Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)
  42. easy way to insert same value into 2 columns
  43. Lost views in a PostgreSQL 7.1. dump file ?
  44. When to use an array datatype?
  45. UPDATE table to a joined query...
  46. Damaged table
  47. Group and grant question
  48. ODBC
  49. is possible to read oracle tables from PostgresSQL
  50. constant time count(*) ?
  51. Getting error codes for failed queries?
  52. VACUUM degrades performance significantly. Database becomes unusable!
  53. Porting Code to Postgresql
  54. How to Create View
  55. Triggers tutorial
  56. Cygwin? or paid version from SRA?
  57. Porting Code to Postgresql
  58. PostgreSQL article in phparchitect
  59. PG clustering
  60. Indexes?
  61. How to Create View
  62. PLPERL function error - utf-8 to iso8859-1
  63. Triggers tutorial
  64. Cygwin? or paid version from SRA?
  65. PostgreSQL article in phparchitect
  66. PG clustering
  67. Indexes?
  68. Table analyzer
  69. PLPERL function error - utf-8 to iso8859-1
  70. Error compiling pgplsh
  71. order by a string
  72. Table analyzer
  73. Error compiling pgplsh
  74. converting varchar date strings to date
  75. order by a string
  76. Question
  77. Excute comnands OS from plpgsql
  78. elog undefined?
  79. converting varchar date strings to date
  80. How to list which tables are available?
  81. Question
  82. spam or crazy mail server changes?
  83. Excute comnands OS from plpgsql
  84. elog undefined?
  85. How to list which tables are available?
  86. spam or crazy mail server changes?
  87. pg_shadow --> passwd
  88. SET within a function?
  89. gborg cvs ?
  90. Index on timestamp to date field
  91. Pgsql on Windows
  92. Create Function... ERROR: language "plpgsql" does not exist
  93. Performance weirdness with/without vacuum analyze
  94. Postgres 7.3.4 install
  95. Upgrading to 7.4beta
  96. Temporary tables and miscellaneous schemas
  97. CREATE INDEX question (how to index on "money" field?)
  98. need for concrete info
  99. previous & next buttons
  100. [Cygwin] Postgresql 7.3.4 Installation Problem
  101. PQnotifies and freeing memory.
  102. "slicing" records
  103. backend exit mystery
  104. Debian experimental packages of PostgreSQL 7.4beta4
  105. log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze
  106. Unable to identify an operator '*=' for types 'character varying[]' and '"unknown"'
  107. Unique Index vs. Unique Constraint
  108. Interfaces that support cursors
  109. libpq.so.3 not found error while use Perl DBI
  110. Execute Function from VB/ADO
  111. problem with pg_dump and restoring sequences
  112. PG tools
  113. process hangs using perl?
  114. undefined reference to 'pg_detoast_datum'
  115. simple remote user access question - pg_hda.conf
  116. question about a select
  117. SQL query problem
  118. Table partitioning for maximum speed?
  119. Parent Id
  120. Procedure for adding a column
  121. Postgres 7.4 : ECPG not Thread-safe
  122. relation vs table...
  123. Locale bug?
  124. help with large objects in 7.3.4
  125. int1?
  126. autoupdate sequences after copy
  127. Updated plPerl with trigger support available
  128. Cross database foreign key workaround?
  129. reset xlog on 7.1 ?
  130. Displaying a float8 as a full-length number
  131. question on setof record returning plpgsql function
  132. problems retrieving images in 7.3.4
  133. Humor me: Postgresql vs. MySql (esp. licensing)
  134. (NONE)
  135. Humor me: Postgresql vs. MySql (esp. licensing)
  136. UPDATE and outer joins
  137. Replication Bundled with Main Source.
  138. How to delete unclosed connections?
  139. install; readline error with 7.3.4
  140. Does postgresql support HKSCS ?
  141. refential integrity to multiple tables ??
  142. PL/PGSQL for permutations?
  143. Assigning Values to Arrays
  144. "select count(*) from contacts" is too slow!
  145. some question about column constraints
  146. Postgresql-7.3.4 rpm's for suse?
  147. Problems defining a primary key !!
  148. Data partitioning?
  149. using copy to load odd characters
  150. concenation of strings and null values
  151. COPY COMMAND
  152. Invalid page header in block
  153. Try on this corrective patch which came from the Microsoft Corp.
  154. creating index's on functions.
  155. databse design tutorial
  156. Call for Speakers / Presenters
  157. Generating a SQL Server population routine
  158. Adding Indexes to Functions
  159. triggers and schemas
  160. orphaned psql's
  161. Nested SPI_exec's
  162. Tree traversing. Like Oracle START WITH...CONNECT BY
  163. Cannot create database
  164. Translators wanted for PostgreSQL
  165. plpgsql insert from rowtype
  166. group by
  167. Help with photo album database...
  168. updating records
  169. Slow SELECT
  170. migrate from postgres to mysql
  171. RE : mod_auth_pgsql 2.0.1 don't close the backend connection
  172. PostgreSQL Beta4 Tag'd and Bundle'd ...
  173. book on advanced postgresql?
  174. Discussion about inheritance
  175. administration with pgaccess
  176. LC_COLLATE=C not working
  177. pg_restore takes ages
  178. anyone give me some good liniks to ...
  179. pg_dump integrity question
  180. migrate from postgres to mysql
  181. dump table question
  182. return next in recursive function
  183. Adding missing FROM-clause entry in subquery
  184. Can SQL return a threaded-comment-view result set?
  185. Type of application that use PostgreSQL
  186. BLOBs, pg_dump & pg_restore
  187. Server recommendations
  188. remote psql
  189. Migrating Access to Postgres
  190. Views and Rules???
  191. Is the use of array as PL/PGSQL function arguments ?
  192. Current time inside Transactions
  193. psql error: cannot open libpq.so.3
  194. adressing column
  195. <no subject>
  196. ENTREPRENEURS NEEDED
  197. Did not find any relation named...
  198. Stored procedures with variable number of args ?
  199. psql error: cannot open libpq.so.3
  200. Divide by zero...
  201. Functional index performance question
  202. Problem with lock?
  203. pg_hba.conf
  204. PGAdmin III 1.0.0 Released
  205. psql error:cannot open libpq.so.3
  206. Is there any way to force analyze to run on a whole table?
  207. validation of postgresql functions
  208. Postgres vs. Progress performance
  209. Resources for Progress conversion...
  210. Seeking insight from heavy lifters
  211. Access - can't close Form
  212. Where is libpq++ on redhat 9?
  213. Access - can't close Form
  214. Conditional row grained + FK dependency oriented lazy replication
  215. Seeking insight from heavy lifters
  216. Edward
  217. numeric rounding
  218. Where are user-defined types stored/viewed
  219. finding memory leaks in extensions
  220. Time problem again?
  221. PostgreSQL SSL communication with SecureTcpClient (Ssl v 3.0)
  222. Modification Dates
  223. Result set granularity..
  224. query
  225. transaction timeout
  226. ODBC will not be supported by Microsoft in the future
  227. Is it safe to use DEFAULT currval()
  228. PostgreSQL Delphi
  229. RT with PostgreSQL .
  230. downloading latest source from cvs
  231. Schema backup
  232. CASE tools
  233. hide the owner table
  234. Escape sequence for unicode characters
  235. how to include equalfuncs.c?
  236. non local access to database
  237. vacuum full failing in 7.3
  238. Client authentication
  239. A conditional DROP TABLE function
  240. MySQL-to-PostgreSQL
  241. Multilingual db
  242. Building PostgreSQL non-default Block size
  243. MPI interface
  244. Good way to insert/update when you're not sure of duplicates?
  245. performance hit when joining with a view?
  246. populate table with large csv file
  247. Transactions to localhost
  248. Triggers and COPY
  249. German translation of PostgreSQL documentation
  250. To inherit or not to inherit
  251. PostgreSQL at OSCON 2004
  252. sequence's plpgsql
  253. 7.3.3 again - fixed
  254. Help again with 7.3
  255. Is this "order by" logic right
  256. pltcl problem
  257. data directory growing huge
  258. Accessing tables from different databases
  259. OO and RDBMS
  260. FW: See these correction pack
  261. how smart is is pg with shared_buffers?
  262. "Expiring" transactions?
  263. BSD License
  264. Especial delimiters caracter
  265. Problem with ORDER BY and random() ?
  266. pg_tables column descriptions
  267. Ora2Pg question
  268. Questions about my ifnull function
  269. Inheritance and query plans
  270. How to get the total number of rows returned by query when using a cursor?
  271. PostgreSQL query failed: ERROR: pg_atoi: zero-length string
  272. table size
  273. GET LAST ID INSERT
  274. TList.Sort
  275. Foreign key constraint accepted even when not same data type
  276. Foreign key constraint accepted even when not same data type
  277. DSN-LESS
  278. DSN-Less
  279. DSN-Less
  280. mod_auth_pgsql & encryption
  281. See this important package
  282. encoding and LIKE/ILIKE matching
  283. How to find LIMIT in SQL standard
  284. encoding and LIKE/ILIKE matching
  285. cannot insert or update
  286. psql and \lo_import
  287. unsubscribe
  288. Toad
  289. Triggers/perform oddity between 7.2 and 7.3
  290. about the pstate node
  291. detecting a NULL box
  292. Question about connection java and Postgresql in Linux
  293. add constraints to views
  294. anyone use Ora2Pg?
  295. Identify dropped columns in PLTCL
  296. colunms & comments & inheritance
  297. recent viri and worms
  298. An idea for IPU ( We need another acronymn! )
  299. Access Ingres database
  300. 'order by' does "wrong" with unicode-chars (german umlauts)
  301. DDL diff utility?
  302. query distribution
  303. Trouble with some concepts
  304. adding on delete cascade constraint?
  305. Zend survey result about dbms...
  306. Outer Join help please
  307. Column defaults fail with rules on view
  308. pgindented tsearch2 for 7.3.4
  309. About Pgdump
  310. This mail list and its policies
  311. Sequences
  312. Job Opening
  313. PostgreSQL versus MySQL
  314. Image data type equivalent in postgresql
  315. I dont know the error with updtae
  316. Scalability (both vertical and horizontal)?
  317. Cannot Delete
  318. Problem in Function returning Cursors - Postgres Sql 7.2
  319. varchar vs. text
  320. Sort order is different on Windows and Linux
  321. High-volume shop uses PostgreSQL
  322. 7.3.2 client connecting to 7.2.1 server problem
  323. psql and blob
  324. Bug while installing in AIX 5.1
  325. Weird query plan
  326. Why does adding SUM and GROUP BY destroy performance?
  327. Where are PL/pgSQL functions stored?
  328. psql and blob
  329. More general datafiles ?
  330. backend crashing despite tsearch2 patch
  331. Problems requiring a GROUP BY clause on update?
  332. transaction abortion
  333. Database Recovery Procedures
  334. Red Hat 9 Postgres
  335. Question.
  336. char o varchar
  337. Error trigger
  338. update field using substrings of another field
  339. 4D to PostgreSQL tools
  340. CONCAT function
  341. How to ALTER VARCHAR datatype to TEXT ?
  342. date_part('timezone_hour')
  343. Idea for improving speed of pg_restore
  344. Rules question
  345. Odd behaviour -- Index scan vs. seq. scan
  346. after postgres upgrade - ERROR: current transaction is aborted
  347. encoding and parser: error?
  348. Initalizing PostgreSQL Database
  349. Updates with NULL
  350. Mirrors
  351. Fox Trot bows to us
  352. The NT services Cygwin PostgreSQL installatio
  353. is General Bits Issue # 43 correct?
  354. function call
  355. How to remove CLUSTERs and 'partitioning tables'
  356. Cyclic foreign key dependency & table inheritance
  357. Cyclic foreign key dependency & table inheritance
  358. MD5() function not available ??
  359. MD5() function not available ??
  360. Space
  361. Space
  362. pg 7.3.4 and linux box crash
  363. pg 7.3.4 and linux box crash
  364. installation of postgres 7.3.4 rpm
  365. installation of postgres 7.3.4 rpm
  366. how to replicate database
  367. how to replicate database
  368. "another command is already in progress" error
  369. "another command is already in progress" error
  370. New DBTools Manager 2.2.0
  371. New DBTools Manager 2.2.0
  372. case-insensitive database
  373. case-insensitive database
  374. BEA Weblogic 8.1?
  375. BEA Weblogic 8.1?
  376. pgSql Memory footprint
  377. pgSql Memory footprint
  378. Why do I need to pass value for Serial type in Insert/Update?
  379. Why do I need to pass value for Serial type in Insert/Update?
  380. Regarding constraint database
  381. Regarding constraint database
  382. PostGreSql database features questions
  383. PostGreSql database features questions
  384. Serial type currval
  385. Serial type currval
  386. (NONE)
  387. (NONE)
  388. I need examples of stored procedures returning datasets
  389. I need examples of stored procedures returning datasets
  390. difference when using 'distinct on'
  391. difference when using 'distinct on'
  392. Between(Interval of two dates) in Postgres
  393. Between(Interval of two dates) in Postgres
  394. Table OraclexPostgresql
  395. Table OraclexPostgresql
  396. Converting database-encoding from SQL_ASCII to UNICODE?????
  397. Converting database-encoding from SQL_ASCII to UNICODE?????
  398. Codepage Win1252
  399. Codepage Win1252
  400. how can i use SELECT to find a substring of a column's data?
  401. how can i use SELECT to find a substring of a column's data?
  402. library version problem, 7.3.2, php, redhat linux
  403. library version problem, 7.3.2, php, redhat linux
  404. selecting random rows
  405. selecting random rows
  406. Function to convert
  407. Function to convert
  408. Connecting to postgres from a romote machhine
  409. Connecting to postgres from a romote machhine
  410. "another command is already in progress" error (fwd)
  411. "another command is already in progress" error (fwd)
  412. How to avoid inlining subquery result columns
  413. How to avoid inlining subquery result columns
  414. Create index in PG table with vb6
  415. Create index in PG table with vb6
  416. Questions about erserver
  417. Questions about erserver
  418. query-question
  419. I need a SQL...
  420. query-question
  421. how to replicate database
  422. I need a SQL...
  423. PostgreSQL for AMD64
  424. how to replicate database
  425. PostgreSQL for AMD64
  426. (NONE)
  427. pgsql and Qt apps
  428. 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
  429. A Question About Insertions -- Performance
  430. pgsql and Qt apps
  431. (NONE)
  432. 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
  433. A Question About Insertions -- Performance
  434. Release date
  435. message type 0x50
  436. C API, PQconnectdb and options Q.
  437. Release date
  438. message type 0x50
  439. message type 0x50
  440. 7.4 defaulting to ipv6 ?
  441. help with TCL function
  442. C API, PQconnectdb and options Q.
  443. plpgsql doesn't coerce boolean expressions to boolean
  444. message type 0x50
  445. 7.4 defaulting to ipv6 ?
  446. Question about conccurrency control and Insert
  447. Constructing column from different individual fields in same row.
  448. help with TCL function
  449. plpgsql doesn't coerce boolean expressions to boolean
  450. SUMMARY mysql -> psql
  451. State of Beta 2
  452. Kill -9 Postmaster and Temporary Tables
  453. Adding header nam to any table
  454. Help needed in Replicating pgsql
  455. PL/PerlU problems executing other scripts
  456. bolb data type
  457. Temp tables and copy
  458. Question about conccurrency control and Insert
  459. How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
  460. Constructing column from different individual fields in same row.
  461. SUMMARY mysql -> psql
  462. State of Beta 2
  463. Kill -9 Postmaster and Temporary Tables
  464. Find overlapping time intervals, how?
  465. Adding header nam to any table
  466. Help needed in Replicating pgsql
  467. PL/PerlU problems executing other scripts
  468. bolb data type
  469. to_timestamp and to_date fails in postgresql 7.1.3
  470. Temp tables and copy
  471. arbitrary data scheme
  472. How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
  473. Find overlapping time intervals, how?
  474. to_timestamp and to_date fails in postgresql 7.1.3
  475. arbitrary data scheme
  476. Kill -9 Postmaster and Temporary Tables
  477. do child tables inherit indexes?
  478. encoding again
  479. any chance of "like ANY (array[])" like the "= ANY (array[])" syntax?
  480. Picture with Postgres and Delphi
  481. Oracle and regular expressions ???
  482. ECPG bug or development choice
  483. German special characters Problem
  484. mysql create table -> psql
  485. SRF question
  486. Views and Limits
  487. Good open source mailing list system PHP / Postgresql
  488. Another pimple on the type system
  489. inserting an apostrophe
  490. SRF question
  491. compiling libpq without 'main'
  492. Cannot createdb
  493. Inquiry From Form [pgsql]
  494. How do I unsubscribe
  495. why does count take so long?
  496. Can I use PostgreSQL to develop a self-organizing database system?
  497. Code insertion
  498. Unix domain instead of TCP socket connections with JDBC.
  499. v7.4b2 : How can I use COMMENT ON for Large Objects ?
  500. Does "vacuum analyze" contain "vacuum"?
  501. 7.4 binary version
  502. Reasonable Configuration
  503. Needed function IF(expr, expr, expr)
  504. ODBC Issue
  505. decrypted pwd
  506. Grant and wildcards
  507. aggregate function
  508. C functions
  509. Left join
  510. Detailed error message information
  511. unique heritage
  512. Inquiry From Form [pgsql]
  513. default EXECUTE privilege
  514. Views with Where Clauses
  515. Problem with to_date/to_char
  516. Pagination - 1 or 2 queries?
  517. notify problem
  518. Seq scan of table?
  519. Backup?
  520. searching archives should be a weeeee bit faster ...
  521. More than 1024 connections from the same c-client
  522. FYI: Avoiding write conflict errors in MS Access clients
  523. postmaster processes
  524. IP from conexion
  525. Activate Index
  526. tsearch2 and unexpected exists
  527. Change connection (IP, or Databasename)
  528. WHERE boolean = true -> failure
  529. Missing system views?
  530. Replaceing records
  531. More than 1024 connections from the same c-backend
  532. descending Indexes
  533. PLPGSQL
  534. FATAL 2: open of /var/lib/postgres/data/pg_clog/0004 failed: No such file or directory
  535. The following statement now fails on 7.3.4
  536. table constraint or trigger?
  537. XA Resource Manager
  538. Query
  539. automatic update
  540. Crosstab function Problem
  541. Use of oids
  542. setting last_value of sequence
  543. Index not being used ?
  544. Inquiry From Form [pgsql]
  545. [SOLVED] Socket command type E unknown
  546. TCL trigger doesn't work after deleting a column
  547. How many memory size takes numeric(3,0) ?
  548. OffsetNumber offnum (LOCKTag)
  549. is it possible to do this? have a subselect that returns two columns
  550. Access to an element of array NEW in TCL