View Full Version : postgresql answers


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

  1. Weird psql problem
  2. many columns with references to one table
  3. function restore order
  4. pl/tcl trigger question
  5. Linux ready for high-volume databases?
  6. is linux ready for databases ? (Ziff Davis article on Oracle and Linux)
  7. convert database to unicode
  8. table constraints and performance
  9. Index usage
  10. LOCK.tag(figuring out granularity of lock)--
  11. greek char
  12. support for OO query
  13. How do I find what views depend on a particular table?
  14. LOCK.tag(figuring out granularity of lock)--
  15. Your details
  16. Replication Ideas
  17. merge multiple records into 1
  18. export data from postgresql on linux to ms-sqlserver 2000 on windows
  19. pgsql-mode.el
  20. The ..... worm
  21. WAL Files checkpoint_timeout with voluminous delete/insert
  22. Inserting CR/LF in a select?
  23. convert interval info into days
  24. Strange problem with PL/PgSQL stored procedures
  25. pgAdminII Error
  26. strftime
  27. how to drop table named user
  28. Stored procedure advice needed
  29. unsubscribe
  30. timeofday() and CAST
  31. Books for PostgreSQL?
  32. Your details
  33. 7.4b: FATAL: invalid value for "lc_monetary": "US_EN"
  34. Open Transaction list
  35. Changed mailing list functionality?
  36. FK to inherited table, referential integrity violation
  37. uptime problem
  38. Mail server load
  39. native win32 version
  40. Bug with pg_restore?
  41. Bulk Insert / Update / Delete
  42. Call for presentations Linux Solutions 2004
  43. Buglist
  44. move to usenet?
  45. Mailing list in French
  46. Grouping by date range
  47. Temporary tables
  48. 'now' vs now() performance
  49. 3 way outer join dilemma
  50. Example Database
  51. factors determining the execution plan
  52. Are you an pgODBC hacker?
  53. Default Value in Table Setup Help
  54. Hour difference?
  55. Simulating sequences
  56. Cache lookup failed?
  57. Bit String Manipulation
  58. Performance with different index types
  59. Too many clients
  60. Need feedback on new feature (\for)
  61. C vs plpgsql and child processes
  62. insert and heritage...
  63. Database modelling question for version management of data
  64. Dreamweaver
  65. getting execution plans with multiple database connections
  66. New to list, quick question.
  67. parameter in trigger function
  68. join of array
  69. Character conversion issues while upgrading database
  70. Manage PostgreSQL Connections
  71. Importing data
  72. Graphical Mapping a Database
  73. 7.4Beta
  74. can't find files in pg_clog and invalid page headers
  75. tsearch2 in 7.4beta1 compile problem
  76. WAL question
  77. Transaction question
  78. connect to remote db
  79. importing db as text files
  80. HLR/HSS
  81. Usogres - Compilation Error
  82. Vacuuming unicode database
  83. more timeofday() and "set time zone" weirdness
  84. SET TIME ZONE with GMT+X notation
  85. How to get the total number of rows with a query "limit" ?
  86. FTI problems
  87. Tsearch2 lexeme position
  88. postgres as an snmp client
  89. Viewing Client Connections..
  90. Installing DBD::Pg Perl module locally
  91. Installing DBD::Pg Perl module locally.
  92. How to relate an attribute of one table with the attributes of another related table
  93. Simple DBI question.
  94. Sorting Problem
  95. Simple DBI question
  96. general database password
  97. {REPOST, CLARIFIED} How to recognize PG SQL files?
  98. types of constraint deferment
  99. Help! Can't pg_dump anything: handler procedure for procedural language plpgsql not found
  100. optimisation of a code
  101. Update of foreign key values
  102. One table into two different databases
  103. PL/C functions
  104. Join faster than single table query
  105. update system table?
  106. Multilingual database
  107. High volume use of postGres
  108. Concatenating String Literals in pgsql
  109. 7.4Beta1 "failed to create socket: Address family not supported byprotocol"
  110. dbmirror -- recovery question
  111. Authentication problem
  112. PostgreSQL
  113. dumbheaded SQL question (probably join or subselect) - longish
  114. public key functions for postgresql ?
  115. Nesting Groups
  116. Fwd: Nesting Groups
  117. Continued mail server problems for all PGSQL mailing lists I'm on
  118. Temporary table
  119. postgesql-7.3.3 lo_create/lo_open fails
  120. CURRENT_TIMESTAMP causes Postgres to shutdown connection
  121. Moving from MySQL
  122. Random via Subselect or Temporary Table
  123. remove $ from money field
  124. Empty Output? How Do I Determine the Character?
  125. ERROR: Invalid UNICODE character sequence found (0xed5c30)
  126. Anomaly with SUM().
  127. Trying to create a GiST index in 7.3
  128. unexpected chunk number
  129. The database is very slow !
  130. strategies for optimising common lookups etc
  131. toast values
  132. problem with timeofday() function in cvs PostgreSQL
  133. Conditional row grained replication with DBMirror
  134. XML?
  135. PostgreSQL and ACID properties support
  136. postmaster(s) have high load average
  137. Auditing idea
  138. date format?
  139. Retrieving tuple data on insert
  140. Web application and database.
  141. bug?
  142. Database theory question: safe query
  143. Does REINDEX TABLE lock the table?
  144. cross join oddity?
  145. Table compression
  146. extracting x from a point(x,y)
  147. Examples for writing own c functions in postgres
  148. Problem wih a CONSTRAINT CHECK not doing its job
  149. Table partitioning and Rules
  150. Postgresql long term commercial potential?
  151. Postgres Performance -- page size
  152. recompiling with JDBC
  153. multiple postmasters
  154. problem w/CREATE RULE...ON INSERT...INSERT INTO...SELECT...FROM...WHERE w/multiple inserts
  155. Array and Aggregate Functions
  156. Silly database question...
  157. Exporting a PostGreSql database
  158. I don't know much about postgres - can I stored procedures in postgres, like you can in MS SQL?
  159. The better of two table designs?
  160. indexes on columns and functions
  161. Vacuum verbose question
  162. Forcing a query plan
  163. Before trigger question
  164. unsubscribe
  165. Synchronising multiple common fields among tables
  166. Using C++ With SPI?
  167. Record locking in deadlock
  168. createlang command line won't work
  169. declaring variables?
  170. Forcing query plans
  171. database names vs. database schemas
  172. Fw: Stored Proc error after modifying field type
  173. Stored Proc error after modifying field type
  174. problems with pg_restore to 7.3.3 db
  175. Installation problem: can't find $libdir
  176. Stored Proc error after modifying field type
  177. Exporting large objects in 7.0.2
  178. ERROR: fixrdesc: no pg_class entry for pg_class
  179. Vacuuming specific schemas..
  180. which Schema I am working on??
  181. Which Schema I am working on??
  182. Performance question
  183. Duplicate key insert question
  184. Upgrading 7.3 to 7.3.3
  185. ERROR: language "c" is not trusted
  186. ERROR: Relation "pg_user" does not exist
  187. Text datatype as Memo in Delphi
  188. IPv6 data type
  189. new to postgres - can you write stored procedures? If so, please send links to good sites about this
  190. Noobie: Problems with a query
  191. How to import data from ver 7.3.2 to 7.0.2 installation
  192. InitDB fails
  193. PostgreSQL based Wiki engine
  194. PostgreSQL Linked server question with MSSQL2K
  195. Urgent: Input of values (that is, dynamic queries)
  196. pg_restore fails
  197. Is there a port of PostgreSQL working on Windows CE
  198. 1991 and 1992 Black Box Catalogs
  199. How to show database table/view/... declaration?
  200. access xp postgres data from linux
  201. insert statement question
  202. escaping - sign
  203. query translation
  204. linking to MS Access using ODBC and geometric types?
  205. Does PostgreSQL have a size limitation
  206. list tables from PHP
  207. Abstracting SQL Statements In An Object
  208. A PHP/PostgreSQL E-Zine available
  209. pg_dump and -t option
  210. scroll bug cursor or me?
  211. too many clients already?????
  212. help on function - result set
  213. How to make a copy of a PG database
  214. licensing
  215. Postgres functions that return multiple values...
  216. Problem of installing PostgreSQL on Windows 2000
  217. ordering field containin non alpha numeric character
  218. COPY command problem
  219. JNDI DataSource with PostgreSQL and Tomcat
  220. Logging trigger calls
  221. Just testing. Please ignore
  222. [PGSQL+MSSQL] - connection between them
  223. DateAdd function?
  224. PostgreSQL ??
  225. pg_autovacuum
  226. Best way to Insert related records
  227. External SQL functions exported by DLLs
  228. time arithmetic
  229. pgsql optimizer
  230. Is GROUP_BY best for this?
  231. Continuous performance regression
  232. A graphical tool for the visualization?
  233. Where to get DBD::pg Perl module for Windows?
  234. PostgreSQL/PHP/UTF-8?
  235. Performance on select on index and large tables
  236. I found this great little site
  237. Insert/Update Perl Function involving two tables needing to by 'in sync'
  238. Data Recovery
  239. Fedora Core 2 postgresql regress problems.
  240. default schema
  241. postgres replication only some datas
  242. Simple ERP problem
  243. Bulk import date into table.
  244. Capturing the result status of an ALTER command in plpgsql
  245. Return set different in pgsql and MS Access/ODBC
  246. [Diploma] Examples of PostgreSQL usage
  247. Creating variables outside a 'create function'
  248. Memory problem
  249. PL/Perl Trigger Problem
  250. Create Table with Foreign Key Error
  251. Create Table with Foreign Key Error
  252. ODBC creating nulls?
  253. using sql to update a table
  254. Recovery after delete
  255. TOP ?
  256. 7.4 serial not working ?
  257. import from oracle dmp.
  258. transform like excel possible?
  259. Can I interrupt queries already processing in the server?
  260. one to one and many to many => one to (one and many)
  261. How to write a single update sql statement to update different setof attributes of a table
  262. Stored procedures in PL/PGSQL
  263. bytea SQL ERROR with size
  264. large dimension table
  265. Concurrency relate issue.
  266. how to transfer contents
  267. Postgres for OpenVMS?
  268. indexed columns in views
  269. Format conversion for import in Postgresql
  270. Timestamp precision and rounding
  271. [v7.0.3]join tables between databases
  272. [v7.0.3] loop through a database and union all tables begiining with "j" and name is like j### (#=digit)
  273. Remote X viewing of pgaccess
  274. Casting hexadecimal to int
  275. pam_pgsql
  276. DBD::Pg handling duplicates in a transaction
  277. relocation error
  278. Starting Postmaster
  279. postgres crashes
  280. problems installing postgresql 7.4.2 on mac osx 10.3
  281. Partition view optimization
  282. Database structure
  283. postgres hangs?
  284. Add Printer Script
  285. Multi-process transactions [share connections]
  286. Fatal Error
  287. coerces
  288. alleviate
  289. FmPro Migrator 1.97 for MacOS X and Windows - Adds FileMaker to PostgreSQL Migration Feature
  290. Gilbertson
  291. ColdFusion MX + PostgreSQL - why slow?
  292. Postgresql 7.3 on Mandrake 9.2
  293. MS SQL vs PostgreSQL
  294. semaphores - FAQ no help
  295. xml to postgres
  296. time question
  297. Question on stored functions
  298. looking for advice...
  299. Unable to identify a function that satisfies the given argument types
  300. Low level API Layers within Postgres
  301. Creating a SQL variable to hold a table name
  302. Errors running cgi program
  303. PostgreSQL on Windows
  304. Cobol esql precompiler
  305. nextval problem
  306. PostgreSQL Inheritance
  307. Help! Select count from a list of digits ??
  308. encrypt like safeJDBC
  309. access to database
  310. Postgresql 7.3 And Redhat Enterprise 3
  311. Native distribution for Windows - when?
  312. Unidata Universe impot into PostgreSQL
  313. user attributes
  314. How can the sequence become out of sequence?
  315. Alternative to ODBC ?
  316. exec sql define
  317. simple tree in postgress
  318. pg_dump and pg_restore wtih lo
  319. Some basic SQL Questions
  320. HOWTO: Join 3 Tables, Compare Unequals To 1 Table
  321. OIDS and their limitations
  322. Different query results in psql and Perl DBI with Postgres 7.2.1
  323. create template database
  324. Concurrency and use of setval()
  325. "on insert" rules happen before the insert?
  326. altering a column
  327. Can't connect with database
  328. reading db schema
  329. What is the best encoding for the UK?
  330. postgres requires too many times to answers to a query view
  331. Spaces and comments in pgplsql
  332. Postgres DBA required - Toronto
  333. postgis and related topics...
  334. Using regular expression in query
  335. many columns in a table
  336. Try these internet package from MS
  337. Convert integer to sql server datetime
  338. ERROR: DeleteTypeTuple: column of type tablename exists in relation #
  339. [7.4] could not bind socket for statistics collector
  340. GRANT ALL error
  341. Difference between REFERENCES and FOREIGN KEY
  342. Returned more than one row error message in a FOR IN EXECUTE loop
  343. reboot oid from database
  344. CREATE ASSERTION in future? CHECK subselect?
  345. mdb (Access) to PosgreSQL migration - tool - text mode
  346. Can Postgresql run under Windows?
  347. Install PostgreSQL on Windows 2000
  348. Simple count()/group by question
  349. postgresql
  350. How to know column constraints via system catalog tables
  351. pg_constraint missing many entries?
  352. Could my postgres database be corrupted?
  353. complex views
  354. SQL relationships
  355. PL/Perl: can you tell that your code is inside a function?
  356. INSERT performance
  357. psql: How to make :HOST expand in a "\!" command?
  358. DownLoad PostGreSQL for Windows
  359. Access retrieving record incorrectly
  360. Nullable 'Foreign Key-like' Constraint
  361. Recursing tree data in PL/pgSQL
  362. Damaged table
  363. Database / SQL
  364. is possible to connect PostgreSQL with Oracle?
  365. RULE Problem with pseudo relations OLD/NEW
  366. Insert with a serial
  367. previous & next buttons
  368. Unicode Broke
  369. get diagnostics not supported by ecpg?
  370. SQL row filtering
  371. See update from MS
  372. slash like system that uses PostgreSQL?
  373. SQL Query
  374. full backup
  375. Migrating from SQL Server to Postgres
  376. Sequence Meta Data from System Catalogs?
  377. insert duplicated unique/PK with no errors
  378. TID 935/15: OID IS INVALID. TUPGONE
  379. MS Project and PostgreSQL
  380. data migration
  381. Triggers/perform oddity between 7.2 and 7.3
  382. moving transaction log
  383. Array fields in Postgresql...
  384. Problem stopping PostgreSQL in Cygwin
  385. RHDB with LInux 9.0
  386. Binary files in PGSQL
  387. SQL Question
  388. relational algebra question - please help!
  389. PostgreSQL port from DBExperts anybody using it ?
  390. OffsetNumber offnum( LOCKTAG in lock.c)
  391. comparing dates?
  392. Zeos components
  393. Q: Redhat Postgresql pkg for Mandrake Linux
  394. PostgreeSql 7.2 pg_relcheck empty
  395. Temp tables represented in pg_class?
  396. LOCK.tag(figuring out granularity of lock)
  397. mysql's last_insert_id
  398. how to import data into table
  399. gmake
  400. Installing postgresql 7.3.4 on knoppix V3.2
  401. How to make an attribute of one table to relate with the attributes of other related table
  402. stored procedures
  403. parser: parse error at or near "."
  404. Recovery systems available
  405. PostgreSQL to MSDE conversion help
  406. Most Reliable Replication Method
  407. trigger problem where two tables reference each other's primary keys
  408. Linux partitions and Postgres
  409. which news server are you using?
  410. drop a column ?
  411. Enable MB *after* install
  412. postgresql on windows
  413. Returning error message
  414. Question regarding table transfer
  415. compressing tables
  416. Table compression
  417. pg_dump 7.2.3, pg_restore 7.3.3
  418. given a table with a point in it, how do I create a table with separate x, y values?
  419. gps to zipcode query: postgres or postgresql + postgis or how?
  420. Row Lock? Who?
  421. PostgreSQL Alias Name Length
  422. Question from a beginner
  423. UniDirectional Data
  424. Can I install postgresql on Slackware linux??
  425. stop postgress
  426. Function parameter
  427. document table schema
  428. Exporting a PostGreSql database