View Full Version : answers

Pages : 1 2 3 4 5 6 [7] 8 9 10 11
  1. Found this in the server log on MAC OSX
  2. DBD::Pg 1.32 ready for testing
  3. Meet this embebed postgresql in Visual Basic
  4. Binary data in PostgreSQL
  5. HELP with a Query
  6. backup and restore questions
  7. Problems with plpgsql and FOR loops
  8. Replication options
  9. finding out actual tuple size
  10. Post gresql commands
  11. Join with equals?
  12. embeding postgre
  13. PHP + Postgres: More than 1000 postmasters produce 70.000 contextswitches
  14. How can I delete a primary or foreign key?
  15. Inherited tables and column references
  16. Slow queries in PL/PGSQL function
  17. Slow queries in PL/PGSQL function
  18. pg_restore problem
  19. Modular application needing additional columns?
  20. Replication options
  21. postgresql & unicode
  22. Edit Tables...
  23. VACUUM Question
  24. Inner join question
  25. Refer to n'th field of a table?
  26. How do I get query result(select e.g.) from a dynamic command(EXECUTE)?
  27. VACUUM Question
  28. Big Tables vs. many Tables vs. many Databases
  29. wishlist: dynamic log volume control
  30. Prepared statements and cursors
  31. [Re] Need help with postgresql/apache/php optimisation
  32. [Re] Need help with postgresql/apache/php optimisation
  33. pg_dumpall dies
  34. cannot use createlang after removing public schema
  35. Adding Functionality
  36. autodoc and debian
  37. Numbering a records
  38. Differences between postgres and mysql
  39. pg_dump and pg_dumpall fail when trying to backup database
  40. Select statment question
  41. CRM Academic Research Request
  42. how to merge a table from another DB
  43. GPG MD5 Checksum for postgres 7.4
  44. pg_dump and circular dependency
  45. unsubscribe
  46. Reuse of Subselects
  47. String manipulation
  48. summary aggregate information from a second table
  49. function returning a record
  50. psql, 7.4, and the \d command
  51. Repost: Syntax - or unavailability of same - for variable join??? Can anyone help?
  52. Cascade delete triggers change user credentials
  53. Dates
  54. to_char problem
  55. using a .postgresql/root.crt
  56. Select for update, locks and transaction levels
  57. Fosdem
  58. How do I call multiple functions in one trigger?
  59. PostgreSQL on Windows
  60. Replication in postgresql
  61. Inputting columns of data
  62. tsearch2: restoring problem
  63. Dazed and Confused
  64. making tsearch2 dictionaries
  65. Pg + perl + apache
  66. Best replication options
  67. test
  68. Wire protocol v3 details
  69. postgresql system column errors
  70. SQL99 IGNORE
  71. Index storage question...
  72. Providing the password to psql from a script
  73. nonblocking libpq large object access?
  74. How to determine current database?
  75. resource monitoring
  76. Using NOTIFY... Slow Client Querys
  77. timestamp/date comparison
  78. Too much CPU usage
  79. inheritance vs performance
  80. book for postgresql
  81. update set x=(subquery on same table)
  82. Join 2 aggregate queries?
  83. Looking for Developer with Postgresql experience
  84. Mysql to Postgresql
  85. Schizophrenic design and solution to it
  86. Idle Connection force-close ?
  87. help with query speed
  88. Connect to PostgreSQL with kylix3
  89. PostgreSQL on OpenSSI
  90. error when executing dynamic commands with transaction
  91. Migrating 7.1.3 to 7.3.4 problem
  92. Not using index
  93. Error language Python (trusted)
  94. Is a capital letters title for this ML blocked?
  95. No More Processes
  96. Prepared queries
  97. createdb feature request
  98. Anyone used GForge?
  99. pl/pythonu
  100. Function parameters of rowtype
  101. Converting timestamps and IP addresses
  102. pg_class and relfilenode
  103. Temporary views
  104. Join query on 1M row table slow
  105. PQunescapeBytea
  106. Changing schema owner?
  107. Duplicate oid and primary key values
  108. Now that I have --enabled-nls...
  109. pl/pythonu and Triggers
  110. Strange Slow query
  111. number of rows in a cursor
  112. Please help re function packaging...
  113. IP adrss and networks in Postgresql
  114. FWD: Try on these correction update for Windows
  115. Case sensitivity
  116. book for postgresql
  117. db_space
  118. odbc problems
  119. CPU Usage
  120. Oracle SQLNet on same server as Postgres
  121. setting default value by "trigger"
  122. Quad Xeon vs. Dual Itanium
  123. Increasing Max Connections Mac OS 10.3
  124. TSearch and rankings
  125. functions and temporary tables
  126. Check for prepared statement
  127. query progress indicator
  128. disallowing multiple NULLs in a unique constraint
  129. Foreign Key on Inheriting Table?
  130. fsync = true beneficial on ext3?
  131. piping output to file
  132. Repost: postmaster growing to consume all memory
  133. Partial index in other DB
  134. CREATE BLOB
  135. Where do I find the init-script
  136. Unable to create a PL/PGSL function : Did I miss something ?
  137. benchmarks?
  138. connectby for BYTEA keys
  139. duplicate key violates unique constraint "pg_class_oid_index"
  140. Can anyone recommend accounting software using PGSQL?
  141. SHOW TABLES ?
  142. Syntax (or unavailability of same) for variable join results?
  143. Indexes and sorting
  144. retrieving parts of a resultset
  145. Getting table attributes
  146. PL/Ruby
  147. how can I select into an array?
  148. Run 2 versions of Postgresql on one machine?
  149. Casting 'record' to a composite type.
  150. Starting the Server ?
  151. Upcoming events: Chemnitzer Linux-Tag
  152. pgsql 7.4.1 copy - end-of-copy marker corrupt
  153. Sort order confusion
  154. Analyze not doing anything?
  155. functional index "real world" uses
  156. functional index "real world" uses
  157. : Proper tool to display graphics?
  158. ERROR: column 'xxx' does not exist (under v. 7.4.1)
  159. dblink - custom datatypes don't work
  160. pg_restore and large files
  161. size of mailing lists?
  162. Proper tool to display graphics?
  163. Can LIKE use indexes or not?
  164. dblink: rollback transaction
  165. Improving performance with a Function instead of a View
  166. Predictive or scoring solution for PostgreSQL ?
  167. Wrong week day language
  168. Copying tables between databases
  169. Resize varchar column
  170. Transaction end on error
  171. RETURN NEXT and reversing order
  172. application developers list?? or report engine using postgres?
  173. BLOB problem
  174. Anyone has nls activated on Mac OS X?
  175. problem with jdbc connection to postgesql
  176. Specifying a index
  177. large crontab database design
  178. Multicolumn Indexing using R-Tree
  179. Copy and xml files
  180. BLOB problem
  181. Before ship 7.4.2
  182. recursive query?
  183. Transfer database tables to a schema
  184. cannot extend error
  185. Select Question
  186. Return Value of a Function
  187. Postgresql 7.3 And Redhat Enterprise 3
  188. isolating users from each other
  189. How to kick out automatically stuck in queries
  190. Array in stored procedure
  191. Error with pg_restore (parse error at or near "BY" at character 144
  192. Functions in CHECK constraint not getting dumped before tables.
  193. partial indexes
  194. Search across multiple sources
  195. Does SET STATISTICS lock the table?
  196. Incorrect Results From Select When Using Non-English Characters
  197. Problem with function
  198. Help: System requirements for postgresql 7.4.1
  199. Viewing detailed lock information
  200. How to...
  201. select ... distinct performance
  202. Using PostgreSQL to store ip traffic information
  203. Insert question null/not null serial, etc.
  204. Fw: [JDBC] Trigger function aborts the transaction on exception
  205. Large object insert/update and oid use
  206. Unicode vs SQL_ASCII DBs
  207. PostgreSQL 7.4.1 and pgdb.py
  208. Two joins on same foreign key
  209. DB cache size strategies
  210. Are there commands to enquire about table structure?
  211. Problem with API (libpq) - detailed error codes
  212. IDENT and pg_hda.conf
  213. No Database Drivers
  214. subqueries vs. separate queries
  215. Planner configuration
  216. Grant question
  217. A strange Vacuum error ...
  218. Pl/tcl auto-load problem
  219. Very slow query - why?
  220. Specifying many rows in a table
  221. Single step Sql script GUI editor
  222. 7.3.4 freezing
  223. Sorting is ignoring spaces
  224. Seaching without accents
  225. Interest in database-based email?
  226. Help, I've killed my system?
  227. Fw: postgres DB duplication
  228. Manually authenticating users in pg_shadow
  229. Is autocommit=true bad?
  230. Call a function when a User (dis)connects from the Server/Database
  231. Logging all queries
  232. Looking for mail relays ...
  233. Postgress resumes ...
  234. Adding missing FROM clause - thanks or no thanks?
  235. Increase stored proc. parameters max count
  236. How can the sequence become out of sequence?
  237. Broken Link on techdocs
  238. Permission Problems:-)?
  239. Reloading Template1
  240. Foreign keys on inherited attributes
  241. postmaster growing to consume all memory
  242. Embedded transactions
  243. crlf and copy
  244. how to enumerate rows ?!?
  245. pg_largeobject and oid mistmach after restore
  246. Executing a query and returning the result set using the SPI
  247. Where is initdb?
  248. Global variables for plpgsql stored procedures
  249. Casting varchar to interval.?
  250. Storing Configuration settings for a database?
  251. About Privileges
  252. Object Relational features in PostgreSQL
  253. COPY, \\copy, and "\357\273\277"\n ^
  254. Multiway associations
  255. I can't upgrade to PostgreSQL 7.4 in RedHat 9.0
  256. on cascade set null works on not null columns
  257. Is there something like an dynamic view ?
  258. pl/pgsql docs 37.4.3. Row Types -- how do I use this function?
  259. force drop of database others are accessing
  260. Calling triggers with arguments
  261. If table A value IS NULL then table B
  262. business references for postgresql
  263. sequence in schema -- broken default
  264. Optimizing SQL: bind variables, prepared stms, histograms
  265. Upcoming events
  266. Nearby zipcodes from a point
  267. psql: relocation error: psql: undefined symbol: PQgetssl
  268. Parsing bug?
  269. regex in plpgsql function
  270. LIVE Coverage of LinuxWorld Conference & Expo | LinuxWorld - where isPostgresql
  271. Want a job?
  272. trust auth in 7.4
  273. Why does the sequence get out of sequence?
  274. varchar_pattern_ops in 7.3.4?
  275. Lost plpgsql function
  276. Question and search for ODBC related postgreSQL questions
  277. Update inside (Insert) Trigger and Unique constraint...
  278. What is holding a connection open.
  279. tablespaces a priority for 7.5?
  280. Compiling postgres-7.4.1
  281. Linux Magazine/Postgres Article
  282. postgresql + apache under heavy load
  283. Idle connections - Too many clients connected already
  284. Ending transaction inside stored function
  285. CTTAS w/ DISTINCT ON crashes backend
  286. SCO Extortion
  287. Referencing subselect returned value
  288. PostgreSQL and Datawarehouse tools
  289. Accessing template0 tables
  290. postGresql Consulting ??
  291. Recursive optimization of IN subqueries
  292. Transaction id
  293. ORM, XPath, and pgxml_dom segfaulting
  294. Alternative to ODBC ?
  295. JDBC Driver moved to gborg.
  296. Can't backup! pg_dump/pg_restore not updated with 7.4.1
  297. Getting rid of duplicate tables.
  298. How to get the requested columns in a rowtype PL/pgSQL function
  299. Attaching files to the database.
  300. Converting from Progress 4GL and DBMS
  301. Very long time to commit or close connections
  302. Introduced PostgreSQL for Windows
  303. Integer ranges in PostgreSQL
  304. Tool to ease development of plpgsql
  305. Tool to ease development of plpgsql
  306. Great change (size of data dir) upgrading postgresql
  307. computed field on a table
  308. Using a Makefile during database development
  309. importing data
  310. Automatic joins?
  311. Automatic joins?
  312. massaging data from multiple timezones
  313. How should I get started?
  314. 7.4 -> 7.4.1 upgrade with customization on freebsd
  315. I got bit by that darn GEQO setting again...
  316. error creating sql function
  317. Tool to ease development of plpgsql
  318. UNICODE-encoded database does not accept umlaut-characters.
  319. Postgresql reporting tool
  320. Potential Problem with PostgeSQL performance on SuSE Linux 9.0
  321. User-specific sequences
  322. plpythonu AKA am I crazy? or....
  323. Problems with \copy and delimiters ','
  324. simple tree in postgress
  325. Adding long text to a database text field generates errors
  326. FAQ (disk space)
  327. serverless postgres, embedded firebird, etc.
  328. Creating GUID
  329. How to become a Windows beta-tester?
  330. Index space reusable?
  331. check date validity
  332. tinterval operators and functions
  333. how to catch the error in procedure ?
  334. transactions in c api (libpq)?
  335. User-specific sequences...
  336. What Version Installed?
  337. why isn't TEXT a key word?
  338. Survey: Motivations to Contribute
  339. How should I get started?
  340. CASE SELECT syntax
  341. Bytea/Large Objects/external files best practices
  342. Bytea/Large Objects/external files best practices
  343. problem starting postmaster as a service
  344. Foreign key question
  345. Returning large select results from stored procedures
  346. parse error in function
  347. fixed-length row
  348. YAGT (yet another GUID thread)
  349. postgresql Error handling in client app
  350. Log_statement behaviour a little misleading?
  351. about postgres odbc on wondows
  352. pg_dump/pg_restore problems with 7.4.1
  353. best practice for use of functions..
  354. Errors after power failure
  355. FW: Postgres: VACUUM
  356. Postgres: VACUUM
  357. Max registers in postgresql 7.4
  358. Quoting for a Select Into - Please Help
  359. Collate is not supported for 7.4
  360. Rights in 7.4
  361. Schemas not created on restore
  362. Detecting database corruption
  363. Using regular expressions in LIKE
  364. Huge Data
  365. Optimising SQL Queries?
  366. COPY FROM STDIN
  367. casting parameters to a function
  368. 7.4.1 packages for RHEL2.1
  369. Incremental Development
  370. serverless postgresql
  371. Trigger Question
  372. Testing Email
  373. dump/restore problem
  374. Error since powerouttage
  375. Error since powerouttage
  376. Nested transaction - I am a bank ??
  377. Pl/Perl speed
  378. sequence incrementing twice
  379. Nested transaction - I am a bank ??
  380. pg_catalog permission problem
  381. Postgress and MYSQL
  382. Best practice? Web application: single PostgreSQL user vs. multipleusers
  383. Best Practice for incremental development
  384. Any real known bugs about wrong selects?
  385. Nested transaction workaround?
  386. Updating the owner of a function
  387. Reallife szenario for GEQO
  388. Help with indexing!
  389. Parse error help needed...
  390. sql insert function
  391. qq- repost
  392. qq
  393. Column qualifier issue
  394. Vacuum Error
  395. Dump/Restore ordering problem?
  396. Connecting using an existing socket (libpq).
  397. unsubscribe
  398. unsubscribe
  399. Granting all table in one command
  400. Dump tables with pg_dump - no or different Owner
  401. Error with tablefunc in postgres 7.4.1
  402. insertion with trigger failed unexpectedly
  403. Precedence of a TRIGGER vs. a CHECK on a column
  404. Compile postgre 7.1 on Redhat 9?
  405. SRF in C
  406. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  407. what we need to use postgresql in the enterprise
  408. how do I get the primary key
  409. How are NULLS stored on disk for PG 7.4?
  410. Using indices with long unique IDs.
  411. Is Mysql Gaining?
  412. Drawbacks of using BYTEA for PK?
  413. CHAR(N) storage requirement
  414. Case sensitivity
  415. psql's "\d" and CLUSTER
  416. Any way to SELECT a list of table names?
  417. Bug with rename bigserial column
  418. Bug in functions returning setof where table has dropped column?
  419. query should use an index?
  420. Query string is too long
  421. unsubscribe
  422. OIDS and its limitations
  423. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  424. Why does this use of accents in psql fail for a Unicode database?
  425. no space left on device
  426. Hierarchical queries
  427. TSearch2 ... ignore word repetition for rank
  428. deferring/disabling unique index
  429. Invalid UNICODE character sequence found(0xc000)
  430. problems dumping from one server 2 another
  431. array faults?
  432. Trouble with MsAccess and records above 13000
  433. Using indices with long unique IDs.
  434. Natural upgrade path for RedHat 9?
  435. Using indices with long unique IDs.
  436. SPI question: trying to read from Large Objects from within a function
  437. RedHat install question.
  438. Simulation output using libpq
  439. full db locking during dump
  440. encrypt
  441. vacuum
  442. beginner query help
  443. int8 version of NUMERIC?
  444. 7.4, 'group by' default ordering?
  445. deferring/disabling unique index
  446. why I can call pg_stat_get_backend_idset directly
  447. Simulation output using libpq
  448. 7.3.3 drop table takes very long time
  449. order by is ambiguous
  450. Optimize query: time of "single * IN(many)" > time of "many * IN(single)"
  451. Compile problem on old Debian Linux with glibc 2.0.7
  452. Open Source Database Rankings
  453. Perl and Python modules problem
  454. Oracle -> Postgres live translation?
  455. Problem with rserv replication
  456. PHP arrays and postgresql
  457. pg_stats question
  458. VACUUM VERBOSE ANALYZE does not work on 7.4.1
  459. 64 Bit Postgresql ports
  460. The script kiddies are busy again ...
  461. Find original number of rows before applied LIMIT/OFFSET?
  462. deadlocks - sharelocks on transactions
  463. Reparse PL/pgSQL Function?
  464. Loading a dumped databse from cd
  465. SPI question (or not): trying to read from Large Objects from within a function
  466. problems with transaction blocks
  467. Query performance question on a large table
  468. DBs and Schemas
  469. Postgresql & 64 Bit Opteron
  470. unsubscribe
  471. create template database
  472. pg_dump and client_encoding
  473. cross-table unique constraint
  474. MVCC for massively parallel inserts
  475. Date column that defaults to 'now'
  476. forking postmaster on my own - not as pguser
  477. plpgsql.so?
  478. release notes/Appendix E in documentation
  479. Slow Performance with 7.4.1
  480. unsubscribe
  481. 7.4.1 Server Not Starting?
  482. History-based (or logged) database.
  483. PostgreSQL 7.4.1 incredibly slow :-(
  484. Cursor Not Found
  485. Anything akin to an Evaluate Statement in Postgresql?
  486. Scripting a new db server setup
  487. Postgresql Errors over ODBC
  488. TPC-C and Postgres
  489. replication choices
  490. Functions Returning Record Datatype
  491. Network Problems over past 48hrs
  492. Foodmart2000 sample database
  493. license issues
  494. license issue
  495. license issue
  496. Passing a comma delimited list to a function
  497. BUG: compiling PL/Python - Semi-SOLVED
  498. Any way to have CREATEUSER privs without having all privs?
  499. 7.4 ERROR: CREATE LOCAL TEMPORARY TABLE ... ON COMMIT DROP inside a function
  500. 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work
  501. pull_up_subqueries question
  502. Help with PostgreSQL porting project
  503. why the need for is null?
  504. Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
  505. GetLastInsertID ?
  506. how to read db schema with php
  507. speeding up inserts
  508. measuring disk usage of records
  509. finding my schema (for sequences)
  510. Binaries (rpm) for SuSE 9.0...
  511. Bug and/or feature? Complex data types in tables...
  512. Replication ?
  513. What does count(*) count?
  514. 7.4.1 RPMS
  515. 7.3 dump into 7.2 (my solution)
  516. Quotes in dynamic sql
  517. 'like' refuses to use an index???
  518. Where can I find the "Contrib" page on the PostgreSQL site?
  519. Problem with ecpg
  520. ERROR: cache lookup for type 0 of ... pg.dropped.14........ failed
  521. md5sum function for debian 7.3.2
  522. Any way to disable backslash as a string literal escape character?
  523. PG_Autotune
  524. Select Non Alpha Contents of a Column
  525. website doc search is extremely SLOW
  526. Building dynamic contents from database
  527. Building dynamic contents from database
  528. Out of memory error when doing an update with IN clause
  529. An out of memory error when doing a vacuum full
  530. altering a column
  531. case insensetive UTF-8
  532. phppgadmin, pkey's and indexes
  533. pg_recvbuf errors
  534. simple auto-updating timestamp ?
  535. what about uniqueness of inherited primary keys
  536. Change onership of database and all tables?
  537. Max length of SQL statement
  538. Time varying referential integrity
  539. comparison: smallint & 2^extract(dow from date)
  540. RPM for RedHat 7.0?
  541. dump 7.3 into 7.2?
  542. pg_ctl logfile rotation not working?
  543. Nested Transactions in 7.5??
  544. between
  545. Is my MySQL Gaining ?
  546. Photos of PostgreSQL booth
  547. Postgresql 7.4.1 Compile problem for SCO 5.0.5
  548. Installing Postgres w/RH9
  549. Where do I get Windows libpq and header files?
  550. Parser does not like %ROWTYPE in the RETURNS clause of a function declaration (BUG?)