View Full Version : postgresql answers


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

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