View Full Version : postgresql answers


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

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