View Full Version : postgresql answers


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

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