View Full Version : postgresql answers


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

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