View Full Version : postgresql answers


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

  1. Are there commands to enquire about table structure?
  2. Problem with API (libpq) - detailed error codes
  3. IDENT and pg_hda.conf
  4. No Database Drivers
  5. subqueries vs. separate queries
  6. Planner configuration
  7. Grant question
  8. A strange Vacuum error ...
  9. Pl/tcl auto-load problem
  10. Very slow query - why?
  11. Specifying many rows in a table
  12. Single step Sql script GUI editor
  13. 7.3.4 freezing
  14. Sorting is ignoring spaces
  15. Seaching without accents
  16. Interest in database-based email?
  17. Help, I've killed my system?
  18. Fw: postgres DB duplication
  19. Manually authenticating users in pg_shadow
  20. Is autocommit=true bad?
  21. Call a function when a User (dis)connects from the Server/Database
  22. Logging all queries
  23. Looking for mail relays ...
  24. Postgress resumes ...
  25. Adding missing FROM clause - thanks or no thanks?
  26. Increase stored proc. parameters max count
  27. How can the sequence become out of sequence?
  28. Broken Link on techdocs
  29. Permission Problems:-)?
  30. Reloading Template1
  31. Foreign keys on inherited attributes
  32. postmaster growing to consume all memory
  33. Embedded transactions
  34. crlf and copy
  35. how to enumerate rows ?!?
  36. pg_largeobject and oid mistmach after restore
  37. Executing a query and returning the result set using the SPI
  38. Where is initdb?
  39. Global variables for plpgsql stored procedures
  40. Casting varchar to interval.?
  41. Storing Configuration settings for a database?
  42. About Privileges
  43. Object Relational features in PostgreSQL
  44. COPY, \\copy, and "\357\273\277"\n ^
  45. Multiway associations
  46. I can't upgrade to PostgreSQL 7.4 in RedHat 9.0
  47. on cascade set null works on not null columns
  48. Is there something like an dynamic view ?
  49. pl/pgsql docs 37.4.3. Row Types -- how do I use this function?
  50. force drop of database others are accessing
  51. Calling triggers with arguments
  52. If table A value IS NULL then table B
  53. business references for postgresql
  54. sequence in schema -- broken default
  55. Optimizing SQL: bind variables, prepared stms, histograms
  56. Upcoming events
  57. Nearby zipcodes from a point
  58. psql: relocation error: psql: undefined symbol: PQgetssl
  59. Parsing bug?
  60. regex in plpgsql function
  61. LIVE Coverage of LinuxWorld Conference & Expo | LinuxWorld - where isPostgresql
  62. Want a job?
  63. trust auth in 7.4
  64. Why does the sequence get out of sequence?
  65. varchar_pattern_ops in 7.3.4?
  66. Lost plpgsql function
  67. Question and search for ODBC related postgreSQL questions
  68. Update inside (Insert) Trigger and Unique constraint...
  69. What is holding a connection open.
  70. tablespaces a priority for 7.5?
  71. Compiling postgres-7.4.1
  72. Linux Magazine/Postgres Article
  73. postgresql + apache under heavy load
  74. Idle connections - Too many clients connected already
  75. Ending transaction inside stored function
  76. CTTAS w/ DISTINCT ON crashes backend
  77. SCO Extortion
  78. Referencing subselect returned value
  79. PostgreSQL and Datawarehouse tools
  80. Accessing template0 tables
  81. postGresql Consulting ??
  82. Recursive optimization of IN subqueries
  83. Transaction id
  84. ORM, XPath, and pgxml_dom segfaulting
  85. Alternative to ODBC ?
  86. JDBC Driver moved to gborg.
  87. Can't backup! pg_dump/pg_restore not updated with 7.4.1
  88. Getting rid of duplicate tables.
  89. How to get the requested columns in a rowtype PL/pgSQL function
  90. Attaching files to the database.
  91. Converting from Progress 4GL and DBMS
  92. Very long time to commit or close connections
  93. Introduced PostgreSQL for Windows
  94. Integer ranges in PostgreSQL
  95. Tool to ease development of plpgsql
  96. Tool to ease development of plpgsql
  97. Great change (size of data dir) upgrading postgresql
  98. computed field on a table
  99. Using a Makefile during database development
  100. importing data
  101. Automatic joins?
  102. Automatic joins?
  103. massaging data from multiple timezones
  104. How should I get started?
  105. 7.4 -> 7.4.1 upgrade with customization on freebsd
  106. I got bit by that darn GEQO setting again...
  107. error creating sql function
  108. Tool to ease development of plpgsql
  109. UNICODE-encoded database does not accept umlaut-characters.
  110. Postgresql reporting tool
  111. Potential Problem with PostgeSQL performance on SuSE Linux 9.0
  112. User-specific sequences
  113. plpythonu AKA am I crazy? or....
  114. Problems with \copy and delimiters ','
  115. simple tree in postgress
  116. Adding long text to a database text field generates errors
  117. FAQ (disk space)
  118. serverless postgres, embedded firebird, etc.
  119. Creating GUID
  120. How to become a Windows beta-tester?
  121. Index space reusable?
  122. check date validity
  123. tinterval operators and functions
  124. how to catch the error in procedure ?
  125. transactions in c api (libpq)?
  126. User-specific sequences...
  127. What Version Installed?
  128. why isn't TEXT a key word?
  129. Survey: Motivations to Contribute
  130. How should I get started?
  131. CASE SELECT syntax
  132. Bytea/Large Objects/external files best practices
  133. Bytea/Large Objects/external files best practices
  134. problem starting postmaster as a service
  135. Foreign key question
  136. Returning large select results from stored procedures
  137. parse error in function
  138. fixed-length row
  139. YAGT (yet another GUID thread)
  140. postgresql Error handling in client app
  141. Log_statement behaviour a little misleading?
  142. about postgres odbc on wondows
  143. pg_dump/pg_restore problems with 7.4.1
  144. best practice for use of functions..
  145. Errors after power failure
  146. FW: Postgres: VACUUM
  147. Postgres: VACUUM
  148. Max registers in postgresql 7.4
  149. Quoting for a Select Into - Please Help
  150. Collate is not supported for 7.4
  151. Rights in 7.4
  152. Schemas not created on restore
  153. Detecting database corruption
  154. Using regular expressions in LIKE
  155. Huge Data
  156. Optimising SQL Queries?
  157. COPY FROM STDIN
  158. casting parameters to a function
  159. 7.4.1 packages for RHEL2.1
  160. Incremental Development
  161. serverless postgresql
  162. Trigger Question
  163. Testing Email
  164. dump/restore problem
  165. Error since powerouttage
  166. Error since powerouttage
  167. Nested transaction - I am a bank ??
  168. Pl/Perl speed
  169. sequence incrementing twice
  170. Nested transaction - I am a bank ??
  171. pg_catalog permission problem
  172. Postgress and MYSQL
  173. Best practice? Web application: single PostgreSQL user vs. multipleusers
  174. Best Practice for incremental development
  175. Any real known bugs about wrong selects?
  176. Nested transaction workaround?
  177. Updating the owner of a function
  178. Reallife szenario for GEQO
  179. Help with indexing!
  180. Parse error help needed...
  181. sql insert function
  182. qq- repost
  183. qq
  184. Column qualifier issue
  185. Vacuum Error
  186. Dump/Restore ordering problem?
  187. Connecting using an existing socket (libpq).
  188. unsubscribe
  189. unsubscribe
  190. Granting all table in one command
  191. Dump tables with pg_dump - no or different Owner
  192. Error with tablefunc in postgres 7.4.1
  193. insertion with trigger failed unexpectedly
  194. Precedence of a TRIGGER vs. a CHECK on a column
  195. Compile postgre 7.1 on Redhat 9?
  196. SRF in C
  197. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  198. what we need to use postgresql in the enterprise
  199. how do I get the primary key
  200. How are NULLS stored on disk for PG 7.4?
  201. Using indices with long unique IDs.
  202. Is Mysql Gaining?
  203. Drawbacks of using BYTEA for PK?
  204. CHAR(N) storage requirement
  205. Case sensitivity
  206. psql's "\d" and CLUSTER
  207. Any way to SELECT a list of table names?
  208. Bug with rename bigserial column
  209. Bug in functions returning setof where table has dropped column?
  210. query should use an index?
  211. Query string is too long
  212. unsubscribe
  213. OIDS and its limitations
  214. ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
  215. Why does this use of accents in psql fail for a Unicode database?
  216. no space left on device
  217. Hierarchical queries
  218. TSearch2 ... ignore word repetition for rank
  219. deferring/disabling unique index
  220. Invalid UNICODE character sequence found(0xc000)
  221. problems dumping from one server 2 another
  222. array faults?
  223. Trouble with MsAccess and records above 13000
  224. Using indices with long unique IDs.
  225. Natural upgrade path for RedHat 9?
  226. Using indices with long unique IDs.
  227. RedHat install question.
  228. SPI question: trying to read from Large Objects from within a function
  229. Simulation output using libpq
  230. full db locking during dump
  231. encrypt
  232. vacuum
  233. int8 version of NUMERIC?
  234. beginner query help
  235. 7.4, 'group by' default ordering?
  236. deferring/disabling unique index
  237. why I can call pg_stat_get_backend_idset directly
  238. Simulation output using libpq
  239. 7.3.3 drop table takes very long time
  240. order by is ambiguous
  241. Optimize query: time of "single * IN(many)" > time of "many * IN(single)"
  242. Compile problem on old Debian Linux with glibc 2.0.7
  243. Open Source Database Rankings
  244. Perl and Python modules problem
  245. Oracle -> Postgres live translation?
  246. Problem with rserv replication
  247. pg_stats question
  248. PHP arrays and postgresql
  249. VACUUM VERBOSE ANALYZE does not work on 7.4.1
  250. 64 Bit Postgresql ports
  251. The script kiddies are busy again ...
  252. Find original number of rows before applied LIMIT/OFFSET?
  253. deadlocks - sharelocks on transactions
  254. Reparse PL/pgSQL Function?
  255. Loading a dumped databse from cd
  256. SPI question (or not): trying to read from Large Objects from within a function
  257. problems with transaction blocks
  258. Query performance question on a large table
  259. DBs and Schemas
  260. Postgresql & 64 Bit Opteron
  261. unsubscribe
  262. create template database
  263. pg_dump and client_encoding
  264. cross-table unique constraint
  265. MVCC for massively parallel inserts
  266. Date column that defaults to 'now'
  267. forking postmaster on my own - not as pguser
  268. plpgsql.so?
  269. release notes/Appendix E in documentation
  270. Slow Performance with 7.4.1
  271. unsubscribe
  272. 7.4.1 Server Not Starting?
  273. History-based (or logged) database.
  274. PostgreSQL 7.4.1 incredibly slow :-(
  275. Cursor Not Found
  276. Anything akin to an Evaluate Statement in Postgresql?
  277. Scripting a new db server setup
  278. Postgresql Errors over ODBC
  279. TPC-C and Postgres
  280. replication choices
  281. Functions Returning Record Datatype
  282. Network Problems over past 48hrs
  283. Foodmart2000 sample database
  284. license issues
  285. license issue
  286. license issue
  287. Passing a comma delimited list to a function
  288. BUG: compiling PL/Python - Semi-SOLVED
  289. Any way to have CREATEUSER privs without having all privs?
  290. 7.4 ERROR: CREATE LOCAL TEMPORARY TABLE ... ON COMMIT DROP inside a function
  291. 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work
  292. pull_up_subqueries question
  293. Help with PostgreSQL porting project
  294. why the need for is null?
  295. Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
  296. GetLastInsertID ?
  297. how to read db schema with php
  298. speeding up inserts
  299. measuring disk usage of records
  300. finding my schema (for sequences)
  301. Binaries (rpm) for SuSE 9.0...
  302. Bug and/or feature? Complex data types in tables...
  303. Replication ?
  304. What does count(*) count?
  305. 7.4.1 RPMS
  306. Quotes in dynamic sql
  307. 7.3 dump into 7.2 (my solution)
  308. 'like' refuses to use an index???
  309. Where can I find the "Contrib" page on the PostgreSQL site?
  310. Problem with ecpg
  311. ERROR: cache lookup for type 0 of ... pg.dropped.14........ failed
  312. md5sum function for debian 7.3.2
  313. Any way to disable backslash as a string literal escape character?
  314. PG_Autotune
  315. Select Non Alpha Contents of a Column
  316. website doc search is extremely SLOW
  317. Building dynamic contents from database
  318. Building dynamic contents from database
  319. Out of memory error when doing an update with IN clause
  320. An out of memory error when doing a vacuum full
  321. altering a column
  322. case insensetive UTF-8
  323. phppgadmin, pkey's and indexes
  324. pg_recvbuf errors
  325. simple auto-updating timestamp ?
  326. what about uniqueness of inherited primary keys
  327. Change onership of database and all tables?
  328. Max length of SQL statement
  329. Time varying referential integrity
  330. comparison: smallint & 2^extract(dow from date)
  331. RPM for RedHat 7.0?
  332. dump 7.3 into 7.2?
  333. pg_ctl logfile rotation not working?
  334. Nested Transactions in 7.5??
  335. between
  336. Is my MySQL Gaining ?
  337. Photos of PostgreSQL booth
  338. Postgresql 7.4.1 Compile problem for SCO 5.0.5
  339. Installing Postgres w/RH9
  340. Where do I get Windows libpq and header files?
  341. Parser does not like %ROWTYPE in the RETURNS clause of a function declaration (BUG?)
  342. SELECT INTO broken (?) in PL/pgSQL when using a set returning function in FROM clause (BGUG?)
  343. getting configure options?
  344. PostgreeSQL C header files
  345. getting configure options?
  346. Mirrors that don't suck.
  347. PostgreeSQL C header files
  348. Join Tutorial
  349. Mirrors that don't suck.
  350. ecpg question
  351. PostgreSQL 7.4.1 Released
  352. Join Tutorial
  353. COPY - Ignore Problems
  354. Parser: parse error - please help...
  355. Normalization and regexp
  356. CHECK versus a Table for an enumeration
  357. hardware requirements under Redhat
  358. ecpg question
  359. postmaster and logrotate
  360. PostgreSQL 7.4.1 Released
  361. COPY - Ignore Problems
  362. Parser: parse error - please help...
  363. Normalization and regexp
  364. CHECK versus a Table for an enumeration
  365. hardware requirements under Redhat
  366. postmaster and logrotate
  367. How to hide database structure
  368. restoring database
  369. extracting date FROM timestamp
  370. Tables Referencing themselves As Foreign Keys
  371. questions about tsearch2 (for czech language)
  372. Groff and Weinberg SQL Complete Reference - Sample database?
  373. bug in query planning?
  374. Where can I learn some more about the rule system?
  375. FEATURE REQUEST: let arrays support null values.
  376. Please remove me from the list, thanks
  377. SELECT ... FOR UPDATE
  378. MySQL Gets Functions in Java - Enlightenment Please
  379. Tables referencing each other
  380. DB & Log Files removed...
  381. Regarding Start of postmaster
  382. automatic verifications
  383. dblink_connect fails
  384. 7.1.3 ecpg
  385. PostgreSQL speakers needed for OSCON 2004
  386. Salvage older PostgreSQL data disk - help?
  387. automatic verifications
  388. Select groupping by one column
  389. Has anyone seen an ADO Provider for Postresql?
  390. Duplication to External Server
  391. authentication failed
  392. performance in selecting from very large recordset
  393. How to navigate tree without CONNECT BY?
  394. pqReadData() -- read() failed: errno=32
  395. Which file system do i have to choose?
  396. BLOBS : how to remove them totally
  397. param max_connections
  398. Check this update from the MS
  399. Function Returning SETOF Problem
  400. Triggers for FK on Views - can they be made deferrable?
  401. bind-dlz with postgresql driver ...
  402. Permissions issue?
  403. Deadlocks with plpgsql
  404. copy command problem
  405. Excel, OpenOffice and Postgres
  406. Need to understand PL/PGSQL, Foreign Key Deferable, and Transactions...
  407. md5 function
  408. Sequence name with SERIAL type
  409. restore error - language "plperlu" is not trusted
  410. Sequence question.
  411. Join Issues
  412. update slows down in pl/pgsql function
  413. 7.4 pg_dump and restore (with postGIS/GEOS)
  414. Firebird and PostgreSQL at the DB Corral.
  415. DB with bytea types reload problem
  416. selecting into a variable like @var=select ...
  417. Authentication Question
  418. Postgres respond after toomany times to a query view
  419. passing array as argument and returning an array in plpgsql
  420. UTF support in WIN32 native and Lower/Upper in 7.5 release
  421. Foriegn Key constraints not enforced when using rules
  422. DBF to PostgreSQL
  423. besides dbfdump........ HOW TO DUMP!
  424. FW: database failure..
  425. Relational data model dead?
  426. deadlock detected when inserting data
  427. Changing user
  428. LIMIT modifier
  429. PostgreSQL on Windows Server 2003
  430. dump and sequence initilizing
  431. password authentication failed for ..
  432. Snippets
  433. windows distribution
  434. database failure..
  435. Calculating total amounts per clientid
  436. Why is postgres an ORDMS
  437. 7.5 features
  438. Delete all records NOT referenced by Foreign Keys
  439. Windows Version of PostgreSQL
  440. Perl "with-perl" configuration option
  441. Error with table
  442. Reordering results for a report
  443. Change date format only for one DB
  444. Moving the database from a filesystem to another
  445. experiences with postgres in ia64 and linux
  446. remark on a slowdown of COPY
  447. Uninstall postgres 7.4
  448. Build Problem in 7.3.5 version
  449. make error Mac OS X (ar: illegal option -- s)
  450. ERROR: JOIN/USING types 'integer' and 'character varying' not matched
  451. Is it not datestyle that determines date format output?
  452. Foreign keys and pg_user table
  453. Weird Problem With PostgreSQL 7.3.1 and VB.Net Datagrid
  454. tablespaces in 7.5?
  455. ERROR: did not find '}' at end of input node (again)
  456. Storing Snapshot Data
  457. sequences not renamed with tables
  458. Any commercial shopping cart packages using postgresql?
  459. Redhat 9.0 Service Shutdown
  460. Moving a database between servers
  461. datestyle in postgresql.conf, version 7.4
  462. Disabling or forwarding external connections
  463. "PostgreSQL Error Code(1)"
  464. highest match in group
  465. Wird behavour of foreign keys
  466. versions of PG
  467. PG 7.4 on Tru64 UNIX 4.0 + threads
  468. JDBC function call: PS vs CS
  469. Users and session ids
  470. Strange permission problem regarding pg_settings
  471. initdb reporting error.
  472. Determining what a user can access
  473. Help: ecpg bytea and PQescapeBytea()/PQunescapeBytea()
  474. Help with Turning debugging on/off
  475. OO database?
  476. PG and AIX
  477. Casting Point to Text
  478. Reset oid , starting value=1
  479. Shell access & send email from PLPGSQL?
  480. Oracle to PostgreSQL migration
  481. A problem during restoring database from PostgreSql 6.5.3/7.1.3 to 7.4
  482. OO database?
  483. Is the COMMUTATOR clause required for self commutative operators?
  484. Manual record locking
  485. Inheritance and foreign keys
  486. Pg_Dump of schema?
  487. dblink questions
  488. remove
  489. Turning on/off debugging
  490. Planner question regarding functions
  491. Install that update from the Microsoft Corporation
  492. Look at security update for Microsoft Windows
  493. left join is strange
  494. pgsql 7.4 on minimal environment
  495. Where to find information about implementing full-text-search
  496. spelling errors in query terms
  497. dblink questions
  498. CMS with PostgreSQL
  499. GRANT ON C
  500. user defined variable per session
  501. CREATE RULE problem/question requesting workaround
  502. functions/operators with 2 sets as arguments
  503. dblink questions
  504. corruption diag/recovery, pg_dump crash
  505. CMS with PostgreSQL
  506. 7.3 --> 7.4 C Functions
  507. Feedback? Is there interest in a PostgreSQL-based CRM suitefriendly to shared hosting?
  508. ERRORs after upgrade from 7.2.1 to 7.4 about nonexisting large objects
  509. PSQL 7.4 on debian woody
  510. FW: Postgres 7.4 runing on BSD
  511. Stored FUnctions
  512. CREATE TABLE AS COMMAND
  513. 7.4 Crashed... Why?
  514. max_fsm_pages
  515. function to find last day of month
  516. OpenFTS-perl-0.35 released
  517. update time zone in timestamps
  518. how to restart on OS X
  519. Groups vs. Roles
  520. last update time of a table
  521. xor for text
  522. XOR on strings
  523. are cursors necessary?
  524. unsubscribe
  525. transaction in progress
  526. ecpg -e
  527. Shared hosting configuration advice requested
  528. How to download pgsql
  529. postgresql locks the whole table!
  530. question
  531. Async Query Processing on Solaris
  532. bug in 7.4
  533. last update time of a table
  534. Invalid page header
  535. multiple PostgresQL installations
  536. Async Query Processing on Solaris
  537. PostgreSQL 7.3.5 Now Available ...
  538. Pronouncing PostgreSQL
  539. [Fedora Core 1] yum repositories with 7.4?
  540. bytea, index and like operator
  541. C/C++ access with no postmaster running?
  542. postgresql locks the whole table!
  543. Teach Yourself PostgreSQL book
  544. Autocommit to off
  545. autocommit off
  546. Accessing fields in RECORD data type using variables as field names
  547. Cast text to bytea
  548. Transaction Question
  549. Money data type in PostgreSQL?
  550. DBD::Pg problem