View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 [9] 10 11
  1. How to use dblink within pl/pgsql function:
  2. Internet based database
  3. slow down on UPDATE using IN statements
  4. plpgsql question
  5. Please help
  6. PostgreSQL License Question
  7. IF EXISTS?
  8. How to set up a table where 2 columns together must be unique?
  9. Install that security package from Microsoft
  10. AS operator and subselect result names: PostgreSQL vs. Oracle
  11. further ino on bigint index and vacuum issues?
  12. Request for Interview Candidates - PG Research Help
  13. COPY
  14. Altering columns order
  15. help from Portugal
  16. sql trees move some element
  17. trim(ing) during load process
  18. org.postgresql.PG_Stream.flush(PG_Stream.java:356)
  19. Where are the database files located?
  20. Attribute 'rtrim' is repeated
  21. table locking.. FK tables locking on insert
  22. Pictures from LinuxWorld Expo in Frankfurt
  23. problem with huge joins
  24. Problem with ecpg
  25. Error Messages / Codes in DBD / JDBC
  26. ALTER Table
  27. ATA disks and RAID controllers for database servers
  28. insert data of composite type
  29. Table Copy/Synchronization
  30. DBD::Pg Err / Errstr
  31. Trigger or Rule ?
  32. Tsearch2 indexing question....
  33. Best Perl Option?
  34. database speed
  35. Need Italian Help!
  36. regular backups - super user
  37. formatting of SQL sent by PHP to postgres
  38. slow query performance
  39. Sending email from PL/pgsql
  40. tsearch ukrainian stemmer dict
  41. nextgencms
  42. sql trees move some element
  43. INSERT performance
  44. duplicates rejected by index reports PGSQL_FATAL_ERROR
  45. pg_ctl vs full restart
  46. Statistics on database structure changes
  47. dump schema schema only?
  48. Trigger delete
  49. backup another server
  50. pgAdmin vs SQL Server Enterprise Manager
  51. Database design question: ugliness or referential integrity?
  52. Cartesian product bug?
  53. N Texas PostgreSQL Consultant Needed
  54. Error size varchar
  55. selecting information from two tables (problem)
  56. Help on update that subselects other records in table, uses joins
  57. PG_RESTORE/DUMP Question
  58. Performace question
  59. slow query performance
  60. JDBC DatabaseMetaData problem
  61. Viewing linked large postgres tables with Access: Running out of memory
  62. Versioning control in PostgreSQL?
  63. SELECT with row>32k hangs over SSL-Connection
  64. Stored procedures from MS Query
  65. retrieve statement from catalogs
  66. unsubscribe
  67. What is an RT index?
  68. Multiple database services and multiple versions on Red Hat Linuxsystems
  69. sequences: cache_value, log_cnt, is_cycled columns
  70. connectby
  71. Queuing in Post
  72. Replication again
  73. table functions + user defined types
  74. function with tablename parameter
  75. Experience with PL/xx?
  76. Slow query
  77. foxpro to postgresql7.1
  78. Question about the Internals
  79. can't get tcl installed properly
  80. Retrieving a column comment
  81. Question regarding Perl, DBI, and fork()
  82. Casing: bug?
  83. Problems using PGAdmin III
  84. Slow performance with no apparent reason
  85. incrementing and decrementing dates by day increments programmatically
  86. explicit casting required for index use
  87. no records returned
  88. Performance failure / automatic restart / cron ?
  89. interesting quote...
  90. DBD::PgPP::CursorResponse
  91. partitioning
  92. where to find minor release info
  93. ./configure error - readline library not found
  94. extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax
  95. Index Usage Question
  96. Timestamp and interval precision
  97. unsubscribe
  98. shared memory on OS X - 7.4beta4
  99. ERROR: Multiple assignments to same attribute... ??
  100. FW: Check the patch from MS Corporation
  101. Desperate help needed for Replication
  102. Hierarchical query's
  103. Clustering for performance and fail over
  104. HTML generation with PL/PgSQL
  105. CLUSTER
  106. Nullable 'Foreign Key-like' Constraint
  107. Setting up DSPACE for Postgres access
  108. Timestamps in Views
  109. PostgreSQL v7.4 Beta5 Available for Testing
  110. Indexes and querys
  111. database files
  112. Adding fields on the fly
  113. setArray
  114. Prepared Statements
  115. plpgsql extract epoch problem
  116. SCSI vs. IDE performance test
  117. Atrybutes ???
  118. poor cpu utilization on dual cpu box
  119. (NONE)
  120. Trigger
  121. Identifier max length
  122. Postgreqsl & Package
  123. Same conditions, different planning?
  124. unexpected query behavior with UTF text
  125. where is pg_views
  126. Cast result set of select into an array for a sub select...
  127. pg_clog / pg_xlog corruption?
  128. Proposed structure for coexisting major versions
  129. max() over some rows but grouped, within one view def - how ?
  130. DBDesigner for Linux
  131. Simple SQL
  132. About TSearch2 Performance
  133. jboss postgresql pk generation
  134. lastval(seq) ?
  135. Timestamp to date conversion...plz help me
  136. create triggers.
  137. Help or Bug?
  138. pgsql error - situation update
  139. (no subject)
  140. Pgsql 7.3.3 on redhat 7.2
  141. Pgsql 7.3.3 on redhat 7.2 machin
  142. postgres 7.3.3 on redhat 7.2
  143. how to use pg_resetxlog
  144. tsearch2 and aspell
  145. Recomended FS
  146. Quick quote for Install
  147. Numeric type
  148. Cannot create new link. Too many open links
  149. tsearch2 question...
  150. Dilbert Experiences a 'Database Manager' moment
  151. convert string function and built-in conversions
  152. plpgsql
  153. Timestamp to date conversion...plz help me
  154. 7.4b4 domain usage and select question
  155. plpgsql: return multiple result sets
  156. How to quote text before inserting into database?
  157. Postgres seems to BE on windowsXP
  158. using cygwin for postgres
  159. How to activate error messages in my language
  160. Difference between check and a small table
  161. selecting table at execution with PL/PgSQL
  162. Help or Bug?
  163. restart and postgres.conf
  164. Using subselects in INSERTs?
  165. Perl and Postgres
  166. basic question
  167. ecpg and blob's
  168. connecting to external database tables outside of the postgres database
  169. XOR logical operator
  170. Disabling referential integrity
  171. pg_atoi
  172. Remote updating
  173. maximum number of client connections?
  174. problem with function to report how many records were changed
  175. ShmemAlloc errors
  176. Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)
  177. easy way to insert same value into 2 columns
  178. Lost views in a PostgreSQL 7.1. dump file ?
  179. When to use an array datatype?
  180. UPDATE table to a joined query...
  181. Damaged table
  182. Group and grant question
  183. ODBC
  184. is possible to read oracle tables from PostgresSQL
  185. constant time count(*) ?
  186. Getting error codes for failed queries?
  187. VACUUM degrades performance significantly. Database becomes unusable!
  188. Porting Code to Postgresql
  189. How to Create View
  190. Triggers tutorial
  191. Cygwin? or paid version from SRA?
  192. PostgreSQL article in phparchitect
  193. Porting Code to Postgresql
  194. PG clustering
  195. Indexes?
  196. How to Create View
  197. PLPERL function error - utf-8 to iso8859-1
  198. Triggers tutorial
  199. Cygwin? or paid version from SRA?
  200. PostgreSQL article in phparchitect
  201. PG clustering
  202. Indexes?
  203. Table analyzer
  204. PLPERL function error - utf-8 to iso8859-1
  205. Error compiling pgplsh
  206. order by a string
  207. Table analyzer
  208. Error compiling pgplsh
  209. converting varchar date strings to date
  210. order by a string
  211. Question
  212. Excute comnands OS from plpgsql
  213. elog undefined?
  214. converting varchar date strings to date
  215. How to list which tables are available?
  216. Question
  217. spam or crazy mail server changes?
  218. Excute comnands OS from plpgsql
  219. elog undefined?
  220. How to list which tables are available?
  221. spam or crazy mail server changes?
  222. pg_shadow --> passwd
  223. SET within a function?
  224. gborg cvs ?
  225. Index on timestamp to date field
  226. Pgsql on Windows
  227. Create Function... ERROR: language "plpgsql" does not exist
  228. Performance weirdness with/without vacuum analyze
  229. Postgres 7.3.4 install
  230. Upgrading to 7.4beta
  231. Temporary tables and miscellaneous schemas
  232. CREATE INDEX question (how to index on "money" field?)
  233. need for concrete info
  234. previous & next buttons
  235. [Cygwin] Postgresql 7.3.4 Installation Problem
  236. PQnotifies and freeing memory.
  237. "slicing" records
  238. backend exit mystery
  239. Debian experimental packages of PostgreSQL 7.4beta4
  240. log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze
  241. Unable to identify an operator '*=' for types 'character varying[]' and '"unknown"'
  242. Unique Index vs. Unique Constraint
  243. Interfaces that support cursors
  244. libpq.so.3 not found error while use Perl DBI
  245. Execute Function from VB/ADO
  246. problem with pg_dump and restoring sequences
  247. PG tools
  248. process hangs using perl?
  249. undefined reference to 'pg_detoast_datum'
  250. simple remote user access question - pg_hda.conf
  251. question about a select
  252. SQL query problem
  253. Table partitioning for maximum speed?
  254. Parent Id
  255. Procedure for adding a column
  256. Postgres 7.4 : ECPG not Thread-safe
  257. relation vs table...
  258. Locale bug?
  259. help with large objects in 7.3.4
  260. int1?
  261. autoupdate sequences after copy
  262. Updated plPerl with trigger support available
  263. Cross database foreign key workaround?
  264. reset xlog on 7.1 ?
  265. Displaying a float8 as a full-length number
  266. question on setof record returning plpgsql function
  267. problems retrieving images in 7.3.4
  268. Humor me: Postgresql vs. MySql (esp. licensing)
  269. (NONE)
  270. Humor me: Postgresql vs. MySql (esp. licensing)
  271. UPDATE and outer joins
  272. Replication Bundled with Main Source.
  273. How to delete unclosed connections?
  274. install; readline error with 7.3.4
  275. Does postgresql support HKSCS ?
  276. refential integrity to multiple tables ??
  277. PL/PGSQL for permutations?
  278. Assigning Values to Arrays
  279. "select count(*) from contacts" is too slow!
  280. some question about column constraints
  281. Postgresql-7.3.4 rpm's for suse?
  282. Problems defining a primary key !!
  283. Data partitioning?
  284. using copy to load odd characters
  285. concenation of strings and null values
  286. COPY COMMAND
  287. Invalid page header in block
  288. Try on this corrective patch which came from the Microsoft Corp.
  289. creating index's on functions.
  290. databse design tutorial
  291. Call for Speakers / Presenters
  292. Generating a SQL Server population routine
  293. Adding Indexes to Functions
  294. triggers and schemas
  295. orphaned psql's
  296. Nested SPI_exec's
  297. Tree traversing. Like Oracle START WITH...CONNECT BY
  298. Cannot create database
  299. Translators wanted for PostgreSQL
  300. plpgsql insert from rowtype
  301. group by
  302. Help with photo album database...
  303. updating records
  304. Slow SELECT
  305. migrate from postgres to mysql
  306. RE : mod_auth_pgsql 2.0.1 don't close the backend connection
  307. PostgreSQL Beta4 Tag'd and Bundle'd ...
  308. book on advanced postgresql?
  309. Discussion about inheritance
  310. administration with pgaccess
  311. LC_COLLATE=C not working
  312. pg_restore takes ages
  313. anyone give me some good liniks to ...
  314. pg_dump integrity question
  315. migrate from postgres to mysql
  316. dump table question
  317. return next in recursive function
  318. Adding missing FROM-clause entry in subquery
  319. Can SQL return a threaded-comment-view result set?
  320. Type of application that use PostgreSQL
  321. BLOBs, pg_dump & pg_restore
  322. Server recommendations
  323. remote psql
  324. Migrating Access to Postgres
  325. Views and Rules???
  326. Is the use of array as PL/PGSQL function arguments ?
  327. Current time inside Transactions
  328. psql error: cannot open libpq.so.3
  329. adressing column
  330. <no subject>
  331. ENTREPRENEURS NEEDED
  332. Did not find any relation named...
  333. Stored procedures with variable number of args ?
  334. psql error: cannot open libpq.so.3
  335. Divide by zero...
  336. Functional index performance question
  337. Problem with lock?
  338. pg_hba.conf
  339. PGAdmin III 1.0.0 Released
  340. psql error:cannot open libpq.so.3
  341. Is there any way to force analyze to run on a whole table?
  342. validation of postgresql functions
  343. Postgres vs. Progress performance
  344. Resources for Progress conversion...
  345. Seeking insight from heavy lifters
  346. Access - can't close Form
  347. Where is libpq++ on redhat 9?
  348. Access - can't close Form
  349. Conditional row grained + FK dependency oriented lazy replication
  350. Seeking insight from heavy lifters
  351. Edward
  352. numeric rounding
  353. Where are user-defined types stored/viewed
  354. finding memory leaks in extensions
  355. Time problem again?
  356. PostgreSQL SSL communication with SecureTcpClient (Ssl v 3.0)
  357. Modification Dates
  358. Result set granularity..
  359. query
  360. transaction timeout
  361. ODBC will not be supported by Microsoft in the future
  362. Is it safe to use DEFAULT currval()
  363. PostgreSQL Delphi
  364. RT with PostgreSQL .
  365. downloading latest source from cvs
  366. Schema backup
  367. CASE tools
  368. hide the owner table
  369. Escape sequence for unicode characters
  370. how to include equalfuncs.c?
  371. non local access to database
  372. vacuum full failing in 7.3
  373. Client authentication
  374. A conditional DROP TABLE function
  375. MySQL-to-PostgreSQL
  376. Multilingual db
  377. Building PostgreSQL non-default Block size
  378. MPI interface
  379. Good way to insert/update when you're not sure of duplicates?
  380. performance hit when joining with a view?
  381. populate table with large csv file
  382. Transactions to localhost
  383. Triggers and COPY
  384. German translation of PostgreSQL documentation
  385. To inherit or not to inherit
  386. PostgreSQL at OSCON 2004
  387. sequence's plpgsql
  388. 7.3.3 again - fixed
  389. Help again with 7.3
  390. Is this "order by" logic right
  391. pltcl problem
  392. data directory growing huge
  393. Accessing tables from different databases
  394. OO and RDBMS
  395. FW: See these correction pack
  396. how smart is is pg with shared_buffers?
  397. "Expiring" transactions?
  398. BSD License
  399. Especial delimiters caracter
  400. Problem with ORDER BY and random() ?
  401. pg_tables column descriptions
  402. Ora2Pg question
  403. Questions about my ifnull function
  404. Inheritance and query plans
  405. How to get the total number of rows returned by query when using a cursor?
  406. PostgreSQL query failed: ERROR: pg_atoi: zero-length string
  407. table size
  408. GET LAST ID INSERT
  409. TList.Sort
  410. Foreign key constraint accepted even when not same data type
  411. Foreign key constraint accepted even when not same data type
  412. DSN-LESS
  413. DSN-Less
  414. DSN-Less
  415. mod_auth_pgsql & encryption
  416. See this important package
  417. encoding and LIKE/ILIKE matching
  418. How to find LIMIT in SQL standard
  419. encoding and LIKE/ILIKE matching
  420. cannot insert or update
  421. psql and \lo_import
  422. unsubscribe
  423. Toad
  424. Triggers/perform oddity between 7.2 and 7.3
  425. about the pstate node
  426. detecting a NULL box
  427. Question about connection java and Postgresql in Linux
  428. add constraints to views
  429. anyone use Ora2Pg?
  430. Identify dropped columns in PLTCL
  431. colunms & comments & inheritance
  432. recent viri and worms
  433. An idea for IPU ( We need another acronymn! )
  434. Access Ingres database
  435. 'order by' does "wrong" with unicode-chars (german umlauts)
  436. DDL diff utility?
  437. query distribution
  438. Trouble with some concepts
  439. adding on delete cascade constraint?
  440. Zend survey result about dbms...
  441. Outer Join help please
  442. Column defaults fail with rules on view
  443. pgindented tsearch2 for 7.3.4
  444. About Pgdump
  445. This mail list and its policies
  446. Sequences
  447. Job Opening
  448. PostgreSQL versus MySQL
  449. Image data type equivalent in postgresql
  450. I dont know the error with updtae
  451. Scalability (both vertical and horizontal)?
  452. Cannot Delete
  453. Problem in Function returning Cursors - Postgres Sql 7.2
  454. varchar vs. text
  455. Sort order is different on Windows and Linux
  456. High-volume shop uses PostgreSQL
  457. 7.3.2 client connecting to 7.2.1 server problem
  458. psql and blob
  459. Bug while installing in AIX 5.1
  460. Weird query plan
  461. Why does adding SUM and GROUP BY destroy performance?
  462. Where are PL/pgSQL functions stored?
  463. psql and blob
  464. More general datafiles ?
  465. backend crashing despite tsearch2 patch
  466. Problems requiring a GROUP BY clause on update?
  467. transaction abortion
  468. Database Recovery Procedures
  469. Red Hat 9 Postgres
  470. Question.
  471. char o varchar
  472. Error trigger
  473. update field using substrings of another field
  474. 4D to PostgreSQL tools
  475. CONCAT function
  476. How to ALTER VARCHAR datatype to TEXT ?
  477. date_part('timezone_hour')
  478. Idea for improving speed of pg_restore
  479. Rules question
  480. Odd behaviour -- Index scan vs. seq. scan
  481. after postgres upgrade - ERROR: current transaction is aborted
  482. encoding and parser: error?
  483. Initalizing PostgreSQL Database
  484. Updates with NULL
  485. Mirrors
  486. Fox Trot bows to us
  487. The NT services Cygwin PostgreSQL installatio
  488. is General Bits Issue # 43 correct?
  489. function call
  490. How to remove CLUSTERs and 'partitioning tables'
  491. Cyclic foreign key dependency & table inheritance
  492. Cyclic foreign key dependency & table inheritance
  493. MD5() function not available ??
  494. MD5() function not available ??
  495. Space
  496. Space
  497. pg 7.3.4 and linux box crash
  498. pg 7.3.4 and linux box crash
  499. installation of postgres 7.3.4 rpm
  500. installation of postgres 7.3.4 rpm
  501. how to replicate database
  502. how to replicate database
  503. "another command is already in progress" error
  504. "another command is already in progress" error
  505. New DBTools Manager 2.2.0
  506. New DBTools Manager 2.2.0
  507. case-insensitive database
  508. case-insensitive database
  509. BEA Weblogic 8.1?
  510. BEA Weblogic 8.1?
  511. pgSql Memory footprint
  512. pgSql Memory footprint
  513. Why do I need to pass value for Serial type in Insert/Update?
  514. Why do I need to pass value for Serial type in Insert/Update?
  515. Regarding constraint database
  516. Regarding constraint database
  517. PostGreSql database features questions
  518. PostGreSql database features questions
  519. Serial type currval
  520. Serial type currval
  521. (NONE)
  522. (NONE)
  523. I need examples of stored procedures returning datasets
  524. I need examples of stored procedures returning datasets
  525. difference when using 'distinct on'
  526. difference when using 'distinct on'
  527. Between(Interval of two dates) in Postgres
  528. Between(Interval of two dates) in Postgres
  529. Table OraclexPostgresql
  530. Table OraclexPostgresql
  531. Converting database-encoding from SQL_ASCII to UNICODE?????
  532. Converting database-encoding from SQL_ASCII to UNICODE?????
  533. Codepage Win1252
  534. Codepage Win1252
  535. how can i use SELECT to find a substring of a column's data?
  536. how can i use SELECT to find a substring of a column's data?
  537. library version problem, 7.3.2, php, redhat linux
  538. library version problem, 7.3.2, php, redhat linux
  539. selecting random rows
  540. selecting random rows
  541. Function to convert
  542. Function to convert
  543. Connecting to postgres from a romote machhine
  544. Connecting to postgres from a romote machhine
  545. "another command is already in progress" error (fwd)
  546. "another command is already in progress" error (fwd)
  547. How to avoid inlining subquery result columns
  548. How to avoid inlining subquery result columns
  549. Create index in PG table with vb6
  550. Create index in PG table with vb6