All Questions
Tagged with postgresql-9.1 postgresql-9.2
4 questions
3
votes
1
answer
247
views
How to validate column while creating Table?
Need to validate the column while creating the tables in postgres , An example before developer create table We are in need to validate the Audit columns,
Example :
create table tab_1 (
a integer,
b ...
- 217
0
votes
2
answers
236
views
Why Postgresql 9.2 word boundary not working!
In my postgresql version 9.1 this query is working fine:
select id,name from flash_card_set where name ~* '\yACT\y'
and matching:
text ACT txt,ACT tests,tests ACT
But in my postgresql version 9.2 it ...
1
vote
1
answer
1k
views
Parsing the value and copying it to another column in postgresql
column_1 (varchar) has values with the format like 1024 MB, 2048 MB etc. There also exits column_2 (int). Now I would like to parse the value in column_1 and update the column_2 with values like 1024, ...
- 11
0
votes
1
answer
1k
views
pg_upgrade fails with lc_ctype cluster values do not match
I'm upgrading my PostgreSQL version 9.1.4 database to version 9.2.4. Both the old and the new version are the bundled versions of postgresapp.com for Mac OS X.
When trying to upgrade the database I ...
- 177