View Full Version : answers

Pages : 1 2 3 [4] 5 6 7 8 9 10 11
  1. functions/stored procedures
  2. sequences in schemas
  3. pltcl.so problem..
  4. Overloading '<' operator
  5. Storing a query plan to disc...
  6. Problems inserting data in Unicode format
  7. DB failure?
  8. psqlodbc-07.03.0200 --with-iodbc won7t compile on Mac OS X
  9. Forcing a stored procedure recompile
  10. Conditional foreign key?
  11. update trigger performance
  12. functionality like Oracle's "connect by"
  13. Copy Table from Text File; Start at Line Number X Rather than at Beginning of File
  14. Generic/Common trigger
  15. Hebrew support -- please help !
  16. Problem with select and null
  17. Representating a family tree
  18. is last modified timestamp for tables recorded in any system table(s)?
  19. Process locked in INSERT: how to debug?
  20. European dates with Win32 version
  21. Technical recommendations
  22. timestamp and date behaviour with '-infinity'
  23. weird error during pg_dump
  24. malformed array literal in 8beta1
  25. RSS Feeds are dead on Web site
  26. Primary key inheritance problem
  27. Single Row Table?
  28. Equivalent to Oracle's inline CURSOR in a SELECT clause?
  29. Migrating between versions. Problem with regexp
  30. Functon no longer supported. Why?
  31. Regression errors on beta1?
  32. SPI query...
  33. Introducing another primary key field?
  34. PSql won't Let me Set Varchar Column to 'true'
  35. Problem with sql COPY command
  36. pg_autovacuum start-script
  37. job for sql, pl/pgsql,gawk,perl or ??
  38. Primary key inheritance problem
  39. Strange difference in query execution time
  40. Audit
  41. grid things and postgres
  42. postgresql, odbc and escape characters?
  43. owner orphaned databases
  44. performance of IN (subquery)
  45. Creating Functions in Separate Schema
  46. space taken by a row & compressed data
  47. detecting a dead db not seeming to work
  48. unsubscribe
  49. stone-age maintenance procedures ;-)
  50. Trigger question
  51. Stored procedure failure
  52. Alter field type?
  53. FK question
  54. Querying large record sets
  55. Constraints to Guarantee unique across tables with foreign key?
  56. EXPLAIN ANALYZE total runtime != walltime
  57. Variable record fetching
  58. IP clash in the PC
  59. Aggregate query for multiple records
  60. update table from internet site
  61. Timestamp with Timezone
  62. pgTcl and Refcursors
  63. The Slony General List
  64. any solution for full text search in Postgres for partial words
  65. help with trigger
  66. Display of text fields
  67. copy a database
  68. monitor+keyboard+mouse together
  69. Missing FROM clause
  70. Ordering by IN
  71. Substring RegExp Extract path
  72. no JDBC driver source with 7.4.5?
  73. Deadlocks caused by referential integrity checks
  74. Gentoo for production DB server?
  75. NAB : insert into <table> select distinct <fields> => when used on null, distinct causes loss of type knowledge
  76. Is this legal SQL? Is it a good practice?
  77. Checking whether postgresql is running
  78. Using Postgres with large number of databases per server
  79. PLPGSQL Install Help
  80. SELECT to an external file
  81. Is it possible...
  82. Not able to build libpq for Windows using 8.0.0 beta1
  83. pg_stat_activity versus ps
  84. Invalid input for integer on VIEW
  85. select ... where <column>='' does a seqscan [auf Viren geprueft]
  86. problems with pg_dump
  87. Bad planner results
  88. replace array values in a select statement
  89. Possible to insert quoted null value into integer field?
  90. pg_dump/psql fails on win32 beta 8.0
  91. Problems with building libpq for windows
  92. Deadlocks -- what can I do about them?
  93. database troubles - various errors
  94. libpq on the server
  95. Connection to a PG 8.0 Beta 1 win32 server
  96. postgres replication only some datas
  97. select columns and its data types
  98. view triggers/procedures
  99. Catching server shutdown in C
  100. pg_dump in stand alone backend
  101. Pgsql beta 8 on windows starts and stops automatically.
  102. restoring a .dmp file to another table name
  103. Python and 8.0 beta
  104. Greatest/Least functions?
  105. About inheritance
  106. Few questions on postgresql (dblink, 2pc, clustering)
  107. Killing a session
  108. ERROR: duplicate key violates unique constraint "pg_class_oid_index"
  109. how do I select unions into a temp table
  110. Cross-datatype Comparisons and Indexes
  111. Log Clutter
  112. problem with postgresql-dump while upgrading to 7.4 format
  113. Postgres filling up hard drive with swap files
  114. Adding missing FROM-clause entry for table "customer"
  115. Libpq and Stored Procedures
  116. Stored Procedures and libpq library
  117. 7.4.5 release
  118. insert waiting
  119. Indexes
  120. libpq or Embedded SQL in C
  121. 8.0 release schedule?
  122. need help
  123. int8, primary key, seq scan
  124. need help with copy function
  125. How to setup default value "0000-00-00" for "date" type under PostgreSQL?
  126. function runs on Windows not on solaris
  127. multimedia on postgresql
  128. Fw: Strange UNICODE sort order
  129. Forwarding kerberos credentials
  130. Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
  131. Finally tsearch works ... somehow... remain a few questions
  132. possible bug in exception handling code? (postgres8.0beta)
  133. Stored Procedures woes
  134. select count(*) from pg_stat_activity in V8.0.0
  135. PostgreSQL 8.0.0 - Win32 C-Language function how to?
  136. Vacuum, per table or entire database? what is better?
  137. BUG: 8.0 beta1 does not run on Windows 2000 Terminal Server
  138. Managing caches for multi-cluster HP-UX box
  139. Could not create a table named "USER" under postgreSQL
  140. can postgresql handle these large tables
  141. Could not create a table named "USER" under postgreSQL
  142. FATAL: invalid frontend message type 8
  143. Installing FullTextSearchTool tsearch2
  144. Postgresql feature
  145. scripting & psql issues
  146. Postgres and JBOSS
  147. manually setting a 'for each statement' to 'deferrable initially deferred' -> any unforeseen side effects?
  148. psql - user defined SQL variables
  149. pg_dump feature request: Exclude tables?
  150. indexed column not working as fast as expected
  151. Fw: libpq or Embedded SQL in C
  152. pg_dump feature request: Exclude tables?
  153. Problem analyzing performance of query
  154. (S)RPMS for 7.4.4 released.
  155. PANIC: btree_split_redo: lost left sibling?
  156. Any recommended forums/wiki/blog s/w that uses PostGreSQL?
  157. apple uses Postgres for RemoteDesktop 2
  158. [Fwd: Slony-I release 1.0.2 includes PostgreSQL 8.0 support]
  159. Problems using count() with a join
  160. pg_clog and pg_xlog empty, postgresql refuses to start
  161. pg_dumpall outputs incorrect sql
  162. Pgsql 7.3/7.4/8.0 on IA64 HP-UX 11i?
  163. making two tables with identical schemas appear as one
  164. Thousands of parallel connections
  165. could not find block containing chunk 0x8483530
  166. Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?
  167. distinct and equal operator
  168. major database breakdown
  169. PostgreSQL 8.0.0 - Win32 C-Language function how to?
  170. postgres in freebsd jail
  171. Error codes to go with errors?
  172. PHP and PostgreSQL question on identifier limits.
  173. (libpq) listen/notify messages are converted to lowercase and/or are case insensitive
  174. PgSQL 8.0.0 - contributed: problem compiling
  175. exception handling support in pgSQL
  176. postgres error handling mechanism
  177. idle processes
  178. Web application: Programming language/Framework
  179. psql wishlist: value completion
  180. Autoincremental value
  181. Postgresql 8.0 beta 1 service issue
  182. Postgres 8.0 -> BEGIN EXCEPTION END Syntax????
  183. ODBC Driver Standards
  184. pg_get_result() hangs for query length > 65535
  185. REINDEX problem
  186. heap errors - should I be worried?
  187. /contrib binaries for win32
  188. pl/pgsql trigger table attributes
  189. pg_dump in windows postgres 8.0
  190. pl pgsql grammer file contains error
  191. datpath error
  192. Access restrictions on rows depending on value of the a column
  193. PgSQL 8.0.0 beta1 compile problem + patch
  194. PHP Postgre-MySql call redirector
  195. case insensitive search with greek characters
  196. upgrading in RH 8
  197. PG 8.0beta: psql suggestion
  198. Changing from base type to inherited
  199. Clustering, mirroriing, or replication?
  200. My admin left the job and I am stuck
  201. disabling autocommit
  202. POSIX RE starting with a (
  203. the behaviour of timestamp on postgres.
  204. How to write soundex query in postgresql??
  205. Resultset problem or BUG !
  206. type cast for ERROR: function chr(double precision) does not exist???
  207. Slony setup help needed
  208. How to identify which query is running - reg.
  209. lock conflicting with another
  210. postmaster does not shut down
  211. Locks in functions?
  212. Sorting varchar w/single digits
  213. dump/restore from 7.4.3linux to 8beta1 win32
  214. psql: immediately exit after an error?
  215. pg_restore with Fc fails with [archiver] out of memory error
  216. 7.4.3 server panic
  217. Transaction blocks
  218. BIGINT indexes still with problems
  219. hostory tables with a generic function?
  220. Replication options?
  221. Problems with MS Visual Basic 6.0
  222. Relation does not exist
  223. User Defined Types and SQL2003
  224. Copy data from one table to another, where some records might already be present
  225. BIGINT indexes still with problems
  226. Replication options?
  227. Relation does not exist
  228. history tables with only one function?
  229. row level lock
  230. nested transaction
  231. error moving table to tablespace (8.0 beta win32 )
  232. Using connection after fork
  233. Postgres update with self join
  234. Listing views
  235. PostgreSQL 8.0.0 Officially Goes Beta
  236. Implicit join
  237. FW: Out of swap space & memory
  238. DELETE and UPDATE in same function with foriegn keys
  239. Implicit join
  240. postgresql and smp linux kernel
  241. plruby issue with redeclaring functions
  242. Stored Procedure - Iam totally lost!
  243. Embedded Database
  244. How Two JOINS from one table
  245. PostgreSQL 8.0 Feature List?
  246. COPY, \copy with defaults
  247. Losing records when server hang
  248. How copy a new line char to a file?
  249. pg jdbc driver
  250. CREATE FUNCTION
  251. Writing regex in PL's
  252. RFC: array literal syntax
  253. Rounding in PGSQL
  254. CA issues million dollar challenge to open source community
  255. FW: Out of swap space & memory
  256. constraint expression
  257. probelm migrating from 7.3.4 to 7.42
  258. Lost my blobs and can't restore.
  259. replication
  260. getting dead locks with 2 functions
  261. Sequence question
  262. Commit Transaction Command
  263. Insert into sintax
  264. getting dead locks with 2 functions
  265. PQunescapeBytea Question
  266. Non-superuser connection limit exceeded
  267. PG over NFS tips
  268. case insensitive sorting & searching in oracle 10g
  269. Sequence Question
  270. Seeking PostgreSQL consultants
  271. most idiomatic way to "update or insert"?
  272. query result set caching
  273. COPY not handling BLOBs
  274. altering the datatype of a column.
  275. Recursive PLPGSQL function?
  276. Simplfied Bytea input/output?
  277. New PHP + PostgreSQL group at Google Groups 2
  278. Creating blank records with sequential record numbers
  279. How to know which queries are to be optimised?
  280. trouble with query
  281. trash talk
  282. root page error
  283. Updateable Views?
  284. Trying to use GIST indexes again
  285. User locking
  286. dropping a rule find an error
  287. recycled transaction log file: too much?
  288. Are Packages for PostgreSQL 7.4.x for Solaris 9 64bit available ?
  289. Casting timestamp with time zone to varchar automatically
  290. CREATE SEQUENCE
  291. Out of swap space & memory
  292. New to Postgres
  293. autovacuum problems
  294. one view for 2 different tables
  295. psql and md5
  296. Information about the type of elements in an array from libpq
  297. Stored procedures
  298. I have some questions...
  299. exclusion in distributing binary-only postgresql to client
  300. pg_proc.proacl documentation
  301. Postgres and Tools Intro?
  302. PostgreSQL, GnuCash
  303. pdql, pg_dump, and pg_restore
  304. How to use as Functional Index to be used as Primary KEY
  305. Correct escaping of untrusted data
  306. pg_hba.conf changes without restarting postmaster
  307. best type for unix file system timestamp?
  308. Shared Foreign Keys From Two Tables
  309. 7.2 - 7.4.2 production server migration issue
  310. pg_restore -t
  311. Moving tables between schemas
  312. Postgresql and OS cluster
  313. Using view
  314. (NONE)
  315. Wal logs
  316. Backup questions
  317. Backup questions
  318. Checking existence of temporary table
  319. tablespace spec
  320. how to limit user to open another session
  321. Need info on performance tuning.
  322. Arrays to table
  323. Status
  324. Timestamp input + copy
  325. php -postgresql
  326. Data entry?
  327. Strange constraint violation when applying rules to a view.
  328. Cascade Order
  329. EXPLAIN on DELETE statements
  330. Indexes on Character Types
  331. Everlasting SQL query
  332. Discussion wanted: 'Trigger on Delete' cascade.
  333. pgadmin III ?
  334. tablename type?
  335. Aborting long running command.
  336. altering a table to set serial function
  337. Perl DBI and nested transaction?
  338. Loading/Retrieving bytea fields?
  339. PostgreSQL running in FreeBSD jail corrupts PostgreSQL running onthe host system
  340. no value fetch
  341. Before/After trigger sequencing question
  342. NNTP server
  343. Trigger on Postgres for tables syncronization
  344. Data model for Postfix v2
  345. open of /usr/lib/pgsql/data/pg_clog/0F3E failed
  346. parsing binary varchar[]-s
  347. estimating table size
  348. vacuumdb hanging database cluster
  349. postgresql password from .pgpass
  350. 7.5 beta?
  351. Beginner: Enhancing postgresql performance
  352. isNumeric function?
  353. selecting more that 2 tables based on 1 subquery find an error
  354. selecting more that 2 tables based on 1 subquery find an error (revision)
  355. Search in code
  356. pg storage system
  357. Connexion to Postgresql using TCP/IP
  358. phppgadmin and external access
  359. pgadmin problem
  360. dumping the schema
  361. select, columns, and aliases
  362. please please please PLEASE help!
  363. any benefit to preparing a sql function?
  364. Best way to recover from crash?
  365. polating (insert into...) a table with determined record from another table.
  366. 2 postgresql processes on the same machine ?
  367. Tsearch2 - list of words or phrase with count
  368. Hex to char
  369. Table access method not behaving like Oracle (index vs sequential scan). Examples and stats provided.
  370. unsubscribe
  371. sorting and spaces in postgresql with en_US locale
  372. Wanted: Want to hide data by using PL/PGSQL functions
  373. SQL - display different data
  374. Locking with foreign key constraints
  375. Using SELECT inside a COPY transaction with PHP
  376. help me
  377. Why index used/not used
  378. mirroring data on different drives?
  379. Aligned Output!!
  380. initdb for postgresql 7.4 doesn't
  381. SQL (?) question
  382. fail to compare between bytea output in
  383. tsearch2, ispell, utf-8 and german special characters
  384. pgadmin 3
  385. DIfferent ORDER BY behaviour in 7.4.2
  386. Stored procedures and "pseudo" fields..
  387. How to find records with the same field?
  388. Postgres vs Sybase ASE
  389. special table queries slow until dump/restore
  390. enumerated type..
  391. LOG table changes ...
  392. Index Using
  393. UPDATE statement
  394. Question on INSERT statement
  395. more intelligence to pg_dump
  396. Fwd: Indexes and Tables: Growth and Treatment
  397. Can someone please explain this error
  398. constraitnt on case sensetive and case insensetive columns
  399. unsubscribe
  400. Column as result of subtraction of two other columns?
  401. FW: [ADMIN] URGENT - Postgres won't work
  402. Insert images through ASP
  403. Postgres C functions documentation
  404. Max size for varchar(n) data type
  405. oh
  406. PQftable insufficient for primary key determination
  407. cd, ls, mkdir, rmdir, etc.
  408. SELECT based on function result
  409. moving an installation
  410. Horology & stats tests fail in 7.4.3/RH 9
  411. Describe table and varchar lrngth
  412. tcl and rpms for rhel3
  413. Getting started with replication
  414. determining supported timezones
  415. FOR-IN-EXECUTE, why fail?
  416. Triggers called twice, triggers debugging
  417. Function and RowType
  418. Indexes and Tables: Growth and Treatment (Modified by Thomas F. O'Connell)
  419. optimization with limit and order by in a view
  420. Where may I find Windows native port
  421. Tuning random_page_cost
  422. function returning a readable representation of a number
  423. Need Libpq.dll w/ SSL
  424. Can connection pointer be obtained from PGresult?
  425. Latitude/Longitude data types and functions
  426. cannot access or delete view
  427. change the last bit
  428. (Again) Datacorruption using 7.4.2 on XFS/raid1
  429. SOLVED: cannot access or delete view
  430. Help needed on time data types
  431. Is a digest avail for postgresql-general?
  432. which tar file to start PostgreSQL??
  433. Determining how to convert a value
  434. Using arguments with functions
  435. Characters which requires escaping
  436. Postgress latest Windows Version
  437. Search your email using SQL!
  438. Are SQL functions better than PG/SQL ones?
  439. Problem pg_restore from 7.3 to 7.4
  440. number of pgsql connections established.
  441. will this bug be fixed in 7.5
  442. order of statements in create function
  443. adding a db-specific user
  444. ODBC creating nulls?
  445. HELP
  446. SSL Problems: invalid connection option "requiressl"
  447. Subtransaction syntax in 7.5??
  448. unexpected update behavior with temp tables
  449. Client lib compatibility v. 7.2, 7.3 and 7.4
  450. PGADMIN default storage EXTENDED for Character fields
  451. ERROR: missing chunk number 0 for toast value 14227980
  452. Column name 'user' not allowed?
  453. FATAL: the database system is in recovery mode
  454. (no subject)
  455. (no subject)
  456. Help with query: indexes on timestamps
  457. Why do subselects in target lists behave differently wrt implicitcasts?
  458. Postmaster starts and stops
  459. Error in postgreSQL
  460. win32 port
  461. Accidentally deleted records - PostgreSQL 7.2
  462. Windows GUI clients
  463. Loading Binary Data into Bytea Fields?
  464. Grant Select privileges for all tables in schema
  465. Syntax question
  466. Determining when db last updated
  467. backup using cron
  468. pam authentification trouble ...
  469. ./configure --with-java fails
  470. Grants on rules
  471. could not access file "$libdir/plpython" when restoring
  472. SUBSTRING for a regular expression
  473. server closed the connection unexpectedly
  474. How to filter on timestamps?
  475. Serials in where clause
  476. creating a complex aggregate function
  477. Formatting Function..
  478. FATAL: shmat(id=1179648) failed: Invalid argument
  479. connection parameters
  480. username length character limits?
  481. alter table cascade does not give notice about dropped indexes
  482. Interpreting query plan
  483. per-session (or persistent) table (and column) aliases
  484. how can Iconnect a Postgres database using odbc in c language?
  485. Row-level security--is it possible?
  486. how could I connect a Postgres database in c language using odbc?
  487. Row values
  488. How to add an userA to login postgresadmin
  489. administrating permisions, groups, owners
  490. get first / last date of given week
  491. COPY command with blank incoming values
  492. Full Text Index Info
  493. Drop Column with Foreign Key Problem
  494. (NONE)
  495. row level grants
  496. Error loading trigger in C
  497. max_fsm_pages
  498. permissions
  499. DELETE TABLE xx do not erase index file after a vacuum full ?
  500. Run a unix or perl command in a trigger
  501. Slow deletion of data from tables
  502. postgresql +AMD64 +big address spaces - does it work?
  503. Mysterious performance of query because of plsql function in where condition
  504. sql-question: sum-function and subqueries?
  505. Restoring template1
  506. Bug in function to_char() !!
  507. Problems restarting after database crashed (signal 11).
  508. case for lock_timeout
  509. pg_dump and pg_restore problems
  510. Internationalization
  511. PostgreSQL 7.4.3 on a windows XP Pro environment Installation
  512. what's best: opteron or xeon for pg 7.4.3?
  513. psql - list objects in a schema
  514. Backward compatibility patch for numutils.c
  515. backups
  516. Running PostgreSQL on Windows 9x/2000/2003...
  517. Transaction XID
  518. substring syntax with regexp
  519. Enough RAM for entire Database.. cost aside, is this going to be fastest?
  520. mysql2postgres has no documentation?
  521. DML Restriction unless through a function
  522. a few Questions about quoted variables in psql
  523. sharing tcl proc's between functions
  524. Slow dump with pg_dump/pg_restore ? How to improve ?
  525. minimum operators for b-tree, r-tree
  526. postgresql install: jdbc: No such file or directory.
  527. FULL JOIN and mergjoinable conditions...
  528. What is the prevalent naming convention in RDBMS?
  529. Postgres tuning?
  530. query failing with out of memory error message.
  531. column contsraints
  532. dup(0) failed after 3195 successes: Bad file descriptor
  533. A few beginner's questions concerning concurrency control
  534. dividing time ??
  535. How to determine field names in a trigger?
  536. Q: upgrading from 7.4.1 to 7.4.3.
  537. Seeing uncommitted transactions
  538. Slony-I Canada Day Release Candidate available
  539. Group by - Case insensitivity
  540. Inconsistant DOW...
  541. is win1250 supported encoding for PG7.5?
  542. Plperlu and sending emails, is it safe?
  543. postgresql perl connectivity
  544. indexing lat lon
  545. ERROR: tables can have at most 1600 columns
  546. Date localization
  547. referencing system catalogs
  548. postgresql on debian
  549. pgsql on debian
  550. Trigger isn't fired