View Full Version : postgresql answers

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