Home : Bytes IT Community / View Full Version : PostgreSQL

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

  1. postgres.h location?
  2. Help on copy function
  3. passing new.* in trigger
  4. database constraints
  5. Commands to browse current connections and processes
  6. Cache lookup failed for relation, when trying to DROP TABLE.
  7. two digit years in inserts
  8. Determining time of last INSERT/UPDATE/DELETE
  9. Mirroring databases in v8
  10. lower/upper support and cyrillic
  11. SSL connection between PHP4 & PostgreSQL ???
  12. Verifying Referential Integrity
  13. problem with pg_restore
  14. storage representation of DATE and TIME types
  15. looking for Mac pgEdit beta testers
  16. Set locale per query?
  17. Mailing
  18. Function array_to_string(text[], text) does not exist ???
  19. more than one instance of pgpool for a backend?
  20. table localisation
  21. current transaction is aborted, commands ignored until end of transactionblock
  22. Single-file databases -- how do they do it?
  23. pgsql 8 beta document
  24. Cursors and JDBC
  25. trouble installing plpgsql
  26. PostgreSQL 8.0 install woes
  27. LOST REFERENTIAL INTEGRITY
  28. Server getting crushed
  29. mirroring/replication
  30. weird issues with plpgsql calls.
  31. Is Win32 port good for operational use?
  32. SELECT from a set of values really slow?
  33. Application user login/management
  34. GnuPG / PGP signed checksums for PostgreSQL 7.4.5, 7.4.4, 7.3.7, 7.3.6, 7.3.5. 7.2.5
  35. guaranteeing that a sequence never skips
  36. sequence rename?
  37. storing files: blob, toasted text of filesystem?
  38. Query problem...
  39. default select ordering
  40. VACUUM FULL on 24/7 server
  41. earthdistance is not giving correct results.
  42. New Student
  43. newby question
  44. earthdistance results seem to be wrong.
  45. See the good, the bad, and the ugly of your Postgres data with OneClickRevelation(tm)
  46. problem getting started with PostgreSQL 8 beta 3 on XP
  47. Pgadmin III Qustion
  48. error connecting to database
  49. Pgsql installer beta2 dev2 / dev3 freeze
  50. Arjunt......
  51. Random not so random
  52. Postgresql commands to display all functions and process/connections based on a database.
  53. How to debug pl/pgSQL -script?
  54. Bug with updateable Views and inherited tables?
  55. newby question
  56. i'm really desperate: invalid memory alloc request size 0
  57. Repeated VACUUM reports same number of deleted rows
  58. POSTGRES
  59. help me in PostgreSQL 7.4
  60. readline install questions
  61. Accessing an array element from a function
  62. about "pg_dump " without pompt password
  63. Undefined symbols: _poll
  64. postgres start problems with memory
  65. how to encode/encrypt a string
  66. problems with lower() and unicode-databases
  67. Upgrade 7.3.3 to 7.4.5
  68. WinXP + PgSQL 8 beta3 = impossible?
  69. Java application and SPI...(?)
  70. Multiple Rules - an example
  71. Out of memory errors on OS X
  72. How to get user's role?
  73. zero-length delimited identifier in pg_dumpall file
  74. initdb on Debian
  75. 7.3.4 vacuum/analyze error
  76. Index Analysis: Filters
  77. dangling permission on tables after drop user.
  78. COPY FROM STDIN not in local file
  79. failure to restart postgresql service after improper shutdown
  80. Converting to Java date example
  81. string is sometimes null ?
  82. Setting search paths inside a function (plpgsql)
  83. Multiple Rules :: Postgres Is confused !!
  84. Composite Type Argument Construction to a Function
  85. sql script confusion
  86. About PostgreSQL's limit on arithmetic operations
  87. error: unicode characters greater than or equal to 0x10000
  88. Indexes on Expressions -- Parentheses
  89. Controlling order of evaluation?
  90. PostgreSQL Installation Question
  91. mssql linked server to postgres
  92. compiler for functions
  93. To OID or not to OID
  94. postgres v8béta3 on AIX5.2
  95. Custom Functions
  96. FYRACLE better then PostgreSQL ?
  97. Hardware recommendations
  98. .net
  99. Getting an out of memory failure.... (long email)
  100. renaming sequences
  101. Aggregates ?? Datamart (to whatever it has implemented a DataMart using Postgres)
  102. Foreign key order evaluation
  103. Syntax Issue in Trigger Function??
  104. limiting execution time of queries
  105. using ltree with tree structured data
  106. How to terminate an individual client connection gracefully?
  107. could not create socket for statistics collector: Protocol not supported
  108. doubt about the database
  109. core dump on select
  110. Is linked servers possible with postgresql?
  111. inheritance
  112. checksum
  113. Pg8.0 beta2 psql error
  114. Use of 'interval'
  115. IN or JOIN
  116. serial data type
  117. psql password prompt
  118. Modifying users password in pg_shadow from php
  119. figuring out if there was a transaction in this connection already
  120. cvs update: waiting for anoncvs's lock
  121. Returning a list of fields in a composite type
  122. Optmizar query
  123. porting a full Ms Sql Server to postgres
  124. BiggerSQL-1.3.7 released
  125. pg_dump: what is advantage with schema and data dumps?
  126. 8.0 logging question
  127. How to insert values in BYTEA?
  128. Removed and then missing pg_clog file
  129. Postgres inherited table, some questions...
  130. Is linked servers possible with postgresql?
  131. PostgreSQL 8 on Win2003 AD server
  132. How to pass initdb LC_COLLATE & locale parameters when using windows? (with or without pginstaller)
  133. formating interval question
  134. plpgsql-fct. fails on NULL in record variables
  135. Large arrays give long lag on server side before command executes
  136. books/sites for someone really learning PG's advanced features?
  137. default value problem in postgresql 7.4.5-2
  138. data modeler
  139. self referencing table structure and constraints
  140. Restore a especific function
  141. Comparing a varchar of length > 32
  142. How do I disable: Adding missing FROM-clause
  143. using COPY table FROM STDIN within script run as psql -f file.sql
  144. mailing list archive search form broken?
  145. Returning recordsets with functions
  146. pg_hba behavior
  147. v8 on AIX5.2
  148. varchar of length > 32
  149. postmaster.pid file
  150. download documentation as HTML (not PDF)
  151. What lock to use?
  152. start psql
  153. brand new user - should I start with v8?
  154. difference 7.3.xx vs 7.4.xx
  155. Trouble with query logging
  156. Unable to drop DB in latest CVS version
  157. the current scoop on ilike and indexes
  158. Set return function with union all
  159. Prioritizing queries
  160. Oracle / Postgres Interface
  161. abnormal data grow
  162. Stored Procedures
  163. basics on User Defined Functions
  164. Austin User Group
  165. Any reason not to use inheritance?
  166. using database for queuing operations?
  167. New PayPal Donate Option
  168. How to get most frequent and least frequent values in a column?
  169. Weird behavior with selects and composite data types
  170. using schemas to create a virtual DB?
  171. NULL/0
  172. import/export or moving data between databases
  173. Problem in converting int to timestamp value - why?
  174. order of row processing affects updates
  175. pgAdmin III creates dud SQL for create table
  176. pg_restore peculiarities
  177. Vacuum related question
  178. converting FK's to "DEFERRABLE"
  179. Import an Excel table to a Postgresql one
  180. Default value if query returns 0 rows?
  181. Is it possible to get the 7.4.1 static docs in HTML form anymore?
  182. UTF-8 question.
  183. 8.0.0beta2 and plpgsql
  184. Not even JPEGs are safe?
  185. Postgres memory usage
  186. Postgresql <--> webservices?
  187. REFERENCES
  188. Stemmer integration in tsearch2 / $libdir error
  189. lexicographical ordering in postgres
  190. problem with pg_restore and user privileges
  191. table partitioning
  192. Invalid large object descriptor : 0 with autocommit
  193. pg_dump in cycle
  194. ECPG & Mac OS X
  195. support on postgres
  196. Hide databases from users?
  197. pg_locks with users
  198. How to find a column name
  199. Returning Errors from User Defined C-functions
  200. Simple getting-started guide
  201. Getting track of foreign keys
  202. psql error - "unrecognizable command" V8.0.0 beta
  203. division by zero issue
  204. Converting varchar() to text
  205. Creating a two-column sequence?
  206. what is flushed?
  207. Updating another table using a trigger
  208. OS X Mac pgAdmin equivalent?
  209. psql + autocommit
  210. schema level variables
  211. Problems with SPI memory management
  212. Tsearch2 adding additional dictionaries
  213. plpgsql assigning RECORD := RECORD
  214. Checking regex pattern validity
  215. 8.0 postgres book??
  216. fedora core2 pgaccess
  217. postgres book
  218. Spacing in output
  219. different results inside transactions
  220. Changed a column type from "integer" to varchar
  221. 8.0.0 beta 2, void type
  222. Grant
  223. PG case sensitivity
  224. logging rule execution?
  225. plpgsql - raising exceptions with open cursors
  226. Rollback on Error
  227. psql exit status varies for scripts on STDIN
  228. Index inheritance
  229. how to use geometric shapes?
  230. Deadlock removal
  231. Corrupted Data?
  232. Trouble EXITing plpgsql labeled BEGIN blocks with DECLAREs
  233. about C-JDBC for postgreSQL
  234. Number of Active Connections
  235. Building plpython on Mac OSX...
  236. Index inheritance
  237. Autonomous transaction
  238. Questions about Postgresql 8.0
  239. LOG: failed to commit transaction_isolation
  240. Network problem
  241. View efficiency questions
  242. Synchronizing Databases
  243. pass an array as parameter to a function
  244. table with a variable name???
  245. Storing birthday data
  246. PL/pgSQL Function Problem
  247. Text search performance vs MY SQL
  248. Auto increment/sequence on multiple columns?
  249. how to constrain a query to return 1 or 0 rows (or >1 or 0 rows)
  250. Speeding up LIKE with placeholders?
  251. SMgrRelation hashtable corrupted
  252. Best practices for migrating a development database to a releasedatabase
  253. What is the postgres version of mysql's "ON DUPLICATE KEY"
  254. Canceling Query due to user request
  255. unicode and varchar
  256. PhpPgAdmin login weird...
  257. Time zone string not showing
  258. incorrect checksum in control file
  259. pg_attribute.attname
  260. Memory exhausted (leak?)
  261. Where does postgres store records of DROP-ed columns?
  262. referential integrity preventing simultaneous insert
  263. Obtaining the Julian Day from a date
  264. pg_dump/pg_dumpall do not correctly dump search_path
  265. MOVE doesn't return number of rows
  266. Text Search vs MYSQL vs Lucene
  267. 8.0.0beta2: Ownership of implicit sequences after dump/restore
  268. Text search performance vs MY SQL
  269. Migrating from MaxDB to postgresql
  270. postgresql hanging (blocking) with smp kernel
  271. national settings
  272. FYI, Sybase performance study on Linux
  273. function calls in WHERE clause
  274. postgres start error
  275. information schema table names in 8.0.0
  276. Returning multiple values (but one row) in plpgsql
  277. Grant Issues with groups
  278. 8.0.0beta2: gcc: unrecognized option `-pthreads'
  279. 'order by' in an insert into command
  280. SQL query - single text value from group by
  281. Need Help in interface..
  282. Heritage
  283. Function caches wrong OID of temporary table?
  284. Starting and stopping database by JAVA
  285. ERROR: parser: unterminated quoted string
  286. Another Security Question: User-based Roles vs. ApplicationBusiness Rules
  287. Firewall Security Requirements for Postgresql Access
  288. Restoring dump of multiuser databases
  289. Selecting columns by position?
  290. supressing NOTICE messages on Windows/cygwin only not working?
  291. Problems importing data from plain text file
  292. explain with placeholders?
  293. Dumping pg_shadow and pg_database as SQL using pg_dump
  294. Salt in encrypted password in pg_shadow
  295. Pb with ecpg and include file on PG 8.0.0
  296. error: insert has more expressions than target column
  297. Access MDB Schema Import Tool?
  298. ERROR: canceling query due to user request
  299. Postgresql and scripting
  300. changing the password of postres
  301. Help supressing NOTICE messages
  302. restricting non superuser from accessing other databases
  303. postgres 8 performance
  304. resilient transactions
  305. Datatypes Documentation
  306. Pb with ecpg and include file on PG 8.0.0
  307. FAQ: Having Trouble Getting PL/pgSQL Going?
  308. PL-PGSQL language
  309. Passing RECORD variable from func1() to func2()
  310. tg_relation doesn't seem to have the attribute names!
  311. radius authentication
  312. DROP TRIGGER permission
  313. One Database per Data File?
  314. how to query the size of an array in a table
  315. Schema and Group permissions question
  316. Confused with db client encoding
  317. Indexing Order By columns
  318. RAD with postgreSQL
  319. hebrew with MS Access Front End
  320. cygserver -S crashes under Windows 2000/cygwin
  321. initdb crashes under Windows
  322. building postgres for windows 2000?
  323. HOWTO: Get a table or database definition
  324. psql leaking?
  325. Index on TEXT versus CHAR(32)... fast exact TEXT matching
  326. How do I list the schema for a table or procedure?
  327. Where can I get pgsqlodbc now gborg is down?
  328. (NONE)
  329. pl/pgsql exceptions
  330. Ingres versus PostgreSQL
  331. test message -- wondering if the list is down -- please delete
  332. disk performance benchmarks
  333. Overloading || ( text,text ) operator
  334. "echo"ing a psql command in a bash script
  335. postgres "on in the internet"
  336. Debugging
  337. How to determine a database is intact?
  338. How do I do update if insert fails?
  339. pgInstaller project dead?
  340. location of postmaster.log on V8 Win 32
  341. psql \o weirdness
  342. Nicer way to access field
  343. Display of text fields
  344. unix socket error in cygwin postgresql-7.4.3
  345. Can we return a table from a function?
  346. "\d tablename" to get column name, and column type by using JDBC
  347. C Function causes backend to die in 7.4.3
  348. Ensuring data consistency - main table and multiple 'details' tables.
  349. search_path problem
  350. Foreign key locks
  351. vacuum full for all databases
  352. plpgsql function
  353. The future of built-in geometric data types
  354. Interval literal not ANSI compliant
  355. materialized view
  356. Understanding pg_autovacuum CPU Usage
  357. can't build libpq with beta 2
  358. beta2 not finding openssl
  359. possible memory leak in 8.0 beta 1
  360. stand-alone psql
  361. PostgreSQL and Fedora?
  362. VISIO and System Tables
  363. pg_autovacuum (7.4) nss_ldap oddity
  364. <> syntax legal?
  365. Join efficiency
  366. insertiing an image file (blob) into postres...
  367. Importing data from MS Access
  368. Exporting/moving Postgress Instance
  369. Performance on 7.4 vs 7.2?
  370. Python Postgresql support?
  371. Error Message Importing Into PostgreSQL (Using phpPgAdmin)
  372. Suppress output from psql?
  373. expected both swapped tables to have TOAST tables
  374. Rule/sequence weirdness
  375. Large Databases
  376. zombie primary key lurches out of database to devour the brains of the unwary
  377. About "lock file postmaster.pid" Error , cannot setup postmaster
  378. Substring result short by 1
  379. Types and SRF's
  380. Not able to build libpq for Windows
  381. Multicolumn Primary Key
  382. Microsoft Project and PostgreSQL?
  383. Change config of running PGSQL
  384. functions/stored procedures
  385. sequences in schemas
  386. pltcl.so problem..
  387. Overloading '<' operator
  388. Storing a query plan to disc...
  389. Problems inserting data in Unicode format
  390. DB failure?
  391. psqlodbc-07.03.0200 --with-iodbc won7t compile on Mac OS X
  392. Forcing a stored procedure recompile
  393. Conditional foreign key?
  394. update trigger performance
  395. functionality like Oracle's "connect by"
  396. Copy Table from Text File; Start at Line Number X Rather than at Beginning of File
  397. Generic/Common trigger
  398. Hebrew support -- please help !
  399. Problem with select and null
  400. Representating a family tree
  401. is last modified timestamp for tables recorded in any system table(s)?
  402. Process locked in INSERT: how to debug?
  403. European dates with Win32 version
  404. Technical recommendations
  405. timestamp and date behaviour with '-infinity'
  406. weird error during pg_dump
  407. malformed array literal in 8beta1
  408. RSS Feeds are dead on Web site
  409. Primary key inheritance problem
  410. Single Row Table?
  411. Equivalent to Oracle's inline CURSOR in a SELECT clause?
  412. Migrating between versions. Problem with regexp
  413. Functon no longer supported. Why?
  414. Regression errors on beta1?
  415. SPI query...
  416. Introducing another primary key field?
  417. PSql won't Let me Set Varchar Column to 'true'
  418. Problem with sql COPY command
  419. pg_autovacuum start-script
  420. job for sql, pl/pgsql,gawk,perl or ??
  421. Primary key inheritance problem
  422. Strange difference in query execution time
  423. Audit
  424. grid things and postgres
  425. postgresql, odbc and escape characters?
  426. owner orphaned databases
  427. performance of IN (subquery)
  428. Creating Functions in Separate Schema
  429. space taken by a row & compressed data
  430. detecting a dead db not seeming to work
  431. stone-age maintenance procedures ;-)
  432. Trigger question
  433. Stored procedure failure
  434. Alter field type?
  435. FK question
  436. Querying large record sets
  437. Constraints to Guarantee unique across tables with foreign key?
  438. EXPLAIN ANALYZE total runtime != walltime
  439. Variable record fetching
  440. IP clash in the PC
  441. Aggregate query for multiple records
  442. update table from internet site
  443. Timestamp with Timezone
  444. pgTcl and Refcursors
  445. The Slony General List
  446. any solution for full text search in Postgres for partial words
  447. help with trigger
  448. copy a database
  449. monitor+keyboard+mouse together
  450. Missing FROM clause
  451. Ordering by IN
  452. Substring RegExp Extract path
  453. no JDBC driver source with 7.4.5?
  454. Deadlocks caused by referential integrity checks
  455. Gentoo for production DB server?
  456. NAB : insert into <table> select distinct <fields> => when used on null, distinct causes loss of type knowledge
  457. Is this legal SQL? Is it a good practice?
  458. Checking whether postgresql is running
  459. Using Postgres with large number of databases per server
  460. PLPGSQL Install Help
  461. SELECT to an external file
  462. Is it possible...
  463. Not able to build libpq for Windows using 8.0.0 beta1
  464. pg_stat_activity versus ps
  465. Invalid input for integer on VIEW
  466. select ... where <column>='' does a seqscan [auf Viren geprueft]
  467. problems with pg_dump
  468. Bad planner results
  469. replace array values in a select statement
  470. Possible to insert quoted null value into integer field?
  471. pg_dump/psql fails on win32 beta 8.0
  472. Problems with building libpq for windows
  473. Deadlocks -- what can I do about them?
  474. database troubles - various errors
  475. libpq on the server
  476. Connection to a PG 8.0 Beta 1 win32 server
  477. postgres replication only some datas
  478. select columns and its data types
  479. view triggers/procedures
  480. Catching server shutdown in C
  481. pg_dump in stand alone backend
  482. Pgsql beta 8 on windows starts and stops automatically.
  483. restoring a .dmp file to another table name
  484. Python and 8.0 beta
  485. Greatest/Least functions?
  486. About inheritance
  487. Few questions on postgresql (dblink, 2pc, clustering)
  488. Killing a session
  489. ERROR: duplicate key violates unique constraint "pg_class_oid_index"
  490. how do I select unions into a temp table
  491. Cross-datatype Comparisons and Indexes
  492. Log Clutter
  493. problem with postgresql-dump while upgrading to 7.4 format
  494. Postgres filling up hard drive with swap files
  495. Adding missing FROM-clause entry for table "customer"
  496. Libpq and Stored Procedures
  497. Stored Procedures and libpq library
  498. 7.4.5 release
  499. insert waiting
  500. Indexes
  501. libpq or Embedded SQL in C
  502. 8.0 release schedule?
  503. need help
  504. int8, primary key, seq scan
  505. need help with copy function
  506. How to setup default value "0000-00-00" for "date" type under PostgreSQL?
  507. function runs on Windows not on solaris
  508. multimedia on postgresql
  509. Fw: Strange UNICODE sort order
  510. Forwarding kerberos credentials
  511. Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
  512. Finally tsearch works ... somehow... remain a few questions
  513. possible bug in exception handling code? (postgres8.0beta)
  514. Stored Procedures woes
  515. select count(*) from pg_stat_activity in V8.0.0
  516. PostgreSQL 8.0.0 - Win32 C-Language function how to?
  517. Vacuum, per table or entire database? what is better?
  518. BUG: 8.0 beta1 does not run on Windows 2000 Terminal Server
  519. Managing caches for multi-cluster HP-UX box
  520. can postgresql handle these large tables
  521. Could not create a table named "USER" under postgreSQL
  522. FATAL: invalid frontend message type 8
  523. Installing FullTextSearchTool tsearch2
  524. Postgresql feature
  525. scripting & psql issues
  526. Postgres and JBOSS
  527. manually setting a 'for each statement' to 'deferrable initially deferred' -> any unforeseen side effects?
  528. psql - user defined SQL variables
  529. pg_dump feature request: Exclude tables?
  530. indexed column not working as fast as expected
  531. Fw: libpq or Embedded SQL in C
  532. pg_dump feature request: Exclude tables?
  533. Problem analyzing performance of query
  534. (S)RPMS for 7.4.4 released.
  535. PANIC: btree_split_redo: lost left sibling?
  536. Any recommended forums/wiki/blog s/w that uses PostGreSQL?
  537. apple uses Postgres for RemoteDesktop 2
  538. [Fwd: Slony-I release 1.0.2 includes PostgreSQL 8.0 support]
  539. Problems using count() with a join
  540. pg_clog and pg_xlog empty, postgresql refuses to start
  541. pg_dumpall outputs incorrect sql
  542. Pgsql 7.3/7.4/8.0 on IA64 HP-UX 11i?
  543. making two tables with identical schemas appear as one
  544. Thousands of parallel connections
  545. could not find block containing chunk 0x8483530
  546. Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?
  547. distinct and equal operator
  548. major database breakdown
  549. PostgreSQL 8.0.0 - Win32 C-Language function how to?
  550. postgres in freebsd jail