View Full Version : postgresql answers


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

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