View Full Version : postgresql answers


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

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