View Full Version : postgresql answers


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

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