View Full Version : postgresql answers


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

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