View Full Version : postgresql answers


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

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