View Full Version : postgresql answers


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

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