Home : Bytes IT Community / View Full Version : PostgreSQL

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

  1. how smart is is pg with shared_buffers?
  2. "Expiring" transactions?
  3. BSD License
  4. Especial delimiters caracter
  5. Problem with ORDER BY and random() ?
  6. pg_tables column descriptions
  7. Ora2Pg question
  8. Questions about my ifnull function
  9. Inheritance and query plans
  10. How to get the total number of rows returned by query when using a cursor?
  11. PostgreSQL query failed: ERROR: pg_atoi: zero-length string
  12. table size
  13. GET LAST ID INSERT
  14. TList.Sort
  15. Foreign key constraint accepted even when not same data type
  16. Foreign key constraint accepted even when not same data type
  17. DSN-LESS
  18. DSN-Less
  19. mod_auth_pgsql & encryption
  20. See this important package
  21. How to find LIMIT in SQL standard
  22. encoding and LIKE/ILIKE matching
  23. cannot insert or update
  24. psql and \lo_import
  25. Toad
  26. Triggers/perform oddity between 7.2 and 7.3
  27. about the pstate node
  28. detecting a NULL box
  29. Question about connection java and Postgresql in Linux
  30. add constraints to views
  31. anyone use Ora2Pg?
  32. Identify dropped columns in PLTCL
  33. colunms & comments & inheritance
  34. recent viri and worms
  35. An idea for IPU ( We need another acronymn! )
  36. Access Ingres database
  37. 'order by' does "wrong" with unicode-chars (german umlauts)
  38. DDL diff utility?
  39. query distribution
  40. Trouble with some concepts
  41. adding on delete cascade constraint?
  42. Zend survey result about dbms...
  43. Outer Join help please
  44. Column defaults fail with rules on view
  45. pgindented tsearch2 for 7.3.4
  46. About Pgdump
  47. This mail list and its policies
  48. Sequences
  49. Job Opening
  50. PostgreSQL versus MySQL
  51. Image data type equivalent in postgresql
  52. I dont know the error with updtae
  53. Scalability (both vertical and horizontal)?
  54. Cannot Delete
  55. Problem in Function returning Cursors - Postgres Sql 7.2
  56. varchar vs. text
  57. Sort order is different on Windows and Linux
  58. High-volume shop uses PostgreSQL
  59. 7.3.2 client connecting to 7.2.1 server problem
  60. Bug while installing in AIX 5.1
  61. Weird query plan
  62. Why does adding SUM and GROUP BY destroy performance?
  63. Where are PL/pgSQL functions stored?
  64. psql and blob
  65. More general datafiles ?
  66. backend crashing despite tsearch2 patch
  67. Problems requiring a GROUP BY clause on update?
  68. transaction abortion
  69. Database Recovery Procedures
  70. Red Hat 9 Postgres
  71. Question.
  72. char o varchar
  73. Error trigger
  74. update field using substrings of another field
  75. 4D to PostgreSQL tools
  76. CONCAT function
  77. How to ALTER VARCHAR datatype to TEXT ?
  78. date_part('timezone_hour')
  79. Idea for improving speed of pg_restore
  80. Rules question
  81. Odd behaviour -- Index scan vs. seq. scan
  82. after postgres upgrade - ERROR: current transaction is aborted
  83. encoding and parser: error?
  84. Initalizing PostgreSQL Database
  85. Updates with NULL
  86. Mirrors
  87. Fox Trot bows to us
  88. The NT services Cygwin PostgreSQL installatio
  89. is General Bits Issue # 43 correct?
  90. function call
  91. How to remove CLUSTERs and 'partitioning tables'
  92. Cyclic foreign key dependency & table inheritance
  93. Cyclic foreign key dependency & table inheritance
  94. MD5() function not available ??
  95. MD5() function not available ??
  96. Space
  97. pg 7.3.4 and linux box crash
  98. installation of postgres 7.3.4 rpm
  99. installation of postgres 7.3.4 rpm
  100. how to replicate database
  101. "another command is already in progress" error
  102. "another command is already in progress" error
  103. New DBTools Manager 2.2.0
  104. New DBTools Manager 2.2.0
  105. case-insensitive database
  106. BEA Weblogic 8.1?
  107. BEA Weblogic 8.1?
  108. pgSql Memory footprint
  109. pgSql Memory footprint
  110. Why do I need to pass value for Serial type in Insert/Update?
  111. Why do I need to pass value for Serial type in Insert/Update?
  112. Regarding constraint database
  113. Regarding constraint database
  114. PostGreSql database features questions
  115. PostGreSql database features questions
  116. Serial type currval
  117. I need examples of stored procedures returning datasets
  118. I need examples of stored procedures returning datasets
  119. difference when using 'distinct on'
  120. Between(Interval of two dates) in Postgres
  121. Table OraclexPostgresql
  122. Table OraclexPostgresql
  123. Converting database-encoding from SQL_ASCII to UNICODE?????
  124. Converting database-encoding from SQL_ASCII to UNICODE?????
  125. Codepage Win1252
  126. how can i use SELECT to find a substring of a column's data?
  127. library version problem, 7.3.2, php, redhat linux
  128. selecting random rows
  129. Function to convert
  130. Function to convert
  131. Connecting to postgres from a romote machhine
  132. "another command is already in progress" error (fwd)
  133. "another command is already in progress" error (fwd)
  134. How to avoid inlining subquery result columns
  135. How to avoid inlining subquery result columns
  136. Create index in PG table with vb6
  137. Questions about erserver
  138. Questions about erserver
  139. query-question
  140. I need a SQL...
  141. query-question
  142. how to replicate database
  143. I need a SQL...
  144. PostgreSQL for AMD64
  145. PostgreSQL for AMD64
  146. (NONE)
  147. pgsql and Qt apps
  148. 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
  149. A Question About Insertions -- Performance
  150. pgsql and Qt apps
  151. (NONE)
  152. Release date
  153. message type 0x50
  154. C API, PQconnectdb and options Q.
  155. Release date
  156. message type 0x50
  157. 7.4 defaulting to ipv6 ?
  158. help with TCL function
  159. plpgsql doesn't coerce boolean expressions to boolean
  160. Question about conccurrency control and Insert
  161. Constructing column from different individual fields in same row.
  162. plpgsql doesn't coerce boolean expressions to boolean
  163. SUMMARY mysql -> psql
  164. State of Beta 2
  165. Help needed in Replicating pgsql
  166. PL/PerlU problems executing other scripts
  167. bolb data type
  168. Temp tables and copy
  169. Question about conccurrency control and Insert
  170. Kill -9 Postmaster and Temporary Tables
  171. Find overlapping time intervals, how?
  172. Adding header nam to any table
  173. Help needed in Replicating pgsql
  174. PL/PerlU problems executing other scripts
  175. bolb data type
  176. arbitrary data scheme
  177. How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
  178. to_timestamp and to_date fails in postgresql 7.1.3
  179. arbitrary data scheme
  180. Kill -9 Postmaster and Temporary Tables
  181. do child tables inherit indexes?
  182. encoding again
  183. any chance of "like ANY (array[])" like the "= ANY (array[])" syntax?
  184. Picture with Postgres and Delphi
  185. Oracle and regular expressions ???
  186. ECPG bug or development choice
  187. German special characters Problem
  188. mysql create table -> psql
  189. Views and Limits
  190. Good open source mailing list system PHP / Postgresql
  191. Another pimple on the type system
  192. inserting an apostrophe
  193. SRF question
  194. compiling libpq without 'main'
  195. Cannot createdb
  196. How do I unsubscribe
  197. why does count take so long?
  198. Can I use PostgreSQL to develop a self-organizing database system?
  199. Code insertion
  200. Unix domain instead of TCP socket connections with JDBC.
  201. v7.4b2 : How can I use COMMENT ON for Large Objects ?
  202. Does "vacuum analyze" contain "vacuum"?
  203. 7.4 binary version
  204. Reasonable Configuration
  205. Needed function IF(expr, expr, expr)
  206. ODBC Issue
  207. decrypted pwd
  208. Grant and wildcards
  209. aggregate function
  210. C functions
  211. Left join
  212. Detailed error message information
  213. unique heritage
  214. Inquiry From Form [pgsql]
  215. default EXECUTE privilege
  216. Views with Where Clauses
  217. Problem with to_date/to_char
  218. Pagination - 1 or 2 queries?
  219. notify problem
  220. Seq scan of table?
  221. Backup?
  222. searching archives should be a weeeee bit faster ...
  223. More than 1024 connections from the same c-client
  224. FYI: Avoiding write conflict errors in MS Access clients
  225. postmaster processes
  226. IP from conexion
  227. Activate Index
  228. tsearch2 and unexpected exists
  229. Change connection (IP, or Databasename)
  230. WHERE boolean = true -> failure
  231. Missing system views?
  232. Replaceing records
  233. More than 1024 connections from the same c-backend
  234. descending Indexes
  235. PLPGSQL
  236. FATAL 2: open of /var/lib/postgres/data/pg_clog/0004 failed: No such file or directory
  237. The following statement now fails on 7.3.4
  238. table constraint or trigger?
  239. XA Resource Manager
  240. Crosstab function Problem
  241. Use of oids
  242. setting last_value of sequence
  243. Index not being used ?
  244. Inquiry From Form [pgsql]
  245. [SOLVED] Socket command type E unknown
  246. TCL trigger doesn't work after deleting a column
  247. How many memory size takes numeric(3,0) ?
  248. OffsetNumber offnum (LOCKTag)
  249. is it possible to do this? have a subselect that returns two columns
  250. Access to an element of array NEW in TCL
  251. identifying rows locked in row level locking
  252. syntax error in eRServer.pm line 69
  253. What is the good equivalent for ENUM ?
  254. Recursive Selects
  255. Output from PLPGSQL
  256. ERROR: PLPGSQL does not exist
  257. Localization (for dates) Oracle vs. Postgresql
  258. Oracle decode Function in Postgres
  259. pg_dump incorrect sequence value
  260. Debian Woody 7.3.4 packages?
  261. Querying $libdir
  262. Comparing dates
  263. how to call a TCL function from within a plpgsql trigger?
  264. Tomcat Connection Pool?
  265. web hosting postgres
  266. Pass parameters to a TCL function
  267. identifying each individual tuple locked
  268. Table name lengths...
  269. Any way to Convince postgres to push join clause inside subquery aggregate?
  270. absolute value fro timestamps
  271. segfaults / backend crashing
  272. postmaster segfault with tsearch2?
  273. LAST_DAY Function in Postgres
  274. Problems with GRANTING SELECT to a table
  275. ADD_Months Function in Postgres
  276. automatic update
  277. pgadmin3 on Gentoo
  278. Optimizer picks an ineffient plan
  279. adding SERIAL to a table
  280. sort ignoring the, a, ...
  281. Field collection in trigger
  282. French translation
  283. Where is the tool to migrate a mysql db to a PostgreSQL db ?
  284. delivering database stand-alone
  285. Getting last inserted SERIAL
  286. Prevent from Deletion
  287. how to group by a joined query?
  288. Mail test
  289. About GPL and proprietary software
  290. cursor bug
  291. Database corupption on pg 7.3.3
  292. Btrieve
  293. Commercial postgresql
  294. Drop All Foreign Keys ? PostgreSQL 7.2.1
  295. After install 7.3.4, I got a 7.3.3 ver. no?
  296. pg_autovacuum
  297. psql buffering
  298. Errors sending Blob to DB
  299. view function details
  300. LOCK.tag(figuring out granularity of lock)--
  301. Optimizer isn't perfect
  302. Errors sending Blob to DB
  303. PostgreSQL upgrade -> fails to start server
  304. Visual database structure browser for postgresql?
  305. Unsubscribe from the list
  306. Install PostgreSQL on AIX 5.1
  307. Join question
  308. backends
  309. Vacuuming and already vacuumed table?
  310. erserver 1.2 problem
  311. left outer join terrible slow compared to inner join
  312. Date Time Function / Age
  313. Arrays and Indices / Foreign Keys
  314. Problems with transactions and sequences
  315. Database Replication
  316. tsearch: how to get a list of stopwords?
  317. Problem with tsearch and stopwords
  318. mysql to pgsqwl migration
  319. Problem compiling tablefunc module in contributions
  320. postgres vs mysql
  321. Question Join/Subselect
  322. before trigger problem
  323. Localization Oracle vs. Postgresql
  324. Localization Oracle vs. Postgresql
  325. Embedding Postgres "inside" an application
  326. process big
  327. plpgsql , dynamic queries
  328. Recent installed 7.3.4 startup doubt
  329. plpgsql FOUND Variable
  330. Functions have 32 args limt ???
  331. Clarifying File System Syncs
  332. Pg_dump : Can I specify the Password ?
  333. CHAR vs TEXT args
  334. postgresql not using index even though it's faster
  335. FATAL: Socket command type A unknown
  336. pgplsql - Oracle nvl
  337. SQL Command - To List Tables ?
  338. Again about temporary table
  339. PostgreSQL and HA?
  340. problem with upgrading 7.2 -> 7.3.4
  341. Fwd: installing postgres7.3.4 problem II
  342. Excel 97 Export to Postgres
  343. deleting referenced data
  344. Weird psql problem
  345. many columns with references to one table
  346. function restore order
  347. pl/tcl trigger question
  348. Linux ready for high-volume databases?
  349. is linux ready for databases ? (Ziff Davis article on Oracle and Linux)
  350. convert database to unicode
  351. table constraints and performance
  352. Index usage
  353. LOCK.tag(figuring out granularity of lock)--
  354. greek char
  355. support for OO query
  356. How do I find what views depend on a particular table?
  357. LOCK.tag(figuring out granularity of lock)--
  358. Your details
  359. Replication Ideas
  360. merge multiple records into 1
  361. export data from postgresql on linux to ms-sqlserver 2000 on windows
  362. pgsql-mode.el
  363. The ..... worm
  364. WAL Files checkpoint_timeout with voluminous delete/insert
  365. Inserting CR/LF in a select?
  366. convert interval info into days
  367. Strange problem with PL/PgSQL stored procedures
  368. pgAdminII Error
  369. strftime
  370. how to drop table named user
  371. Stored procedure advice needed
  372. timeofday() and CAST
  373. Books for PostgreSQL?
  374. Your details
  375. 7.4b: FATAL: invalid value for "lc_monetary": "US_EN"
  376. Open Transaction list
  377. Changed mailing list functionality?
  378. FK to inherited table, referential integrity violation
  379. uptime problem
  380. Mail server load
  381. native win32 version
  382. Bug with pg_restore?
  383. Bulk Insert / Update / Delete
  384. Call for presentations Linux Solutions 2004
  385. Buglist
  386. move to usenet?
  387. Mailing list in French
  388. Grouping by date range
  389. Temporary tables
  390. 'now' vs now() performance
  391. 3 way outer join dilemma
  392. Example Database
  393. factors determining the execution plan
  394. Are you an pgODBC hacker?
  395. Default Value in Table Setup Help
  396. Hour difference?
  397. Simulating sequences
  398. Cache lookup failed?
  399. Bit String Manipulation
  400. Performance with different index types
  401. Too many clients
  402. Need feedback on new feature (\for)
  403. C vs plpgsql and child processes
  404. insert and heritage...
  405. Database modelling question for version management of data
  406. Dreamweaver
  407. getting execution plans with multiple database connections
  408. New to list, quick question.
  409. parameter in trigger function
  410. join of array
  411. Character conversion issues while upgrading database
  412. Manage PostgreSQL Connections
  413. Importing data
  414. Graphical Mapping a Database
  415. 7.4Beta
  416. can't find files in pg_clog and invalid page headers
  417. tsearch2 in 7.4beta1 compile problem
  418. WAL question
  419. Transaction question
  420. connect to remote db
  421. importing db as text files
  422. HLR/HSS
  423. Usogres - Compilation Error
  424. Vacuuming unicode database
  425. more timeofday() and "set time zone" weirdness
  426. SET TIME ZONE with GMT+X notation
  427. How to get the total number of rows with a query "limit" ?
  428. FTI problems
  429. Tsearch2 lexeme position
  430. postgres as an snmp client
  431. Viewing Client Connections..
  432. Installing DBD::Pg Perl module locally
  433. Installing DBD::Pg Perl module locally.
  434. How to relate an attribute of one table with the attributes of another related table
  435. Simple DBI question.
  436. Sorting Problem
  437. Simple DBI question
  438. general database password
  439. {REPOST, CLARIFIED} How to recognize PG SQL files?
  440. types of constraint deferment
  441. Help! Can't pg_dump anything: handler procedure for procedural language plpgsql not found
  442. optimisation of a code
  443. Update of foreign key values
  444. One table into two different databases
  445. PL/C functions
  446. Join faster than single table query
  447. update system table?
  448. Multilingual database
  449. High volume use of postGres
  450. Concatenating String Literals in pgsql
  451. 7.4Beta1 "failed to create socket: Address family not supported byprotocol"
  452. dbmirror -- recovery question
  453. Authentication problem
  454. PostgreSQL
  455. dumbheaded SQL question (probably join or subselect) - longish
  456. public key functions for postgresql ?
  457. Nesting Groups
  458. Fwd: Nesting Groups
  459. Continued mail server problems for all PGSQL mailing lists I'm on
  460. Temporary table
  461. postgesql-7.3.3 lo_create/lo_open fails
  462. CURRENT_TIMESTAMP causes Postgres to shutdown connection
  463. Moving from MySQL
  464. Random via Subselect or Temporary Table
  465. remove $ from money field
  466. Empty Output? How Do I Determine the Character?
  467. ERROR: Invalid UNICODE character sequence found (0xed5c30)
  468. Anomaly with SUM().
  469. Trying to create a GiST index in 7.3
  470. unexpected chunk number
  471. The database is very slow !
  472. strategies for optimising common lookups etc
  473. toast values
  474. problem with timeofday() function in cvs PostgreSQL
  475. Conditional row grained replication with DBMirror
  476. XML?
  477. PostgreSQL and ACID properties support
  478. postmaster(s) have high load average
  479. Auditing idea
  480. date format?
  481. Retrieving tuple data on insert
  482. Web application and database.
  483. bug?
  484. Database theory question: safe query
  485. Does REINDEX TABLE lock the table?
  486. cross join oddity?
  487. Table compression
  488. extracting x from a point(x,y)
  489. Examples for writing own c functions in postgres
  490. Problem wih a CONSTRAINT CHECK not doing its job
  491. Table partitioning and Rules
  492. Postgresql long term commercial potential?
  493. Postgres Performance -- page size
  494. recompiling with JDBC
  495. multiple postmasters
  496. problem w/CREATE RULE...ON INSERT...INSERT INTO...SELECT...FROM...WHERE w/multiple inserts
  497. Array and Aggregate Functions
  498. Silly database question...
  499. Exporting a PostGreSql database
  500. I don't know much about postgres - can I stored procedures in postgres, like you can in MS SQL?
  501. The better of two table designs?
  502. indexes on columns and functions
  503. Vacuum verbose question
  504. Forcing a query plan
  505. Before trigger question
  506. Synchronising multiple common fields among tables
  507. Using C++ With SPI?
  508. Record locking in deadlock
  509. createlang command line won't work
  510. declaring variables?
  511. Forcing query plans
  512. database names vs. database schemas
  513. Fw: Stored Proc error after modifying field type
  514. Stored Proc error after modifying field type
  515. problems with pg_restore to 7.3.3 db
  516. Installation problem: can't find $libdir
  517. Exporting large objects in 7.0.2
  518. ERROR: fixrdesc: no pg_class entry for pg_class
  519. Vacuuming specific schemas..
  520. which Schema I am working on??
  521. Which Schema I am working on??
  522. Performance question
  523. Duplicate key insert question
  524. Upgrading 7.3 to 7.3.3
  525. ERROR: language "c" is not trusted
  526. ERROR: Relation "pg_user" does not exist
  527. Text datatype as Memo in Delphi
  528. IPv6 data type
  529. new to postgres - can you write stored procedures? If so, please send links to good sites about this
  530. Noobie: Problems with a query
  531. How to import data from ver 7.3.2 to 7.0.2 installation
  532. InitDB fails
  533. PostgreSQL based Wiki engine
  534. PostgreSQL Linked server question with MSSQL2K
  535. Urgent: Input of values (that is, dynamic queries)
  536. pg_restore fails
  537. Is there a port of PostgreSQL working on Windows CE
  538. 1991 and 1992 Black Box Catalogs
  539. How to show database table/view/... declaration?
  540. Web Application "Job Hunter" Updated
  541. access xp postgres data from linux
  542. insert statement question
  543. escaping - sign
  544. query translation
  545. linking to MS Access using ODBC and geometric types?
  546. list tables from PHP
  547. Abstracting SQL Statements In An Object
  548. scroll bug cursor or me?
  549. pg_dump and -t option
  550. A PHP/PostgreSQL E-Zine available