View Full Version : postgresql answers


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

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