View Full Version : postgresql answers


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

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