View Full Version : postgresql answers


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

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