Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with postgresql
Search options not deleted
user 11393
All versions of PostgreSQL. Add an additional version-specific tag like [postgresql-13] if that context is relevant.
7
votes
2
answers
3k
views
Creating sequence for longer numeric values
my_sequence_name INCREMENT BY 1 NO MINVALUE NO MAXVALUE START WITH 10000000000000000101;
ERROR: value "10000000000000000101" is out of range for type bigint
For data integrity, I must handle this within POstgresql … I am using Postgresql 8.4 and Django 1.3
UPDATE: I guess it is better to make a clarification...
I am trying to find a way to solve this within DBMS. …
- 459
3
votes
1
answer
1k
views
Index method for very few updates and many inserts
I am using Postgresql 9.1 with *pg_trgm* extension. I need to create an index on a text-based field. I do not need full-text searches, I use ILIKE queries to make my searches. …
- 459
23
votes
1
answer
26k
views
log_min_duration_statement setting is ignored
I am running Postgresql 9.1 on Ubuntu. Exact Postgresql version is 9.1+129ubuntu1 as my package manager shows.
I have 2 databases that are actively in use and they are used from a remote server. … So I set following parameters in /etc/postgresql/9.1/main/postgresql.conf file
log_min_duration_statement = 10000
log_statement = 'mod'
so Postgresql will log queries that takes longer than 10 seconds …
- 459