View Full Version : postgresql answers


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

  1. to change datatype
  2. Problem in converting float4 type to float8
  3. postgreSQl chennai trainingc enter
  4. returning columns from different tables, in plpgsql function
  5. Names of columns with foreign keys
  6. Error: relation with OID 22938 does not exist
  7. how to qeuey this in paadmin like mssql
  8. Can you use a stored procedure in a subquery in postgres?
  9. Installation fails
  10. Encoding problem in create database
  11. Address already in Use, postgres doesnot restart
  12. Restoring the dump in a new database does not contain oids
  13. Selection in pgsql using dynamic tables.
  14. Table Creation Problem
  15. Connecting to PostgreSQL using VB.NET
  16. BYTEA convertion to TEXT
  17. PostgreSQL Tablespace Creation Problem
  18. doubt in CASE command
  19. Can I connect to remote DB using psql?
  20. Installation Problems with Windows XP
  21. return type of function wen having different datatypes
  22. round to the nearest integer
  23. Is there a PHP cursor?
  24. Bitemporal tables sequenced unique triggers
  25. postgresql
  26. syntax to view the structure of a table using sql
  27. Running ACT! 2008 Database on two Laptops
  28. getting tuples of result
  29. how to configure Pgpool-II to replicate postgres database in linux
  30. Restore from plain text
  31. Problem in executing sql file
  32. trigger problem
  33. double quotes inside single quotes => ' " ... " '
  34. How to show time stamp in postgres pg_log/TodaysFile
  35. plperl problem
  36. How to setup a Arabic compatable Postgres DB
  37. postgreSQL user permission denied
  38. Postgresql database connection error...
  39. doubt in update query inside a function
  40. CREATE LANGUAGE cannot load library
  41. Need help with a slow UPDATE query
  42. PostgreSQL logical storage
  43. pg_restore in C - language how to...
  44. Physical files
  45. Problem in Select Query
  46. PostgresSQL server connectiong problem with C-language...
  47. Transactions
  48. converting POINT(-43.16 -0.876) to Latitude and Longitude
  49. doubt in exporting a file into database
  50. datamodel
  51. executing a query daily
  52. Error in following query
  53. PG archiver problem
  54. PostgreSQL dump restore from client
  55. Online replication of Postgresql databases
  56. Performance Tuning
  57. Postgresql Reinstallation problem on Windows
  58. problem in using unicode datatype
  59. current transaction is aborted. queries ignored until end of the transaction block
  60. Problem regarding a function
  61. install postgre
  62. install postgre
  63. why did not suppert Rollback? postgresql
  64. doubts in slony
  65. difference
  66. PostScript Reports
  67. stupid misstake with DB encoding
  68. Query about 20,000 record problem(slow)
  69. Problems with unique key constraint.(CASE INSENSITIVE)
  70. Insert data in win1251 encoding to base with utf8 encoding
  71. Problem inserting into a view
  72. Updating a coloumn value by comparing coloumns from two tables
  73. Top Value in a Table
  74. PostgreSQL equivalent to MySQL LOCATE()
  75. pg_dump backup doesnt restore everything - things missing... restore howto required
  76. Using the result of a function that RETURNS SETOF
  77. Closing a database
  78. doubt regarding rollback
  79. database connection problem
  80. logically-delete a row rather than actually remove in from table in postgreSQL
  81. Restore after server crash
  82. Add not null column in a table
  83. Rules in Postgresql
  84. FATAL: role "root" does not exist
  85. postres triggers
  86. Problem: Retrieving Records based on the From & To Date
  87. doubt in arrays used in function
  88. PostgreSql Documents
  89. how to move the data ,because of the partition table
  90. doubt in function
  91. MySQL and PostgreSQL
  92. Reading into FoxPro via psqlODBC
  93. how can we use partition table ?
  94. Combining two fields data into one field in the same table
  95. Need Help In Postgres
  96. COPY Query fails in postgre release 8.2
  97. how can i use the initdb?
  98. Optimal architecture for a postgres DB?
  99. Open Source Application Server (PostgreSQL Perspective)
  100. function in postgreSql
  101. How to speed up a query
  102. Cannot change column data type
  103. query the results of a table function applied to all the rows of a different table
  104. Project On Postgresql
  105. Duplicate a DB
  106. how to retrieve number of fields in the table
  107. Installation Issues
  108. Lock Problem
  109. How to create Function for executing query ....
  110. DISTINCT or GROUP BY don't seem to help
  111. Multiple Group by
  112. ERROR : relation "master"
  113. Error while running createdb from a batch file in windows xp
  114. Are queries different between sql and postgresql?
  115. Integer array in where clause
  116. copy command
  117. Partitioning database in Postgres
  118. how to get column names of a table
  119. copy command
  120. Using cursor for update
  121. Enterprise Wide Deployment
  122. syntax for copy command
  123. Benchmarking tools for PostgreSQL on Linux (fedora)
  124. ERROR: return type mismatch in function returning tuple
  125. ERROR: SELECT query has no destination for result data;
  126. inserting data in time field
  127. Get the generated value of serial type field (primary key)
  128. Slony-I questions
  129. Select For Update
  130. Function To Return Insert Statements In Postgres
  131. Extract date from timestamp
  132. Exporting data from postgresql to oracle
  133. Is there separate package for client and server in postgresql
  134. Server - Client Application
  135. doubt in a datatype
  136. syntax to view the structure of a table
  137. Is Pg replication used for multi master or two master asynnchronus replication
  138. explain
  139. ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist
  140. Cant view table description
  141. PGCluster-II version 1.3 implementation
  142. Error:: 'more' is not recognized as an internal or external command
  143. What replication are people using
  144. Import data into Postgresql
  145. how to post to the forum
  146. Understanding End of Cursor?
  147. A far cry - but here's hoping - PostgreSQL Replicator
  148. Too many clients already
  149. Installation of PostgreSQL on Windows XP
  150. Help with Tags database design.
  151. retrieve two tables in a single query
  152. Returning SETOF in plpgsql
  153. oid problem
  154. How to add a column to the table
  155. Convert data from char type to byte tape
  156. Stored functions
  157. Mapping select results through a function
  158. Stored functions books
  159. I couldn't install 8.2 ( Instead of I got a lot of Error messages :)
  160. alias name inside the function
  161. What is the output statement in PostgreSQL
  162. Regarding Installation of postgresql as a client - server
  163. syntax error at or near "TYPE"
  164. Postgresql supports Map Info's Easy Loader and MapXtreme-- Java
  165. Hybrid Environment
  166. Too Many Client Connections -- Error -- Need Help
  167. Hello everyone, I am new to this site and SQL server
  168. Building an aggregate function
  169. "is not scalar Variable" Error
  170. scripts for converting dbf or mdb files to postgres
  171. array parameter in plpgsql function
  172. Keeping two db's in synch across continents
  173. order by for varchar datatype column with numeric values
  174. Functiion Problem
  175. starting psql in windows
  176. Postgres backup and restore
  177. PostgreSQL Database Backup at System Shutdown time in OS Windows XP
  178. shp2pgsql Help with syntax
  179. pg_restore is not recognizing dump
  180. maximum function
  181. What is commit_delay & commit_siblings?
  182. Problem with function
  183. Start of Year
  184. migration tool
  185. All About - PostgreSql
  186. PostgreSQL and OleDb
  187. Need help with triggers
  188. using ILIKE xyz where xyz is a function parameter
  189. Pgsql 8.4 on Vista starts and stops automatically.
  190. bulk copy from flat file to postgres dbserver
  191. output parameters in functions
  192. Postgres 7.x and Legato backup
  193. Postgres8.1 Database Server could not be started
  194. How to store binary files in the PostgreSql database table?
  195. How PostgreSQL searching Queries?
  196. Constraints vs Indexes
  197. Create function question...
  198. Transaction Problem
  199. Improving date(timestamp) searches
  200. crystal report
  201. How to set TG_ARGV values
  202. USE OF VARIABLES IN postgreSQL
  203. How to replace characters in dblink
  204. getting latest filled row
  205. problem with date
  206. How to get column name
  207. Auto mail sending using postgresql
  208. syntax is not supported error
  209. need an sql query for the following situation
  210. Copy Table to other database
  211. Cannot compile plpgsql function
  212. pg_dump Failure
  213. Aggregate/concatenate function (flattening columns into a row)
  214. Temporary tables
  215. User and Role
  216. How to copy data from one table to other table
  217. Function declaration for MSFTSql developer
  218. function execution
  219. using array data type
  220. What would my SQL statement look like?
  221. Database connection problem
  222. Error Installing PostgreSQL 8.1.9 on XP
  223. no lock
  224. unsorted column
  225. how to convert a query from SQL to HQL(hibernate Query Language)
  226. Beginning with PostgreSQL
  227. How to configure static ip PostgresSQL 8.1 for windows XP system
  228. How to find out that SSL is activated
  229. Postgresql 8.2 connection problem on static ip
  230. Stored Procedures in PostgreSQL
  231. execute funtions in psql
  232. SUM with possible NULL values
  233. Connecting to PostgreSQL through SSH (putty)
  234. Exporting tables from Postgres to SQL
  235. Installation of PostgreSQL 8.0 on Solaris10
  236. Stored procedure
  237. problem in querry
  238. Adding new column to existing table
  239. Support for ROWNUM and ROWID
  240. Size of table and size of database
  241. Use Of Dblink
  242. how to export postgresql tables
  243. psql won't connect, though other clients are OK
  244. Serverless/embedded PostgreSQL database
  245. Date difference
  246. count months between two dates
  247. 24 hour time format
  248. Substract hour into a function
  249. import Excel to postgreSQL
  250. Retrieve number of rows in table
  251. Invoking psql at command prompt
  252. Migration from SQL Server to PostgreSQL
  253. How to recover the deleted fields with values from bakup.
  254. recovering fields in tables
  255. Postgres Violates Primary key and OID
  256. hai i am new here.i have question,please give me reply as soon as possible
  257. Function returning setof
  258. PostreSql function
  259. Migrating IBM Universe Database to Postgres, date format Problem
  260. Run Unix Shell Scripts With Postgres Trigger
  261. server closed the connection unexpectedly
  262. getting current date
  263. For Report Generate
  264. Usisng PQgetvalue
  265. Database Design Help
  266. Need help with query involving automatically decaying values
  267. psql copy
  268. Getting Parse Error at or near and at character......
  269. Variable column name
  270. Transfer of Data from Oracle to PostgreSQL
  271. create database if not exists
  272. data fetch and insert
  273. Oid
  274. Foreign key problem
  275. How to assign a primary key
  276. pg_restore doesn't work for postgresql 7.2.3
  277. How To Execue Queris Fastly
  278. Posting Guidelines. Please read before you post in a forum!
  279. Inheritance Problem
  280. Help : what this Error means
  281. Installing PostgreSQL 8.1 on VISTA
  282. load balancing
  283. how retrive this problem
  284. Problem in function with CREATE ROLE with parameters
  285. BackUp and Restore PostGreSQL8.1
  286. HOW TO exit from a query
  287. controlling postgres I/O and CPU processing
  288. performance tuning postgres 8.2.3 on windows with shared server applications
  289. Retrieving values from tables
  290. stored procedure in postgresql
  291. Problem with Windows PostgreSQL 8.1 service
  292. download old version of PG
  293. restore problem
  294. how to compare two tables
  295. what is the keyWord DELETING
  296. Strange result using transactions
  297. How to Upgrade Postgres 7.x.x in RH9 to new Postgres version 8.x.x ??
  298. Postgresql installation problem??
  299. php objects in postgresql
  300. odbc call failed
  301. Starting More Than one Transaction
  302. Fatal error: Call to undefined function pg_connect()
  303. Connection Exception
  304. joins
  305. How to know the Number of Connection made with the database
  306. how to write the select query for this situation
  307. C# .NET ===> postgreSQL
  308. Pagination in Postgre
  309. If criteria is Null then show all.
  310. Test Suite for Postgresql
  311. How can I display the stored image?
  312. Storing files in Postgresql database
  313. Interface to posgresql
  314. How to check a query execution plans in PostgreSQL
  315. HOW TO merge two strings
  316. need copy table sql example in postgres
  317. use of client-side \lo_import and \lo_export commands
  318. Server doesn't listen
  319. SHA function?
  320. Fastly Inserting Records
  321. how to release locks when instance crashes
  322. HOW TO Use transaction control statements inside a sored procedure
  323. Back Up And Restore
  324. Functions and Commits
  325. how to write this sql statement
  326. Nested use of found doesn't seem to be working
  327. Alter table doubt
  328. Driver for postgresql
  329. Redundant data in postgres
  330. Migrating data between dbs with different schemas
  331. Postgres Newbie - Case Problems in queries
  332. Multi dimensional arrays, sub selects...
  333. Error When creating the table
  334. String was not recognized as a Valid Date Time
  335. Postmaster is accepting TCP/IP connections error
  336. Data Migration From Excel to PostgreSQL
  337. date queries with portions of the date unknown
  338. How to Fix Corrupt Tables
  339. Unable to connect
  340. Postgresql Compression Across Network
  341. limit database size
  342. limit database size
  343. query and subquery in python
  344. retrieve column array values
  345. how to execute script from file within function
  346. retreive values from an array into column
  347. Can PostgreSQL initiate a message through a socket?
  348. how to insert image
  349. which is the best interface for postgresql
  350. unable to set 'Owner' column to different role
  351. username
  352. inserting values into array column
  353. Query regarding odbc connection ??
  354. how to give login in a table
  355. limitation of postgresql
  356. how can I fetch data from the database and display it in form of a editable html form
  357. ALIAS error
  358. postgis function
  359. FATAL ERROR on Solaris 10
  360. postgresql function
  361. invert an array
  362. postgresql installation fails on windows 2000
  363. accessing last element of an array
  364. How to cast varchar into timestamp in postgres
  365. How to make a copy of data in RAM ???
  366. update multiple cols in trigger
  367. How to make cross-database reference in Postgres
  368. nesting joins
  369. How to insert multiple sub columns inside a column ??
  370. on delete set null problem
  371. Databinding bool fields
  372. Increase the Cache Size
  373. Query regarding SQL commands ?
  374. how to make a Postgre DB setup on windows
  375. PL/PGSQL function
  376. getting the last record using timestamp
  377. create database test if not exists
  378. Writing DDLs in Functions
  379. Writing DDLs in Functions
  380. Postgre Sql on Solaris operating system
  381. urgent help!!
  382. Sum of “sales” for each date in a timestamp column
  383. How to know that a schema exist?
  384. Web Development Team Needed - Prefer Croatian or Eastern Europeanbased
  385. PHP Postgresql "All-In-One" CRUD Needed
  386. need help
  387. a problem when I create a trigger procedure.
  388. Postgres on XP / ODBC setup / Visual C++ API
  389. Transaction Logging Mechanism
  390. SQL question??
  391. TCP/IP Connection Error
  392. The MySQL command LEFT() counterpart in PostgreSQL?
  393. Exception Handling
  394. current transaction aborted
  395. SQL problem, help if possible please.
  396. How can I support multimedia with postgres?
  397. Postgres Connection Error
  398. HI all
  399. Restoring dump files completely
  400. PostgreSQL - JDBC2 lose connectivity after a while
  401. hi all
  402. .NET Questions
  403. postgresql module
  404. Copy / Paste in PostgreSQL from remote server.
  405. postgresql installation
  406. functions in postgresql!!!
  407. select distinct with datatype point
  408. an urgent question
  409. data conversion
  410. select-where anomaly
  411. Migration od Database
  412. installation error
  413. inserting values in relational main tables
  414. Hash index creation problem
  415. How can we manage PK and FK using inheritance??
  416. Are Primary Keys Necessary for Linking Tables?
  417. filename extension postgreSQL
  418. DBF to Postgres using DBF2PG
  419. Bulk Extract and Load data in PostgreSQL
  420. error in logs file
  421. To insert 60million rows to database
  422. can't get the full results from postgresql
  423. What is ODBC Query timeout error
  424. How to configure postgres for max disk space usage
  425. web interface library/classes
  426. Sql Case Statement
  427. Problem with executing Postgres function from javacode
  428. pg_clog errors
  429. table creation
  430. Postgres and ESQL
  431. Postgresql Vs. Mysql -- Need advice
  432. How to write postgres query with time comparison ?
  433. Hey i need advice!
  434. Subjectre31
  435. Reg Postgres Sql Replication Concept
  436. Reg Postgres Sql Database Instal On Windows 2000
  437. Syntax error doesn't make sense...
  438. just some info you might be intersted
  439. Tickets
  440. Create UNIQUE KEY
  441. Reg AutoVacuum
  442. Garbage Collection with Custom Session Handlers?
  443. Performance problem with joins
  444. plpgsql FOUND unexpected behaviour
  445. Need Clarification About Replication Concept In Postgres Sql
  446. How to convert from sql to postgresql (stored procedure)
  447. 7.4.13 LANG=C, order by still wrong
  448. Recieving notification when a table changes
  449. Limitation in query result from postgresql table
  450. date format in postgresql database
  451. libpqdll.lib
  452. Help with Database Solution
  453. Linking Tables from 2 databases
  454. Ora2PG exporter and UTF Characters
  455. alternative to distinct on?
  456. How to Use "If Exists" in PgSql
  457. Postgresql Stored procedures
  458. Postgresql
  459. Money datatype?
  460. Performance Issues PostgreSQL on Solaris
  461. Two general, simple questions
  462. Postmaster Problem
  463. What architecture for a Large Database with PostgreSQL
  464. XP Embedded and Postgres No Happy Campers
  465. Fedora Core 4 & PostgreSQL
  466. xml export tool?
  467. Dual servers
  468. Python x Postgresql Thrreading Problem
  469. Outer Join on 3 tables
  470. Conditional delete
  471. Timestamp not working
  472. is there a function which elminates spaces?
  473. OLAPy stuff crawling a bit
  474. async queries (libpq)
  475. Looks to me like MySQL has a change coming
  476. Generate/Manage a PostgresSQL database using Visio?
  477. PostgreSQL Linked server question with MSSQL2K
  478. Urgent: Input of values to execute dynamic queries
  479. 1991 and 1992 Black Box Catalogs
  480. Happy Fish Database Designer
  481. Need Database person
  482. Need Database person
  483. encoding question
  484. Where can I download HTML manual?
  485. linking access using ODBC driver with geometric data
  486. Good Portal for data mining resources
  487. Tablespace layout question
  488. scroll cursor bug or me?
  489. SQL Profiler
  490. How to copy a PG database
  491. ordering text field with non-alphanumerical character
  492. crosstab error 'query-specified return row and actual function return do not...
  493. Statement-level Triggers
  494. DateAdd function ?
  495. views, functions and parameters...
  496. ADO and PostgreSQL functions
  497. How to return a record and sets of record in plpython
  498. Great News Blog!
  499. Query Optimizer Failure / Possible Bug
  500. Bitwise operators for bytea
  501. can't update bytea field with function
  502. resultset to xml
  503. Tsearch index not set by UPDATE in PgSQL 7.3.2
  504. function no return
  505. Installing PostgreSQL 8 on Debian
  506. how to run function?
  507. SQLDescribecol in driver 8.00.0100
  508. Postgresql 8.0-beta2-dev3 on Windows 2000
  509. Adding pgAdminIII Server - Passwords?
  510. Good page with Oracle x PostgreSQL comparsion
  511. PostgreSQL and XML
  512. Danish users
  513. simple query runs very slowly
  514. using OLD variable in DELETE trigger
  515. Please Help with libpq and unicode
  516. eval function?
  517. Postgres+XML
  518. SQL Query
  519. libpq location?
  520. pgsql user account in pgadmin doesn't need password
  521. SuSE Linux and PostgreSQL
  522. What is future of partitioning?
  523. PostgreSQL/PHP/UTF-8?
  524. Oid Type
  525. The second RFD is in news.groups.
  526. Table name as parameter in function
  527. Upcoming Changes to News Server ...
  528. I need to add a column to a table
  529. Will B4->B5 require an Initdb?
  530. Lexical question...
  531. Bug in queries ??
  532. PostgreSQL 8.0.0 Beta 5 Now Available
  533. null value of type java.sql.Time
  534. primary key and the default index operator class
  535. Postgres-Windows -Perl DBI
  536. Foriegn Keys?
  537. SELECT duplicates in a table
  538. Storing every scrabble board possible
  539. Help with syntax for timestamp addition
  540. null value of type java.sql.Time
  541. Oid to text...
  542. Unions, schemas, and design questions...
  543. timestamp with time zone question...
  544. COMMIT within function?
  545. Any good report/form generators for postgresql?
  546. Wrong string length from unicode database in Borland's app
  547. Delete very slow after deletion of many rows in dependent table
  548. Join between databases or (???)
  549. Unit testing plpgsql code
  550. I found this great little site