View Full Version : postgresql answers


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

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