View Full Version : postgresql answers


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

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