View Full Version : postgresql answers

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