View Full Version : postgresql answers


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

  1. Try these internet package from MS
  2. plpgsql string concatanation
  3. ip of the user doing an insert
  4. Convert integer to sql server datetime
  5. XQL and PostgreSQL
  6. 7.3.4 and 7.4 ORDER in queries
  7. Postgresql on file system EXT2 or EXT3
  8. passing function's output into C function
  9. CREATE TYPE in Postgres 7.3.4
  10. Proposed project: Multimaster, synchronous replication system
  11. Happy Thanksgiving!
  12. disaster recovery
  13. MS-Project 2000 data into a Postgresql database
  14. [Fwd: [Gllug] Next GLLUG Meeting, 6 December 2003]
  15. GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 7.4.0
  16. rules and return values question
  17. aggregate generic ANYARRAY
  18. Tweak postgresql ODBC driver
  19. pg_dump table schema ...
  20. postgres metadata
  21. marking record origin in views
  22. cross table indexes?
  23. TIMEZONE not working?
  24. Java Strings and quote marks
  25. plpgsql question
  26. performance versus order of fields in row
  27. inheritance help
  28. ERROR: get_typdefault
  29. (No Subject)
  30. bug?!: lower() breaks unicode
  31. PostgreSQL is much faster than MySQL, only when...
  32. duplicate primary key entries?
  33. Can I get rid of the schemas?
  34. What is WAL used for?
  35. Help, Australian Time Problem
  36. get_typdefault: failed to ...
  37. Cron-job for checking up on pg_autovacuum
  38. Index on array element
  39. configure --with-java fails
  40. RPM RH9.0 conflict with unixODBC
  41. PostgreSQL certifications?
  42. patch for pg_autovacuum
  43. fairly serious bug with pg_autovacuum in pg7.4
  44. The new autovacuum tool
  45. SRPM (PGDG) will not build
  46. pam authentication for postgres
  47. SQL text of view
  48. autocommit in 7.4
  49. Lock strategies!
  50. Declaring empty, non-NULL array in plpgsql
  51. rounding timestamps
  52. The python module?
  53. 7.4 Python configure hosed
  54. 7.4 Docs in PDF format
  55. partial uniqueness
  56. updated linux startup script?
  57. array iteration?
  58. error loading shared libraries: libpq.so.3
  59. Connecting Openoffice Postgres
  60. Invalid page header in block xxxx
  61. Silent truncation of numeric values.
  62. Open source data modeling tools for PostgreSQL
  63. question about error message
  64. Problem with 7.4 RPMS for Fedora Core 1
  65. Foreign Keys
  66. Pg Dump error
  67. Can't initdb, libdir points to static location
  68. FWD: Take a look at this critical patch
  69. Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / MySQL appliance forLinux arrives
  70. Execute vacuum
  71. Bug in pg_dumpall
  72. linking postgre to AD
  73. Concatenation in SELECT
  74. tsearch2 column update produces "word too long" error
  75. Concurrent testing PostgreSQL Vs MySQL
  76. Modelling Oracle Sequences
  77. why ORDER BY works wrong in pg7.3.4?
  78. PGSQL on shared hosting
  79. postmaster PANIC?
  80. SuSE PostgreSQL 7.4 RPMS
  81. Psql bug?
  82. SELECT 'pg_catalog.pg_class'::regclass::oid
  83. rounding timestamp
  84. tsearch2 installation
  85. lo_import for bytea columns
  86. pg_hba.conf change in 7.4
  87. Multiuser testing -- PostgreSQL 7.3.4
  88. error durring compilation
  89. tsearch2 installation
  90. ripe whois server and postgresql
  91. lo_import for bytea columns
  92. ERROR: nodeRead: did not find '}' [x2]
  93. pg_hba.conf change in 7.4
  94. "Transaction over connections"
  95. error durring compilation
  96. Multiuser testing -- PostgreSQL 7.3.4
  97. SELECT Question
  98. ripe whois server and postgresql
  99. Is it possible to find a size of a table
  100. Is it possible to find a size of a table
  101. Is it possible find a size of a table
  102. ERROR: nodeRead: did not find '}' [x2]
  103. Export CSV from psql
  104. "Transaction over connections"
  105. Pg_dumpall problem
  106. Two rules on a view do not like each other :-(
  107. SELECT Question
  108. Is it possible to find a size of a table
  109. Is it possible to find a size of a table
  110. Is it possible find a size of a table
  111. Export CSV from psql
  112. ERROR: nodeRead: did not find '}'
  113. pg_aclcheck: invalid user id #
  114. Pg_dumpall problem
  115. Two rules on a view do not like each other :-(
  116. Japanese and PostgreSQL
  117. ERROR: nodeRead: did not find '}'
  118. pg_aclcheck: invalid user id #
  119. core dump
  120. Japanese and PostgreSQL
  121. core dump
  122. Wanted: Trick for granting permissions to users with hyphens
  123. Wanted: Trick for granting permissions to users with hyphens
  124. exclusive access
  125. 7.4 broke psql
  126. Problem with exec sql include
  127. defferable update & unique
  128. Optimizing query
  129. Tunning postgresql
  130. Seeking concise PL/pgSQL syntax diagram
  131. 7.4RC2 vs 7.4
  132. AUTOCOMMIT didn't work...
  133. SQL text of view
  134. Better Unilization of Memory
  135. unix_socket_directory not fully recognized by pg_ctl?
  136. Query Planner Filtering Of Specified Value From 'On Distinct' Clause
  137. problem running postmaster
  138. indexing with lower(...) -> queries are not optimised very well - Please Help
  139. Lock questions
  140. 7.4RC2 --> 7.4
  141. support
  142. Debian packages of 7.4
  143. pgAdmin3 [pgAdminIII] installation SUSE9
  144. Array syntax
  145. Error during check
  146. Quoting Problem in PLPGSQL
  147. how to get historical data?
  148. PLPGSQL Returning Records
  149. building 7.4 with plperl
  150. Detaching from controlling terminal
  151. Stuck processes, viewing the queries inside
  152. tracking down temp files
  153. SuSE RPMs available for PostgreSQL 7.4
  154. PostgreSQL v7.4 Released
  155. pg_constraint missing many entries?
  156. snort, acid and postgres
  157. MultiByte Columns?
  158. Move a table to another schema
  159. Take a minute to make yourself heard ... (PostgreSQL vs ...)
  160. Alternative cluster location
  161. Market Research on Open Source Database Management Software?
  162. MultiByte columns
  163. Retoring non-administrative user databases
  164. how to find version?
  165. vacuum from ecpg
  166. Help with quote escaping in plpgsql
  167. Grant alter privileges
  168. What are these files about?
  169. Updated Documentation
  170. UPGRADING 7.1 TO 7.3.4
  171. Storage consumption
  172. about serial
  173. Can Postgresql run under Windows?
  174. Loggin SQL Statements from JBOSS/JDBC
  175. Conservation of OIDs
  176. Error on initdb with 7.4RC2
  177. Restoring From pg_dumpall (SOLVED)
  178. Restoring From pg_dumpall
  179. GUIDs
  180. Database Corruption ?
  181. Determine if a string is digit
  182. 64 bit compile on Linux SPARC U5
  183. More Praise! 7.4
  184. DOMAIN usability
  185. Curious about exclusive table locks
  186. embedded postgresql
  187. plpgsql return setof integer?
  188. PL/PGSQL functions suddenly not working
  189. how can I change a btree index into a hash index?
  190. serial type vs. sequences
  191. pl/perl function life and variable scope - concurrency problem?
  192. using NOLOCK cause Cartesian joins
  193. dumping sequences
  194. Column Sizes
  195. Perfomance difference between 7.2 and 7.3
  196. Problem with FKEYS
  197. plperl/createlang issue
  198. Failure of make for 7.3.4 on Mac OS 10.3 Panther
  199. More Praise for 7.4RC2
  200. update slow
  201. change conndeferrable in pg_constraint?
  202. PGexec dumps core at pqResultAlloc
  203. Postgre Architecture
  204. procpid in pg_stat_activity but no correspoding backend
  205. Locks information
  206. Proposal for a cascaded master-slave replication system
  207. Functional index definition
  208. RHEL
  209. Changing xml in a database
  210. multibyte support
  211. Problem with create index
  212. ALTER TABLE ADD UNIQUE .....
  213. psql version mismatch
  214. PostgreSQL v7.4 Release Candidate 2
  215. PL/Perl returning multiple rows
  216. Try internet update from MS
  217. [off-topic] Bugtracker using PostgreSQL
  218. Two build problems - openssl and plperl on RedHat
  219. Visual C++ and Postgres
  220. case-sensitive sorting and locale settings?
  221. Dynamic expression evaluation
  222. PGSQL technical documentation
  223. PL/PGSQL help for getting number of rows matched.
  224. starting the server at boot
  225. drop user question
  226. Problem Deleting Referenced records
  227. Tables spanning db's in cluster
  228. disk access measurment
  229. FrontRange GoldMine w/ PostgreSQL
  230. Questions from a beginner!
  231. phpPGAdmin Indexes, what does this do?
  232. Optimiser desicion bringing system to its knees?
  233. Question on Select
  234. SQL-question: returning the id of an insert querry
  235. Tools are disabled, except connect & disconnect
  236. Problem in restoring data
  237. Converting SQL-ASCII encoding database to UNICODE
  238. Help With date/time
  239. performance: time & disk access measurment
  240. Question on Replication
  241. BUG?
  242. postgresql ODBC for Windows!
  243. PostgreSQL, Postgre and Apple
  244. pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'
  245. Problem creating ROWTYPE variable in plpgsql.
  246. Referencing columns from system tables possible?
  247. why does explain tell me I'm using a seq scan?
  248. regarding constant values
  249. phpPGAdmin Indexes, what does this do?
  250. Temp rows - is it possible?
  251. German mailing list
  252. Visio Like Tool....
  253. error when creating rule
  254. DDL for a single schema
  255. Changing the buffer size
  256. Database of electoral results?
  257. on connect trigger?
  258. on connect trigger
  259. int8 primary keys still not using index without manual JDBC driverpatch (7.4RC1)
  260. pg_stat_activity
  261. Optimiser desicion bringing system to its knees?
  262. create function for trigger question
  263. pid of current session?
  264. Insert and obtain the pk
  265. Install files for version 7.4
  266. Default user after upgrade to 7.3?
  267. Fixed column format data
  268. New eRServer patch/fork release
  269. INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE COLUMNS
  270. Sequences without blank holes
  271. Problems with PLPGSQL
  272. PostgreSQL v7.4 Release Candidate 1 compile errors
  273. SQL_ASCII encoding
  274. Select for update and locking problem
  275. Multi-master asynchronous replication
  276. tsearch2 and gist index bloat
  277. Getting time from date field
  278. Question on database structure
  279. Database Design & Application Server Design
  280. invalid command \
  281. How to store pg_constraint's int2[] data type in C++
  282. System crash and trying to run vacuum getting errors
  283. How to know column constraints via system catalog tables
  284. SET AUTOCOMMIT OFF
  285. select/update performance?
  286. Changes in Rel. 7.4
  287. Calculating default values on insert?
  288. access linux command from SQL Query
  289. question
  290. Using SUBSELECT in CHECK expressions
  291. Foreign Key to Inherited table
  292. PostgreSQL v7.4 Release Candidate 1
  293. Problem with Pg_dumpall
  294. Databases with different encodings
  295. Very strange selectproblem
  296. pg7.3.4: pg_atoi: zero-length string
  297. SELECT question
  298. now() problem
  299. Obtain boolean value of expression in PLPGSQL
  300. Query to pg_stat_activity
  301. C functions quicker than Plpgsql?
  302. transposed query?
  303. question
  304. How to use dblink within pl/pgsql function:
  305. Internet based database
  306. slow down on UPDATE using IN statements
  307. plpgsql question
  308. Please help
  309. PostgreSQL License Question
  310. IF EXISTS?
  311. How to set up a table where 2 columns together must be unique?
  312. Install that security package from Microsoft
  313. AS operator and subselect result names: PostgreSQL vs. Oracle
  314. further ino on bigint index and vacuum issues?
  315. Request for Interview Candidates - PG Research Help
  316. COPY
  317. Altering columns order
  318. help from Portugal
  319. sql trees move some element
  320. trim(ing) during load process
  321. org.postgresql.PG_Stream.flush(PG_Stream.java:356)
  322. Where are the database files located?
  323. Attribute 'rtrim' is repeated
  324. table locking.. FK tables locking on insert
  325. Pictures from LinuxWorld Expo in Frankfurt
  326. problem with huge joins
  327. Problem with ecpg
  328. Error Messages / Codes in DBD / JDBC
  329. ALTER Table
  330. ATA disks and RAID controllers for database servers
  331. insert data of composite type
  332. Table Copy/Synchronization
  333. DBD::Pg Err / Errstr
  334. Trigger or Rule ?
  335. Tsearch2 indexing question....
  336. Best Perl Option?
  337. database speed
  338. Need Italian Help!
  339. regular backups - super user
  340. formatting of SQL sent by PHP to postgres
  341. slow query performance
  342. Sending email from PL/pgsql
  343. tsearch ukrainian stemmer dict
  344. nextgencms
  345. sql trees move some element
  346. INSERT performance
  347. duplicates rejected by index reports PGSQL_FATAL_ERROR
  348. pg_ctl vs full restart
  349. Statistics on database structure changes
  350. dump schema schema only?
  351. Trigger delete
  352. backup another server
  353. pgAdmin vs SQL Server Enterprise Manager
  354. Database design question: ugliness or referential integrity?
  355. Cartesian product bug?
  356. N Texas PostgreSQL Consultant Needed
  357. Error size varchar
  358. selecting information from two tables (problem)
  359. Help on update that subselects other records in table, uses joins
  360. PG_RESTORE/DUMP Question
  361. Performace question
  362. slow query performance
  363. JDBC DatabaseMetaData problem
  364. Viewing linked large postgres tables with Access: Running out of memory
  365. Versioning control in PostgreSQL?
  366. SELECT with row>32k hangs over SSL-Connection
  367. Stored procedures from MS Query
  368. retrieve statement from catalogs
  369. unsubscribe
  370. What is an RT index?
  371. Multiple database services and multiple versions on Red Hat Linuxsystems
  372. sequences: cache_value, log_cnt, is_cycled columns
  373. connectby
  374. Queuing in Post
  375. Replication again
  376. table functions + user defined types
  377. function with tablename parameter
  378. Experience with PL/xx?
  379. Slow query
  380. foxpro to postgresql7.1
  381. Question about the Internals
  382. can't get tcl installed properly
  383. Retrieving a column comment
  384. Question regarding Perl, DBI, and fork()
  385. Casing: bug?
  386. Problems using PGAdmin III
  387. Slow performance with no apparent reason
  388. incrementing and decrementing dates by day increments programmatically
  389. explicit casting required for index use
  390. no records returned
  391. Performance failure / automatic restart / cron ?
  392. interesting quote...
  393. DBD::PgPP::CursorResponse
  394. partitioning
  395. where to find minor release info
  396. ./configure error - readline library not found
  397. extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax
  398. Index Usage Question
  399. Timestamp and interval precision
  400. unsubscribe
  401. shared memory on OS X - 7.4beta4
  402. ERROR: Multiple assignments to same attribute... ??
  403. FW: Check the patch from MS Corporation
  404. Desperate help needed for Replication
  405. Hierarchical query's
  406. Clustering for performance and fail over
  407. HTML generation with PL/PgSQL
  408. CLUSTER
  409. Nullable 'Foreign Key-like' Constraint
  410. Setting up DSPACE for Postgres access
  411. Timestamps in Views
  412. PostgreSQL v7.4 Beta5 Available for Testing
  413. Indexes and querys
  414. database files
  415. Adding fields on the fly
  416. setArray
  417. Prepared Statements
  418. plpgsql extract epoch problem
  419. SCSI vs. IDE performance test
  420. Atrybutes ???
  421. poor cpu utilization on dual cpu box
  422. (NONE)
  423. Trigger
  424. Identifier max length
  425. Postgreqsl & Package
  426. Same conditions, different planning?
  427. unexpected query behavior with UTF text
  428. where is pg_views
  429. Cast result set of select into an array for a sub select...
  430. pg_clog / pg_xlog corruption?
  431. Proposed structure for coexisting major versions
  432. max() over some rows but grouped, within one view def - how ?
  433. DBDesigner for Linux
  434. Simple SQL
  435. About TSearch2 Performance
  436. jboss postgresql pk generation
  437. lastval(seq) ?
  438. Timestamp to date conversion...plz help me
  439. create triggers.
  440. Help or Bug?
  441. pgsql error - situation update
  442. (no subject)
  443. Pgsql 7.3.3 on redhat 7.2
  444. Pgsql 7.3.3 on redhat 7.2 machin
  445. postgres 7.3.3 on redhat 7.2
  446. how to use pg_resetxlog
  447. tsearch2 and aspell
  448. Recomended FS
  449. Quick quote for Install
  450. Numeric type
  451. Cannot create new link. Too many open links
  452. tsearch2 question...
  453. Dilbert Experiences a 'Database Manager' moment
  454. convert string function and built-in conversions
  455. plpgsql
  456. Timestamp to date conversion...plz help me
  457. 7.4b4 domain usage and select question
  458. plpgsql: return multiple result sets
  459. How to quote text before inserting into database?
  460. Postgres seems to BE on windowsXP
  461. using cygwin for postgres
  462. How to activate error messages in my language
  463. Difference between check and a small table
  464. selecting table at execution with PL/PgSQL
  465. Help or Bug?
  466. restart and postgres.conf
  467. Using subselects in INSERTs?
  468. Perl and Postgres
  469. basic question
  470. ecpg and blob's
  471. connecting to external database tables outside of the postgres database
  472. XOR logical operator
  473. Disabling referential integrity
  474. pg_atoi
  475. Remote updating
  476. maximum number of client connections?
  477. problem with function to report how many records were changed
  478. ShmemAlloc errors
  479. Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)
  480. easy way to insert same value into 2 columns
  481. Lost views in a PostgreSQL 7.1. dump file ?
  482. When to use an array datatype?
  483. UPDATE table to a joined query...
  484. Damaged table
  485. Group and grant question
  486. ODBC
  487. is possible to read oracle tables from PostgresSQL
  488. constant time count(*) ?
  489. Getting error codes for failed queries?
  490. VACUUM degrades performance significantly. Database becomes unusable!
  491. Porting Code to Postgresql
  492. How to Create View
  493. Triggers tutorial
  494. Cygwin? or paid version from SRA?
  495. PostgreSQL article in phparchitect
  496. Porting Code to Postgresql
  497. PG clustering
  498. Indexes?
  499. How to Create View
  500. PLPERL function error - utf-8 to iso8859-1
  501. Triggers tutorial
  502. Cygwin? or paid version from SRA?
  503. PostgreSQL article in phparchitect
  504. PG clustering
  505. Indexes?
  506. PLPERL function error - utf-8 to iso8859-1
  507. Table analyzer
  508. Error compiling pgplsh
  509. order by a string
  510. Table analyzer
  511. Error compiling pgplsh
  512. converting varchar date strings to date
  513. order by a string
  514. Question
  515. Excute comnands OS from plpgsql
  516. elog undefined?
  517. converting varchar date strings to date
  518. How to list which tables are available?
  519. Question
  520. spam or crazy mail server changes?
  521. Excute comnands OS from plpgsql
  522. elog undefined?
  523. How to list which tables are available?
  524. spam or crazy mail server changes?
  525. pg_shadow --> passwd
  526. SET within a function?
  527. gborg cvs ?
  528. Index on timestamp to date field
  529. Pgsql on Windows
  530. Create Function... ERROR: language "plpgsql" does not exist
  531. Performance weirdness with/without vacuum analyze
  532. Postgres 7.3.4 install
  533. Upgrading to 7.4beta
  534. Temporary tables and miscellaneous schemas
  535. CREATE INDEX question (how to index on "money" field?)
  536. need for concrete info
  537. previous & next buttons
  538. [Cygwin] Postgresql 7.3.4 Installation Problem
  539. PQnotifies and freeing memory.
  540. "slicing" records
  541. backend exit mystery
  542. Debian experimental packages of PostgreSQL 7.4beta4
  543. log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze
  544. Unable to identify an operator '*=' for types 'character varying[]' and '"unknown"'
  545. Unique Index vs. Unique Constraint
  546. Interfaces that support cursors
  547. libpq.so.3 not found error while use Perl DBI
  548. Execute Function from VB/ADO
  549. problem with pg_dump and restoring sequences
  550. PG tools