Home : Bytes IT Community / View Full Version : PostgreSQL

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

  1. Vacuum, per table or entire database? what is better?
  2. BUG: 8.0 beta1 does not run on Windows 2000 Terminal Server
  3. Managing caches for multi-cluster HP-UX box
  4. Could not create a table named "USER" under postgreSQL
  5. can postgresql handle these large tables
  6. Could not create a table named "USER" under postgreSQL
  7. FATAL: invalid frontend message type 8
  8. Installing FullTextSearchTool tsearch2
  9. Postgresql feature
  10. scripting & psql issues
  11. Postgres and JBOSS
  12. manually setting a 'for each statement' to 'deferrable initially deferred' -> any unforeseen side effects?
  13. psql - user defined SQL variables
  14. pg_dump feature request: Exclude tables?
  15. indexed column not working as fast as expected
  16. Fw: libpq or Embedded SQL in C
  17. pg_dump feature request: Exclude tables?
  18. Problem analyzing performance of query
  19. (S)RPMS for 7.4.4 released.
  20. PANIC: btree_split_redo: lost left sibling?
  21. Any recommended forums/wiki/blog s/w that uses PostGreSQL?
  22. apple uses Postgres for RemoteDesktop 2
  23. [Fwd: Slony-I release 1.0.2 includes PostgreSQL 8.0 support]
  24. Problems using count() with a join
  25. pg_clog and pg_xlog empty, postgresql refuses to start
  26. pg_dumpall outputs incorrect sql
  27. Pgsql 7.3/7.4/8.0 on IA64 HP-UX 11i?
  28. making two tables with identical schemas appear as one
  29. Thousands of parallel connections
  30. could not find block containing chunk 0x8483530
  31. Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?
  32. distinct and equal operator
  33. major database breakdown
  34. PostgreSQL 8.0.0 - Win32 C-Language function how to?
  35. postgres in freebsd jail
  36. Error codes to go with errors?
  37. PHP and PostgreSQL question on identifier limits.
  38. (libpq) listen/notify messages are converted to lowercase and/or are case insensitive
  39. PgSQL 8.0.0 - contributed: problem compiling
  40. exception handling support in pgSQL
  41. postgres error handling mechanism
  42. idle processes
  43. Web application: Programming language/Framework
  44. psql wishlist: value completion
  45. Autoincremental value
  46. Postgresql 8.0 beta 1 service issue
  47. Postgres 8.0 -> BEGIN EXCEPTION END Syntax????
  48. ODBC Driver Standards
  49. pg_get_result() hangs for query length > 65535
  50. REINDEX problem
  51. heap errors - should I be worried?
  52. /contrib binaries for win32
  53. pl/pgsql trigger table attributes
  54. pg_dump in windows postgres 8.0
  55. pl pgsql grammer file contains error
  56. datpath error
  57. Access restrictions on rows depending on value of the a column
  58. PgSQL 8.0.0 beta1 compile problem + patch
  59. PHP Postgre-MySql call redirector
  60. case insensitive search with greek characters
  61. upgrading in RH 8
  62. PG 8.0beta: psql suggestion
  63. Changing from base type to inherited
  64. Clustering, mirroriing, or replication?
  65. My admin left the job and I am stuck
  66. disabling autocommit
  67. POSIX RE starting with a (
  68. the behaviour of timestamp on postgres.
  69. How to write soundex query in postgresql??
  70. Resultset problem or BUG !
  71. type cast for ERROR: function chr(double precision) does not exist???
  72. Slony setup help needed
  73. How to identify which query is running - reg.
  74. lock conflicting with another
  75. postmaster does not shut down
  76. Locks in functions?
  77. Sorting varchar w/single digits
  78. dump/restore from 7.4.3linux to 8beta1 win32
  79. psql: immediately exit after an error?
  80. pg_restore with Fc fails with [archiver] out of memory error
  81. 7.4.3 server panic
  82. Transaction blocks
  83. BIGINT indexes still with problems
  84. hostory tables with a generic function?
  85. Replication options?
  86. Problems with MS Visual Basic 6.0
  87. Relation does not exist
  88. User Defined Types and SQL2003
  89. Copy data from one table to another, where some records might already be present
  90. BIGINT indexes still with problems
  91. Replication options?
  92. Relation does not exist
  93. history tables with only one function?
  94. row level lock
  95. nested transaction
  96. error moving table to tablespace (8.0 beta win32 )
  97. Using connection after fork
  98. Postgres update with self join
  99. Listing views
  100. PostgreSQL 8.0.0 Officially Goes Beta
  101. Implicit join
  102. FW: Out of swap space & memory
  103. DELETE and UPDATE in same function with foriegn keys
  104. Implicit join
  105. postgresql and smp linux kernel
  106. plruby issue with redeclaring functions
  107. Stored Procedure - Iam totally lost!
  108. Embedded Database
  109. How Two JOINS from one table
  110. PostgreSQL 8.0 Feature List?
  111. COPY, \copy with defaults
  112. Losing records when server hang
  113. How copy a new line char to a file?
  114. pg jdbc driver
  115. CREATE FUNCTION
  116. Writing regex in PL's
  117. RFC: array literal syntax
  118. Rounding in PGSQL
  119. CA issues million dollar challenge to open source community
  120. FW: Out of swap space & memory
  121. constraint expression
  122. probelm migrating from 7.3.4 to 7.42
  123. Lost my blobs and can't restore.
  124. replication
  125. getting dead locks with 2 functions
  126. Sequence question
  127. Commit Transaction Command
  128. Insert into sintax
  129. getting dead locks with 2 functions
  130. PQunescapeBytea Question
  131. Non-superuser connection limit exceeded
  132. PG over NFS tips
  133. case insensitive sorting & searching in oracle 10g
  134. Sequence Question
  135. Seeking PostgreSQL consultants
  136. most idiomatic way to "update or insert"?
  137. query result set caching
  138. COPY not handling BLOBs
  139. altering the datatype of a column.
  140. Recursive PLPGSQL function?
  141. Simplfied Bytea input/output?
  142. New PHP + PostgreSQL group at Google Groups 2
  143. Creating blank records with sequential record numbers
  144. How to know which queries are to be optimised?
  145. trouble with query
  146. trash talk
  147. root page error
  148. Updateable Views?
  149. Trying to use GIST indexes again
  150. User locking
  151. dropping a rule find an error
  152. recycled transaction log file: too much?
  153. Are Packages for PostgreSQL 7.4.x for Solaris 9 64bit available ?
  154. Casting timestamp with time zone to varchar automatically
  155. CREATE SEQUENCE
  156. Out of swap space & memory
  157. New to Postgres
  158. autovacuum problems
  159. one view for 2 different tables
  160. psql and md5
  161. Information about the type of elements in an array from libpq
  162. Stored procedures
  163. I have some questions...
  164. exclusion in distributing binary-only postgresql to client
  165. pg_proc.proacl documentation
  166. Postgres and Tools Intro?
  167. PostgreSQL, GnuCash
  168. pdql, pg_dump, and pg_restore
  169. How to use as Functional Index to be used as Primary KEY
  170. Correct escaping of untrusted data
  171. pg_hba.conf changes without restarting postmaster
  172. best type for unix file system timestamp?
  173. Shared Foreign Keys From Two Tables
  174. 7.2 - 7.4.2 production server migration issue
  175. pg_restore -t
  176. Moving tables between schemas
  177. Postgresql and OS cluster
  178. Using view
  179. (NONE)
  180. Wal logs
  181. Backup questions
  182. Backup questions
  183. Checking existence of temporary table
  184. tablespace spec
  185. how to limit user to open another session
  186. Need info on performance tuning.
  187. Arrays to table
  188. Status
  189. Timestamp input + copy
  190. php -postgresql
  191. Data entry?
  192. Strange constraint violation when applying rules to a view.
  193. Cascade Order
  194. EXPLAIN on DELETE statements
  195. Indexes on Character Types
  196. Everlasting SQL query
  197. Discussion wanted: 'Trigger on Delete' cascade.
  198. pgadmin III ?
  199. tablename type?
  200. Aborting long running command.
  201. altering a table to set serial function
  202. Perl DBI and nested transaction?
  203. Loading/Retrieving bytea fields?
  204. PostgreSQL running in FreeBSD jail corrupts PostgreSQL running onthe host system
  205. no value fetch
  206. Before/After trigger sequencing question
  207. NNTP server
  208. Trigger on Postgres for tables syncronization
  209. Data model for Postfix v2
  210. open of /usr/lib/pgsql/data/pg_clog/0F3E failed
  211. parsing binary varchar[]-s
  212. estimating table size
  213. vacuumdb hanging database cluster
  214. postgresql password from .pgpass
  215. 7.5 beta?
  216. Beginner: Enhancing postgresql performance
  217. isNumeric function?
  218. selecting more that 2 tables based on 1 subquery find an error
  219. selecting more that 2 tables based on 1 subquery find an error (revision)
  220. Search in code
  221. pg storage system
  222. Connexion to Postgresql using TCP/IP
  223. phppgadmin and external access
  224. pgadmin problem
  225. dumping the schema
  226. select, columns, and aliases
  227. please please please PLEASE help!
  228. any benefit to preparing a sql function?
  229. Best way to recover from crash?
  230. polating (insert into...) a table with determined record from another table.
  231. 2 postgresql processes on the same machine ?
  232. Tsearch2 - list of words or phrase with count
  233. Hex to char
  234. Table access method not behaving like Oracle (index vs sequential scan). Examples and stats provided.
  235. unsubscribe
  236. sorting and spaces in postgresql with en_US locale
  237. Wanted: Want to hide data by using PL/PGSQL functions
  238. SQL - display different data
  239. Locking with foreign key constraints
  240. Using SELECT inside a COPY transaction with PHP
  241. help me
  242. Why index used/not used
  243. mirroring data on different drives?
  244. Aligned Output!!
  245. initdb for postgresql 7.4 doesn't
  246. SQL (?) question
  247. fail to compare between bytea output in
  248. tsearch2, ispell, utf-8 and german special characters
  249. pgadmin 3
  250. DIfferent ORDER BY behaviour in 7.4.2
  251. Stored procedures and "pseudo" fields..
  252. How to find records with the same field?
  253. Postgres vs Sybase ASE
  254. special table queries slow until dump/restore
  255. enumerated type..
  256. LOG table changes ...
  257. Index Using
  258. UPDATE statement
  259. Question on INSERT statement
  260. more intelligence to pg_dump
  261. Fwd: Indexes and Tables: Growth and Treatment
  262. Can someone please explain this error
  263. constraitnt on case sensetive and case insensetive columns
  264. unsubscribe
  265. Column as result of subtraction of two other columns?
  266. FW: [ADMIN] URGENT - Postgres won't work
  267. Insert images through ASP
  268. Postgres C functions documentation
  269. Max size for varchar(n) data type
  270. oh
  271. PQftable insufficient for primary key determination
  272. cd, ls, mkdir, rmdir, etc.
  273. SELECT based on function result
  274. moving an installation
  275. Horology & stats tests fail in 7.4.3/RH 9
  276. Describe table and varchar lrngth
  277. tcl and rpms for rhel3
  278. Getting started with replication
  279. determining supported timezones
  280. FOR-IN-EXECUTE, why fail?
  281. Triggers called twice, triggers debugging
  282. Function and RowType
  283. Indexes and Tables: Growth and Treatment (Modified by Thomas F. O'Connell)
  284. optimization with limit and order by in a view
  285. Where may I find Windows native port
  286. Tuning random_page_cost
  287. function returning a readable representation of a number
  288. Need Libpq.dll w/ SSL
  289. Can connection pointer be obtained from PGresult?
  290. Latitude/Longitude data types and functions
  291. cannot access or delete view
  292. change the last bit
  293. (Again) Datacorruption using 7.4.2 on XFS/raid1
  294. SOLVED: cannot access or delete view
  295. Help needed on time data types
  296. Is a digest avail for postgresql-general?
  297. which tar file to start PostgreSQL??
  298. Determining how to convert a value
  299. Using arguments with functions
  300. Characters which requires escaping
  301. Postgress latest Windows Version
  302. Search your email using SQL!
  303. Are SQL functions better than PG/SQL ones?
  304. Problem pg_restore from 7.3 to 7.4
  305. number of pgsql connections established.
  306. will this bug be fixed in 7.5
  307. order of statements in create function
  308. adding a db-specific user
  309. ODBC creating nulls?
  310. HELP
  311. SSL Problems: invalid connection option "requiressl"
  312. Subtransaction syntax in 7.5??
  313. unexpected update behavior with temp tables
  314. Client lib compatibility v. 7.2, 7.3 and 7.4
  315. PGADMIN default storage EXTENDED for Character fields
  316. ERROR: missing chunk number 0 for toast value 14227980
  317. Column name 'user' not allowed?
  318. FATAL: the database system is in recovery mode
  319. (no subject)
  320. (no subject)
  321. Help with query: indexes on timestamps
  322. Why do subselects in target lists behave differently wrt implicitcasts?
  323. Postmaster starts and stops
  324. Error in postgreSQL
  325. win32 port
  326. Accidentally deleted records - PostgreSQL 7.2
  327. Windows GUI clients
  328. Loading Binary Data into Bytea Fields?
  329. Grant Select privileges for all tables in schema
  330. Syntax question
  331. Determining when db last updated
  332. backup using cron
  333. pam authentification trouble ...
  334. ./configure --with-java fails
  335. Grants on rules
  336. could not access file "$libdir/plpython" when restoring
  337. SUBSTRING for a regular expression
  338. server closed the connection unexpectedly
  339. How to filter on timestamps?
  340. Serials in where clause
  341. creating a complex aggregate function
  342. Formatting Function..
  343. FATAL: shmat(id=1179648) failed: Invalid argument
  344. connection parameters
  345. username length character limits?
  346. alter table cascade does not give notice about dropped indexes
  347. Interpreting query plan
  348. per-session (or persistent) table (and column) aliases
  349. how can Iconnect a Postgres database using odbc in c language?
  350. Row-level security--is it possible?
  351. how could I connect a Postgres database in c language using odbc?
  352. Row values
  353. How to add an userA to login postgresadmin
  354. administrating permisions, groups, owners
  355. get first / last date of given week
  356. COPY command with blank incoming values
  357. Full Text Index Info
  358. Drop Column with Foreign Key Problem
  359. (NONE)
  360. row level grants
  361. Error loading trigger in C
  362. max_fsm_pages
  363. permissions
  364. DELETE TABLE xx do not erase index file after a vacuum full ?
  365. Run a unix or perl command in a trigger
  366. Slow deletion of data from tables
  367. postgresql +AMD64 +big address spaces - does it work?
  368. Mysterious performance of query because of plsql function in where condition
  369. sql-question: sum-function and subqueries?
  370. Restoring template1
  371. Bug in function to_char() !!
  372. Problems restarting after database crashed (signal 11).
  373. case for lock_timeout
  374. pg_dump and pg_restore problems
  375. Internationalization
  376. PostgreSQL 7.4.3 on a windows XP Pro environment Installation
  377. what's best: opteron or xeon for pg 7.4.3?
  378. psql - list objects in a schema
  379. Backward compatibility patch for numutils.c
  380. backups
  381. Running PostgreSQL on Windows 9x/2000/2003...
  382. Transaction XID
  383. substring syntax with regexp
  384. Enough RAM for entire Database.. cost aside, is this going to be fastest?
  385. mysql2postgres has no documentation?
  386. DML Restriction unless through a function
  387. a few Questions about quoted variables in psql
  388. sharing tcl proc's between functions
  389. Slow dump with pg_dump/pg_restore ? How to improve ?
  390. minimum operators for b-tree, r-tree
  391. postgresql install: jdbc: No such file or directory.
  392. FULL JOIN and mergjoinable conditions...
  393. What is the prevalent naming convention in RDBMS?
  394. Postgres tuning?
  395. query failing with out of memory error message.
  396. column contsraints
  397. dup(0) failed after 3195 successes: Bad file descriptor
  398. A few beginner's questions concerning concurrency control
  399. dividing time ??
  400. How to determine field names in a trigger?
  401. Q: upgrading from 7.4.1 to 7.4.3.
  402. Seeing uncommitted transactions
  403. Slony-I Canada Day Release Candidate available
  404. Group by - Case insensitivity
  405. Inconsistant DOW...
  406. is win1250 supported encoding for PG7.5?
  407. Plperlu and sending emails, is it safe?
  408. postgresql perl connectivity
  409. indexing lat lon
  410. ERROR: tables can have at most 1600 columns
  411. Date localization
  412. referencing system catalogs
  413. postgresql on debian
  414. pgsql on debian
  415. Trigger isn't fired
  416. enable thready safety on Mac OS X 10.3.4
  417. Performance problem on RH7.1
  418. Speed of pg_dump -l -s (List Schema) Variations
  419. (NONE)
  420. Deadlock. Referential Integrity checks select for update?
  421. Running two postmasters on one host: could not create semaphores
  422. Multi-Language upper(),lower()
  423. Ranking values within a query (pseudo-ROWNUM) **fixed**
  424. psql
  425. hackers dudes
  426. Ranking values within a query (pseudo-ROWNUM)
  427. Renaming a schema
  428. Possible To Modify Part of String in Certain Rows?
  429. Queries not always using index on timestamp search
  430. 7.4.3 RPMS for RHEL3
  431. PostgreSQL Optimizer
  432. strange apllicaion error
  433. PHP: Too many open links (0) with libpg7.4.3
  434. Replace-function
  435. unicode and sorting(at least)
  436. Blob
  437. Performance
  438. langauges, locales, regex, LIKE
  439. clusters and database instances
  440. LIKE and REGEX on postgres
  441. LIKE and encoding and locale
  442. Catching errors
  443. Dump produces file with new line characters
  444. coalesce and nvl question
  445. simultaneous use of JDBC and libpq
  446. timestamp without time zone format
  447. Logging duration of batch runs
  448. FW: problems with installing postgres
  449. setting autocommit off in pgsql
  450. Point in time recovery
  451. Parameters from trigger to function.
  452. incremental backups?
  453. Datatype sizes; a space and speed issue?
  454. Deleting all but one row of a list of non-uniques
  455. Planner choice & tuning
  456. flock user defined function
  457. Connection gets into state where all queries fail
  458. Can I interrupt queries already processing in the server?
  459. More psql problems... >.<
  460. 7.5 Windows version
  461. PostgreSQL Docs for Paper (benchmark and contrib)
  462. Experience with postgres/apache host providers
  463. psql
  464. insert with select as value
  465. pgpool 2.0 is available
  466. How can I add a new language localization(locale) support
  467. User Privileges using dblink
  468. Do we need more emphasis on backup?
  469. PGplSql: Relation 44451 does not exist
  470. who can run utility - pg_controldata ?
  471. JDBC driver inserting into a table with Bytea type gets out of memory error.
  472. Possible SET SESSION AUTHORIZATION bug
  473. New to the list; would this be an okay question?
  474. New to the list; would this be an okay question?
  475. Database name in the log
  476. Database name in the log
  477. Problem while OS-Update
  478. Problem while OS-Update
  479. PGSQL service dieing...
  480. PGSQL service dieing...
  481. Is this a "Stupid Question" ?
  482. Is this a "Stupid Question" ?
  483. IpcMemoryCreate Failed
  484. IpcMemoryCreate Failed
  485. Postgresql installation.
  486. Postgresql installation.
  487. pivot table sql -- COUNT() not working as expected
  488. pivot table sql -- COUNT() not working as expected
  489. Relocation error pg_dumpall undefined symbol get_progname in 7.4.3
  490. Help please - completely baffled by quoting
  491. Help please - completely baffled by quoting
  492. Relocation error pg_dumpall undefined symbol get_progname in 7.4.3
  493. Need help with Dead Lock - reg.
  494. Need help with Dead Lock - reg.
  495. administering files, data type "file"
  496. administering files, data type "file"
  497. File System Restore
  498. File System Restore
  499. INSERT BEFORE Trigger
  500. INSERT BEFORE Trigger
  501. syntax error but command executes anyway?
  502. syntax error but command executes anyway?
  503. How do I clean up a site from an old version to install anew
  504. How do I clean up a site from an old version to install anew
  505. Current Query from Trigger
  506. Current Query from Trigger
  507. RHEL 2.1 rpms for 7.4.2
  508. RHEL 2.1 rpms for 7.4.2
  509. UPDATE inside an Update trigger
  510. UPDATE inside an Update trigger
  511. Article on open-source databases
  512. Article on open-source databases
  513. UTF8 vs C_LOCALE
  514. UTF8 vs C_LOCALE
  515. Trigger to update records out of memory
  516. Trigger to update records out of memory
  517. INSERT ON DUPLICATE KEY UPDATE
  518. INSERT ON DUPLICATE KEY UPDATE
  519. Restoring a table with blobs - Without doing a full restore - Is it even possible ?
  520. Restoring a table with blobs - Without doing a full restore - Is it even possible ?
  521. Variadic functions in plpgsql?
  522. Variadic functions in plpgsql?
  523. virtual fields on VIEW?
  524. virtual fields on VIEW?
  525. PgSQL shut down
  526. PgSQL shut down
  527. User Rights
  528. User Rights
  529. Just saying thank you for PostgreSQL
  530. Just saying thank you for PostgreSQL
  531. 7.4 windows version?
  532. 7.4 windows version?
  533. Connection Problem to DB Table
  534. Connection Problem to DB Table
  535. test post
  536. test post
  537. pg_dump out of shared memory
  538. pg_dump out of shared memory
  539. putting binary data in a char field?
  540. putting binary data in a char field?
  541. 7.4 for Windows?
  542. 7.4 for Windows?
  543. MySQL to Postgres.
  544. MySQL to Postgres.
  545. Off Topic: Book about High available / Load Balancing / Cluster
  546. Off Topic: Book about High available / Load Balancing / Cluster
  547. Join a varchar array
  548. Join a varchar array
  549. List prime key column names
  550. List prime key column names