View Full Version : postgresql answers


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

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