View Full Version : postgresql answers


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

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