View Full Version : postgresql answers


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

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