View Full Version : postgresql answers


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

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