View Full Version : answers

Pages : 1 2 [3] 4 5 6 7 8 9 10 11
  1. Slony-I 1.0.4 Released
  2. Two questions from the boss (SQL:2003 && scalability)
  3. Outliers of data
  4. Is it possible to remove the public schema?
  5. Information about storge engine in PostgreSQL
  6. DB modeler
  7. Linking question
  8. generic sql question
  9. inquiry on readline functionality on psql client
  10. Invalid page header
  11. table size/record limit
  12. character encoding problem with delphi
  13. CREATE TEMPORARY TABLE AS ... ON COMMIT?
  14. max length bit(x) bit varying(x)
  15. create table/type
  16. Query buffer editing on Win32 version of postgresql?
  17. undefined symbols
  18. Oracle Varray to Postgres conversion problem
  19. index not used?
  20. Sequence question
  21. union query returning duplicates
  22. files ending with .1 or .2
  23. Where clause limited to 8 items?
  24. How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment
  25. Problem
  26. how much ram do i give postgres?
  27. User Defined Functions/management of OS_Directories
  28. Segmentation Fault using PHP code
  29. removing idle connections
  30. download postgreql problem
  31. Views + UNION ALL = Slow ?
  32. delayed input
  33. Sequence question
  34. code in docs gives me an error
  35. OID and PK/FK KEYS
  36. " CLI describe error: Out of memory while reading tuples."
  37. About upper() and lower to handle multibyte char
  38. plpython question
  39. Sequence question
  40. vacuum schema
  41. Database Disappeared
  42. French paper
  43. Online & update races
  44. Online system & transactions
  45. How to time several queries?
  46. 8.0.0beta3 vacuum analyze
  47. How to increase number of connections to 7.2.1
  48. timezone abbreviation in timestamp string input
  49. dealing with invalid date
  50. pgsql function using C++?, or at least C interfacing with C++ lib?
  51. reusing column labels in select
  52. Avoiding sequential scans with OR join condition
  53. plpgsql loop not returning value
  54. OS X Install
  55. pgsql cvs
  56. Multicolumn Indexes
  57. Any Show Stoppers for v8 libpq talking to v7.x db?
  58. Changing session ownership in a web app (or how to peel an onion)
  59. Mathematical operations with NULL values
  60. test -- please ignore
  61. unsubscribe
  62. 7.4 in-lining of SQL functions
  63. Complex Update Queries with Fromlist
  64. Boolean
  65. Count Issues
  66. dirty reads
  67. Does PostgreSQL provide anything comparable with MySQL Cluster?
  68. tcl bindings for 8.0
  69. Is there an opposite to pg_get_userbyid() ?
  70. Verifying a user.
  71. sum 2 arrays of general int type
  72. IMPORT FROM CTREE to POSTGRESQL
  73. solaris and ps
  74. beta3 winxp initdb problems
  75. any way to remove a password?
  76. psycopg help
  77. unsubscribe from the mailing list.
  78. creating audit tables
  79. PostgreSQL CE started
  80. Has anyone tried Date/Darwen/Lorentzos's model for temporal data?
  81. correct representation of timestamp difference
  82. Level of replication support?
  83. Still more pg_clog errors
  84. Commit / Rollback in PL/pgSQL ?
  85. ODBC
  86. converting database to unicode
  87. Proper Sizing of Shared Buffer Cache
  88. Date format for bulk copy
  89. Recovering data from corrupted table. Urgent Help!!
  90. Management software for Postgresql
  91. Time at end of transaction
  92. PostgreSQLv8 native Windows NAMEDATALEN = 128
  93. could not access status of transaction 4244329
  94. psql : how to make it more silent....
  95. adding two tables
  96. about permissions...
  97. cost logging
  98. how to open stat mode in db
  99. Proposal: GRANT cascade to implicit sequences
  100. capacity of datatype "text"
  101. Change primary key in Postgres 7.3?
  102. memory leak of PQmakeEmptyPGresult??
  103. LISTEN/NOTIFY for lightweight replication
  104. error opening pg_clog file
  105. deadlock with vacuum full on 7.4.5
  106. How Do I Change The 'Owner' of a Database?
  107. PostgreSQL v8 NAMEDATALEn >=128
  108. data dir permissions and ownership
  109. connection or query affected
  110. Message-ID as unique key?
  111. Return resultset from a function
  112. Confused with LABEL and LOOP
  113. Rule uses wrong value
  114. update query confusion
  115. Need some advice on appropriate PL strategy...
  116. 'NOW' in UTC with no timezone
  117. Very slow delete.
  118. Reiniciar secuencias
  119. created databases as other users...
  120. Rule is using wrong values
  121. CVS broken?
  122. Reusable pl/pgsql samples ?
  123. update sequence conversion script
  124. Get Postgre Status and Information
  125. Change query priority
  126. Rule problem
  127. Testing Inserts, Deletes and Updates before execution ...
  128. OS not good for database
  129. external function libraries on non-build machine
  130. Rules and locking within a transaction?...
  131. install problem
  132. Management system for PostgreSQL?
  133. foreign key constraints, cannot delete
  134. Explain output question
  135. pg_restore -l and schema name
  136. text + text
  137. interesting! a sequence clashes with data already in that table
  138. when to use NULL and when to NOT NULL DEFAULT ''
  139. CGI program cannot access database
  140. Index problem.... GIST (tsearch2)
  141. regular expression searches
  142. Question about timezones
  143. PSQL undesired transaction behavior when connection is lost.
  144. 8.0 questions
  145. Date variables in psql
  146. pre-sroted table (w/ index)
  147. flattened tables with normalized tables
  148. Reading a text file into PostgreSQL
  149. Alternate interval output function
  150. unsubscription
  151. PostgreSQL seems to wait and block all the queries
  152. Informatica with postgres
  153. interfaces for python
  154. Current wisdom wrt fsm on 8.0
  155. pgpool log errors
  156. Activestate Perl and DBD-Pg?
  157. postgres.h location?
  158. Help on copy function
  159. passing new.* in trigger
  160. database constraints
  161. Commands to browse current connections and processes
  162. Cache lookup failed for relation, when trying to DROP TABLE.
  163. two digit years in inserts
  164. (no subject)
  165. Determining time of last INSERT/UPDATE/DELETE
  166. Mirroring databases in v8
  167. lower/upper support and cyrillic
  168. SSL connection between PHP4 & PostgreSQL ???
  169. Verifying Referential Integrity
  170. problem with pg_restore
  171. storage representation of DATE and TIME types
  172. looking for Mac pgEdit beta testers
  173. Set locale per query?
  174. Mailing
  175. Function array_to_string(text[], text) does not exist ???
  176. more than one instance of pgpool for a backend?
  177. table localisation
  178. current transaction is aborted, commands ignored until end of transactionblock
  179. Single-file databases -- how do they do it?
  180. pgsql 8 beta document
  181. Cursors and JDBC
  182. trouble installing plpgsql
  183. PostgreSQL 8.0 install woes
  184. LOST REFERENTIAL INTEGRITY
  185. Server getting crushed
  186. mirroring/replication
  187. weird issues with plpgsql calls.
  188. Is Win32 port good for operational use?
  189. SELECT from a set of values really slow?
  190. Application user login/management
  191. GnuPG / PGP signed checksums for PostgreSQL 7.4.5, 7.4.4, 7.3.7, 7.3.6, 7.3.5. 7.2.5
  192. guaranteeing that a sequence never skips
  193. Random not so random
  194. sequence rename?
  195. storing files: blob, toasted text of filesystem?
  196. Query problem...
  197. default select ordering
  198. VACUUM FULL on 24/7 server
  199. earthdistance is not giving correct results.
  200. New Student
  201. newby question
  202. earthdistance results seem to be wrong.
  203. See the good, the bad, and the ugly of your Postgres data with OneClickRevelation(tm)
  204. about "pg_dump " without pompt password
  205. problem getting started with PostgreSQL 8 beta 3 on XP
  206. Pgadmin III Qustion
  207. error connecting to database
  208. Pgsql installer beta2 dev2 / dev3 freeze
  209. Arjunt......
  210. Random not so random
  211. Postgresql commands to display all functions and process/connections based on a database.
  212. How to debug pl/pgSQL -script?
  213. Bug with updateable Views and inherited tables?
  214. newby question
  215. i'm really desperate: invalid memory alloc request size 0
  216. Repeated VACUUM reports same number of deleted rows
  217. POSTGRES
  218. help me in PostgreSQL 7.4
  219. readline install questions
  220. Accessing an array element from a function
  221. about "pg_dump " without pompt password
  222. about "pg_dump " without pompt password
  223. Undefined symbols: _poll
  224. postgres start problems with memory
  225. how to encode/encrypt a string
  226. problems with lower() and unicode-databases
  227. Upgrade 7.3.3 to 7.4.5
  228. WinXP + PgSQL 8 beta3 = impossible?
  229. Java application and SPI...(?)
  230. Multiple Rules - an example
  231. Out of memory errors on OS X
  232. How to get user's role?
  233. zero-length delimited identifier in pg_dumpall file
  234. initdb on Debian
  235. 7.3.4 vacuum/analyze error
  236. Index Analysis: Filters
  237. dangling permission on tables after drop user.
  238. COPY FROM STDIN not in local file
  239. failure to restart postgresql service after improper shutdown
  240. Converting to Java date example
  241. string is sometimes null ?
  242. Setting search paths inside a function (plpgsql)
  243. Multiple Rules :: Postgres Is confused !!
  244. Composite Type Argument Construction to a Function
  245. sql script confusion
  246. About PostgreSQL's limit on arithmetic operations
  247. error: unicode characters greater than or equal to 0x10000
  248. Indexes on Expressions -- Parentheses
  249. Controlling order of evaluation?
  250. PostgreSQL Installation Question
  251. mssql linked server to postgres
  252. compiler for functions
  253. To OID or not to OID
  254. postgres v8béta3 on AIX5.2
  255. Custom Functions
  256. FYRACLE better then PostgreSQL ?
  257. Hardware recommendations
  258. .net
  259. Getting an out of memory failure.... (long email)
  260. renaming sequences
  261. Aggregates ?? Datamart (to whatever it has implemented a DataMart using Postgres)
  262. Foreign key order evaluation
  263. Syntax Issue in Trigger Function??
  264. limiting execution time of queries
  265. using ltree with tree structured data
  266. How to terminate an individual client connection gracefully?
  267. could not create socket for statistics collector: Protocol not supported
  268. doubt about the database
  269. core dump on select
  270. Is linked servers possible with postgresql?
  271. inheritance
  272. checksum
  273. Pg8.0 beta2 psql error
  274. Use of 'interval'
  275. IN or JOIN
  276. serial data type
  277. SMgrRelation hashtable corrupted
  278. psql password prompt
  279. Modifying users password in pg_shadow from php
  280. figuring out if there was a transaction in this connection already
  281. cvs update: waiting for anoncvs's lock
  282. Returning a list of fields in a composite type
  283. Optmizar query
  284. porting a full Ms Sql Server to postgres
  285. BiggerSQL-1.3.7 released
  286. pg_dump: what is advantage with schema and data dumps?
  287. 8.0 logging question
  288. How to insert values in BYTEA?
  289. Removed and then missing pg_clog file
  290. Postgres inherited table, some questions...
  291. Is linked servers possible with postgresql?
  292. PostgreSQL 8 on Win2003 AD server
  293. How to pass initdb LC_COLLATE & locale parameters when using windows? (with or without pginstaller)
  294. formating interval question
  295. plpgsql-fct. fails on NULL in record variables
  296. Large arrays give long lag on server side before command executes
  297. books/sites for someone really learning PG's advanced features?
  298. default value problem in postgresql 7.4.5-2
  299. data modeler
  300. self referencing table structure and constraints
  301. Restore a especific function
  302. Comparing a varchar of length > 32
  303. How do I disable: Adding missing FROM-clause
  304. using COPY table FROM STDIN within script run as psql -f file.sql
  305. mailing list archive search form broken?
  306. Returning recordsets with functions
  307. pg_hba behavior
  308. v8 on AIX5.2
  309. varchar of length > 32
  310. postmaster.pid file
  311. download documentation as HTML (not PDF)
  312. What lock to use?
  313. start psql
  314. brand new user - should I start with v8?
  315. difference 7.3.xx vs 7.4.xx
  316. Trouble with query logging
  317. Unable to drop DB in latest CVS version
  318. the current scoop on ilike and indexes
  319. Set return function with union all
  320. Prioritizing queries
  321. Oracle / Postgres Interface
  322. abnormal data grow
  323. Stored Procedures
  324. basics on User Defined Functions
  325. Austin User Group
  326. Any reason not to use inheritance?
  327. using database for queuing operations?
  328. New PayPal Donate Option
  329. How to get most frequent and least frequent values in a column?
  330. Weird behavior with selects and composite data types
  331. using schemas to create a virtual DB?
  332. NULL/0
  333. import/export or moving data between databases
  334. Problem in converting int to timestamp value - why?
  335. order of row processing affects updates
  336. pgAdmin III creates dud SQL for create table
  337. pg_restore peculiarities
  338. Vacuum related question
  339. converting FK's to "DEFERRABLE"
  340. Import an Excel table to a Postgresql one
  341. Default value if query returns 0 rows?
  342. Is it possible to get the 7.4.1 static docs in HTML form anymore?
  343. UTF-8 question.
  344. 8.0.0beta2 and plpgsql
  345. 8.0.0beta2 and plpgsql
  346. Not even JPEGs are safe?
  347. Postgres memory usage
  348. Postgresql <--> webservices?
  349. REFERENCES
  350. Stemmer integration in tsearch2 / $libdir error
  351. lexicographical ordering in postgres
  352. problem with pg_restore and user privileges
  353. table partitioning
  354. Invalid large object descriptor : 0 with autocommit
  355. pg_dump in cycle
  356. ECPG & Mac OS X
  357. 8.0.0 beta 2, void type
  358. support on postgres
  359. Hide databases from users?
  360. pg_locks with users
  361. How to find a column name
  362. Returning Errors from User Defined C-functions
  363. Simple getting-started guide
  364. Getting track of foreign keys
  365. psql error - "unrecognizable command" V8.0.0 beta
  366. division by zero issue
  367. Converting varchar() to text
  368. Creating a two-column sequence?
  369. what is flushed?
  370. Updating another table using a trigger
  371. OS X Mac pgAdmin equivalent?
  372. psql + autocommit
  373. schema level variables
  374. Problems with SPI memory management
  375. Tsearch2 adding additional dictionaries
  376. plpgsql assigning RECORD := RECORD
  377. Checking regex pattern validity
  378. 8.0 postgres book??
  379. fedora core2 pgaccess
  380. postgres book
  381. Spacing in output
  382. different results inside transactions
  383. Changed a column type from "integer" to varchar
  384. 8.0.0 beta 2, void type
  385. Grant
  386. PG case sensitivity
  387. logging rule execution?
  388. plpgsql - raising exceptions with open cursors
  389. Rollback on Error
  390. psql exit status varies for scripts on STDIN
  391. Index inheritance
  392. how to use geometric shapes?
  393. Deadlock removal
  394. Corrupted Data?
  395. Trouble EXITing plpgsql labeled BEGIN blocks with DECLAREs
  396. about C-JDBC for postgreSQL
  397. Number of Active Connections
  398. Building plpython on Mac OSX...
  399. Index inheritance
  400. Autonomous transaction
  401. Questions about Postgresql 8.0
  402. LOG: failed to commit transaction_isolation
  403. Network problem
  404. View efficiency questions
  405. Synchronizing Databases
  406. pass an array as parameter to a function
  407. table with a variable name???
  408. Storing birthday data
  409. PL/pgSQL Function Problem
  410. Text search performance vs MY SQL
  411. Auto increment/sequence on multiple columns?
  412. how to constrain a query to return 1 or 0 rows (or >1 or 0 rows)
  413. Speeding up LIKE with placeholders?
  414. SMgrRelation hashtable corrupted
  415. Best practices for migrating a development database to a releasedatabase
  416. What is the postgres version of mysql's "ON DUPLICATE KEY"
  417. Canceling Query due to user request
  418. unicode and varchar
  419. PhpPgAdmin login weird...
  420. Time zone string not showing
  421. incorrect checksum in control file
  422. pg_attribute.attname
  423. Memory exhausted (leak?)
  424. Where does postgres store records of DROP-ed columns?
  425. referential integrity preventing simultaneous insert
  426. Obtaining the Julian Day from a date
  427. pg_dump/pg_dumpall do not correctly dump search_path
  428. MOVE doesn't return number of rows
  429. Text Search vs MYSQL vs Lucene
  430. 8.0.0beta2: Ownership of implicit sequences after dump/restore
  431. Text search performance vs MY SQL
  432. Migrating from MaxDB to postgresql
  433. postgresql hanging (blocking) with smp kernel
  434. national settings
  435. FYI, Sybase performance study on Linux
  436. function calls in WHERE clause
  437. postgres start error
  438. information schema table names in 8.0.0
  439. Returning multiple values (but one row) in plpgsql
  440. test
  441. Grant Issues with groups
  442. 8.0.0beta2: gcc: unrecognized option `-pthreads'
  443. 'order by' in an insert into command
  444. SQL query - single text value from group by
  445. Need Help in interface..
  446. Heritage
  447. Function caches wrong OID of temporary table?
  448. Postgresql and scripting
  449. Starting and stopping database by JAVA
  450. ERROR: parser: unterminated quoted string
  451. Another Security Question: User-based Roles vs. ApplicationBusiness Rules
  452. Firewall Security Requirements for Postgresql Access
  453. Restoring dump of multiuser databases
  454. Selecting columns by position?
  455. supressing NOTICE messages on Windows/cygwin only not working?
  456. Problems importing data from plain text file
  457. explain with placeholders?
  458. Dumping pg_shadow and pg_database as SQL using pg_dump
  459. Salt in encrypted password in pg_shadow
  460. Pb with ecpg and include file on PG 8.0.0
  461. error: insert has more expressions than target column
  462. Access MDB Schema Import Tool?
  463. ERROR: canceling query due to user request
  464. Postgresql and scripting
  465. changing the password of postres
  466. Help supressing NOTICE messages
  467. restricting non superuser from accessing other databases
  468. postgres 8 performance
  469. resilient transactions
  470. Datatypes Documentation
  471. Pb with ecpg and include file on PG 8.0.0
  472. FAQ: Having Trouble Getting PL/pgSQL Going?
  473. PL-PGSQL language
  474. Passing RECORD variable from func1() to func2()
  475. tg_relation doesn't seem to have the attribute names!
  476. radius authentication
  477. DROP TRIGGER permission
  478. One Database per Data File?
  479. how to query the size of an array in a table
  480. Schema and Group permissions question
  481. Confused with db client encoding
  482. Indexing Order By columns
  483. RAD with postgreSQL
  484. hebrew with MS Access Front End
  485. cygserver -S crashes under Windows 2000/cygwin
  486. initdb crashes under Windows
  487. building postgres for windows 2000?
  488. HOWTO: Get a table or database definition
  489. psql leaking?
  490. Index on TEXT versus CHAR(32)... fast exact TEXT matching
  491. How do I list the schema for a table or procedure?
  492. Where can I get pgsqlodbc now gborg is down?
  493. (NONE)
  494. pl/pgsql exceptions
  495. postgres "on in the internet"
  496. Ingres versus PostgreSQL
  497. test message -- wondering if the list is down -- please delete
  498. disk performance benchmarks
  499. Overloading || ( text,text ) operator
  500. "echo"ing a psql command in a bash script
  501. postgres "on in the internet"
  502. Debugging
  503. How to determine a database is intact?
  504. How do I do update if insert fails?
  505. pgInstaller project dead?
  506. location of postmaster.log on V8 Win 32
  507. psql \o weirdness
  508. Nicer way to access field
  509. Display of text fields
  510. unix socket error in cygwin postgresql-7.4.3
  511. Can we return a table from a function?
  512. "\d tablename" to get column name, and column type by using JDBC
  513. C Function causes backend to die in 7.4.3
  514. Ensuring data consistency - main table and multiple 'details' tables.
  515. search_path problem
  516. Foreign key locks
  517. vacuum full for all databases
  518. plpgsql function
  519. The future of built-in geometric data types
  520. Interval literal not ANSI compliant
  521. materialized view
  522. Understanding pg_autovacuum CPU Usage
  523. can't build libpq with beta 2
  524. beta2 not finding openssl
  525. possible memory leak in 8.0 beta 1
  526. stand-alone psql
  527. PostgreSQL and Fedora?
  528. VISIO and System Tables
  529. pg_autovacuum (7.4) nss_ldap oddity
  530. <> syntax legal?
  531. Join efficiency
  532. insertiing an image file (blob) into postres...
  533. Importing data from MS Access
  534. Exporting/moving Postgress Instance
  535. Performance on 7.4 vs 7.2?
  536. Python Postgresql support?
  537. Error Message Importing Into PostgreSQL (Using phpPgAdmin)
  538. Suppress output from psql?
  539. expected both swapped tables to have TOAST tables
  540. Rule/sequence weirdness
  541. Large Databases
  542. zombie primary key lurches out of database to devour the brains of the unwary
  543. About "lock file postmaster.pid" Error , cannot setup postmaster
  544. Substring result short by 1
  545. Types and SRF's
  546. Not able to build libpq for Windows
  547. Multicolumn Primary Key
  548. Microsoft Project and PostgreSQL?
  549. Change config of running PGSQL
  550. functions/stored procedures