Home : Bytes IT Community / View Full Version : PostgreSQL

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

  1. Postmaster won't shut down
  2. Access Conversion
  3. help needed regarding Query processing in postgres
  4. COPY TO order
  5. Errors in transactions
  6. running postgresql database from loopback filesystem?
  7. Data Encryption in PostgreSQL, and a Tutorial.
  8. Why would query return PGRES_NONFATAL_ERROR?
  9. Sorting in Unicode not working
  10. Accented chars in several apps
  11. Select/Group by/Order by question
  12. Upgrading from 7.3.6 to 7.4.2 pg_dumpall question
  13. pgsql yum update for Fedora system?
  14. Postgresql yum update for Fedora Core 1 system?
  15. Error Message from pgsql v7.3.6
  16. First Question: to_char statement problems
  17. To_char statement problems
  18. Date Comparison Help
  19. extract epoch and index scanning
  20. Orphaned trigger -- bug?
  21. pg_ctl problem
  22. Big string using Zeos from Delphi
  23. Oid problem
  24. Problem with pg_dump - reg.
  25. eval in plpgsl
  26. MacOS X, Postgresql and Aqua Tcl/Tk
  27. Moving from narrow to wide tables
  28. Are functions automatically transactioned?
  29. ERROR: invalid memory alloc request size 0
  30. Error numbers
  31. timestamp precision with or without timezones
  32. \? not working in psql
  33. How to list domains
  34. Can the username calling a function be made available within thefunction?
  35. How estimated rows is running ?
  36. More aggregate functions?
  37. Informations about functions ...
  38. Tcl load command and mac os x
  39. Logging database and statement with errors
  40. PERFORM statement inside procedure
  41. Crash in postgres/linux on verly large database
  42. Subqueries failing inside pl/pgsql fuction called by trigger
  43. ignore
  44. pg_autovacuum won't make on FreeBSD
  45. Upgrade
  46. ignore this test
  47. set timestamp oddness
  48. domains
  49. Date differences
  50. left and overleft/notright revisited: why !>> and !<< might be poornames
  51. Cursors and Transactions, why?
  52. Storing jpgs
  53. Evening in NYC
  54. Mirroring tables from Oracle to Postgresql
  55. Need to replace PostgreSQL 7.4 with 7.3 on cygwin
  56. Optimize query
  57. Version 1.0.0.4 released
  58. RPM init-script: Why the locale setting?
  59. Invalid page header in block...
  60. Creating a trigger function
  61. Recursive FOREIGN KEY?
  62. thread_test.c problems
  63. Best Practices for Storing Set Combinations
  64. postgres 7.4.2: float(20) results in error msg, but should not since7.4)
  65. Problem in calling prepare statement from STORED PROCEDURE
  66. namespace dilemma
  67. relfilenode on 7.2.3
  68. Casting int to bool with join...
  69. Storage cost of a null column
  70. execute function after user connect
  71. Optimization on UPDATEs and FOREIGN KEYs...
  72. PostgreSQL 7.4.2 warnings in HPUX IPF: LOG: could not resolve "localhost": host nor service provided
  73. glibc update.. effect on PG
  74. FUNCTION problem
  75. Loading text files into a text attribute
  76. Create Type Problem
  77. SQL Question: Query for Newest Records
  78. Problems compiling Apache 2.0.49 with mod_auth_pgsql
  79. Some Aberdeen report
  80. Compound keys and foreign constraints
  81. Select Union
  82. A simple question about Read committed isolation level
  83. Problems Vacuum'ing
  84. 7.2.3-7.4.2 migration
  85. Problem restoring Database
  86. Checking FKs after COPY and disabled Triggers
  87. Whats missing from postgresql
  88. recursive trigger
  89. 7.4.1 upgrade issues
  90. ECPG - bug in EXEC SQL WHENEVER NOT FOUND?
  91. why is this index not being used?
  92. Postgres dump utility
  93. copy command verbose
  94. Large table performance and vacuum
  95. PHP on slackware
  96. Setting up Postgres on Linux
  97. Trigger Update Issue
  98. relocatable binary distribution
  99. extented ascii problem
  100. Management of "varchar types"
  101. sum of a time column
  102. performance problems: join conditions
  103. building 7.4.1 (on linux) with --disable-shared
  104. ERROR: function round(double precision, integer) does not exist - WTF?
  105. Question on stored functions
  106. Tom Lane heads up
  107. ORDER by Clauses do not seem to be working correct
  108. Fastest way to query limited time ordered data set
  109. Setting up Postgresql on Linux
  110. Aggregate function capability with \d in psql
  111. Enable/Disable triggers
  112. Information about a column
  113. Inherited tables and foreign keys
  114. clarification of postgres limitations
  115. Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?
  116. need advice.
  117. using Postgres to store many small files
  118. Setting up Postgresql in Linux
  119. REFERENCES error message complaint, suggestion
  120. Slony-I makes progress
  121. gist index build produces corrupt result on first access totable.
  122. Mistake in my query or Index Scan on subquery failure? (7.4)
  123. Error message
  124. autocommit to off?
  125. making a copy of a table within the same database
  126. How index are running and how to optimise ?
  127. Large Object
  128. Trigger using 'if NEW = OLD'
  129. SPI memory managment issue
  130. Selecting reals into doubles
  131. plpgsql trigger function with arguments
  132. constraints
  133. ת·¢: docs on tsearch2
  134. Record order change after update
  135. Max/min of 2 values function, plpgsql efficency?
  136. max table size
  137. Data in table changed?
  138. More info on table fields
  139. Installing Postgresql in Irix
  140. how to detect last change
  141. can you run a psql command line query?
  142. How to Cancel a query ?
  143. Setting up Postgresql on Linux
  144. sql query to get field types
  145. Linux Labs
  146. using the "copy from" command
  147. libpq API for PQcmdTuples()
  148. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  149. using the "copy from" command to load tables from a txt flat file
  150. ORDER BY problem
  151. INSERTS and Queries
  152. Different version of PostgreSQL on same machine?
  153. elog: out of memory
  154. A simple question (under pressure :-))....
  155. referring to computed values from the select list in the where andorder clauses
  156. count(1) return 0?
  157. Postgres slow after a couple of days
  158. Are Triggers Synchronous
  159. dumping fields from Perl
  160. inlined sql functions in 7.4
  161. ispell tsearch2 dictionary
  162. SERIAL type - auto-increment grouped by other field
  163. inheritance of triggers (OO tables)
  164. Korean characters in a SQL_ASCII database?!?
  165. Where are the backend/commands?
  166. postmaster out of memory....
  167. help with correlated delete and outer join
  168. pgCluster in production environment
  169. Memory usage
  170. Triggers per transaction, workaround? prospects?
  171. Copying data from one table to another
  172. installation -- help ?
  173. Trigger function aborts the transaction on exception
  174. value too long error
  175. Postgresql bajo Windows Míralo Ve
  176. setting datestyle for different databases within a cluster
  177. Regarding BITs vs. INTs
  178. clear defunct entries from pg_stat_activity
  179. Restoring a table with a different name
  180. XML Challenge
  181. PostgreSQL in Cluster
  182. Here there is a Postgresql for Windows Sample APP
  183. On Update (trigger hint)
  184. field must appear in the GROUP BY clause or be used in an aggregatefunction?
  185. compartmentalizing users
  186. PostgreSQL insert speed tests
  187. Case of strings
  188. check for user validity
  189. change db encoding
  190. correlated delete with "in" and "left outer join"
  191. Simple, but VERYuseful enhancement for psql command - or am I missing something?
  192. Help with a query
  193. Postmasters pile up
  194. Postgres clustering?
  195. Hostname change - pgsql won't start
  196. PostgreSQL on XFS experiences?
  197. [PgSQL 7.4.1] Problem with subquery
  198. PL/pgSQL debugger
  199. help using arrays in a function
  200. Windows Library for libpq
  201. postgreSQL licenseing
  202. Simplyfying many equals in a join
  203. How to drop sequence?
  204. reindexing, pg_class (and other system tables)
  205. key = currval('tab_key_seq') choses SEQSCAN?!
  206. REINDEX issues
  207. TG_RELNAME problem
  208. Moving from MySQL to PGSQL....some questions
  209. invalid memory alloc request size
  210. tsearch2 trigger alternative
  211. PLSQL Question regarding multiple inserts
  212. Inheritance and column references problem
  213. select statement against pg_stats returns inconsistent data
  214. Sequence Permissions.
  215. Rows to columns
  216. Irreversible performance drop after increasing shared mem
  217. dynamic views
  218. ON DELETE RULE problem
  219. Why does app fail?
  220. Column headings using Comment?
  221. Create Schema functionality question
  222. Found this in the server log on MAC OSX
  223. DBD::Pg 1.32 ready for testing
  224. Meet this embebed postgresql in Visual Basic
  225. Binary data in PostgreSQL
  226. HELP with a Query
  227. backup and restore questions
  228. Problems with plpgsql and FOR loops
  229. Replication options
  230. finding out actual tuple size
  231. Post gresql commands
  232. Join with equals?
  233. embeding postgre
  234. PHP + Postgres: More than 1000 postmasters produce 70.000 contextswitches
  235. How can I delete a primary or foreign key?
  236. Inherited tables and column references
  237. Slow queries in PL/PGSQL function
  238. pg_restore problem
  239. Modular application needing additional columns?
  240. Replication options
  241. postgresql & unicode
  242. Edit Tables...
  243. Inner join question
  244. Refer to n'th field of a table?
  245. How do I get query result(select e.g.) from a dynamic command(EXECUTE)?
  246. VACUUM Question
  247. Big Tables vs. many Tables vs. many Databases
  248. wishlist: dynamic log volume control
  249. Prepared statements and cursors
  250. [Re] Need help with postgresql/apache/php optimisation
  251. pg_dumpall dies
  252. cannot use createlang after removing public schema
  253. Adding Functionality
  254. autodoc and debian
  255. Numbering a records
  256. Differences between postgres and mysql
  257. pg_dump and pg_dumpall fail when trying to backup database
  258. Select statment question
  259. CRM Academic Research Request
  260. how to merge a table from another DB
  261. GPG MD5 Checksum for postgres 7.4
  262. pg_dump and circular dependency
  263. Reuse of Subselects
  264. String manipulation
  265. summary aggregate information from a second table
  266. function returning a record
  267. psql, 7.4, and the \d command
  268. Repost: Syntax - or unavailability of same - for variable join??? Can anyone help?
  269. Cascade delete triggers change user credentials
  270. Dates
  271. to_char problem
  272. using a .postgresql/root.crt
  273. Select for update, locks and transaction levels
  274. Fosdem
  275. How do I call multiple functions in one trigger?
  276. PostgreSQL on Windows
  277. Replication in postgresql
  278. Inputting columns of data
  279. tsearch2: restoring problem
  280. Dazed and Confused
  281. making tsearch2 dictionaries
  282. Pg + perl + apache
  283. Best replication options
  284. Wire protocol v3 details
  285. postgresql system column errors
  286. SQL99 IGNORE
  287. Index storage question...
  288. Providing the password to psql from a script
  289. nonblocking libpq large object access?
  290. How to determine current database?
  291. resource monitoring
  292. Using NOTIFY... Slow Client Querys
  293. timestamp/date comparison
  294. Too much CPU usage
  295. inheritance vs performance
  296. update set x=(subquery on same table)
  297. Join 2 aggregate queries?
  298. Looking for Developer with Postgresql experience
  299. Mysql to Postgresql
  300. Schizophrenic design and solution to it
  301. Idle Connection force-close ?
  302. help with query speed
  303. Connect to PostgreSQL with kylix3
  304. PostgreSQL on OpenSSI
  305. error when executing dynamic commands with transaction
  306. Migrating 7.1.3 to 7.3.4 problem
  307. Not using index
  308. Error language Python (trusted)
  309. Is a capital letters title for this ML blocked?
  310. No More Processes
  311. Prepared queries
  312. createdb feature request
  313. Anyone used GForge?
  314. pl/pythonu
  315. Function parameters of rowtype
  316. Converting timestamps and IP addresses
  317. pg_class and relfilenode
  318. Temporary views
  319. Join query on 1M row table slow
  320. PQunescapeBytea
  321. Changing schema owner?
  322. Duplicate oid and primary key values
  323. Now that I have --enabled-nls...
  324. pl/pythonu and Triggers
  325. Strange Slow query
  326. number of rows in a cursor
  327. Please help re function packaging...
  328. IP adrss and networks in Postgresql
  329. FWD: Try on these correction update for Windows
  330. book for postgresql
  331. db_space
  332. odbc problems
  333. CPU Usage
  334. Oracle SQLNet on same server as Postgres
  335. setting default value by "trigger"
  336. Quad Xeon vs. Dual Itanium
  337. Increasing Max Connections Mac OS 10.3
  338. TSearch and rankings
  339. functions and temporary tables
  340. Check for prepared statement
  341. query progress indicator
  342. disallowing multiple NULLs in a unique constraint
  343. Foreign Key on Inheriting Table?
  344. fsync = true beneficial on ext3?
  345. piping output to file
  346. Repost: postmaster growing to consume all memory
  347. Partial index in other DB
  348. CREATE BLOB
  349. Where do I find the init-script
  350. Unable to create a PL/PGSL function : Did I miss something ?
  351. benchmarks?
  352. connectby for BYTEA keys
  353. duplicate key violates unique constraint "pg_class_oid_index"
  354. Can anyone recommend accounting software using PGSQL?
  355. SHOW TABLES ?
  356. Syntax (or unavailability of same) for variable join results?
  357. Indexes and sorting
  358. retrieving parts of a resultset
  359. Getting table attributes
  360. PL/Ruby
  361. how can I select into an array?
  362. Run 2 versions of Postgresql on one machine?
  363. Casting 'record' to a composite type.
  364. Starting the Server ?
  365. Upcoming events: Chemnitzer Linux-Tag
  366. pgsql 7.4.1 copy - end-of-copy marker corrupt
  367. Sort order confusion
  368. Analyze not doing anything?
  369. functional index "real world" uses
  370. : Proper tool to display graphics?
  371. ERROR: column 'xxx' does not exist (under v. 7.4.1)
  372. dblink - custom datatypes don't work
  373. pg_restore and large files
  374. size of mailing lists?
  375. Proper tool to display graphics?
  376. Can LIKE use indexes or not?
  377. dblink: rollback transaction
  378. Improving performance with a Function instead of a View
  379. Predictive or scoring solution for PostgreSQL ?
  380. Wrong week day language
  381. Copying tables between databases
  382. Resize varchar column
  383. Transaction end on error
  384. RETURN NEXT and reversing order
  385. application developers list?? or report engine using postgres?
  386. BLOB problem
  387. Anyone has nls activated on Mac OS X?
  388. problem with jdbc connection to postgesql
  389. Specifying a index
  390. large crontab database design
  391. Multicolumn Indexing using R-Tree
  392. Copy and xml files
  393. Before ship 7.4.2
  394. recursive query?
  395. Transfer database tables to a schema
  396. cannot extend error
  397. Select Question
  398. Return Value of a Function
  399. Postgresql 7.3 And Redhat Enterprise 3
  400. isolating users from each other
  401. How to kick out automatically stuck in queries
  402. Array in stored procedure
  403. Error with pg_restore (parse error at or near "BY" at character 144
  404. Functions in CHECK constraint not getting dumped before tables.
  405. partial indexes
  406. Search across multiple sources
  407. Does SET STATISTICS lock the table?
  408. Incorrect Results From Select When Using Non-English Characters
  409. Problem with function
  410. Help: System requirements for postgresql 7.4.1
  411. Viewing detailed lock information
  412. How to...
  413. select ... distinct performance
  414. Using PostgreSQL to store ip traffic information
  415. Insert question null/not null serial, etc.
  416. Fw: [JDBC] Trigger function aborts the transaction on exception
  417. Large object insert/update and oid use
  418. Unicode vs SQL_ASCII DBs
  419. PostgreSQL 7.4.1 and pgdb.py
  420. Two joins on same foreign key
  421. DB cache size strategies
  422. Are there commands to enquire about table structure?
  423. Problem with API (libpq) - detailed error codes
  424. IDENT and pg_hda.conf
  425. No Database Drivers
  426. subqueries vs. separate queries
  427. Planner configuration
  428. Grant question
  429. A strange Vacuum error ...
  430. Pl/tcl auto-load problem
  431. Very slow query - why?
  432. Specifying many rows in a table
  433. Single step Sql script GUI editor
  434. 7.3.4 freezing
  435. Sorting is ignoring spaces
  436. Seaching without accents
  437. Interest in database-based email?
  438. Help, I've killed my system?
  439. Fw: postgres DB duplication
  440. Manually authenticating users in pg_shadow
  441. Is autocommit=true bad?
  442. Call a function when a User (dis)connects from the Server/Database
  443. Logging all queries
  444. Looking for mail relays ...
  445. Postgress resumes ...
  446. Adding missing FROM clause - thanks or no thanks?
  447. Increase stored proc. parameters max count
  448. How can the sequence become out of sequence?
  449. Broken Link on techdocs
  450. Permission Problems:-)?
  451. Reloading Template1
  452. Foreign keys on inherited attributes
  453. postmaster growing to consume all memory
  454. Embedded transactions
  455. crlf and copy
  456. how to enumerate rows ?!?
  457. pg_largeobject and oid mistmach after restore
  458. Executing a query and returning the result set using the SPI
  459. Where is initdb?
  460. Global variables for plpgsql stored procedures
  461. Casting varchar to interval.?
  462. Storing Configuration settings for a database?
  463. About Privileges
  464. Object Relational features in PostgreSQL
  465. COPY, \\copy, and "\357\273\277"\n ^
  466. Multiway associations
  467. I can't upgrade to PostgreSQL 7.4 in RedHat 9.0
  468. on cascade set null works on not null columns
  469. Is there something like an dynamic view ?
  470. pl/pgsql docs 37.4.3. Row Types -- how do I use this function?
  471. force drop of database others are accessing
  472. Calling triggers with arguments
  473. If table A value IS NULL then table B
  474. business references for postgresql
  475. sequence in schema -- broken default
  476. Optimizing SQL: bind variables, prepared stms, histograms
  477. Upcoming events
  478. Nearby zipcodes from a point
  479. psql: relocation error: psql: undefined symbol: PQgetssl
  480. Parsing bug?
  481. regex in plpgsql function
  482. LIVE Coverage of LinuxWorld Conference & Expo | LinuxWorld - where isPostgresql
  483. Want a job?
  484. trust auth in 7.4
  485. Why does the sequence get out of sequence?
  486. varchar_pattern_ops in 7.3.4?
  487. Lost plpgsql function
  488. Question and search for ODBC related postgreSQL questions
  489. Update inside (Insert) Trigger and Unique constraint...
  490. What is holding a connection open.
  491. tablespaces a priority for 7.5?
  492. Compiling postgres-7.4.1
  493. Linux Magazine/Postgres Article
  494. postgresql + apache under heavy load
  495. Idle connections - Too many clients connected already
  496. Ending transaction inside stored function
  497. CTTAS w/ DISTINCT ON crashes backend
  498. SCO Extortion
  499. Referencing subselect returned value
  500. PostgreSQL and Datawarehouse tools
  501. Accessing template0 tables
  502. postGresql Consulting ??
  503. Recursive optimization of IN subqueries
  504. Transaction id
  505. ORM, XPath, and pgxml_dom segfaulting
  506. JDBC Driver moved to gborg.
  507. Can't backup! pg_dump/pg_restore not updated with 7.4.1
  508. Getting rid of duplicate tables.
  509. How to get the requested columns in a rowtype PL/pgSQL function
  510. Attaching files to the database.
  511. Converting from Progress 4GL and DBMS
  512. Very long time to commit or close connections
  513. Introduced PostgreSQL for Windows
  514. Integer ranges in PostgreSQL
  515. Tool to ease development of plpgsql
  516. Tool to ease development of plpgsql
  517. Great change (size of data dir) upgrading postgresql
  518. computed field on a table
  519. Using a Makefile during database development
  520. importing data
  521. Automatic joins?
  522. massaging data from multiple timezones
  523. How should I get started?
  524. 7.4 -> 7.4.1 upgrade with customization on freebsd
  525. I got bit by that darn GEQO setting again...
  526. error creating sql function
  527. Tool to ease development of plpgsql
  528. UNICODE-encoded database does not accept umlaut-characters.
  529. Postgresql reporting tool
  530. Potential Problem with PostgeSQL performance on SuSE Linux 9.0
  531. User-specific sequences
  532. plpythonu AKA am I crazy? or....
  533. Problems with \copy and delimiters ','
  534. simple tree in postgress
  535. Adding long text to a database text field generates errors
  536. FAQ (disk space)
  537. serverless postgres, embedded firebird, etc.
  538. Creating GUID
  539. How to become a Windows beta-tester?
  540. Index space reusable?
  541. check date validity
  542. tinterval operators and functions
  543. how to catch the error in procedure ?
  544. transactions in c api (libpq)?
  545. User-specific sequences...
  546. What Version Installed?
  547. why isn't TEXT a key word?
  548. Survey: Motivations to Contribute
  549. CASE SELECT syntax
  550. Bytea/Large Objects/external files best practices