View Full Version : answers

Pages : 1 [2] 3 4 5 6 7 8 9 10 11
  1. Test Suite for Postgresql
  2. How can I display the stored image?
  3. Storing files in Postgresql database
  4. Interface to posgresql
  5. How to check a query execution plans in PostgreSQL
  6. HOW TO merge two strings
  7. need copy table sql example in postgres
  8. use of client-side \lo_import and \lo_export commands
  9. Server doesn't listen
  10. SHA function?
  11. Fastly Inserting Records
  12. how to release locks when instance crashes
  13. HOW TO Use transaction control statements inside a sored procedure
  14. Back Up And Restore
  15. Functions and Commits
  16. how to write this sql statement
  17. Nested use of found doesn't seem to be working
  18. Alter table doubt
  19. Driver for postgresql
  20. Redundant data in postgres
  21. Migrating data between dbs with different schemas
  22. Postgres Newbie - Case Problems in queries
  23. Multi dimensional arrays, sub selects...
  24. Error When creating the table
  25. String was not recognized as a Valid Date Time
  26. Postmaster is accepting TCP/IP connections error
  27. Data Migration From Excel to PostgreSQL
  28. date queries with portions of the date unknown
  29. How to Fix Corrupt Tables
  30. Unable to connect
  31. Postgresql Compression Across Network
  32. limit database size
  33. limit database size
  34. query and subquery in python
  35. retrieve column array values
  36. how to execute script from file within function
  37. retreive values from an array into column
  38. Can PostgreSQL initiate a message through a socket?
  39. how to insert image
  40. which is the best interface for postgresql
  41. unable to set 'Owner' column to different role
  42. username
  43. inserting values into array column
  44. Query regarding odbc connection ??
  45. how to give login in a table
  46. limitation of postgresql
  47. how can I fetch data from the database and display it in form of a editable html form
  48. ALIAS error
  49. postgis function
  50. FATAL ERROR on Solaris 10
  51. postgresql function
  52. invert an array
  53. postgresql installation fails on windows 2000
  54. accessing last element of an array
  55. How to cast varchar into timestamp in postgres
  56. How to make a copy of data in RAM ???
  57. update multiple cols in trigger
  58. How to make cross-database reference in Postgres
  59. nesting joins
  60. How to insert multiple sub columns inside a column ??
  61. on delete set null problem
  62. Databinding bool fields
  63. Increase the Cache Size
  64. Query regarding SQL commands ?
  65. how to make a Postgre DB setup on windows
  66. PL/PGSQL function
  67. getting the last record using timestamp
  68. create database test if not exists
  69. Writing DDLs in Functions
  70. Writing DDLs in Functions
  71. Postgre Sql on Solaris operating system
  72. urgent help!!
  73. Sum of “sales” for each date in a timestamp column
  74. How to know that a schema exist?
  75. Web Development Team Needed - Prefer Croatian or Eastern Europeanbased
  76. PHP Postgresql "All-In-One" CRUD Needed
  77. need help
  78. a problem when I create a trigger procedure.
  79. Postgres on XP / ODBC setup / Visual C++ API
  80. Transaction Logging Mechanism
  81. SQL question??
  82. TCP/IP Connection Error
  83. The MySQL command LEFT() counterpart in PostgreSQL?
  84. Exception Handling
  85. current transaction aborted
  86. SQL problem, help if possible please.
  87. Anyone know any DB2 ?
  88. How can I support multimedia with postgres?
  89. Postgres Connection Error
  90. HI all
  91. Restoring dump files completely
  92. PostgreSQL - JDBC2 lose connectivity after a while
  93. hi all
  94. .NET Questions
  95. postgresql module
  96. Copy / Paste in PostgreSQL from remote server.
  97. postgresql installation
  98. functions in postgresql!!!
  99. select distinct with datatype point
  100. an urgent question
  101. data conversion
  102. select-where anomaly
  103. Migration od Database
  104. installation error
  105. inserting values in relational main tables
  106. Hash index creation problem
  107. How can we manage PK and FK using inheritance??
  108. Are Primary Keys Necessary for Linking Tables?
  109. filename extension postgreSQL
  110. DBF to Postgres using DBF2PG
  111. Bulk Extract and Load data in PostgreSQL
  112. error in logs file
  113. To insert 60million rows to database
  114. can't get the full results from postgresql
  115. What is ODBC Query timeout error
  116. How to configure postgres for max disk space usage
  117. web interface library/classes
  118. Sql Case Statement
  119. Problem with executing Postgres function from javacode
  120. pg_clog errors
  121. table creation
  122. Postgres and ESQL
  123. Postgresql Vs. Mysql -- Need advice
  124. How to write postgres query with time comparison ?
  125. Hey i need advice!
  126. Subjectre31
  127. Reg Postgres Sql Replication Concept
  128. Reg Postgres Sql Database Instal On Windows 2000
  129. Syntax error doesn't make sense...
  130. just some info you might be intersted
  131. Tickets
  132. Create UNIQUE KEY
  133. Reg AutoVacuum
  134. Garbage Collection with Custom Session Handlers?
  135. Performance problem with joins
  136. plpgsql FOUND unexpected behaviour
  137. Need Clarification About Replication Concept In Postgres Sql
  138. How to convert from sql to postgresql (stored procedure)
  139. 7.4.13 LANG=C, order by still wrong
  140. Recieving notification when a table changes
  141. Limitation in query result from postgresql table
  142. date format in postgresql database
  143. libpqdll.lib
  144. Help with Database Solution
  145. Linking Tables from 2 databases
  146. Ora2PG exporter and UTF Characters
  147. alternative to distinct on?
  148. How to Use "If Exists" in PgSql
  149. Postgresql Stored procedures
  150. Postgresql
  151. Money datatype?
  152. Performance Issues PostgreSQL on Solaris
  153. Two general, simple questions
  154. Postmaster Problem
  155. What architecture for a Large Database with PostgreSQL
  156. XP Embedded and Postgres No Happy Campers
  157. Fedora Core 4 & PostgreSQL
  158. xml export tool?
  159. Dual servers
  160. Python x Postgresql Thrreading Problem
  161. Outer Join on 3 tables
  162. Timestamp not working
  163. Conditional delete
  164. async queries (libpq)
  165. OLAPy stuff crawling a bit
  166. is there a function which elminates spaces?
  167. Looks to me like MySQL has a change coming
  168. Generate/Manage a PostgresSQL database using Visio?
  169. PostgreSQL Linked server question with MSSQL2K
  170. Urgent: Input of values to execute dynamic queries
  171. 1991 and 1992 Black Box Catalogs
  172. Need Database person
  173. Happy Fish Database Designer
  174. Need Database person
  175. encoding question
  176. Where can I download HTML manual?
  177. linking access using ODBC driver with geometric data
  178. Good Portal for data mining resources
  179. Tablespace layout question
  180. scroll cursor bug or me?
  181. SQL Profiler
  182. How to copy a PG database
  183. ordering text field with non-alphanumerical character
  184. crosstab error 'query-specified return row and actual function return do not...
  185. Statement-level Triggers
  186. DateAdd function ?
  187. views, functions and parameters...
  188. How to return a record and sets of record in plpython
  189. ADO and PostgreSQL functions
  190. Great News Blog!
  191. Query Optimizer Failure / Possible Bug
  192. Bitwise operators for bytea
  193. can't update bytea field with function
  194. resultset to xml
  195. function no return
  196. Tsearch index not set by UPDATE in PgSQL 7.3.2
  197. Installing PostgreSQL 8 on Debian
  198. how to run function?
  199. SQLDescribecol in driver 8.00.0100
  200. Postgresql 8.0-beta2-dev3 on Windows 2000
  201. Adding pgAdminIII Server - Passwords?
  202. PostgreSQL and XML
  203. Good page with Oracle x PostgreSQL comparsion
  204. Danish users
  205. simple query runs very slowly
  206. using OLD variable in DELETE trigger
  207. Please Help with libpq and unicode
  208. eval function?
  209. Postgres+XML
  210. SQL Query
  211. libpq location?
  212. pgsql user account in pgadmin doesn't need password
  213. SuSE Linux and PostgreSQL
  214. What is future of partitioning?
  215. PostgreSQL/PHP/UTF-8?
  216. Oid Type
  217. The second RFD is in news.groups.
  218. Table name as parameter in function
  219. Upcoming Changes to News Server ...
  220. I need to add a column to a table
  221. Will B4->B5 require an Initdb?
  222. Lexical question...
  223. Bug in queries ??
  224. PostgreSQL 8.0.0 Beta 5 Now Available
  225. null value of type java.sql.Time
  226. primary key and the default index operator class
  227. Postgres-Windows -Perl DBI
  228. Foriegn Keys?
  229. SELECT duplicates in a table
  230. Storing every scrabble board possible
  231. Help with syntax for timestamp addition
  232. null value of type java.sql.Time
  233. Oid to text...
  234. Unions, schemas, and design questions...
  235. timestamp with time zone question...
  236. COMMIT within function?
  237. Any good report/form generators for postgresql?
  238. Wrong string length from unicode database in Borland's app
  239. Delete very slow after deletion of many rows in dependent table
  240. Join between databases or (???)
  241. Unit testing plpgsql code
  242. I found this great little site
  243. Posting COPY data with shared sequences
  244. altre table and large object deletion
  245. phpPgAdmin problem - this list?
  246. PostegreSQL 8.0.0 Beta4 Win32
  247. Phantom user in db--'128'
  248. How to make lo_import and lo_export to use file on clientlocal machine?
  249. pgEdit public beta for Macintosh and Windows
  250. Any equivalent of MSSQL Detach?
  251. postgres & glibs 1.2
  252. Odd permission denied message when starting client
  253. only seeing first of many COPY commands in input file
  254. Can COPY skip columns?
  255. index and queries using '<' '>'
  256. How to make a good documentation of a database ?
  257. A couple serious errors
  258. ERROR: Unable to locate type oid 0 in catalog...
  259. How to know a record has been updated, then reset the flag?
  260. PROPOSAL: Usenet Discussion Repost
  261. User-defined types
  262. Rules WHERE condition
  263. Tsearch2 and Unicode?
  264. Knowing when a row was last updated
  265. error querying temp table in plpgsql function
  266. PostgreSQL certification
  267. Q about NAS mounting things
  268. Controlling maximal on-disk size of a table
  269. Certifications in military environment
  270. Transactions in different DB
  271. How to suppress echo while executing batch files?
  272. Problems importing Unicode
  273. Moving from 7.x to 8.0beta4 with a backup
  274. ERROR: column "id" does not exist
  275. How to overload POSITION
  276. question about temp table in function
  277. Fwd: Problem installing Postgresql on MDK10.0
  278. out of disk space
  279. How to deal with almost recurring data?
  280. How to handle larger databases?
  281. PL/pgsql - getting row from record
  282. Transaction in different DB
  283. How to clear linux file cache?
  284. PGCLIENTENCODING behavior of current CVS source
  285. Preventing connections during vacuum and reindex
  286. Schemas?
  287. Oracle versus PostgreSQL
  288. "q" with psql display paging dumps out of psql
  289. Nairobi time zone fails in 7.4
  290. I'm sure a good time was had by many...
  291. Data from Internet direct into PostgeSQL Database??
  292. relations betwee subclasses in postgersql
  293. Question about indexes
  294. suggestion for "psql"
  295. table configuration tweak for performance gain.
  296. Error "cannot compare arrays of different element types" when tryingto ANALYZE
  297. Visual Studio and Postgresql
  298. shrinking physical space used
  299. Mysterious Death of postmaster (-9)
  300. Spam notice
  301. PostGresql USENET Vote
  302. sub-query question
  303. How to use custom functions created by my2pg.pl?
  304. How many secondary databases can I create?
  305. query with table alias
  306. simple query question: return latest
  307. Want to help on open-source ERP?
  308. invalid page header in block 52979 of relation "pg_attribute"
  309. When to switch to Postgres 8.0?
  310. oid size on 64 bit machine
  311. DROP DATABASE, but still there
  312. implicit casting problem
  313. Problem with showing time diff?
  314. logging
  315. checkpoints
  316. New Opteron server from pogo linux
  317. Last value inserted
  318. Vacuum message
  319. Lionel Lauer 58 Gore Street Fitzroy, Victoria Australia 3065
  320. making another super user other than postgres
  321. pg_ctl and stderr
  322. Can't insert date in field with foreign key
  323. Modifying FK constraints
  324. Error connecting using pgadmin from different computer !!
  325. Analyse - max_locks_per_transaction - why?
  326. Rolling back an update
  327. Ping Mike Cox
  328. Large database
  329. updateString error in PostgreSQL7.4 with JDBC
  330. Lost databases
  331. These Lists Are Being Cut To FOUR
  332. unconvertible BIG5 character 0xf9d8
  333. the column in Update
  334. I'm about to release the next postgresql RFD. Comments wanted.
  335. Creating DB with pass, but pass not required to connect
  336. Vacuum hangs
  337. new data types
  338. need simple strategy for universal extension table
  339. FW: Proper nesting of hierarchical objects
  340. Functions in postgres
  341. PostGreSQL to Access Updatable recordset
  342. Linux DBDesigner4 and PostgreSQL
  343. troubleshooting deadlocks
  344. Per-Table Transaction Isolation Level?
  345. server auto-restarts and ipcs
  346. INTERVAL in a function
  347. Loading data Binary data and text with newlines ..
  348. Backend disconnect problems
  349. Installing pgbench
  350. Proper nesting of hierarchical objects
  351. subselect, order by and left join
  352. technical help
  353. can you use variables in PostgreSQL rules?
  354. start postmaster as root : problem
  355. index not always used when selecting on a date field
  356. I spoke with Marc from the postgresql mailing list.
  357. FTP mirror problems
  358. Visual Designer in linux?
  359. Sorting based on maximum value over several columns
  360. SQL question
  361. Trying to get postgres to use an index
  362. Mass Import/Generate PKs
  363. Postresql RFD version 2.0 Help Wanted.
  364. Report Generation
  365. Temporarily disable rule, is this possible?
  366. superuser equality
  367. Can this be indexed?
  368. Gborg down?
  369. Converting number to words
  370. Copy command and import - MS SQL Server to Postgres
  371. Are there any PostgreSQL bloggers?
  372. Retrieve ip client from postgres
  373. ALERT This mailing list may be voted into a newsgroup
  374. Trigger Parameter problem
  375. Using EXECUTE in same manner as SELECT
  376. ALERT This mailing list may be voted into a newsgroup
  377. start postmaster as root : problem
  378. restoring pgdump file file from 7.2 branch to 7.4
  379. Java / Perl Return codes
  380. Characters used for pattern matching with like
  381. Conactenating text with null values
  382. TSearch2: Problems with compound words and stop words
  383. Making this group a part of the official comp.* hierarchy.
  384. how to edit a function from psql?
  385. RFD: comp.databases.postgresql.general
  386. create a text file from postgres (like Oracle UTL_FILE package)
  387. VACUUMING questions...
  388. Selecting a random row
  389. visiting Seoul, Korea
  390. UTF-8 and =, LIKE problems
  391. oid file, but no pg_class row for it
  392. Number of months
  393. Number of months
  394. pg_xlog
  395. pg_xlog
  396. PostgreSQL on Linux PC vs MacOS X
  397. PostgreSQL on Linux PC vs MacOS X
  398. MD5 for PostgreSQL 7.3.4
  399. MD5 for PostgreSQL 7.3.4
  400. autovacuum redhat startup
  401. autovacuum redhat startup
  402. unsubscribe
  403. unsubscribe
  404. Batch processing select
  405. Batch processing select
  406. Postgres Versions / Releases
  407. Postgres Versions / Releases
  408. Subselect Question
  409. Subselect Question
  410. SQL Agreate Functions
  411. SQL Agreate Functions
  412. Split query
  413. Split query
  414. routine reindexing in 7.4.6/8.0?
  415. routine reindexing in 7.4.6/8.0?
  416. Rows created by a stored proc prompt Access' dreaded "write conflict"
  417. Rows created by a stored proc prompt Access' dreaded "write conflict"
  418. Age of statistics
  419. Age of statistics
  420. Calling on all SQL guru's
  421. Calling on all SQL guru's
  422. unique problem
  423. unique problem
  424. spreading the DB?
  425. spreading the DB?
  426. AT TIME ZONE: "convert"?
  427. AT TIME ZONE: "convert"?
  428. Numeric type problems
  429. Numeric type problems
  430. Functions not dropped.
  431. Functions not dropped.
  432. dumping on 7.4.6 importing on 7.4.1
  433. dumping on 7.4.6 importing on 7.4.1
  434. oracle synchronization strategy
  435. PQSQL - binary data question
  436. oracle synchronization strategy
  437. PQSQL - binary data question
  438. Suggested Triggers & Functions Naming Convention?
  439. Suggested Triggers & Functions Naming Convention?
  440. Daylight Savings Time handling on persistent connections
  441. Daylight Savings Time handling on persistent connections
  442. procedural languages in 7.4.6
  443. procedural languages in 7.4.6
  444. Interpolation of environment variables in SQL at runtime?
  445. Interpolation of environment variables in SQL at runtime?
  446. 8.0 Beta 4 denying network connections?
  447. can't shrink relation
  448. logging queries and time used
  449. Recommended Procedure for Archiving Table Data
  450. column updates
  451. SELECT a value from various tables depending on a column value
  452. (b)trim anomalies
  453. tasks
  454. UTF-8 -> ISO8859-1 conversion problem
  455. adding missing FROM-clause
  456. Max length name of a database/schema
  457. PostgreSQL on Windows
  458. Creating database problem
  459. PgSQL8 beta4 ODBC, JDBC and WinXP sk_SK
  460. {OT?] Auth_PG_grp_group_field directive gives parameter error
  461. export-import problem
  462. Upgrading from beta3 to beta4
  463. Turning a subselect into an array
  464. Derived tables?
  465. Issue adding foreign key
  466. Sorting street addresses
  467. field incrementing in a PL/pgSQL trigger
  468. : Unable to load libsqlpg.so
  469. disabling constraints
  470. Tables and Indexes
  471. determine sequence name for a serial
  472. Creating schema copy
  473. View's rule on delete problem
  474. WARNING: column "footype" has type "unknown"
  475. interval to seconds conversion. How?
  476. QMail
  477. Psycopg difficulty...
  478. Reasoning behind process instead of thread based arch?
  479. Exact or less specific match ?
  480. Resource temporarily unavailable
  481. Array values and foreign keys
  482. Changing access permissions without re-starting the database
  483. update data in different database
  484. (NONE)
  485. Theory
  486. pg_autovacuum in 8beta-dev3 small bug
  487. basic debugging question
  488. Base type OIDs
  489. [SECURITY] New set of PostgreSQL RPMS are available for download
  490. primary key and existing unique fields
  491. page locking? too many btree indexes...
  492. Out of memory error
  493. Any plans on allowing user-defined triggers to be deferrable?
  494. Bug: 8.0 beta1 either view optimization or pgdump/pgrestore
  495. compatibilityissues from 7.1 to 7.4
  496. Strange count(*) implementation?
  497. Kill a postgres session
  498. [Fwd: Abrupt close of pgsql backend]
  499. Theory!!
  500. what could cause inserts getting queued up and db locking??
  501. list fieldnames in table? (from PHP)
  502. PostgreSQL 8.0.0 Beta 4 Now Available
  503. pg_restore does not restore
  504. process hang during drop schema
  505. Error restoring bytea from dump
  506. shared buffers
  507. ON DELETE trigger blocks delete from my table
  508. The reasoning behind having several features outside of source?
  509. Arrays, placeholders, and column types
  510. PgSQL MVCC vs MySQL InnoDB
  511. (NONE)
  512. How to connect with postmaster through TCP socket
  513. Sorting, when values are equal....
  514. dbms
  515. partial index on a text field
  516. Function syntax checking
  517. (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready
  518. pqAdmin3
  519. Memory exhausted on DELETE.
  520. Permission denied error
  521. sequence behavior - is this correct
  522. Comment on timezone and interval types
  523. COPY data and referential triggers ...
  524. Problem with 7.4.1 and complicated queries
  525. repost(gmane): sql update max smartries
  526. The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.3.
  527. how to port Oracle database to PostgreSQL?
  528. sql update max smartries
  529. '1 year' = '360 days' ????
  530. Log
  531. field incrementing in a PL/pgSQL trigger
  532. Duplicating a database
  533. Win installed pgsql 8.0 beta2 dev3
  534. COPY command with PHP
  535. Bug or stupidity
  536. PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4
  537. OID's
  538. returning inserted rows, derived tables design
  539. schema repository
  540. combining two queries?
  541. ia64 hostname lookup problem
  542. unexpected field count in D message
  543. Problem with query plan
  544. A Simple Question
  545. PlPERL and shared libraries on Suse
  546. PostgreSQL-related job posting
  547. FKs and deadlocks
  548. C++ Class Library for ODBC?
  549. correct example of a functional index usage?
  550. Row versioning