View Full Version : postgresql answers


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

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