View Full Version : postgresql answers


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

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