PDA

View Full Version : PostgreSQL

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