View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 [10] 11
  1. Questions about erserver
  2. query-question
  3. I need a SQL...
  4. query-question
  5. how to replicate database
  6. I need a SQL...
  7. PostgreSQL for AMD64
  8. how to replicate database
  9. PostgreSQL for AMD64
  10. (NONE)
  11. pgsql and Qt apps
  12. 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
  13. A Question About Insertions -- Performance
  14. pgsql and Qt apps
  15. (NONE)
  16. 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
  17. A Question About Insertions -- Performance
  18. Release date
  19. message type 0x50
  20. C API, PQconnectdb and options Q.
  21. Release date
  22. message type 0x50
  23. message type 0x50
  24. 7.4 defaulting to ipv6 ?
  25. help with TCL function
  26. C API, PQconnectdb and options Q.
  27. plpgsql doesn't coerce boolean expressions to boolean
  28. message type 0x50
  29. 7.4 defaulting to ipv6 ?
  30. Question about conccurrency control and Insert
  31. Constructing column from different individual fields in same row.
  32. help with TCL function
  33. plpgsql doesn't coerce boolean expressions to boolean
  34. SUMMARY mysql -> psql
  35. State of Beta 2
  36. Kill -9 Postmaster and Temporary Tables
  37. Adding header nam to any table
  38. Help needed in Replicating pgsql
  39. PL/PerlU problems executing other scripts
  40. bolb data type
  41. Temp tables and copy
  42. Question about conccurrency control and Insert
  43. How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
  44. Constructing column from different individual fields in same row.
  45. SUMMARY mysql -> psql
  46. State of Beta 2
  47. Kill -9 Postmaster and Temporary Tables
  48. Find overlapping time intervals, how?
  49. Adding header nam to any table
  50. Help needed in Replicating pgsql
  51. PL/PerlU problems executing other scripts
  52. bolb data type
  53. to_timestamp and to_date fails in postgresql 7.1.3
  54. Temp tables and copy
  55. arbitrary data scheme
  56. How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
  57. Find overlapping time intervals, how?
  58. to_timestamp and to_date fails in postgresql 7.1.3
  59. arbitrary data scheme
  60. Kill -9 Postmaster and Temporary Tables
  61. do child tables inherit indexes?
  62. encoding again
  63. any chance of "like ANY (array[])" like the "= ANY (array[])" syntax?
  64. Picture with Postgres and Delphi
  65. Oracle and regular expressions ???
  66. ECPG bug or development choice
  67. German special characters Problem
  68. mysql create table -> psql
  69. SRF question
  70. Views and Limits
  71. Good open source mailing list system PHP / Postgresql
  72. Another pimple on the type system
  73. inserting an apostrophe
  74. SRF question
  75. compiling libpq without 'main'
  76. Cannot createdb
  77. Inquiry From Form [pgsql]
  78. How do I unsubscribe
  79. why does count take so long?
  80. Can I use PostgreSQL to develop a self-organizing database system?
  81. Code insertion
  82. Unix domain instead of TCP socket connections with JDBC.
  83. v7.4b2 : How can I use COMMENT ON for Large Objects ?
  84. Does "vacuum analyze" contain "vacuum"?
  85. 7.4 binary version
  86. Reasonable Configuration
  87. Needed function IF(expr, expr, expr)
  88. ODBC Issue
  89. decrypted pwd
  90. Grant and wildcards
  91. aggregate function
  92. C functions
  93. Left join
  94. Detailed error message information
  95. unique heritage
  96. Inquiry From Form [pgsql]
  97. default EXECUTE privilege
  98. Views with Where Clauses
  99. Problem with to_date/to_char
  100. Pagination - 1 or 2 queries?
  101. notify problem
  102. Seq scan of table?
  103. Backup?
  104. searching archives should be a weeeee bit faster ...
  105. More than 1024 connections from the same c-client
  106. FYI: Avoiding write conflict errors in MS Access clients
  107. postmaster processes
  108. IP from conexion
  109. Activate Index
  110. tsearch2 and unexpected exists
  111. Change connection (IP, or Databasename)
  112. WHERE boolean = true -> failure
  113. Missing system views?
  114. Replaceing records
  115. More than 1024 connections from the same c-backend
  116. descending Indexes
  117. PLPGSQL
  118. FATAL 2: open of /var/lib/postgres/data/pg_clog/0004 failed: No such file or directory
  119. The following statement now fails on 7.3.4
  120. table constraint or trigger?
  121. XA Resource Manager
  122. Query
  123. automatic update
  124. Crosstab function Problem
  125. Use of oids
  126. setting last_value of sequence
  127. Index not being used ?
  128. Inquiry From Form [pgsql]
  129. [SOLVED] Socket command type E unknown
  130. TCL trigger doesn't work after deleting a column
  131. How many memory size takes numeric(3,0) ?
  132. OffsetNumber offnum (LOCKTag)
  133. is it possible to do this? have a subselect that returns two columns
  134. Access to an element of array NEW in TCL
  135. identifying rows locked in row level locking
  136. identifying rows locked in row level locking
  137. syntax error in eRServer.pm line 69
  138. What is the good equivalent for ENUM ?
  139. Recursive Selects
  140. Output from PLPGSQL
  141. ERROR: PLPGSQL does not exist
  142. Localization (for dates) Oracle vs. Postgresql
  143. Oracle decode Function in Postgres
  144. pg_dump incorrect sequence value
  145. Debian Woody 7.3.4 packages?
  146. Querying $libdir
  147. Comparing dates
  148. how to call a TCL function from within a plpgsql trigger?
  149. Tomcat Connection Pool?
  150. web hosting postgres
  151. Pass parameters to a TCL function
  152. identifying each individual tuple locked
  153. Table name lengths...
  154. Any way to Convince postgres to push join clause inside subquery aggregate?
  155. absolute value fro timestamps
  156. segfaults / backend crashing
  157. postmaster segfault with tsearch2?
  158. LAST_DAY Function in Postgres
  159. Problems with GRANTING SELECT to a table
  160. ADD_Months Function in Postgres
  161. automatic update
  162. pgadmin3 on Gentoo
  163. Optimizer picks an ineffient plan
  164. adding SERIAL to a table
  165. sort ignoring the, a, ...
  166. Field collection in trigger
  167. Field collection in trigger
  168. French translation
  169. Where is the tool to migrate a mysql db to a PostgreSQL db ?
  170. delivering database stand-alone
  171. Getting last inserted SERIAL
  172. Prevent from Deletion
  173. how to group by a joined query?
  174. Mail test
  175. About GPL and proprietary software
  176. SELECT Question
  177. cursor bug
  178. Database corupption on pg 7.3.3
  179. Btrieve
  180. Commercial postgresql
  181. Drop All Foreign Keys ? PostgreSQL 7.2.1
  182. After install 7.3.4, I got a 7.3.3 ver. no?
  183. pg_autovacuum
  184. psql buffering
  185. Errors sending Blob to DB
  186. view function details
  187. LOCK.tag(figuring out granularity of lock)--
  188. Optimizer isn't perfect
  189. Errors sending Blob to DB
  190. PostgreSQL upgrade -> fails to start server
  191. Visual database structure browser for postgresql?
  192. Unsubscribe from the list
  193. Install PostgreSQL on AIX 5.1
  194. Join question
  195. backends
  196. Vacuuming and already vacuumed table?
  197. erserver 1.2 problem
  198. left outer join terrible slow compared to inner join
  199. Date Time Function / Age
  200. Arrays and Indices / Foreign Keys
  201. Problems with transactions and sequences
  202. Database Replication
  203. tsearch: how to get a list of stopwords?
  204. Problem with tsearch and stopwords
  205. mysql to pgsqwl migration
  206. Problem compiling tablefunc module in contributions
  207. postgres vs mysql
  208. Question Join/Subselect
  209. before trigger problem
  210. Localization Oracle vs. Postgresql
  211. Localization Oracle vs. Postgresql
  212. Embedding Postgres "inside" an application
  213. process big
  214. plpgsql , dynamic queries
  215. Recent installed 7.3.4 startup doubt
  216. plpgsql FOUND Variable
  217. Functions have 32 args limt ???
  218. Clarifying File System Syncs
  219. Pg_dump : Can I specify the Password ?
  220. CHAR vs TEXT args
  221. postgresql not using index even though it's faster
  222. FATAL: Socket command type A unknown
  223. pgplsql - Oracle nvl
  224. SQL Command - To List Tables ?
  225. Again about temporary table
  226. PostgreSQL and HA?
  227. problem with upgrading 7.2 -> 7.3.4
  228. Fwd: installing postgres7.3.4 problem II
  229. Excel 97 Export to Postgres
  230. deleting referenced data
  231. Weird psql problem
  232. many columns with references to one table
  233. function restore order
  234. pl/tcl trigger question
  235. Linux ready for high-volume databases?
  236. is linux ready for databases ? (Ziff Davis article on Oracle and Linux)
  237. convert database to unicode
  238. table constraints and performance
  239. Index usage
  240. LOCK.tag(figuring out granularity of lock)--
  241. greek char
  242. support for OO query
  243. How do I find what views depend on a particular table?
  244. LOCK.tag(figuring out granularity of lock)--
  245. Your details
  246. Replication Ideas
  247. merge multiple records into 1
  248. export data from postgresql on linux to ms-sqlserver 2000 on windows
  249. pgsql-mode.el
  250. The ..... worm
  251. WAL Files checkpoint_timeout with voluminous delete/insert
  252. Inserting CR/LF in a select?
  253. convert interval info into days
  254. Strange problem with PL/PgSQL stored procedures
  255. pgAdminII Error
  256. strftime
  257. how to drop table named user
  258. Stored procedure advice needed
  259. unsubscribe
  260. timeofday() and CAST
  261. Books for PostgreSQL?
  262. Your details
  263. 7.4b: FATAL: invalid value for "lc_monetary": "US_EN"
  264. Open Transaction list
  265. Changed mailing list functionality?
  266. FK to inherited table, referential integrity violation
  267. uptime problem
  268. Mail server load
  269. native win32 version
  270. Bug with pg_restore?
  271. Bulk Insert / Update / Delete
  272. Call for presentations Linux Solutions 2004
  273. Buglist
  274. move to usenet?
  275. Mailing list in French
  276. Grouping by date range
  277. Temporary tables
  278. 'now' vs now() performance
  279. 3 way outer join dilemma
  280. Example Database
  281. factors determining the execution plan
  282. Are you an pgODBC hacker?
  283. Default Value in Table Setup Help
  284. Hour difference?
  285. Simulating sequences
  286. Cache lookup failed?
  287. Bit String Manipulation
  288. Performance with different index types
  289. Too many clients
  290. Need feedback on new feature (\for)
  291. C vs plpgsql and child processes
  292. insert and heritage...
  293. Database modelling question for version management of data
  294. Dreamweaver
  295. getting execution plans with multiple database connections
  296. New to list, quick question.
  297. parameter in trigger function
  298. join of array
  299. Character conversion issues while upgrading database
  300. Manage PostgreSQL Connections
  301. Importing data
  302. Graphical Mapping a Database
  303. 7.4Beta
  304. can't find files in pg_clog and invalid page headers
  305. tsearch2 in 7.4beta1 compile problem
  306. WAL question
  307. Transaction question
  308. connect to remote db
  309. importing db as text files
  310. HLR/HSS
  311. Usogres - Compilation Error
  312. Vacuuming unicode database
  313. more timeofday() and "set time zone" weirdness
  314. SET TIME ZONE with GMT+X notation
  315. How to get the total number of rows with a query "limit" ?
  316. FTI problems
  317. Tsearch2 lexeme position
  318. postgres as an snmp client
  319. Viewing Client Connections..
  320. Installing DBD::Pg Perl module locally
  321. Installing DBD::Pg Perl module locally.
  322. How to relate an attribute of one table with the attributes of another related table
  323. Simple DBI question.
  324. Sorting Problem
  325. Simple DBI question
  326. general database password
  327. {REPOST, CLARIFIED} How to recognize PG SQL files?
  328. types of constraint deferment
  329. Help! Can't pg_dump anything: handler procedure for procedural language plpgsql not found
  330. optimisation of a code
  331. Update of foreign key values
  332. One table into two different databases
  333. PL/C functions
  334. Join faster than single table query
  335. update system table?
  336. Multilingual database
  337. High volume use of postGres
  338. Concatenating String Literals in pgsql
  339. 7.4Beta1 "failed to create socket: Address family not supported byprotocol"
  340. dbmirror -- recovery question
  341. Authentication problem
  342. PostgreSQL
  343. dumbheaded SQL question (probably join or subselect) - longish
  344. public key functions for postgresql ?
  345. Nesting Groups
  346. Fwd: Nesting Groups
  347. Continued mail server problems for all PGSQL mailing lists I'm on
  348. Temporary table
  349. postgesql-7.3.3 lo_create/lo_open fails
  350. CURRENT_TIMESTAMP causes Postgres to shutdown connection
  351. Moving from MySQL
  352. Random via Subselect or Temporary Table
  353. remove $ from money field
  354. Empty Output? How Do I Determine the Character?
  355. ERROR: Invalid UNICODE character sequence found (0xed5c30)
  356. Anomaly with SUM().
  357. Trying to create a GiST index in 7.3
  358. unexpected chunk number
  359. The database is very slow !
  360. strategies for optimising common lookups etc
  361. toast values
  362. problem with timeofday() function in cvs PostgreSQL
  363. Conditional row grained replication with DBMirror
  364. XML?
  365. PostgreSQL and ACID properties support
  366. postmaster(s) have high load average
  367. Auditing idea
  368. date format?
  369. Retrieving tuple data on insert
  370. Web application and database.
  371. bug?
  372. Database theory question: safe query
  373. Does REINDEX TABLE lock the table?
  374. cross join oddity?
  375. Table compression
  376. extracting x from a point(x,y)
  377. Examples for writing own c functions in postgres
  378. Problem wih a CONSTRAINT CHECK not doing its job
  379. Table partitioning and Rules
  380. Postgresql long term commercial potential?
  381. Postgres Performance -- page size
  382. recompiling with JDBC
  383. multiple postmasters
  384. problem w/CREATE RULE...ON INSERT...INSERT INTO...SELECT...FROM...WHERE w/multiple inserts
  385. Array and Aggregate Functions
  386. Silly database question...
  387. Exporting a PostGreSql database
  388. I don't know much about postgres - can I stored procedures in postgres, like you can in MS SQL?
  389. The better of two table designs?
  390. indexes on columns and functions
  391. Vacuum verbose question
  392. Forcing a query plan
  393. Before trigger question
  394. unsubscribe
  395. Synchronising multiple common fields among tables
  396. Using C++ With SPI?
  397. Record locking in deadlock
  398. createlang command line won't work
  399. declaring variables?
  400. Forcing query plans
  401. database names vs. database schemas
  402. Fw: Stored Proc error after modifying field type
  403. Stored Proc error after modifying field type
  404. problems with pg_restore to 7.3.3 db
  405. Installation problem: can't find $libdir
  406. Stored Proc error after modifying field type
  407. Exporting large objects in 7.0.2
  408. ERROR: fixrdesc: no pg_class entry for pg_class
  409. Vacuuming specific schemas..
  410. which Schema I am working on??
  411. Which Schema I am working on??
  412. Performance question
  413. Duplicate key insert question
  414. Upgrading 7.3 to 7.3.3
  415. ERROR: language "c" is not trusted
  416. ERROR: Relation "pg_user" does not exist
  417. Text datatype as Memo in Delphi
  418. IPv6 data type
  419. new to postgres - can you write stored procedures? If so, please send links to good sites about this
  420. Noobie: Problems with a query
  421. How to import data from ver 7.3.2 to 7.0.2 installation
  422. InitDB fails
  423. PostgreSQL based Wiki engine
  424. PostgreSQL Linked server question with MSSQL2K
  425. Urgent: Input of values (that is, dynamic queries)
  426. pg_restore fails
  427. Is there a port of PostgreSQL working on Windows CE
  428. 1991 and 1992 Black Box Catalogs
  429. How to show database table/view/... declaration?
  430. Web Application "Job Hunter" Updated
  431. access xp postgres data from linux
  432. insert statement question
  433. escaping - sign
  434. query translation
  435. linking to MS Access using ODBC and geometric types?
  436. Does PostgreSQL have a size limitation
  437. list tables from PHP
  438. Abstracting SQL Statements In An Object
  439. scroll bug cursor or me?
  440. pg_dump and -t option
  441. A PHP/PostgreSQL E-Zine available
  442. How to make a copy of a PG database
  443. help on function - result set
  444. too many clients already?????
  445. licensing
  446. Postgres functions that return multiple values...
  447. ordering field containin non alpha numeric character
  448. Problem of installing PostgreSQL on Windows 2000
  449. COPY command problem
  450. JNDI DataSource with PostgreSQL and Tomcat
  451. Just testing. Please ignore
  452. Logging trigger calls
  453. [PGSQL+MSSQL] - connection between them
  454. DateAdd function?
  455. PostgreSQL ??
  456. pg_autovacuum
  457. Best way to Insert related records
  458. External SQL functions exported by DLLs
  459. time arithmetic
  460. pgsql optimizer
  461. Is GROUP_BY best for this?
  462. Continuous performance regression
  463. A graphical tool for the visualization?
  464. Where to get DBD::pg Perl module for Windows?
  465. PostgreSQL/PHP/UTF-8?
  466. Performance on select on index and large tables
  467. I found this great little site
  468. Insert/Update Perl Function involving two tables needing to by 'in sync'
  469. Data Recovery
  470. Fedora Core 2 postgresql regress problems.
  471. default schema
  472. postgres replication only some datas
  473. Simple ERP problem
  474. Capturing the result status of an ALTER command in plpgsql
  475. Bulk import date into table.
  476. Return set different in pgsql and MS Access/ODBC
  477. [Diploma] Examples of PostgreSQL usage
  478. Creating variables outside a 'create function'
  479. Memory problem
  480. PL/Perl Trigger Problem
  481. Create Table with Foreign Key Error
  482. Create Table with Foreign Key Error
  483. ODBC creating nulls?
  484. using sql to update a table
  485. Recovery after delete
  486. TOP ?
  487. 7.4 serial not working ?
  488. import from oracle dmp.
  489. transform like excel possible?
  490. Can I interrupt queries already processing in the server?
  491. one to one and many to many => one to (one and many)
  492. How to write a single update sql statement to update different setof attributes of a table
  493. Stored procedures in PL/PGSQL
  494. bytea SQL ERROR with size
  495. large dimension table
  496. Concurrency relate issue.
  497. how to transfer contents
  498. Postgres for OpenVMS?
  499. indexed columns in views
  500. Format conversion for import in Postgresql
  501. Timestamp precision and rounding
  502. [v7.0.3]join tables between databases
  503. Remote X viewing of pgaccess
  504. [v7.0.3] loop through a database and union all tables begiining with "j" and name is like j### (#=digit)
  505. Casting hexadecimal to int
  506. pam_pgsql
  507. DBD::Pg handling duplicates in a transaction
  508. relocation error
  509. Starting Postmaster
  510. problems installing postgresql 7.4.2 on mac osx 10.3
  511. postgres crashes
  512. Partition view optimization
  513. postgres hangs?
  514. Database structure
  515. Add Printer Script
  516. Multi-process transactions [share connections]
  517. coerces
  518. Fatal Error
  519. alleviate
  520. FmPro Migrator 1.97 for MacOS X and Windows - Adds FileMaker to PostgreSQL Migration Feature
  521. Gilbertson
  522. ColdFusion MX + PostgreSQL - why slow?
  523. Postgresql 7.3 on Mandrake 9.2
  524. MS SQL vs PostgreSQL
  525. semaphores - FAQ no help
  526. xml to postgres
  527. time question
  528. Question on stored functions
  529. looking for advice...
  530. Unable to identify a function that satisfies the given argument types
  531. Low level API Layers within Postgres
  532. Creating a SQL variable to hold a table name
  533. Errors running cgi program
  534. Cobol esql precompiler
  535. PostgreSQL on Windows
  536. nextval problem
  537. PostgreSQL Inheritance
  538. encrypt like safeJDBC
  539. Help! Select count from a list of digits ??
  540. access to database
  541. Postgresql 7.3 And Redhat Enterprise 3
  542. Native distribution for Windows - when?
  543. Unidata Universe impot into PostgreSQL
  544. user attributes
  545. How can the sequence become out of sequence?
  546. Alternative to ODBC ?
  547. exec sql define
  548. simple tree in postgress
  549. pg_dump and pg_restore wtih lo
  550. Some basic SQL Questions