View Full Version : postgresql answers


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

  1. BIGINT indexes still with problems
  2. Replication options?
  3. Relation does not exist
  4. history tables with only one function?
  5. row level lock
  6. nested transaction
  7. error moving table to tablespace (8.0 beta win32 )
  8. Using connection after fork
  9. Postgres update with self join
  10. Listing views
  11. PostgreSQL 8.0.0 Officially Goes Beta
  12. Implicit join
  13. FW: Out of swap space & memory
  14. Implicit join
  15. DELETE and UPDATE in same function with foriegn keys
  16. postgresql and smp linux kernel
  17. plruby issue with redeclaring functions
  18. Stored Procedure - Iam totally lost!
  19. Embedded Database
  20. How Two JOINS from one table
  21. PostgreSQL 8.0 Feature List?
  22. COPY, \copy with defaults
  23. Losing records when server hang
  24. How copy a new line char to a file?
  25. pg jdbc driver
  26. CREATE FUNCTION
  27. Writing regex in PL's
  28. RFC: array literal syntax
  29. Rounding in PGSQL
  30. CA issues million dollar challenge to open source community
  31. FW: Out of swap space & memory
  32. constraint expression
  33. probelm migrating from 7.3.4 to 7.42
  34. Lost my blobs and can't restore.
  35. replication
  36. getting dead locks with 2 functions
  37. Sequence question
  38. Commit Transaction Command
  39. Insert into sintax
  40. getting dead locks with 2 functions
  41. PQunescapeBytea Question
  42. Non-superuser connection limit exceeded
  43. PG over NFS tips
  44. case insensitive sorting & searching in oracle 10g
  45. Sequence Question
  46. Seeking PostgreSQL consultants
  47. most idiomatic way to "update or insert"?
  48. query result set caching
  49. COPY not handling BLOBs
  50. altering the datatype of a column.
  51. Recursive PLPGSQL function?
  52. Simplfied Bytea input/output?
  53. New PHP + PostgreSQL group at Google Groups 2
  54. Creating blank records with sequential record numbers
  55. How to know which queries are to be optimised?
  56. trouble with query
  57. trash talk
  58. root page error
  59. Updateable Views?
  60. Trying to use GIST indexes again
  61. User locking
  62. dropping a rule find an error
  63. recycled transaction log file: too much?
  64. Casting timestamp with time zone to varchar automatically
  65. Are Packages for PostgreSQL 7.4.x for Solaris 9 64bit available ?
  66. CREATE SEQUENCE
  67. Out of swap space & memory
  68. New to Postgres
  69. autovacuum problems
  70. one view for 2 different tables
  71. psql and md5
  72. Information about the type of elements in an array from libpq
  73. Stored procedures
  74. I have some questions...
  75. exclusion in distributing binary-only postgresql to client
  76. pg_proc.proacl documentation
  77. Postgres and Tools Intro?
  78. PostgreSQL, GnuCash
  79. pdql, pg_dump, and pg_restore
  80. How to use as Functional Index to be used as Primary KEY
  81. Correct escaping of untrusted data
  82. pg_hba.conf changes without restarting postmaster
  83. best type for unix file system timestamp?
  84. Shared Foreign Keys From Two Tables
  85. 7.2 - 7.4.2 production server migration issue
  86. pg_restore -t
  87. Moving tables between schemas
  88. Postgresql and OS cluster
  89. Using view
  90. (NONE)
  91. Wal logs
  92. Backup questions
  93. Backup questions
  94. Checking existence of temporary table
  95. tablespace spec
  96. how to limit user to open another session
  97. Arrays to table
  98. Need info on performance tuning.
  99. Status
  100. Timestamp input + copy
  101. php -postgresql
  102. Data entry?
  103. Strange constraint violation when applying rules to a view.
  104. Cascade Order
  105. EXPLAIN on DELETE statements
  106. Indexes on Character Types
  107. Everlasting SQL query
  108. Discussion wanted: 'Trigger on Delete' cascade.
  109. pgadmin III ?
  110. tablename type?
  111. Aborting long running command.
  112. altering a table to set serial function
  113. Perl DBI and nested transaction?
  114. Loading/Retrieving bytea fields?
  115. PostgreSQL running in FreeBSD jail corrupts PostgreSQL running onthe host system
  116. Before/After trigger sequencing question
  117. no value fetch
  118. NNTP server
  119. Trigger on Postgres for tables syncronization
  120. Data model for Postfix v2
  121. open of /usr/lib/pgsql/data/pg_clog/0F3E failed
  122. parsing binary varchar[]-s
  123. estimating table size
  124. vacuumdb hanging database cluster
  125. postgresql password from .pgpass
  126. 7.5 beta?
  127. Beginner: Enhancing postgresql performance
  128. isNumeric function?
  129. selecting more that 2 tables based on 1 subquery find an error (revision)
  130. selecting more that 2 tables based on 1 subquery find an error
  131. Search in code
  132. pg storage system
  133. Connexion to Postgresql using TCP/IP
  134. phppgadmin and external access
  135. pgadmin problem
  136. select, columns, and aliases
  137. dumping the schema
  138. please please please PLEASE help!
  139. any benefit to preparing a sql function?
  140. Best way to recover from crash?
  141. polating (insert into...) a table with determined record from another table.
  142. 2 postgresql processes on the same machine ?
  143. Tsearch2 - list of words or phrase with count
  144. Table access method not behaving like Oracle (index vs sequential scan). Examples and stats provided.
  145. Hex to char
  146. sorting and spaces in postgresql with en_US locale
  147. unsubscribe
  148. Wanted: Want to hide data by using PL/PGSQL functions
  149. SQL - display different data
  150. Locking with foreign key constraints
  151. Using SELECT inside a COPY transaction with PHP
  152. help me
  153. Why index used/not used
  154. mirroring data on different drives?
  155. Aligned Output!!
  156. initdb for postgresql 7.4 doesn't
  157. SQL (?) question
  158. fail to compare between bytea output in
  159. tsearch2, ispell, utf-8 and german special characters
  160. DIfferent ORDER BY behaviour in 7.4.2
  161. pgadmin 3
  162. Stored procedures and "pseudo" fields..
  163. How to find records with the same field?
  164. Postgres vs Sybase ASE
  165. special table queries slow until dump/restore
  166. enumerated type..
  167. LOG table changes ...
  168. Index Using
  169. UPDATE statement
  170. Question on INSERT statement
  171. Fwd: Indexes and Tables: Growth and Treatment
  172. more intelligence to pg_dump
  173. Can someone please explain this error
  174. constraitnt on case sensetive and case insensetive columns
  175. unsubscribe
  176. Column as result of subtraction of two other columns?
  177. FW: [ADMIN] URGENT - Postgres won't work
  178. Insert images through ASP
  179. Max size for varchar(n) data type
  180. Postgres C functions documentation
  181. PQftable insufficient for primary key determination
  182. oh
  183. cd, ls, mkdir, rmdir, etc.
  184. SELECT based on function result
  185. moving an installation
  186. Horology & stats tests fail in 7.4.3/RH 9
  187. Describe table and varchar lrngth
  188. tcl and rpms for rhel3
  189. Getting started with replication
  190. determining supported timezones
  191. FOR-IN-EXECUTE, why fail?
  192. Triggers called twice, triggers debugging
  193. Function and RowType
  194. Indexes and Tables: Growth and Treatment (Modified by Thomas F. O'Connell)
  195. optimization with limit and order by in a view
  196. Where may I find Windows native port
  197. Tuning random_page_cost
  198. function returning a readable representation of a number
  199. Need Libpq.dll w/ SSL
  200. Latitude/Longitude data types and functions
  201. Can connection pointer be obtained from PGresult?
  202. (Again) Datacorruption using 7.4.2 on XFS/raid1
  203. change the last bit
  204. cannot access or delete view
  205. SOLVED: cannot access or delete view
  206. Help needed on time data types
  207. Is a digest avail for postgresql-general?
  208. Determining how to convert a value
  209. which tar file to start PostgreSQL??
  210. Using arguments with functions
  211. Characters which requires escaping
  212. Postgress latest Windows Version
  213. Search your email using SQL!
  214. Are SQL functions better than PG/SQL ones?
  215. Problem pg_restore from 7.3 to 7.4
  216. number of pgsql connections established.
  217. will this bug be fixed in 7.5
  218. order of statements in create function
  219. adding a db-specific user
  220. ODBC creating nulls?
  221. HELP
  222. SSL Problems: invalid connection option "requiressl"
  223. Subtransaction syntax in 7.5??
  224. unexpected update behavior with temp tables
  225. Client lib compatibility v. 7.2, 7.3 and 7.4
  226. PGADMIN default storage EXTENDED for Character fields
  227. Column name 'user' not allowed?
  228. ERROR: missing chunk number 0 for toast value 14227980
  229. FATAL: the database system is in recovery mode
  230. (no subject)
  231. (no subject)
  232. Why do subselects in target lists behave differently wrt implicitcasts?
  233. Help with query: indexes on timestamps
  234. Postmaster starts and stops
  235. Error in postgreSQL
  236. win32 port
  237. Accidentally deleted records - PostgreSQL 7.2
  238. Windows GUI clients
  239. Loading Binary Data into Bytea Fields?
  240. Grant Select privileges for all tables in schema
  241. Syntax question
  242. Determining when db last updated
  243. backup using cron
  244. pam authentification trouble ...
  245. ./configure --with-java fails
  246. Grants on rules
  247. could not access file "$libdir/plpython" when restoring
  248. SUBSTRING for a regular expression
  249. How to filter on timestamps?
  250. server closed the connection unexpectedly
  251. Serials in where clause
  252. creating a complex aggregate function
  253. Formatting Function..
  254. FATAL: shmat(id=1179648) failed: Invalid argument
  255. username length character limits?
  256. connection parameters
  257. alter table cascade does not give notice about dropped indexes
  258. Interpreting query plan
  259. per-session (or persistent) table (and column) aliases
  260. how can Iconnect a Postgres database using odbc in c language?
  261. Row-level security--is it possible?
  262. how could I connect a Postgres database in c language using odbc?
  263. Row values
  264. How to add an userA to login postgresadmin
  265. administrating permisions, groups, owners
  266. get first / last date of given week
  267. COPY command with blank incoming values
  268. Full Text Index Info
  269. Drop Column with Foreign Key Problem
  270. (NONE)
  271. row level grants
  272. max_fsm_pages
  273. Error loading trigger in C
  274. DELETE TABLE xx do not erase index file after a vacuum full ?
  275. permissions
  276. Run a unix or perl command in a trigger
  277. Slow deletion of data from tables
  278. postgresql +AMD64 +big address spaces - does it work?
  279. Mysterious performance of query because of plsql function in where condition
  280. sql-question: sum-function and subqueries?
  281. Restoring template1
  282. Bug in function to_char() !!
  283. Problems restarting after database crashed (signal 11).
  284. case for lock_timeout
  285. pg_dump and pg_restore problems
  286. Internationalization
  287. PostgreSQL 7.4.3 on a windows XP Pro environment Installation
  288. what's best: opteron or xeon for pg 7.4.3?
  289. psql - list objects in a schema
  290. Backward compatibility patch for numutils.c
  291. backups
  292. Running PostgreSQL on Windows 9x/2000/2003...
  293. Transaction XID
  294. substring syntax with regexp
  295. Enough RAM for entire Database.. cost aside, is this going to be fastest?
  296. mysql2postgres has no documentation?
  297. DML Restriction unless through a function
  298. a few Questions about quoted variables in psql
  299. sharing tcl proc's between functions
  300. Slow dump with pg_dump/pg_restore ? How to improve ?
  301. minimum operators for b-tree, r-tree
  302. postgresql install: jdbc: No such file or directory.
  303. FULL JOIN and mergjoinable conditions...
  304. What is the prevalent naming convention in RDBMS?
  305. Postgres tuning?
  306. query failing with out of memory error message.
  307. column contsraints
  308. dup(0) failed after 3195 successes: Bad file descriptor
  309. A few beginner's questions concerning concurrency control
  310. dividing time ??
  311. How to determine field names in a trigger?
  312. Q: upgrading from 7.4.1 to 7.4.3.
  313. Seeing uncommitted transactions
  314. Slony-I Canada Day Release Candidate available
  315. Inconsistant DOW...
  316. Group by - Case insensitivity
  317. is win1250 supported encoding for PG7.5?
  318. Plperlu and sending emails, is it safe?
  319. postgresql perl connectivity
  320. indexing lat lon
  321. ERROR: tables can have at most 1600 columns
  322. Date localization
  323. referencing system catalogs
  324. postgresql on debian
  325. pgsql on debian
  326. Trigger isn't fired
  327. enable thready safety on Mac OS X 10.3.4
  328. Performance problem on RH7.1
  329. Speed of pg_dump -l -s (List Schema) Variations
  330. (NONE)
  331. Deadlock. Referential Integrity checks select for update?
  332. Running two postmasters on one host: could not create semaphores
  333. Multi-Language upper(),lower()
  334. Ranking values within a query (pseudo-ROWNUM) **fixed**
  335. psql
  336. hackers dudes
  337. Ranking values within a query (pseudo-ROWNUM)
  338. Renaming a schema
  339. Possible To Modify Part of String in Certain Rows?
  340. Queries not always using index on timestamp search
  341. 7.4.3 RPMS for RHEL3
  342. PostgreSQL Optimizer
  343. strange apllicaion error
  344. PHP: Too many open links (0) with libpg7.4.3
  345. Replace-function
  346. unicode and sorting(at least)
  347. Performance
  348. Blob
  349. langauges, locales, regex, LIKE
  350. clusters and database instances
  351. LIKE and REGEX on postgres
  352. LIKE and encoding and locale
  353. Catching errors
  354. Dump produces file with new line characters
  355. coalesce and nvl question
  356. simultaneous use of JDBC and libpq
  357. timestamp without time zone format
  358. Logging duration of batch runs
  359. FW: problems with installing postgres
  360. setting autocommit off in pgsql
  361. Point in time recovery
  362. Parameters from trigger to function.
  363. incremental backups?
  364. Datatype sizes; a space and speed issue?
  365. Deleting all but one row of a list of non-uniques
  366. Planner choice & tuning
  367. flock user defined function
  368. Connection gets into state where all queries fail
  369. Can I interrupt queries already processing in the server?
  370. More psql problems... >.<
  371. 7.5 Windows version
  372. PostgreSQL Docs for Paper (benchmark and contrib)
  373. Experience with postgres/apache host providers
  374. psql
  375. insert with select as value
  376. pgpool 2.0 is available
  377. How can I add a new language localization(locale) support
  378. User Privileges using dblink
  379. Do we need more emphasis on backup?
  380. PGplSql: Relation 44451 does not exist
  381. who can run utility - pg_controldata ?
  382. JDBC driver inserting into a table with Bytea type gets out of memory error.
  383. Possible SET SESSION AUTHORIZATION bug
  384. New to the list; would this be an okay question?
  385. New to the list; would this be an okay question?
  386. Database name in the log
  387. Database name in the log
  388. Problem while OS-Update
  389. Problem while OS-Update
  390. PGSQL service dieing...
  391. PGSQL service dieing...
  392. Is this a "Stupid Question" ?
  393. Is this a "Stupid Question" ?
  394. IpcMemoryCreate Failed
  395. IpcMemoryCreate Failed
  396. Postgresql installation.
  397. Postgresql installation.
  398. pivot table sql -- COUNT() not working as expected
  399. pivot table sql -- COUNT() not working as expected
  400. Help please - completely baffled by quoting
  401. Help please - completely baffled by quoting
  402. Relocation error pg_dumpall undefined symbol get_progname in 7.4.3
  403. Relocation error pg_dumpall undefined symbol get_progname in 7.4.3
  404. Need help with Dead Lock - reg.
  405. Need help with Dead Lock - reg.
  406. administering files, data type "file"
  407. administering files, data type "file"
  408. File System Restore
  409. File System Restore
  410. INSERT BEFORE Trigger
  411. INSERT BEFORE Trigger
  412. syntax error but command executes anyway?
  413. syntax error but command executes anyway?
  414. How do I clean up a site from an old version to install anew
  415. How do I clean up a site from an old version to install anew
  416. Current Query from Trigger
  417. Current Query from Trigger
  418. RHEL 2.1 rpms for 7.4.2
  419. RHEL 2.1 rpms for 7.4.2
  420. UPDATE inside an Update trigger
  421. UPDATE inside an Update trigger
  422. Article on open-source databases
  423. Article on open-source databases
  424. UTF8 vs C_LOCALE
  425. UTF8 vs C_LOCALE
  426. Trigger to update records out of memory
  427. Trigger to update records out of memory
  428. INSERT ON DUPLICATE KEY UPDATE
  429. INSERT ON DUPLICATE KEY UPDATE
  430. Restoring a table with blobs - Without doing a full restore - Is it even possible ?
  431. Restoring a table with blobs - Without doing a full restore - Is it even possible ?
  432. Variadic functions in plpgsql?
  433. Variadic functions in plpgsql?
  434. virtual fields on VIEW?
  435. virtual fields on VIEW?
  436. PgSQL shut down
  437. PgSQL shut down
  438. User Rights
  439. User Rights
  440. Just saying thank you for PostgreSQL
  441. Just saying thank you for PostgreSQL
  442. 7.4 windows version?
  443. 7.4 windows version?
  444. Connection Problem to DB Table
  445. Connection Problem to DB Table
  446. pg_dump out of shared memory
  447. pg_dump out of shared memory
  448. putting binary data in a char field?
  449. putting binary data in a char field?
  450. 7.4 for Windows?
  451. 7.4 for Windows?
  452. MySQL to Postgres.
  453. MySQL to Postgres.
  454. Off Topic: Book about High available / Load Balancing / Cluster
  455. Off Topic: Book about High available / Load Balancing / Cluster
  456. Join a varchar array
  457. Join a varchar array
  458. List prime key column names
  459. List prime key column names
  460. 7.4's INFORMATION_SCHEMA.Columns View
  461. 7.4's INFORMATION_SCHEMA.Columns View
  462. PostgresSQL 7.3.x removal
  463. PostgresSQL 7.3.x removal
  464. korean encoding, sort order off anyhow
  465. korean encoding, sort order off anyhow
  466. Database accesss using plperl
  467. Database accesss using plperl
  468. Remembering values in pl/pgsql
  469. Remembering values in pl/pgsql
  470. Tracking down deadlocks
  471. Tracking down deadlocks
  472. PostGres ODBC MFC Application
  473. PostGres ODBC MFC Application
  474. reference to a view
  475. reference to a view
  476. why no answer? [Fwd: backup and restore just with use ofjdbc?]
  477. why no answer? [Fwd: backup and restore just with use ofjdbc?]
  478. Query
  479. Query
  480. Multicolumn indexes and ORDER BY
  481. Multicolumn indexes and ORDER BY
  482. "Interesting" query planning for timestamp ranges in where clause?
  483. "Interesting" query planning for timestamp ranges in where clause?
  484. how does license work for non-profit companies?
  485. how does license work for non-profit companies?
  486. building 7.4.3 on Solaris 9/Intel
  487. building 7.4.3 on Solaris 9/Intel
  488. postgresql.conf for pg_stat_activity
  489. postgresql.conf for pg_stat_activity
  490. Installation problem - mutex_lock/unlock or libpq.so ?
  491. Installation problem - mutex_lock/unlock or libpq.so ?
  492. PostgreSQL 7.4.3 Now Available ...
  493. PostgreSQL 7.4.3 Now Available ...
  494. Fw: Feature idea
  495. Fw: Feature idea
  496. Feature idea
  497. Feature idea
  498. Why is a union of two null-results automatically casted to type text ?
  499. Why is a union of two null-results automatically casted to type text ?
  500. C_LOCALE vs. UTF8
  501. C_LOCALE vs. UTF8
  502. Can you help me with this query?
  503. Can you help me with this query?
  504. pg_hba auth failure
  505. pg_hba auth failure
  506. perl access
  507. perl access
  508. perl access
  509. perl access
  510. Error application using Powerbuilder 7 and postgresql 7.3
  511. Error application using Powerbuilder 7 and postgresql 7.3
  512. info about dependenciŽs between objects (add to ToDo)
  513. info about dependenciŽs between objects (add to ToDo)
  514. HTML output
  515. HTML output
  516. Question about array data types
  517. Question about array data types
  518. "alter sequence" equivilant in 7.2?
  519. "alter sequence" equivilant in 7.2?
  520. backup and restore just with use of jdbc?
  521. backup and restore just with use of jdbc?
  522. large dimension table
  523. large dimension table
  524. Trying to minimize the impact of checkpoints (resend)
  525. Trying to minimize the impact of checkpoints (resend)
  526. Set returning functions and Crystal Reports
  527. Set returning functions and Crystal Reports
  528. bytea functions
  529. bytea functions
  530. Installing 7.4.2
  531. Installing 7.4.2
  532. Information Schema - Can the views be applied to older versions ofPostgreSQL
  533. Information Schema - Can the views be applied to older versions ofPostgreSQL
  534. lost pg_xlog // recover database-structure without it?
  535. lost pg_xlog // recover database-structure without it?
  536. Keep history of modifications
  537. Keep history of modifications
  538. out of memory error
  539. out of memory error
  540. Can't compile a contrib util: dbsize (probably simply though)
  541. Can't compile a contrib util: dbsize (probably simply though)
  542. Opteron scaling with PostgreSQL
  543. Opteron scaling with PostgreSQL
  544. global temporary tables?
  545. global temporary tables?
  546. Returning rowsets/results from a function to another one in plpgsl.
  547. Returning rowsets/results from a function to another one in plpgsl.
  548. Trouble with locking tables - reg.
  549. Trouble with locking tables - reg.
  550. FK issue