Home : Bytes IT Community / View Full Version : PostgreSQL

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

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