View Full Version : postgresql answers


Pages : 1 2 [3] 4 5 6 7 8 9 10 11

  1. Wrong string length from unicode database in Borland's app
  2. Delete very slow after deletion of many rows in dependent table
  3. Join between databases or (???)
  4. Unit testing plpgsql code
  5. I found this great little site
  6. Posting COPY data with shared sequences
  7. altre table and large object deletion
  8. phpPgAdmin problem - this list?
  9. PostegreSQL 8.0.0 Beta4 Win32
  10. Phantom user in db--'128'
  11. How to make lo_import and lo_export to use file on clientlocal machine?
  12. pgEdit public beta for Macintosh and Windows
  13. Any equivalent of MSSQL Detach?
  14. postgres & glibs 1.2
  15. Odd permission denied message when starting client
  16. only seeing first of many COPY commands in input file
  17. Can COPY skip columns?
  18. index and queries using '<' '>'
  19. How to make a good documentation of a database ?
  20. A couple serious errors
  21. ERROR: Unable to locate type oid 0 in catalog...
  22. How to know a record has been updated, then reset the flag?
  23. PROPOSAL: Usenet Discussion Repost
  24. User-defined types
  25. Rules WHERE condition
  26. Tsearch2 and Unicode?
  27. Knowing when a row was last updated
  28. error querying temp table in plpgsql function
  29. PostgreSQL certification
  30. Q about NAS mounting things
  31. Controlling maximal on-disk size of a table
  32. Certifications in military environment
  33. Transactions in different DB
  34. How to suppress echo while executing batch files?
  35. Problems importing Unicode
  36. Moving from 7.x to 8.0beta4 with a backup
  37. ERROR: column "id" does not exist
  38. How to overload POSITION
  39. question about temp table in function
  40. Fwd: Problem installing Postgresql on MDK10.0
  41. out of disk space
  42. How to deal with almost recurring data?
  43. How to handle larger databases?
  44. PL/pgsql - getting row from record
  45. Transaction in different DB
  46. How to clear linux file cache?
  47. PGCLIENTENCODING behavior of current CVS source
  48. Schemas?
  49. Preventing connections during vacuum and reindex
  50. Oracle versus PostgreSQL
  51. "q" with psql display paging dumps out of psql
  52. Nairobi time zone fails in 7.4
  53. I'm sure a good time was had by many...
  54. Data from Internet direct into PostgeSQL Database??
  55. relations betwee subclasses in postgersql
  56. Question about indexes
  57. suggestion for "psql"
  58. table configuration tweak for performance gain.
  59. Error "cannot compare arrays of different element types" when tryingto ANALYZE
  60. Visual Studio and Postgresql
  61. shrinking physical space used
  62. Mysterious Death of postmaster (-9)
  63. Spam notice
  64. PostGresql USENET Vote
  65. sub-query question
  66. How to use custom functions created by my2pg.pl?
  67. How many secondary databases can I create?
  68. query with table alias
  69. simple query question: return latest
  70. Want to help on open-source ERP?
  71. invalid page header in block 52979 of relation "pg_attribute"
  72. When to switch to Postgres 8.0?
  73. oid size on 64 bit machine
  74. DROP DATABASE, but still there
  75. implicit casting problem
  76. Problem with showing time diff?
  77. logging
  78. checkpoints
  79. Last value inserted
  80. New Opteron server from pogo linux
  81. Vacuum message
  82. Lionel Lauer 58 Gore Street Fitzroy, Victoria Australia 3065
  83. making another super user other than postgres
  84. pg_ctl and stderr
  85. Can't insert date in field with foreign key
  86. Modifying FK constraints
  87. Error connecting using pgadmin from different computer !!
  88. Analyse - max_locks_per_transaction - why?
  89. Rolling back an update
  90. Ping Mike Cox
  91. Large database
  92. updateString error in PostgreSQL7.4 with JDBC
  93. Lost databases
  94. These Lists Are Being Cut To FOUR
  95. the column in Update
  96. unconvertible BIG5 character 0xf9d8
  97. I'm about to release the next postgresql RFD. Comments wanted.
  98. Creating DB with pass, but pass not required to connect
  99. Vacuum hangs
  100. new data types
  101. need simple strategy for universal extension table
  102. FW: Proper nesting of hierarchical objects
  103. Functions in postgres
  104. PostGreSQL to Access Updatable recordset
  105. Linux DBDesigner4 and PostgreSQL
  106. troubleshooting deadlocks
  107. Per-Table Transaction Isolation Level?
  108. server auto-restarts and ipcs
  109. INTERVAL in a function
  110. Loading data Binary data and text with newlines ..
  111. Backend disconnect problems
  112. Installing pgbench
  113. Proper nesting of hierarchical objects
  114. subselect, order by and left join
  115. technical help
  116. can you use variables in PostgreSQL rules?
  117. start postmaster as root : problem
  118. index not always used when selecting on a date field
  119. I spoke with Marc from the postgresql mailing list.
  120. FTP mirror problems
  121. Visual Designer in linux?
  122. Sorting based on maximum value over several columns
  123. SQL question
  124. Trying to get postgres to use an index
  125. Mass Import/Generate PKs
  126. Postresql RFD version 2.0 Help Wanted.
  127. Report Generation
  128. Temporarily disable rule, is this possible?
  129. superuser equality
  130. Can this be indexed?
  131. Gborg down?
  132. Converting number to words
  133. Copy command and import - MS SQL Server to Postgres
  134. Are there any PostgreSQL bloggers?
  135. Retrieve ip client from postgres
  136. ALERT This mailing list may be voted into a newsgroup
  137. Trigger Parameter problem
  138. Using EXECUTE in same manner as SELECT
  139. ALERT This mailing list may be voted into a newsgroup
  140. start postmaster as root : problem
  141. restoring pgdump file file from 7.2 branch to 7.4
  142. Java / Perl Return codes
  143. Characters used for pattern matching with like
  144. Conactenating text with null values
  145. TSearch2: Problems with compound words and stop words
  146. Making this group a part of the official comp.* hierarchy.
  147. how to edit a function from psql?
  148. RFD: comp.databases.postgresql.general
  149. create a text file from postgres (like Oracle UTL_FILE package)
  150. VACUUMING questions...
  151. Selecting a random row
  152. visiting Seoul, Korea
  153. UTF-8 and =, LIKE problems
  154. oid file, but no pg_class row for it
  155. Number of months
  156. Number of months
  157. pg_xlog
  158. pg_xlog
  159. PostgreSQL on Linux PC vs MacOS X
  160. PostgreSQL on Linux PC vs MacOS X
  161. MD5 for PostgreSQL 7.3.4
  162. MD5 for PostgreSQL 7.3.4
  163. autovacuum redhat startup
  164. autovacuum redhat startup
  165. unsubscribe
  166. unsubscribe
  167. Batch processing select
  168. Batch processing select
  169. Postgres Versions / Releases
  170. Postgres Versions / Releases
  171. Subselect Question
  172. Subselect Question
  173. SQL Agreate Functions
  174. SQL Agreate Functions
  175. Split query
  176. Split query
  177. routine reindexing in 7.4.6/8.0?
  178. routine reindexing in 7.4.6/8.0?
  179. Rows created by a stored proc prompt Access' dreaded "write conflict"
  180. Rows created by a stored proc prompt Access' dreaded "write conflict"
  181. Age of statistics
  182. Age of statistics
  183. Calling on all SQL guru's
  184. Calling on all SQL guru's
  185. unique problem
  186. unique problem
  187. spreading the DB?
  188. spreading the DB?
  189. AT TIME ZONE: "convert"?
  190. AT TIME ZONE: "convert"?
  191. Numeric type problems
  192. Numeric type problems
  193. Functions not dropped.
  194. dumping on 7.4.6 importing on 7.4.1
  195. Functions not dropped.
  196. oracle synchronization strategy
  197. dumping on 7.4.6 importing on 7.4.1
  198. PQSQL - binary data question
  199. oracle synchronization strategy
  200. PQSQL - binary data question
  201. Suggested Triggers & Functions Naming Convention?
  202. Suggested Triggers & Functions Naming Convention?
  203. Daylight Savings Time handling on persistent connections
  204. Daylight Savings Time handling on persistent connections
  205. procedural languages in 7.4.6
  206. procedural languages in 7.4.6
  207. Interpolation of environment variables in SQL at runtime?
  208. Interpolation of environment variables in SQL at runtime?
  209. 8.0 Beta 4 denying network connections?
  210. can't shrink relation
  211. logging queries and time used
  212. Recommended Procedure for Archiving Table Data
  213. column updates
  214. SELECT a value from various tables depending on a column value
  215. (b)trim anomalies
  216. tasks
  217. UTF-8 -> ISO8859-1 conversion problem
  218. adding missing FROM-clause
  219. Max length name of a database/schema
  220. PostgreSQL on Windows
  221. Creating database problem
  222. PgSQL8 beta4 ODBC, JDBC and WinXP sk_SK
  223. {OT?] Auth_PG_grp_group_field directive gives parameter error
  224. export-import problem
  225. Upgrading from beta3 to beta4
  226. Turning a subselect into an array
  227. Derived tables?
  228. Issue adding foreign key
  229. Sorting street addresses
  230. field incrementing in a PL/pgSQL trigger
  231. : Unable to load libsqlpg.so
  232. disabling constraints
  233. Tables and Indexes
  234. determine sequence name for a serial
  235. View's rule on delete problem
  236. Creating schema copy
  237. WARNING: column "footype" has type "unknown"
  238. interval to seconds conversion. How?
  239. QMail
  240. Psycopg difficulty...
  241. Reasoning behind process instead of thread based arch?
  242. Exact or less specific match ?
  243. Resource temporarily unavailable
  244. Array values and foreign keys
  245. Changing access permissions without re-starting the database
  246. update data in different database
  247. (NONE)
  248. Theory
  249. pg_autovacuum in 8beta-dev3 small bug
  250. basic debugging question
  251. Base type OIDs
  252. [SECURITY] New set of PostgreSQL RPMS are available for download
  253. primary key and existing unique fields
  254. page locking? too many btree indexes...
  255. Out of memory error
  256. Any plans on allowing user-defined triggers to be deferrable?
  257. Bug: 8.0 beta1 either view optimization or pgdump/pgrestore
  258. compatibilityissues from 7.1 to 7.4
  259. Strange count(*) implementation?
  260. Kill a postgres session
  261. [Fwd: Abrupt close of pgsql backend]
  262. Theory!!
  263. list fieldnames in table? (from PHP)
  264. what could cause inserts getting queued up and db locking??
  265. PostgreSQL 8.0.0 Beta 4 Now Available
  266. pg_restore does not restore
  267. process hang during drop schema
  268. Error restoring bytea from dump
  269. shared buffers
  270. ON DELETE trigger blocks delete from my table
  271. The reasoning behind having several features outside of source?
  272. Arrays, placeholders, and column types
  273. PgSQL MVCC vs MySQL InnoDB
  274. (NONE)
  275. How to connect with postmaster through TCP socket
  276. Sorting, when values are equal....
  277. dbms
  278. partial index on a text field
  279. Function syntax checking
  280. (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready
  281. pqAdmin3
  282. Memory exhausted on DELETE.
  283. Permission denied error
  284. sequence behavior - is this correct
  285. Comment on timezone and interval types
  286. COPY data and referential triggers ...
  287. Problem with 7.4.1 and complicated queries
  288. repost(gmane): sql update max smartries
  289. The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
  290. how to port Oracle database to PostgreSQL?
  291. sql update max smartries
  292. '1 year' = '360 days' ????
  293. Log
  294. field incrementing in a PL/pgSQL trigger
  295. Duplicating a database
  296. Win installed pgsql 8.0 beta2 dev3
  297. COPY command with PHP
  298. Bug or stupidity
  299. PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4
  300. OID's
  301. returning inserted rows, derived tables design
  302. schema repository
  303. combining two queries?
  304. ia64 hostname lookup problem
  305. unexpected field count in D message
  306. Problem with query plan
  307. A Simple Question
  308. PlPERL and shared libraries on Suse
  309. PostgreSQL-related job posting
  310. FKs and deadlocks
  311. C++ Class Library for ODBC?
  312. correct example of a functional index usage?
  313. Row versioning
  314. Slony-I 1.0.4 Released
  315. Two questions from the boss (SQL:2003 && scalability)
  316. Outliers of data
  317. Is it possible to remove the public schema?
  318. Information about storge engine in PostgreSQL
  319. DB modeler
  320. Linking question
  321. generic sql question
  322. inquiry on readline functionality on psql client
  323. Invalid page header
  324. table size/record limit
  325. character encoding problem with delphi
  326. CREATE TEMPORARY TABLE AS ... ON COMMIT?
  327. max length bit(x) bit varying(x)
  328. create table/type
  329. Query buffer editing on Win32 version of postgresql?
  330. undefined symbols
  331. Oracle Varray to Postgres conversion problem
  332. index not used?
  333. Sequence question
  334. union query returning duplicates
  335. files ending with .1 or .2
  336. Where clause limited to 8 items?
  337. How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment
  338. Problem
  339. how much ram do i give postgres?
  340. User Defined Functions/management of OS_Directories
  341. Segmentation Fault using PHP code
  342. removing idle connections
  343. download postgreql problem
  344. Views + UNION ALL = Slow ?
  345. delayed input
  346. Sequence question
  347. code in docs gives me an error
  348. OID and PK/FK KEYS
  349. " CLI describe error: Out of memory while reading tuples."
  350. About upper() and lower to handle multibyte char
  351. plpython question
  352. Sequence question
  353. vacuum schema
  354. Database Disappeared
  355. French paper
  356. Online & update races
  357. Online system & transactions
  358. How to time several queries?
  359. 8.0.0beta3 vacuum analyze
  360. How to increase number of connections to 7.2.1
  361. timezone abbreviation in timestamp string input
  362. dealing with invalid date
  363. pgsql function using C++?, or at least C interfacing with C++ lib?
  364. reusing column labels in select
  365. Avoiding sequential scans with OR join condition
  366. plpgsql loop not returning value
  367. OS X Install
  368. pgsql cvs
  369. Multicolumn Indexes
  370. Any Show Stoppers for v8 libpq talking to v7.x db?
  371. Changing session ownership in a web app (or how to peel an onion)
  372. Mathematical operations with NULL values
  373. unsubscribe
  374. 7.4 in-lining of SQL functions
  375. Complex Update Queries with Fromlist
  376. Count Issues
  377. Boolean
  378. dirty reads
  379. Does PostgreSQL provide anything comparable with MySQL Cluster?
  380. tcl bindings for 8.0
  381. Is there an opposite to pg_get_userbyid() ?
  382. Verifying a user.
  383. sum 2 arrays of general int type
  384. IMPORT FROM CTREE to POSTGRESQL
  385. solaris and ps
  386. beta3 winxp initdb problems
  387. any way to remove a password?
  388. psycopg help
  389. creating audit tables
  390. unsubscribe from the mailing list.
  391. PostgreSQL CE started
  392. Has anyone tried Date/Darwen/Lorentzos's model for temporal data?
  393. correct representation of timestamp difference
  394. Level of replication support?
  395. Still more pg_clog errors
  396. Commit / Rollback in PL/pgSQL ?
  397. ODBC
  398. converting database to unicode
  399. Proper Sizing of Shared Buffer Cache
  400. Date format for bulk copy
  401. Recovering data from corrupted table. Urgent Help!!
  402. Management software for Postgresql
  403. Time at end of transaction
  404. PostgreSQLv8 native Windows NAMEDATALEN = 128
  405. could not access status of transaction 4244329
  406. psql : how to make it more silent....
  407. adding two tables
  408. about permissions...
  409. cost logging
  410. how to open stat mode in db
  411. Proposal: GRANT cascade to implicit sequences
  412. capacity of datatype "text"
  413. Change primary key in Postgres 7.3?
  414. memory leak of PQmakeEmptyPGresult??
  415. LISTEN/NOTIFY for lightweight replication
  416. error opening pg_clog file
  417. deadlock with vacuum full on 7.4.5
  418. How Do I Change The 'Owner' of a Database?
  419. PostgreSQL v8 NAMEDATALEn >=128
  420. data dir permissions and ownership
  421. connection or query affected
  422. Message-ID as unique key?
  423. Return resultset from a function
  424. Confused with LABEL and LOOP
  425. Rule uses wrong value
  426. update query confusion
  427. Need some advice on appropriate PL strategy...
  428. 'NOW' in UTC with no timezone
  429. Very slow delete.
  430. Reiniciar secuencias
  431. created databases as other users...
  432. Rule is using wrong values
  433. CVS broken?
  434. Reusable pl/pgsql samples ?
  435. update sequence conversion script
  436. Get Postgre Status and Information
  437. Change query priority
  438. Rule problem
  439. Testing Inserts, Deletes and Updates before execution ...
  440. OS not good for database
  441. external function libraries on non-build machine
  442. Rules and locking within a transaction?...
  443. install problem
  444. Management system for PostgreSQL?
  445. foreign key constraints, cannot delete
  446. Explain output question
  447. pg_restore -l and schema name
  448. text + text
  449. interesting! a sequence clashes with data already in that table
  450. when to use NULL and when to NOT NULL DEFAULT ''
  451. CGI program cannot access database
  452. Index problem.... GIST (tsearch2)
  453. regular expression searches
  454. Question about timezones
  455. PSQL undesired transaction behavior when connection is lost.
  456. 8.0 questions
  457. Date variables in psql
  458. pre-sroted table (w/ index)
  459. flattened tables with normalized tables
  460. Reading a text file into PostgreSQL
  461. Alternate interval output function
  462. unsubscription
  463. PostgreSQL seems to wait and block all the queries
  464. Informatica with postgres
  465. interfaces for python
  466. Current wisdom wrt fsm on 8.0
  467. pgpool log errors
  468. Activestate Perl and DBD-Pg?
  469. postgres.h location?
  470. Help on copy function
  471. passing new.* in trigger
  472. database constraints
  473. Commands to browse current connections and processes
  474. Cache lookup failed for relation, when trying to DROP TABLE.
  475. two digit years in inserts
  476. (no subject)
  477. Determining time of last INSERT/UPDATE/DELETE
  478. Mirroring databases in v8
  479. lower/upper support and cyrillic
  480. SSL connection between PHP4 & PostgreSQL ???
  481. Verifying Referential Integrity
  482. problem with pg_restore
  483. storage representation of DATE and TIME types
  484. looking for Mac pgEdit beta testers
  485. Set locale per query?
  486. Mailing
  487. Function array_to_string(text[], text) does not exist ???
  488. more than one instance of pgpool for a backend?
  489. table localisation
  490. current transaction is aborted, commands ignored until end of transactionblock
  491. Single-file databases -- how do they do it?
  492. pgsql 8 beta document
  493. Cursors and JDBC
  494. trouble installing plpgsql
  495. PostgreSQL 8.0 install woes
  496. LOST REFERENTIAL INTEGRITY
  497. Server getting crushed
  498. mirroring/replication
  499. weird issues with plpgsql calls.
  500. Is Win32 port good for operational use?
  501. SELECT from a set of values really slow?
  502. Application user login/management
  503. GnuPG / PGP signed checksums for PostgreSQL 7.4.5, 7.4.4, 7.3.7, 7.3.6, 7.3.5. 7.2.5
  504. guaranteeing that a sequence never skips
  505. sequence rename?
  506. Random not so random
  507. storing files: blob, toasted text of filesystem?
  508. Query problem...
  509. default select ordering
  510. VACUUM FULL on 24/7 server
  511. earthdistance is not giving correct results.
  512. New Student
  513. newby question
  514. earthdistance results seem to be wrong.
  515. See the good, the bad, and the ugly of your Postgres data with OneClickRevelation(tm)
  516. about "pg_dump " without pompt password
  517. problem getting started with PostgreSQL 8 beta 3 on XP
  518. error connecting to database
  519. Pgadmin III Qustion
  520. Pgsql installer beta2 dev2 / dev3 freeze
  521. Arjunt......
  522. Random not so random
  523. Postgresql commands to display all functions and process/connections based on a database.
  524. How to debug pl/pgSQL -script?
  525. Bug with updateable Views and inherited tables?
  526. newby question
  527. i'm really desperate: invalid memory alloc request size 0
  528. Repeated VACUUM reports same number of deleted rows
  529. POSTGRES
  530. help me in PostgreSQL 7.4
  531. readline install questions
  532. Accessing an array element from a function
  533. about "pg_dump " without pompt password
  534. about "pg_dump " without pompt password
  535. Undefined symbols: _poll
  536. postgres start problems with memory
  537. how to encode/encrypt a string
  538. problems with lower() and unicode-databases
  539. Upgrade 7.3.3 to 7.4.5
  540. Java application and SPI...(?)
  541. WinXP + PgSQL 8 beta3 = impossible?
  542. Multiple Rules - an example
  543. Out of memory errors on OS X
  544. How to get user's role?
  545. zero-length delimited identifier in pg_dumpall file
  546. initdb on Debian
  547. 7.3.4 vacuum/analyze error
  548. Index Analysis: Filters
  549. dangling permission on tables after drop user.
  550. COPY FROM STDIN not in local file